1. mst
  2. ooo340

Commits

Uwe Fischer  committed 007d55a

hccalc01: #71289# makefiles and scalctree

  • Participants
  • Parent commits 4274032
  • Branches default

Comments (0)

Files changed (10)

File helpcontent2/source/auxiliary/scalc.tree

View file
  • Ignore whitespace
 		</node>
 		<node id="0803" title="Functions Types and Operators">
 <topic id="scalc/text/scalc/01/04060000.xhp">Function Wizard</topic>
-<topic id="scalc/text/scalc/01/04060100.xhp">Categories and Functions</topic>
-<topic id="scalc/text/scalc/01/04060101.xhp">Database Functions</topic>
-<topic id="scalc/text/scalc/01/04060102.xhp">Date + Time Functions</topic>
-<topic id="scalc/text/scalc/01/04060103.xhp">Financial Functions Part One</topic>
-<topic id="scalc/text/scalc/01/04060119.xhp">Financial Functions Part Two</topic>
-<topic id="scalc/text/scalc/01/04060118.xhp">Financial Functions Part Three</topic>
-<topic id="scalc/text/scalc/01/04060104.xhp">Information Functions</topic>
-<topic id="scalc/text/scalc/01/04060105.xhp">Logical Functions</topic>
-<topic id="scalc/text/scalc/01/04060106.xhp">Mathematical Functions</topic>
-<topic id="scalc/text/scalc/01/04060107.xhp">Array Functions</topic>
-<topic id="scalc/text/scalc/01/04060108.xhp">Statistics Functions</topic>
-<topic id="scalc/text/scalc/01/04060181.xhp">Statistical Functions Part One</topic>
-<topic id="scalc/text/scalc/01/04060182.xhp">Statistical Functions Part Two</topic>
-<topic id="scalc/text/scalc/01/04060183.xhp">Statistical Functions Part Three</topic>
-<topic id="scalc/text/scalc/01/04060184.xhp">Statistical Functions Part Four</topic>
-<topic id="scalc/text/scalc/01/04060185.xhp">Statistical Functions Part Five</topic>
-<topic id="scalc/text/scalc/01/04060109.xhp">Spreadsheet Functions</topic>
-<topic id="scalc/text/scalc/01/04060110.xhp">Text Functions</topic>
-<topic id="scalc/text/scalc/01/04060111.xhp">Add-in Functions</topic>
-<topic id="scalc/text/scalc/01/04060115.xhp">Add-in Functions, List of Analysis Functions Part One</topic>
-<topic id="scalc/text/scalc/01/04060116.xhp">Add-in Functions, List of Analysis Functions Part Two</topic>
+<topic id="scalc/text/scalc/01/main_functions.xhp">Categories and Functions</topic>
+<topic id="scalc/text/scalc/01/main_database.xhp">Database Functions</topic>
+<topic id="scalc/text/scalc/01/main_date_time.xhp">Date + Time Functions</topic>
+<topic id="scalc/text/scalc/01/main_financial.xhp">Financial Functions</topic>
+<topic id="scalc/text/scalc/01/main_information.xhp">Information Functions</topic>
+<topic id="scalc/text/scalc/01/main_logical.xhp">Logical Functions</topic>
+<topic id="scalc/text/scalc/01/main_mathematical.xhp">Mathematical Functions</topic>
+<topic id="scalc/text/scalc/01/main_array.xhp">Array Functions</topic>
+<topic id="scalc/text/scalc/01/main_statistical.xhp">Statistics Functions</topic>
+<topic id="scalc/text/scalc/01/main_spreadsheet.xhp">Spreadsheet Functions</topic>
+<topic id="scalc/text/scalc/01/main_text.xhp">Text Functions</topic>
+<topic id="scalc/text/scalc/01/main_add-in.xhp">Add-in Functions</topic>
+<topic id="scalc/text/scalc/01/main_complex.xhp">Add-in Functions, Complex Numbers</topic>
+<topic id="scalc/text/scalc/01/main_convert.xhp">Add-in Functions, Number Conversion</topic>
 
 <topic id="scalc/text/scalc/01/04060199.xhp">Operators in %PRODUCTNAME Calc</topic>
 <topic id="scalc/text/scalc/guide/userdefined_function.xhp">User-Defined Functions</topic>

File helpcontent2/source/text/scalc/01/makefile.mk

View file
  • Ignore whitespace
    04050000.xhp \
    04050100.xhp \
    04060000.xhp \
-   04060100.xhp \
-   04060101.xhp \
-   04060102.xhp \
-   04060103.xhp \
-   04060104.xhp \
-   04060105.xhp \
-   04060106.xhp \
-   04060107.xhp \
-   04060108.xhp \
-   04060109.xhp \
-   04060110.xhp \
-   04060111.xhp \
    04060112.xhp \
-   04060115.xhp \
-   04060116.xhp \
-   04060118.xhp \
-   04060119.xhp \
-   04060181.xhp \
-   04060182.xhp \
-   04060183.xhp \
-   04060184.xhp \
-   04060185.xhp \
    04060199.xhp \
    04070000.xhp \
    04070100.xhp \
    12120100.xhp \
    12120200.xhp \
    12120300.xhp \
