From c1c2a9e4a98939e3229813b40101cdf99a8cf346 Mon Sep 17 00:00:00 2001 From: Caolán McNamara Date: Thu, 16 May 2013 15:22:08 +0100 Subject: update help ids for calculation opt page .ui conversion Change-Id: I45a3e8154d4e84a548f03393f41fdee6f21f9c85 --- source/text/shared/optionen/01060500.xhp | 55 ++++++++++++++++---------------- 1 file changed, 27 insertions(+), 28 deletions(-) (limited to 'source/text') diff --git a/source/text/shared/optionen/01060500.xhp b/source/text/shared/optionen/01060500.xhp index 34874ba84e..ffbad49736 100644 --- a/source/text/shared/optionen/01060500.xhp +++ b/source/text/shared/optionen/01060500.xhp @@ -43,7 +43,7 @@ search criteria for database functions in cells Excel; search criteria UFI: removed a double entrymw changed "cell contents;" to "case sensitivity;.."mw deleted "numbers;decimal places (Calc)" - + Calculate Defines the calculation settings for spreadsheets. Defines the behavior of spreadsheets with iterative references, the date settings, the number of decimal places, and if capitalization or lower cases are to be considered when searching within sheets. @@ -52,9 +52,9 @@ Iterative references In this section you can delimit the number of approximation steps carried out during iterative calculations. In addition, you can specify the degree of precision of the answer. - + Iterations - Specifies whether formulas with iterative references (formulas that are continuously repeated until the problem is solved) are calculated after a specific number of repetitions. If the Iterations box is not marked, an iterative reference in the table will cause an error message. + Specifies whether formulas with iterative references (formulas that are continuously repeated until the problem is solved) are calculated after a specific number of repetitions. If the Iterations box is not marked, an iterative reference in the table will cause an error message. Example: calculating the cost of an item without the value-added tax. @@ -117,44 +117,44 @@ - + Steps - Sets the maximum number of iteration steps. - + Sets the maximum number of iteration steps. + Minimum Change - Specifies the difference between two consecutive iteration step results. If the result of the iteration is lower than the minimum change value, then the iteration will stop. + Specifies the difference between two consecutive iteration step results. If the result of the iteration is lower than the minimum change value, then the iteration will stop. Date Select the start date for the internal conversion from days to numbers. - + 12/30/1899 (default) - Sets 12/30/1899 as day zero. - + Sets 12/30/1899 as day zero. + 01/01/1900 (StarCalc 1.0) - Sets 1/1/1900 as day zero. Use this setting for StarCalc 1.0 spreadsheets containing date entries. - + Sets 1/1/1900 as day zero. Use this setting for StarCalc 1.0 spreadsheets containing date entries. + 01/01/1904 - Sets 1/1/1904 as day zero. Use this setting for spreadsheets that are imported in a foreign format. - + Sets 1/1/1904 as day zero. Use this setting for spreadsheets that are imported in a foreign format. + Case sensitive - Specifies whether to distinguish between upper and lower case in texts when comparing cell contents. + Specifies whether to distinguish between upper and lower case in texts when comparing cell contents. Example: Type the text 'Test' in cell A1; and the text 'test' in B1. Then type the formula "=A1=B1" in cell C1. If the Case sensitive box is marked, FALSE will appear in the cell; otherwise, TRUE will appear in the cell. The EXACT text function is always case-sensitive, independent of the settings in this dialog. - + Precision as shown - Specifies whether to make calculations using the rounded values displayed in the sheet. Charts will be shown with the displayed values. If the Precision as shown option is not marked, the displayed numbers are rounded, but they are calculated internally using the non-rounded number. - + Specifies whether to make calculations using the rounded values displayed in the sheet. Charts will be shown with the displayed values. If the Precision as shown option is not marked, the displayed numbers are rounded, but they are calculated internally using the non-rounded number. + Search criteria = and <> must apply to whole cells - Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly. When the Search criteria = and <> must apply to whole cells box is marked, $[officename] Calc behaves exactly as MS Excel when searching cells in the database functions. + Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly. When the Search criteria = and <> must apply to whole cells box is marked, $[officename] Calc behaves exactly as MS Excel when searching cells in the database functions. @@ -199,26 +199,25 @@
If Search criteria = and <> must apply to whole cells 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. - + Enable regular expressions in formulas - Specifies that regular expressions are enabled when searching and also for character string comparisons. This relates to the database functions, and to VLOOKUP, HLOOKUP and SEARCH. + Specifies that regular expressions are enabled when searching and also for character string comparisons. This relates to the database functions, and to VLOOKUP, HLOOKUP and SEARCH. Sorry, no more switches allowed inside AVIS tags - + Automatically find column and row labels - Specifies that you can use the text in any cell as a label for the column below the text or the row to the right of the text. The text must consist of at least one word and must not contain any operators. + Specifies that you can use the text in any cell as a label for the column below the text or the row to the right of the text. The text must consist of at least one word and must not contain any operators. Example: Cell E5 contains the text "Europe". Below, in cell E6, is the value 100 and in cell E7 the value 200. If the Automatically find column and row labels box is marked, you can write the following formula in cell A1: =SUM(Europe). - - + Limit decimals for general number format You can specify the maximum number of decimal places that are shown by default for cells with General number format. If not enabled, cells with General number format show as many decimal places as the column width allows. - + Decimal places - Defines the number of decimals to be displayed for numbers with the Standard number format. The numbers are displayed as rounded numbers, but are not saved as rounded numbers. + Defines the number of decimals to be displayed for numbers with the Standard number format. The numbers are displayed as rounded numbers, but are not saved as rounded numbers. - \ No newline at end of file + -- cgit