+   abs.xhp \
+   accrint.xhp \
+   accrintm.xhp \
+   acos.xhp \
+   acosh.xhp \
+   acot.xhp \
+   acoth.xhp \
+   address.xhp \
+   amordegrc.xhp \
+   amorlinc.xhp \
+   and.xhp \
+   arabic.xhp \
+   areas.xhp \
+   asc.xhp \
+   asin.xhp \
+   asinh.xhp \
+   atan.xhp \
+   atan2.xhp \
+   atanh.xhp \
+   avedev.xhp \
+   average.xhp \
+   averagea.xhp \
+   b.xhp \
+   bahttext.xhp \
+   base.xhp \
+   besseli.xhp \
+   besselj.xhp \
+   besselk.xhp \
+   bessely.xhp \
+   betadist.xhp \
+   betainv.xhp \
+   bin2dec.xhp \
+   bin2hex.xhp \
+   bin2oct.xhp \
+   binomdist.xhp \
+   ceiling.xhp \
+   cell.xhp \
+   char.xhp \
+   chidist.xhp \
+   chiinv.xhp \
+   chisqdist.xhp \
+   chisqinv.xhp \
+   chitest.xhp \
+   choose.xhp \
+   clean.xhp \
+   code.xhp \
+   column.xhp \
+   columns.xhp \
+   combin.xhp \
+   combina.xhp \
+   complex.xhp \
+   concatenate.xhp \
+   confidence.xhp \
+   convert.xhp \
+   convert_add.xhp \
+   correl.xhp \
+   cos.xhp \
+   cosh.xhp \
+   cot.xhp \
+   coth.xhp \
+   count.xhp \
+   counta.xhp \
+   countblank.xhp \
+   countif.xhp \
+   coupdaybs.xhp \
+   coupdays.xhp \
+   coupdaysnc.xhp \
+   coupncd.xhp \
+   coupnum.xhp \
+   couppcd.xhp \
+   covar.xhp \
+   critbinom.xhp \
+   cumipmt.xhp \
+   cumipmt_add.xhp \
+   cumprinc.xhp \
+   cumprinc_add.xhp \
+   current.xhp \
+   date.xhp \
+   datevalue.xhp \
+   daverage.xhp \
+   day.xhp \
+   days.xhp \
+   days360.xhp \
+   daysinmonth.xhp \
+   daysinyear.xhp \
+   db.xhp \
+   dcount.xhp \
+   dcounta.xhp \
+   ddb.xhp \
+   dde.xhp \
+   dec2bin.xhp \
+   dec2hex.xhp \
+   dec2oct.xhp \
+   decimal.xhp \
+   degrees.xhp \
+   delta.xhp \
+   devsq.xhp \
+   dget.xhp \
+   disc.xhp \
+   dmax.xhp \
+   dmin.xhp \
+   dollar.xhp \
+   dollarde.xhp \
+   dollarfr.xhp \
+   dproduct.xhp \
+   dstdev.xhp \
+   dstdevp.xhp \
+   dsum.xhp \
+   duration.xhp \
+   duration_add.xhp \
+   dvar.xhp \
+   dvarp.xhp \
+   eastersunday.xhp \
+   edate.xhp \
+   effect_add.xhp \
+   effective.xhp \
+   eomonth.xhp \
+   erf.xhp \
+   erfc.xhp \
+   errortype.xhp \
+   euroconvert.xhp \
+   even.xhp \
+   exact.xhp \
+   exp.xhp \
+   expondist.xhp \
+   fact.xhp \
+   factdouble.xhp \
+   false.xhp \
+   fdist.xhp \
+   find.xhp \
+   finv.xhp \
+   fisher.xhp \
+   fisherinv.xhp \
+   fixed.xhp \
+   floor.xhp \
+   forecast.xhp \
    format_graphic.xhp \
-   func_date.xhp \
-   func_datevalue.xhp \
-   func_day.xhp \
-   func_days.xhp \
-   func_days360.xhp \
-   func_eastersunday.xhp \
-   func_edate.xhp \
-   func_eomonth.xhp \
-   func_hour.xhp \
-   func_minute.xhp \
-   func_month.xhp \
-   func_networkdays.xhp \
-   func_now.xhp \
-   func_second.xhp \
-   func_time.xhp \
-   func_timevalue.xhp \
-   func_today.xhp \
-   func_weekday.xhp \
-   func_weeknum.xhp \
-   func_weeknumadd.xhp \
-   func_workday.xhp \
-   func_year.xhp \
-   func_yearfrac.xhp \
+   formula.xhp \
+   frequency.xhp \
+   ftest.xhp \
+   fv.xhp \
+   fvschedule.xhp \
+   gamma.xhp \
+   gammadist.xhp \
+   gammainv.xhp \
+   gammaln.xhp \
+   gauss.xhp \
+   gcd.xhp \
+   gcd_add.xhp \
+   geomean.xhp \
+   gestep.xhp \
+   getpivotdata.xhp \
+   growth.xhp \
+   harmean.xhp \
+   hex2bin.xhp \
+   hex2dec.xhp \
+   hex2oct.xhp \
+   hlookup.xhp \
+   hour.xhp \
+   hyperlink.xhp \
+   hypgeomdist.xhp \
+   if.xhp \
+   imabs.xhp \
+   imaginary.xhp \
+   imargument.xhp \
+   imconjugate.xhp \
+   imcos.xhp \
+   imdiv.xhp \
+   imexp.xhp \
+   imln.xhp \
+   imlog10.xhp \
+   imlog2.xhp \
+   impower.xhp \
+   improduct.xhp \
+   imreal.xhp \
+   imsin.xhp \
+   imsqrt.xhp \
+   imsub.xhp \
+   imsum.xhp \
+   index.xhp \
+   indirect.xhp \
+   info.xhp \
+   int.xhp \
+   intercept.xhp \
+   intrate.xhp \
+   ipmt.xhp \
+   irr.xhp \
+   isblank.xhp \
+   iserr.xhp \
+   iserror.xhp \
+   iseven.xhp \
+   iseven_add.xhp \
+   isformula.xhp \
+   isleapyear.xhp \
+   islogical.xhp \
+   isna.xhp \
+   isnontext.xhp \
+   isnumber.xhp \
+   isodd.xhp \
+   isodd_add.xhp \
+   ispmt.xhp \
+   isref.xhp \
+   istext.xhp \
+   jis.xhp \
+   kurt.xhp \
+   large.xhp \
+   lcm.xhp \
+   lcm_add.xhp \
+   left.xhp \
+   len.xhp \
+   linest.xhp \
+   ln.xhp \
+   log.xhp \
+   log10.xhp \
+   logest.xhp \
+   loginv.xhp \
+   lognormdist.xhp \
+   lookup.xhp \
+   lower.xhp \
+   main_add-in.xhp \
+   main_array.xhp \
+   main_complex.xhp \
+   main_convert.xhp \
+   main_database.xhp \
+   main_date_time.xhp \
+   main_financial.xhp \
+   main_functions.xhp \
+   main_information.xhp \
+   main_logical.xhp \
+   main_mathematical.xhp \
+   main_spreadsheet.xhp \
+   main_statistical.xhp \
+   main_text.xhp \
+   match.xhp \
+   max.xhp \
+   maxa.xhp \
+   mdeterm.xhp \
+   mduration.xhp \
+   median.xhp \
+   mid.xhp \
+   min.xhp \
+   mina.xhp \
+   minute.xhp \
+   minverse.xhp \
+   mirr.xhp \
+   mmult.xhp \
+   mod.xhp \
+   mode.xhp \
+   month.xhp \
+   months.xhp \
+   mround.xhp \
+   multinomial.xhp \
+   munit.xhp \
+   n.xhp \
+   na.xhp \
+   negbinomdist.xhp \
+   networkdays.xhp \
+   nominal.xhp \
+   nominal_add.xhp \
+   normdist.xhp \
+   norminv.xhp \
+   normsdist.xhp \
+   normsinv.xhp \
+   not.xhp \
+   now.xhp \
+   nper.xhp \
+   npv.xhp \
+   oct2bin.xhp \
+   oct2dec.xhp \
+   oct2hex.xhp \
+   odd.xhp \
+   oddfprice.xhp \
+   oddfyield.xhp \
+   oddlprice.xhp \
+   oddlyield.xhp \
+   offset.xhp \
+   or.xhp \
+   pearson.xhp \
+   percentile.xhp \
+   percentrank.xhp \
+   permut.xhp \
+   permutationa.xhp \
+   phi.xhp \
+   pi.xhp \
+   pmt.xhp \
+   poisson.xhp \
+   power.xhp \
+   ppmt.xhp \
+   price.xhp \
+   pricedisc.xhp \
+   pricemat.xhp \
+   prob.xhp \
+   product.xhp \
+   proper.xhp \
+   pv.xhp \
+   quartile.xhp \
+   quotient.xhp \
+   radians.xhp \
+   rand.xhp \
+   randbetween.xhp \
+   rank.xhp \
+   rate.xhp \
+   received.xhp \
+   replace.xhp \
+   rept.xhp \
+   right.xhp \
+   roman.xhp \
+   rot13.xhp \
+   round.xhp \
+   rounddown.xhp \
+   roundup.xhp \
+   row.xhp \
+   rows.xhp \
+   rri.xhp \
+   rsq.xhp \
+   search.xhp \
+   second.xhp \
+   seriessum.xhp \
+   sheet.xhp \
+   sheets.xhp \
+   sign.xhp \
+   sin.xhp \
+   sinh.xhp \
+   skew.xhp \
+   sln.xhp \
+   slope.xhp \
+   small.xhp \
    solver.xhp \
    solver_options.xhp \
-   text2columns.xhp 
+   sqrt.xhp \
+   sqrtpi.xhp \
+   standardize.xhp \
+   stdev.xhp \
+   stdeva.xhp \
+   stdevp.xhp \
+   stdevpa.xhp \
+   steyx.xhp \
+   style.xhp \
+   substitute.xhp \
+   subtotal.xhp \
+   sum.xhp \
+   sumif.xhp \
+   sumproduct.xhp \
+   sumsq.xhp \
+   sumx2my2.xhp \
+   sumx2py2.xhp \
+   sumxmy2.xhp \
+   syd.xhp \
+   t.xhp \
+   tan.xhp \
+   tanh.xhp \
+   tbilleq.xhp \
+   tbillprice.xhp \
+   tbillyield.xhp \
+   tdist.xhp \
+   text.xhp \
+   text2columns.xhp \
+   time.xhp \
+   timevalue.xhp \
+   tinv.xhp \
+   today.xhp \
+   transpose.xhp \
+   trend.xhp \
+   trim.xhp \
+   trimmean.xhp \
+   true.xhp \
+   trunc.xhp \
+   ttest.xhp \
+   type.xhp \
+   unichar.xhp \
+   unicode.xhp \
+   upper.xhp \
+   value.xhp \
+   var.xhp \
+   vara.xhp \
+   varp.xhp \
+   varpa.xhp \
+   vdb.xhp \
+   vlookup.xhp \
+   weekday.xhp \
+   weeknum.xhp \
+   weeknum_add.xhp \
+   weeks.xhp \
+   weeksinyear.xhp \
+   weibull.xhp \
+   workday.xhp \
+   xirr.xhp \
+   xnpv.xhp \
+   year.xhp \
+   yearfrac.xhp \
+   years.xhp \
+   yield.xhp \
+   yielddisc.xhp \
+   yieldmat.xhp \
+   ztest.xhp 
 	
 # --- Targets ------------------------------------------------------
 

File helpcontent2/source/text/scalc/guide/autofilter.xhp

View file
  • Ignore whitespace
          <paragraph xml-lang="en-US" id="par_id3153714" role="paragraph" l10n="U" oldref="12">To display all records again, select the "all<emph>"</emph> entry in the AutoFilter combo box. If you choose "Standard<emph>"</emph>, the <item type="menuitem">Standard Filter</item> dialog appears, allowing you to set up a standard filter. Choose "Top 10" to display the highest 10 values only. </paragraph>
          <paragraph xml-lang="en-US" id="par_id3147340" role="paragraph" l10n="CHG" oldref="19">To stop using AutoFilter, reselect all cells selected in step 1 and once again choose <emph>Data - Filter - AutoFilter</emph>.</paragraph>
          <paragraph xml-lang="en-US" id="par_id4303415" role="tip" l10n="NEW">To assign different AutoFilters to different sheets, you must first define a database range on each sheet.</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3159236" role="warning" l10n="CHG" oldref="14">The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the <link href="text/scalc/01/04060106.xhp" name="SUBTOTAL">SUBTOTAL</link> function if only the cells visible after the application of a filter are to be taken into account.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3159236" role="warning" l10n="CHG" oldref="14">The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the <link href="text/scalc/01/main_mathematical.xhp" name="SUBTOTAL">SUBTOTAL</link> function if only the cells visible after the application of a filter are to be taken into account.</paragraph>
       </section>
       <section id="relatedtopics">
          <embed href="text/scalc/guide/filters.xhp#filters"/>
          <embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/>
          <embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/>
          <paragraph xml-lang="en-US" id="par_id3152985" role="paragraph" l10n="U" oldref="16"><link href="text/scalc/01/12040100.xhp" name="Data - Filter - AutoFilter">Data - Filter - AutoFilter</link></paragraph>
-         <paragraph xml-lang="en-US" id="par_id3154484" role="paragraph" l10n="U" oldref="17"><link href="text/scalc/01/04060106.xhp" name="SUBTOTAL">SUBTOTAL</link></paragraph>
+         <paragraph xml-lang="en-US" id="par_id3154484" role="paragraph" l10n="U" oldref="17"><link href="text/scalc/01/main_mathematical.xhp" name="SUBTOTAL">SUBTOTAL</link></paragraph>
       </section>
    </body>
 </helpdocument>

File helpcontent2/source/text/scalc/guide/formulas.xhp

View file
  • Ignore whitespace
 <paragraph role="paragraph" id="par_id3150109" xml-lang="en-US" l10n="U" oldref="30">It is also possible to nest functions in formulas, as shown in the example. You can also nest functions within functions. The Function Wizard assists you with nested functions.</paragraph>
 <section id="relatedtopics">
 <embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/>
-<paragraph role="paragraph" id="par_id3150213" xml-lang="en-US" l10n="U" oldref="44"><link href="text/scalc/01/04060100.xhp" name="Functions list">Functions list</link></paragraph>
+<paragraph role="paragraph" id="par_id3150213" xml-lang="en-US" l10n="U" oldref="44"><link href="text/scalc/01/main_functions.xhp" name="Functions list">Functions list</link></paragraph>
 <paragraph role="paragraph" id="par_id3152869" xml-lang="en-US" l10n="U" oldref="43"><link href="text/scalc/01/04060000.xhp" name="AutoPilot: Functions">Function Wizard</link></paragraph>
 </section>
 </body>

File helpcontent2/source/text/scalc/guide/userdefined_function.xhp

View file
  • Ignore whitespace
 <paragraph role="listitem" id="par_id3145366" xml-lang="en-US" l10n="CHG" oldref="4">You can define your own functions using the Basic-IDE. This method requires a basic knowledge of programming.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3153768" xml-lang="en-US" l10n="CHG" oldref="3">You can program functions as <link href="text/scalc/01/04060111.xhp" name="add-ins">add-ins</link>. This method requires an advanced knowledge of programming.</paragraph>
+<paragraph role="listitem" id="par_id3153768" xml-lang="en-US" l10n="CHG" oldref="3">You can program functions as <link href="text/scalc/01/main_add-in.xhp" name="add-ins">add-ins</link>. This method requires an advanced knowledge of programming.</paragraph>
 </listitem>
 </list>
 <paragraph role="heading" id="hd_id3149260" xml-lang="en-US" level="2" l10n="CHG" oldref="6">Defining A Function Using %PRODUCTNAME Basic</paragraph>

File helpcontent2/source/text/scalc/main0000.xhp

View file
  • Ignore whitespace
 <paragraph role="heading" id="hd_id3153965" xml-lang="en-US" level="3" l10n="U" oldref="3">How to Work With $[officename] Calc</paragraph>
 <embed href="text/scalc/guide/main.xhp#main"/>
 <embed href="text/scalc/main0503.xhp#main0503"/>
-<paragraph role="paragraph" id="par_id3147004" xml-lang="en-US" l10n="CHG" oldref="5"><link href="text/scalc/01/04060100.xhp" name="List of Functions by Category">List of Functions by Category</link></paragraph>
+<paragraph role="paragraph" id="par_id3147004" xml-lang="en-US" l10n="CHG" oldref="5"><link href="text/scalc/01/main_functions.xhp" name="List of Functions by Category">List of Functions by Category</link></paragraph>
 <embed href="text/schart/main0000.xhp#chart_main"/>
 <paragraph role="heading" id="hd_id3154659" xml-lang="en-US" level="3" l10n="U" oldref="6">$[officename] Calc Menus, Toolbars, and Keys</paragraph>
 <embed href="text/scalc/main0100.xhp#main0100"/>

File helpcontent2/source/text/scalc/main0503.xhp

View file
  • Ignore whitespace
   <paragraph role="paragraph" id="par_id3149457" l10n="U" xml-lang="en-US" oldref="2">$[officename] Calc is a spreadsheet application that you can use to calculate, analyze, and manage your data. You can also import and modify Microsoft Excel spreadsheets.</paragraph>
   </section>
   <paragraph role="heading" level="2" id="hd_id3148797" l10n="U" xml-lang="en-US" oldref="4">Calculations</paragraph>
-  <paragraph xml-lang="en-US" role="paragraph" id="par_id3145172" l10n="U" oldref="5">$[officename] Calc provides you with <link href="text/scalc/01/04060100.xhp" name="functions">functions</link>, including statistical and banking functions, that you can use to create formulas to perform complex calculations on your data.</paragraph>
+  <paragraph xml-lang="en-US" role="paragraph" id="par_id3145172" l10n="U" oldref="5">$[officename] Calc provides you with <link href="text/scalc/01/main_functions.xhp" name="functions">functions</link>, including statistical and banking functions, that you can use to create formulas to perform complex calculations on your data.</paragraph>
   <paragraph xml-lang="en-US" role="paragraph" id="par_id3145271" l10n="U" oldref="6">You can also use the <link href="text/scalc/01/04060000.xhp" name="AutoPilots">Function Wizard</link> to help you create your formulas.</paragraph>
   <paragraph role="heading" level="2" id="hd_id3152596" l10n="U" xml-lang="en-US" oldref="13">What-If Calculations</paragraph>
   <paragraph role="paragraph" id="par_id3156444" l10n="U" xml-lang="en-US" oldref="14">An interesting feature is to be able to immediately view the results of changes made to one factor of calculations that are composed of several factors. For instance, you can see how changing the time period in a loan calculation affects the interest rates or repayment amounts. Furthermore, you can manage larger tables by using different predefined scenarios.</paragraph>

File helpcontent2/source/text/schart/01/04050100.xhp

View file
  • Ignore whitespace
       <paragraph xml-lang="en-US" id="par_id33875" role="paragraph" l10n="NEW">Create a table with the columns x, x², x³, … , xⁿ, y up to the desired degree n. </paragraph>
       <paragraph xml-lang="en-US" id="par_id8720053" role="paragraph" l10n="NEW">Use the formula <item type="literal">=LINEST(Data_Y,Data_X)</item> with the complete range x to xⁿ (without headings) as Data_X. </paragraph>
       <paragraph xml-lang="en-US" id="par_id5068514" role="paragraph" l10n="NEW">The first row of the LINEST output contains the coefficients of the regression polynomial, with the coefficient of xⁿ at the leftmost position.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id8202154" role="paragraph" l10n="NEW">The first element of the third row of the LINEST output is the value of r². See the <link href="text/scalc/01/04060107.xhp#Section8">LINEST</link> function for details on proper use and an explanation of the other output parameters.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id8202154" role="paragraph" l10n="NEW">The first element of the third row of the LINEST output is the value of r². See the <link href="text/scalc/01/main_array.xhp#Section8">LINEST</link> function for details on proper use and an explanation of the other output parameters.</paragraph>
       <section id="relatedtopics">
          <paragraph xml-lang="en-US" id="par_id4562211" role="paragraph" l10n="CHG"><link href="text/schart/01/04050000.xhp">Y Error Bars tab page</link></paragraph>
       </section>

File helpcontent2/source/text/shared/optionen/01060500.xhp

View file
  • Ignore whitespace
 <paragraph role="paragraph" id="par_id3148814" xml-lang="en-US" l10n="U" oldref="44">If <emph>Search criteria = and &lt;&gt; must apply to whole cells </emph>is not enabled, the "win" search pattern acts like ".*win.*". The search pattern can be at any position within the cell when searching with the Calc database functions.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/SC_CHECKBOX_RID_SCPAGE_CALC_BTN_REGEX" id="bm_id3154419" localize="false"/>
 <paragraph role="heading" id="hd_id3156448" xml-lang="en-US" level="2" l10n="U" oldref="58">Enable regular expressions in formulas</paragraph>
-<paragraph role="paragraph" id="par_id3155092" xml-lang="en-US" l10n="U" oldref="59"><ahelp hid="SC_CHECKBOX_RID_SCPAGE_CALC_BTN_REGEX">Specifies that regular expressions are enabled when searching and also for character string comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This relates to the <link href="text/scalc/01/04060101.xhp" name="database functions">database functions</link>, and to VLOOKUP, HLOOKUP and SEARCH. 
+<paragraph role="paragraph" id="par_id3155092" xml-lang="en-US" l10n="U" oldref="59"><ahelp hid="SC_CHECKBOX_RID_SCPAGE_CALC_BTN_REGEX">Specifies that regular expressions are enabled when searching and also for character string comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This relates to the <link href="text/scalc/01/main_database.xhp" name="database functions">database functions</link>, and to VLOOKUP, HLOOKUP and SEARCH. 
 </caseinline></switchinline><comment>Sorry, no more switches allowed inside AVIS tags</comment></paragraph>
 <bookmark xml-lang="en-US" branch="hid/SC:CHECKBOX:RID_SCPAGE_CALC:BTN_LOOKUP" id="bm_id3152901" localize="false"/>
 <paragraph role="heading" id="hd_id3156199" xml-lang="en-US" level="2" l10n="U" oldref="55">Automatically find column and row labels</paragraph>

File helpcontent2/util/scalc/makefile.mk

View file
  • Ignore whitespace
    text$/scalc$/01$/04050000.xhp \
    text$/scalc$/01$/04050100.xhp \
    text$/scalc$/01$/04060000.xhp \
-   text$/scalc$/01$/04060100.xhp \
-   text$/scalc$/01$/04060101.xhp \
-   text$/scalc$/01$/04060102.xhp \
-   text$/scalc$/01$/04060103.xhp \
-   text$/scalc$/01$/04060104.xhp \
-   text$/scalc$/01$/04060105.xhp \
-   text$/scalc$/01$/04060106.xhp \
-   text$/scalc$/01$/04060107.xhp \
-   text$/scalc$/01$/04060108.xhp \
-   text$/scalc$/01$/04060109.xhp \
-   text$/scalc$/01$/04060110.xhp \
-   text$/scalc$/01$/04060111.xhp \
    text$/scalc$/01$/04060112.xhp \
-   text$/scalc$/01$/04060115.xhp \
-   text$/scalc$/01$/04060116.xhp \
-   text$/scalc$/01$/04060118.xhp \
-   text$/scalc$/01$/04060119.xhp \
-   text$/scalc$/01$/04060181.xhp \
-   text$/scalc$/01$/04060182.xhp \
-   text$/scalc$/01$/04060183.xhp \
-   text$/scalc$/01$/04060184.xhp \
-   text$/scalc$/01$/04060185.xhp \
    text$/scalc$/01$/04060199.xhp \
    text$/scalc$/01$/04070000.xhp \
    text$/scalc$/01$/04070100.xhp \
    text$/scalc$/01$/12120100.xhp \
    text$/scalc$/01$/12120200.xhp \
    text$/scalc$/01$/12120300.xhp \
+   text$/scalc$/01$/abs.xhp \
+   text$/scalc$/01$/accrint.xhp \
+   text$/scalc$/01$/accrintm.xhp \
+   text$/scalc$/01$/acos.xhp \
+   text$/scalc$/01$/acosh.xhp \
+   text$/scalc$/01$/acot.xhp \
+   text$/scalc$/01$/acoth.xhp \
+   text$/scalc$/01$/address.xhp \
+   text$/scalc$/01$/amordegrc.xhp \
+   text$/scalc$/01$/amorlinc.xhp \
+   text$/scalc$/01$/and.xhp \
+   text$/scalc$/01$/arabic.xhp \
+   text$/scalc$/01$/areas.xhp \
+   text$/scalc$/01$/asc.xhp \
+   text$/scalc$/01$/asin.xhp \
+   text$/scalc$/01$/asinh.xhp \
+   text$/scalc$/01$/atan.xhp \
+   text$/scalc$/01$/atan2.xhp \
+   text$/scalc$/01$/atanh.xhp \
+   text$/scalc$/01$/avedev.xhp \
+   text$/scalc$/01$/average.xhp \
+   text$/scalc$/01$/averagea.xhp \
+   text$/scalc$/01$/b.xhp \
+   text$/scalc$/01$/bahttext.xhp \
+   text$/scalc$/01$/base.xhp \
+   text$/scalc$/01$/besseli.xhp \
+   text$/scalc$/01$/besselj.xhp \
+   text$/scalc$/01$/besselk.xhp \
+   text$/scalc$/01$/bessely.xhp \
+   text$/scalc$/01$/betadist.xhp \
+   text$/scalc$/01$/betainv.xhp \
+   text$/scalc$/01$/bin2dec.xhp \
+   text$/scalc$/01$/bin2hex.xhp \
+   text$/scalc$/01$/bin2oct.xhp \
+   text$/scalc$/01$/binomdist.xhp \
+   text$/scalc$/01$/ceiling.xhp \
+   text$/scalc$/01$/cell.xhp \
+   text$/scalc$/01$/char.xhp \
+   text$/scalc$/01$/chidist.xhp \
+   text$/scalc$/01$/chiinv.xhp \
+   text$/scalc$/01$/chisqdist.xhp \
+   text$/scalc$/01$/chisqinv.xhp \
+   text$/scalc$/01$/chitest.xhp \
+   text$/scalc$/01$/choose.xhp \
+   text$/scalc$/01$/clean.xhp \
+   text$/scalc$/01$/code.xhp \
+   text$/scalc$/01$/column.xhp \
+   text$/scalc$/01$/columns.xhp \
+   text$/scalc$/01$/combin.xhp \
+   text$/scalc$/01$/combina.xhp \
+   text$/scalc$/01$/complex.xhp \
+   text$/scalc$/01$/concatenate.xhp \
+   text$/scalc$/01$/confidence.xhp \
+   text$/scalc$/01$/convert.xhp \
+   text$/scalc$/01$/convert_add.xhp \
+   text$/scalc$/01$/correl.xhp \
+   text$/scalc$/01$/cos.xhp \
+   text$/scalc$/01$/cosh.xhp \
+   text$/scalc$/01$/cot.xhp \
+   text$/scalc$/01$/coth.xhp \
+   text$/scalc$/01$/count.xhp \
+   text$/scalc$/01$/counta.xhp \
+   text$/scalc$/01$/countblank.xhp \
+   text$/scalc$/01$/countif.xhp \
+   text$/scalc$/01$/coupdaybs.xhp \
+   text$/scalc$/01$/coupdays.xhp \
+   text$/scalc$/01$/coupdaysnc.xhp \
+   text$/scalc$/01$/coupncd.xhp \
+   text$/scalc$/01$/coupnum.xhp \
+   text$/scalc$/01$/couppcd.xhp \
+   text$/scalc$/01$/covar.xhp \
+   text$/scalc$/01$/critbinom.xhp \
+   text$/scalc$/01$/cumipmt.xhp \
+   text$/scalc$/01$/cumipmt_add.xhp \
+   text$/scalc$/01$/cumprinc.xhp \
+   text$/scalc$/01$/cumprinc_add.xhp \
+   text$/scalc$/01$/current.xhp \
+   text$/scalc$/01$/date.xhp \
+   text$/scalc$/01$/datevalue.xhp \
+   text$/scalc$/01$/daverage.xhp \
+   text$/scalc$/01$/day.xhp \
+   text$/scalc$/01$/days.xhp \
+   text$/scalc$/01$/days360.xhp \
+   text$/scalc$/01$/daysinmonth.xhp \
+   text$/scalc$/01$/daysinyear.xhp \
+   text$/scalc$/01$/db.xhp \
+   text$/scalc$/01$/dcount.xhp \
+   text$/scalc$/01$/dcounta.xhp \
+   text$/scalc$/01$/ddb.xhp \
+   text$/scalc$/01$/dde.xhp \
+   text$/scalc$/01$/dec2bin.xhp \
+   text$/scalc$/01$/dec2hex.xhp \
+   text$/scalc$/01$/dec2oct.xhp \
+   text$/scalc$/01$/decimal.xhp \
+   text$/scalc$/01$/degrees.xhp \
+   text$/scalc$/01$/delta.xhp \
+   text$/scalc$/01$/devsq.xhp \
+   text$/scalc$/01$/dget.xhp \
+   text$/scalc$/01$/disc.xhp \
+   text$/scalc$/01$/dmax.xhp \
+   text$/scalc$/01$/dmin.xhp \
+   text$/scalc$/01$/dollar.xhp \
+   text$/scalc$/01$/dollarde.xhp \
+   text$/scalc$/01$/dollarfr.xhp \
+   text$/scalc$/01$/dproduct.xhp \
+   text$/scalc$/01$/dstdev.xhp \
+   text$/scalc$/01$/dstdevp.xhp \
+   text$/scalc$/01$/dsum.xhp \
+   text$/scalc$/01$/duration.xhp \
+   text$/scalc$/01$/duration_add.xhp \
+   text$/scalc$/01$/dvar.xhp \
+   text$/scalc$/01$/dvarp.xhp \
+   text$/scalc$/01$/eastersunday.xhp \
+   text$/scalc$/01$/edate.xhp \
+   text$/scalc$/01$/effect_add.xhp \
+   text$/scalc$/01$/effective.xhp \
+   text$/scalc$/01$/eomonth.xhp \
+   text$/scalc$/01$/erf.xhp \
+   text$/scalc$/01$/erfc.xhp \
+   text$/scalc$/01$/errortype.xhp \
+   text$/scalc$/01$/euroconvert.xhp \
+   text$/scalc$/01$/even.xhp \
+   text$/scalc$/01$/exact.xhp \
+   text$/scalc$/01$/exp.xhp \
+   text$/scalc$/01$/expondist.xhp \
+   text$/scalc$/01$/fact.xhp \
+   text$/scalc$/01$/factdouble.xhp \
+   text$/scalc$/01$/false.xhp \
+   text$/scalc$/01$/fdist.xhp \
+   text$/scalc$/01$/find.xhp \
+   text$/scalc$/01$/finv.xhp \
+   text$/scalc$/01$/fisher.xhp \
+   text$/scalc$/01$/fisherinv.xhp \
+   text$/scalc$/01$/fixed.xhp \
+   text$/scalc$/01$/floor.xhp \
+   text$/scalc$/01$/forecast.xhp \
    text$/scalc$/01$/format_graphic.xhp \
-   text$/scalc$/01$/func_date.xhp \
-   text$/scalc$/01$/func_datevalue.xhp \
-   text$/scalc$/01$/func_day.xhp \
-   text$/scalc$/01$/func_days.xhp \
-   text$/scalc$/01$/func_days360.xhp \
-   text$/scalc$/01$/func_eastersunday.xhp \
-   text$/scalc$/01$/func_edate.xhp \
-   text$/scalc$/01$/func_eomonth.xhp \
-   text$/scalc$/01$/func_hour.xhp \
-   text$/scalc$/01$/func_minute.xhp \
-   text$/scalc$/01$/func_month.xhp \
-   text$/scalc$/01$/func_networkdays.xhp \
-   text$/scalc$/01$/func_now.xhp \
-   text$/scalc$/01$/func_second.xhp \
-   text$/scalc$/01$/func_time.xhp \
-   text$/scalc$/01$/func_timevalue.xhp \
-   text$/scalc$/01$/func_today.xhp \
-   text$/scalc$/01$/func_weekday.xhp \
-   text$/scalc$/01$/func_weeknum.xhp \
-   text$/scalc$/01$/func_weeknumadd.xhp \
-   text$/scalc$/01$/func_workday.xhp \
-   text$/scalc$/01$/func_year.xhp \
-   text$/scalc$/01$/func_yearfrac.xhp \
+   text$/scalc$/01$/formula.xhp \
+   text$/scalc$/01$/frequency.xhp \
+   text$/scalc$/01$/ftest.xhp \
+   text$/scalc$/01$/fv.xhp \
+   text$/scalc$/01$/fvschedule.xhp \
+   text$/scalc$/01$/gamma.xhp \
+   text$/scalc$/01$/gammadist.xhp \
+   text$/scalc$/01$/gammainv.xhp \
+   text$/scalc$/01$/gammaln.xhp \
+   text$/scalc$/01$/gauss.xhp \
+   text$/scalc$/01$/gcd.xhp \
+   text$/scalc$/01$/gcd_add.xhp \
+   text$/scalc$/01$/geomean.xhp \
+   text$/scalc$/01$/gestep.xhp \
+   text$/scalc$/01$/getpivotdata.xhp \
+   text$/scalc$/01$/growth.xhp \
+   text$/scalc$/01$/harmean.xhp \
+   text$/scalc$/01$/hex2bin.xhp \
+   text$/scalc$/01$/hex2dec.xhp \
+   text$/scalc$/01$/hex2oct.xhp \
+   text$/scalc$/01$/hlookup.xhp \
+   text$/scalc$/01$/hour.xhp \
+   text$/scalc$/01$/hyperlink.xhp \
+   text$/scalc$/01$/hypgeomdist.xhp \
+   text$/scalc$/01$/if.xhp \
+   text$/scalc$/01$/imabs.xhp \
+   text$/scalc$/01$/imaginary.xhp \
+   text$/scalc$/01$/imargument.xhp \
+   text$/scalc$/01$/imconjugate.xhp \
+   text$/scalc$/01$/imcos.xhp \
+   text$/scalc$/01$/imdiv.xhp \
+   text$/scalc$/01$/imexp.xhp \
+   text$/scalc$/01$/imln.xhp \
+   text$/scalc$/01$/imlog10.xhp \
+   text$/scalc$/01$/imlog2.xhp \
+   text$/scalc$/01$/impower.xhp \
+   text$/scalc$/01$/improduct.xhp \
+   text$/scalc$/01$/imreal.xhp \
+   text$/scalc$/01$/imsin.xhp \
+   text$/scalc$/01$/imsqrt.xhp \
+   text$/scalc$/01$/imsub.xhp \
+   text$/scalc$/01$/imsum.xhp \
+   text$/scalc$/01$/index.xhp \
+   text$/scalc$/01$/indirect.xhp \
+   text$/scalc$/01$/info.xhp \
+   text$/scalc$/01$/int.xhp \
+   text$/scalc$/01$/intercept.xhp \
+   text$/scalc$/01$/intrate.xhp \
+   text$/scalc$/01$/ipmt.xhp \
+   text$/scalc$/01$/irr.xhp \
+   text$/scalc$/01$/isblank.xhp \
+   text$/scalc$/01$/iserr.xhp \
+   text$/scalc$/01$/iserror.xhp \
+   text$/scalc$/01$/iseven.xhp \
+   text$/scalc$/01$/iseven_add.xhp \
+   text$/scalc$/01$/isformula.xhp \
+   text$/scalc$/01$/isleapyear.xhp \
+   text$/scalc$/01$/islogical.xhp \
+   text$/scalc$/01$/isna.xhp \
+   text$/scalc$/01$/isnontext.xhp \
+   text$/scalc$/01$/isnumber.xhp \
+   text$/scalc$/01$/isodd.xhp \
+   text$/scalc$/01$/isodd_add.xhp \
+   text$/scalc$/01$/ispmt.xhp \
+   text$/scalc$/01$/isref.xhp \
+   text$/scalc$/01$/istext.xhp \
+   text$/scalc$/01$/jis.xhp \
+   text$/scalc$/01$/kurt.xhp \
+   text$/scalc$/01$/large.xhp \
+   text$/scalc$/01$/lcm.xhp \
+   text$/scalc$/01$/lcm_add.xhp \
+   text$/scalc$/01$/left.xhp \
+   text$/scalc$/01$/len.xhp \
+   text$/scalc$/01$/linest.xhp \
+   text$/scalc$/01$/ln.xhp \
+   text$/scalc$/01$/log.xhp \
+   text$/scalc$/01$/log10.xhp \
+   text$/scalc$/01$/logest.xhp \
+   text$/scalc$/01$/loginv.xhp \
+   text$/scalc$/01$/lognormdist.xhp \
+   text$/scalc$/01$/lookup.xhp \
+   text$/scalc$/01$/lower.xhp \
+   text$/scalc$/01$/main_add-in.xhp \
+   text$/scalc$/01$/main_array.xhp \
+   text$/scalc$/01$/main_complex.xhp \
+   text$/scalc$/01$/main_convert.xhp \
+   text$/scalc$/01$/main_database.xhp \
+   text$/scalc$/01$/main_date_time.xhp \
+   text$/scalc$/01$/main_financial.xhp \
+   text$/scalc$/01$/main_functions.xhp \
+   text$/scalc$/01$/main_information.xhp \
+   text$/scalc$/01$/main_logical.xhp \
+   text$/scalc$/01$/main_mathematical.xhp \
+   text$/scalc$/01$/main_spreadsheet.xhp \
+   text$/scalc$/01$/main_statistical.xhp \
+   text$/scalc$/01$/main_text.xhp \
+   text$/scalc$/01$/match.xhp \
+   text$/scalc$/01$/max.xhp \
+   text$/scalc$/01$/maxa.xhp \
+   text$/scalc$/01$/mdeterm.xhp \
+   text$/scalc$/01$/mduration.xhp \
+   text$/scalc$/01$/median.xhp \
+   text$/scalc$/01$/mid.xhp \
+   text$/scalc$/01$/min.xhp \
+   text$/scalc$/01$/mina.xhp \
+   text$/scalc$/01$/minute.xhp \
+   text$/scalc$/01$/minverse.xhp \
+   text$/scalc$/01$/mirr.xhp \
+   text$/scalc$/01$/mmult.xhp \
+   text$/scalc$/01$/mod.xhp \
+   text$/scalc$/01$/mode.xhp \
+   text$/scalc$/01$/month.xhp \
+   text$/scalc$/01$/months.xhp \
+   text$/scalc$/01$/mround.xhp \
+   text$/scalc$/01$/multinomial.xhp \
+   text$/scalc$/01$/munit.xhp \
+   text$/scalc$/01$/n.xhp \
+   text$/scalc$/01$/na.xhp \
+   text$/scalc$/01$/negbinomdist.xhp \
+   text$/scalc$/01$/networkdays.xhp \
+   text$/scalc$/01$/nominal.xhp \
+   text$/scalc$/01$/nominal_add.xhp \
+   text$/scalc$/01$/normdist.xhp \
+   text$/scalc$/01$/norminv.xhp \
+   text$/scalc$/01$/normsdist.xhp \
+   text$/scalc$/01$/normsinv.xhp \
+   text$/scalc$/01$/not.xhp \
+   text$/scalc$/01$/now.xhp \
+   text$/scalc$/01$/nper.xhp \
+   text$/scalc$/01$/npv.xhp \
+   text$/scalc$/01$/oct2bin.xhp \
+   text$/scalc$/01$/oct2dec.xhp \
+   text$/scalc$/01$/oct2hex.xhp \
+   text$/scalc$/01$/odd.xhp \
+   text$/scalc$/01$/oddfprice.xhp \
+   text$/scalc$/01$/oddfyield.xhp \
+   text$/scalc$/01$/oddlprice.xhp \
+   text$/scalc$/01$/oddlyield.xhp \
+   text$/scalc$/01$/offset.xhp \
+   text$/scalc$/01$/or.xhp \
+   text$/scalc$/01$/pearson.xhp \
+   text$/scalc$/01$/percentile.xhp \
+   text$/scalc$/01$/percentrank.xhp \
+   text$/scalc$/01$/permut.xhp \
+   text$/scalc$/01$/permutationa.xhp \
+   text$/scalc$/01$/phi.xhp \
+   text$/scalc$/01$/pi.xhp \
+   text$/scalc$/01$/pmt.xhp \
+   text$/scalc$/01$/poisson.xhp \
+   text$/scalc$/01$/power.xhp \
+   text$/scalc$/01$/ppmt.xhp \
+   text$/scalc$/01$/price.xhp \
+   text$/scalc$/01$/pricedisc.xhp \
+   text$/scalc$/01$/pricemat.xhp \
+   text$/scalc$/01$/prob.xhp \
+   text$/scalc$/01$/product.xhp \
+   text$/scalc$/01$/proper.xhp \
+   text$/scalc$/01$/pv.xhp \
+   text$/scalc$/01$/quartile.xhp \
+   text$/scalc$/01$/quotient.xhp \
+   text$/scalc$/01$/radians.xhp \
+   text$/scalc$/01$/rand.xhp \
+   text$/scalc$/01$/randbetween.xhp \
+   text$/scalc$/01$/rank.xhp \
+   text$/scalc$/01$/rate.xhp \
+   text$/scalc$/01$/received.xhp \
+   text$/scalc$/01$/replace.xhp \
+   text$/scalc$/01$/rept.xhp \
+   text$/scalc$/01$/right.xhp \
+   text$/scalc$/01$/roman.xhp \
+   text$/scalc$/01$/rot13.xhp \
+   text$/scalc$/01$/round.xhp \
+   text$/scalc$/01$/rounddown.xhp \
+   text$/scalc$/01$/roundup.xhp \
+   text$/scalc$/01$/row.xhp \
+   text$/scalc$/01$/rows.xhp \
+   text$/scalc$/01$/rri.xhp \
+   text$/scalc$/01$/rsq.xhp \
+   text$/scalc$/01$/search.xhp \
+   text$/scalc$/01$/second.xhp \
+   text$/scalc$/01$/seriessum.xhp \
+   text$/scalc$/01$/sheet.xhp \
+   text$/scalc$/01$/sheets.xhp \
+   text$/scalc$/01$/sign.xhp \
+   text$/scalc$/01$/sin.xhp \
+   text$/scalc$/01$/sinh.xhp \
+   text$/scalc$/01$/skew.xhp \
+   text$/scalc$/01$/sln.xhp \
+   text$/scalc$/01$/slope.xhp \
+   text$/scalc$/01$/small.xhp \
    text$/scalc$/01$/solver.xhp \
    text$/scalc$/01$/solver_options.xhp \
+   text$/scalc$/01$/sqrt.xhp \
+   text$/scalc$/01$/sqrtpi.xhp \
+   text$/scalc$/01$/standardize.xhp \
+   text$/scalc$/01$/stdev.xhp \
+   text$/scalc$/01$/stdeva.xhp \
+   text$/scalc$/01$/stdevp.xhp \
+   text$/scalc$/01$/stdevpa.xhp \
+   text$/scalc$/01$/steyx.xhp \
+   text$/scalc$/01$/style.xhp \
+   text$/scalc$/01$/substitute.xhp \
+   text$/scalc$/01$/subtotal.xhp \
+   text$/scalc$/01$/sum.xhp \
+   text$/scalc$/01$/sumif.xhp \
+   text$/scalc$/01$/sumproduct.xhp \
+   text$/scalc$/01$/sumsq.xhp \
+   text$/scalc$/01$/sumx2my2.xhp \
+   text$/scalc$/01$/sumx2py2.xhp \
+   text$/scalc$/01$/sumxmy2.xhp \
+   text$/scalc$/01$/syd.xhp \
+   text$/scalc$/01$/t.xhp \
+   text$/scalc$/01$/tan.xhp \
+   text$/scalc$/01$/tanh.xhp \
+   text$/scalc$/01$/tbilleq.xhp \
+   text$/scalc$/01$/tbillprice.xhp \
+   text$/scalc$/01$/tbillyield.xhp \
+   text$/scalc$/01$/tdist.xhp \
+   text$/scalc$/01$/text.xhp \
    text$/scalc$/01$/text2columns.xhp \
+   text$/scalc$/01$/time.xhp \
+   text$/scalc$/01$/timevalue.xhp \
+   text$/scalc$/01$/tinv.xhp \
+   text$/scalc$/01$/today.xhp \
+   text$/scalc$/01$/transpose.xhp \
+   text$/scalc$/01$/trend.xhp \
+   text$/scalc$/01$/trim.xhp \
+   text$/scalc$/01$/trimmean.xhp \
+   text$/scalc$/01$/true.xhp \
+   text$/scalc$/01$/trunc.xhp \
+   text$/scalc$/01$/ttest.xhp \
+   text$/scalc$/01$/type.xhp \
+   text$/scalc$/01$/unichar.xhp \
+   text$/scalc$/01$/unicode.xhp \
+   text$/scalc$/01$/upper.xhp \
+   text$/scalc$/01$/value.xhp \
+   text$/scalc$/01$/var.xhp \
+   text$/scalc$/01$/vara.xhp \
+   text$/scalc$/01$/varp.xhp \
+   text$/scalc$/01$/varpa.xhp \
+   text$/scalc$/01$/vdb.xhp \
+   text$/scalc$/01$/vlookup.xhp \
+   text$/scalc$/01$/weekday.xhp \
+   text$/scalc$/01$/weeknum.xhp \
+   text$/scalc$/01$/weeknum_add.xhp \
+   text$/scalc$/01$/weeks.xhp \
+   text$/scalc$/01$/weeksinyear.xhp \
+   text$/scalc$/01$/weibull.xhp \
+   text$/scalc$/01$/workday.xhp \
+   text$/scalc$/01$/xirr.xhp \
+   text$/scalc$/01$/xnpv.xhp \
+   text$/scalc$/01$/year.xhp \
+   text$/scalc$/01$/yearfrac.xhp \
+   text$/scalc$/01$/years.xhp \
+   text$/scalc$/01$/yield.xhp \
+   text$/scalc$/01$/yielddisc.xhp \
+   text$/scalc$/01$/yieldmat.xhp \
+   text$/scalc$/01$/ztest.xhp \
    text$/scalc$/02$/02130000.xhp \
    text$/scalc$/02$/02140000.xhp \
    text$/scalc$/02$/02150000.xhp \
    text$/scalc$/guide$/multioperation.xhp \
    text$/scalc$/guide$/multitables.xhp \
    text$/scalc$/guide$/note_insert.xhp \
+   text$/scalc$/guide$/numbers_text.xhp \
    text$/scalc$/guide$/print_details.xhp \
    text$/scalc$/guide$/print_exact.xhp \
    text$/scalc$/guide$/print_landscape.xhp \