From f93153f617a109f1249802a49ce747b64faaeab4 Mon Sep 17 00:00:00 2001 From: Uwe Fischer Date: Fri, 16 Oct 2009 08:59:46 +0000 Subject: Zwischenstand --- helpcontent2/source/text/scalc/01/04060106.xhp | 8 +- helpcontent2/source/text/scalc/01/04060109.xhp | 1 - .../source/text/scalc/guide/format_value.xhp | 110 +++--- .../text/scalc/guide/format_value_userdef.xhp | 224 ++++++------ .../text/scalc/guide/integer_leading_zero.xhp | 144 ++++---- .../source/text/scalc/guide/numbers_text.xhp | 13 +- .../source/text/scalc/guide/text_numbers.xhp | 9 +- helpcontent2/source/text/schart/01/04030000.xhp | 25 +- helpcontent2/source/text/shared/00/00000021.xhp | 6 +- helpcontent2/source/text/shared/00/00040502.xhp | 2 +- helpcontent2/source/text/shared/01/02100001.xhp | 22 +- helpcontent2/source/text/shared/01/05020301.xhp | 4 +- helpcontent2/source/text/shared/01/05340100.xhp | 63 ++-- .../text/shared/explorer/database/30000000.xhp | 84 +---- .../source/text/shared/guide/digitalsign_send.xhp | 2 +- .../source/text/shared/guide/scripting.xhp | 390 ++++++++++----------- .../source/text/shared/optionen/01010600.xhp | 125 +++---- .../source/text/shared/optionen/01060500.xhp | 361 +++++++++---------- .../source/text/shared/optionen/01130100.xhp | 127 +++---- helpcontent2/source/text/smath/01/03090000.xhp | 2 +- helpcontent2/source/text/swriter/01/04090200.xhp | 104 +++--- .../source/text/swriter/guide/auto_off.xhp | 8 +- .../source/text/swriter/guide/search_regexp.xhp | 112 +++--- .../source/text/swriter/guide/tablemode.xhp | 32 +- .../source/text/swriter/guide/template_default.xhp | 10 +- .../text/swriter/guide/word_completion_adjust.xhp | 50 +-- 26 files changed, 984 insertions(+), 1054 deletions(-) (limited to 'helpcontent2/source/text') diff --git a/helpcontent2/source/text/scalc/01/04060106.xhp b/helpcontent2/source/text/scalc/01/04060106.xhp index 0774564c79..d8bcbea6f3 100644 --- a/helpcontent2/source/text/scalc/01/04060106.xhp +++ b/helpcontent2/source/text/scalc/01/04060106.xhp @@ -740,14 +740,14 @@ oldref="640">Example POWER -Returns a number raised to a power. +Returns a number raised to another number. Syntax -POWER(Base; Power) -Returns Base raised to the power of Power. +POWER(Base; Exponent) +Returns Base raised to the power of Exponent. The same result may be achieved by using the exponentiation operator ^: -Base^Power +Base^Exponent Example diff --git a/helpcontent2/source/text/scalc/01/04060109.xhp b/helpcontent2/source/text/scalc/01/04060109.xhp index ab90880518..7f75839ecb 100644 --- a/helpcontent2/source/text/scalc/01/04060109.xhp +++ b/helpcontent2/source/text/scalc/01/04060109.xhp @@ -243,7 +243,6 @@ A1 (optional) - if set to 0, the R1C1 notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used. If you open an Excel spreadsheet that uses indirect addresses calculated from string functions, the sheet addresses will not be translated automatically. For example, the Excel address in INDIRECT("filename!sheetname"&B1) is not converted into the Calc address in INDIRECT("filename.sheetname"&B1).UFI: for #i34465# - INDIRECT cannot resolve range names as in INDIRECT("RangeName").i83070 Example diff --git a/helpcontent2/source/text/scalc/guide/format_value.xhp b/helpcontent2/source/text/scalc/guide/format_value.xhp index 842362762f..7d97cabc0d 100644 --- a/helpcontent2/source/text/scalc/guide/format_value.xhp +++ b/helpcontent2/source/text/scalc/guide/format_value.xhp @@ -1,8 +1,8 @@ - - + + + - - -Formatting Numbers With Decimals -/text/scalc/guide/format_value.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - - - -numbers; formatting in tables -formats; numbers in tables -tables; number formats -defaults; number formats in spreadsheets -decimal places;formatting numbers -formatting;numbers with decimals -formatting;adding/deleting decimal places -number formats; adding/deleting decimal places in cells -deleting; decimal places -decimal places; adding/deleting -mw changed one index entrymw inserted three index entries from scalc/02/02160000.xhp and three index entries from scalc/02/02170000.xhp. Then changed three index entries and deleted two.mw deleted one "number formats;..." entry and changed the other -Formatting Numbers With Decimals + + Formatting Numbers With Decimals + /text/scalc/guide/format_value.xhp + + + +numbers;formatting decimals + formats; numbers in tables + tables; number formats + defaults; number formats in spreadsheets + decimal places;formatting numbers + formatting;numbers with decimals + formatting;adding/deleting decimal places + number formats; adding/deleting decimal places in cells + deleting; decimal places + decimal places; adding/deleting +mw changed "numbers;" +Formatting Numbers With Decimals -Enter a number into the sheet, for example, 1234.5678. This number will be displayed in the default number format, with two decimal places. You will see 1234.57 when you confirm the entry. Only the display in the document will be rounded off; internally, the number retains all four decimal places after the decimal point. -To format numbers with decimals: - - -Set the cursor at the number and choose Format - Cells to start the Format Cells dialog. - - -On the Numbers tab you will see a selection of predefined number formats. In the bottom right in the dialog you will see a preview of how your current number would look if you were to give it a particular format. - - - - - - -Icon + Enter a number into the sheet, for example, 1234.5678. This number will be displayed in the default number format, with two decimal places. You will see 1234.57 when you confirm the entry. Only the display in the document will be rounded off; internally, the number retains all four decimal places after the decimal point. + To format numbers with decimals: + + + Set the cursor at the number and choose Format - Cells to start the Format Cells dialog. + + + On the Numbers tab you will see a selection of predefined number formats. In the bottom right in the dialog you will see a preview of how your current number would look if you were to give it a particular format. + + +
+ + + +Icon - - -If you only want to modify the number of the decimal places displayed, the easiest method is to use the Number Format: Add Decimal Place or Number Format: Delete Decimal Place icons on the Formatting Bar. - - -
+ + + If you only want to modify the number of the decimal places displayed, the easiest method is to use the Number Format: Add Decimal Place or Number Format: Delete Decimal Place icons on the Formatting Bar. + + + -
- - - - -
- - +
+ + + + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/format_value_userdef.xhp b/helpcontent2/source/text/scalc/guide/format_value_userdef.xhp index 659656e40c..1144320d0d 100755 --- a/helpcontent2/source/text/scalc/guide/format_value_userdef.xhp +++ b/helpcontent2/source/text/scalc/guide/format_value_userdef.xhp @@ -1,9 +1,8 @@ - - - + + - - - + + - -User-defined Number Formats -/text/scalc/guide/format_value_userdef.xhp - - - - - - -numbers; user-defined formatting in tables -formatting; user-defined numbers -number formats; millions -format codes; user-defined number formats - - mw copied "format codes;" from shared/01/05020300.xhp - User-defined Number Formats + + User-defined Number Formats + /text/scalc/guide/format_value_userdef.xhp + + + +numbers;user-defined formatting + formatting; user-defined numbers + number formats; millions + format codes; user-defined number formats +mw changed "numbers;" +User-defined Number Formats - You can define your own number formats to display numbers in %PRODUCTNAME Calc. - As an example, to display the number 10,200,000 as 10.2 Million: - - - Select the cells to which you want to apply a new, user-defined format. - - - Choose Format - Cells - Numbers. - - - In the Categories list box select "User-defined". - - - In the Format code text box enter the following code: - 0.0,, "Million" - - - Click OK. - - - The following table shows the effects of rounding, thousands delimiters (,), decimal delimiters (.) and the placeholders # and 0. - - - - - - Number - - - .#,, "Million" - - - 0.0,, "Million" - - - #,, "Million" - - - - - 10200000 - - - 10.2 Million - - - 10.2 Million - - - 10 Million - - - - - 500000 - - - .5 Million - - - 0.5 Million - - - 1 Million - - - - - 100000000 - - - 100. Million - - - 100.0 Million - - - 100 Million - - -
-
- - - - - - -
- - + You can define your own number formats to display numbers in %PRODUCTNAME Calc. + As an example, to display the number 10,200,000 as 10.2 Million: + + + Select the cells to which you want to apply a new, user-defined format. + + + Choose Format - Cells - Numbers. + + + In the Categories list box select "User-defined". + + + In the Format code text box enter the following code: + 0.0,, "Million" + + + Click OK. + + + The following table shows the effects of rounding, thousands delimiters (,), decimal delimiters (.) and the placeholders # and 0. + + + + Number + + + .#,, "Million" + + + 0.0,, "Million" + + + #,, "Million" + + + + + 10200000 + + + 10.2 Million + + + 10.2 Million + + + 10 Million + + + + + 500000 + + + .5 Million + + + 0.5 Million + + + 1 Million + + + + + 100000000 + + + 100. Million + + + 100.0 Million + + + 100 Million + + +
+ +
+ + + + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/integer_leading_zero.xhp b/helpcontent2/source/text/scalc/guide/integer_leading_zero.xhp index 9612575904..ed941f9763 100755 --- a/helpcontent2/source/text/scalc/guide/integer_leading_zero.xhp +++ b/helpcontent2/source/text/scalc/guide/integer_leading_zero.xhp @@ -1,9 +1,8 @@ - - - + + - - - + + - -Entering a Number with Leading Zeros -/text/scalc/guide/integer_leading_zero.xhp - - - + + Entering a Number with Leading Zeros + /text/scalc/guide/integer_leading_zero.xhp + + + zero values; entering leading zeros -numbers; with leading zeros -leading zeros -integers with leading zeros -numbers; changing text/number formats -cells; changing text/number formats -formats; changing text/number -text in cells; changing to numbers -converting; text to numbers -UFI: inserted "converting;text to numbers"Entering a Number with Leading Zeros + numbers; with leading zeros + leading zeros + integers with leading zeros + cells; changing text/number formats + formats; changing text/number + text in cells; changing to numbers + converting;text with leading zeros, into numbers +UFI: inserted "converting;text to numbers"mw changed "converting;" and deleted "numbers,changing..." +Entering a Number with Leading Zeros -
-There are various ways to enter integers starting with a zero: - - -Enter the number as text. The easiest way is to enter the number starting with an apostrophe (for example, '0987). The apostrophe will not appear in the cell, and the number will be formatted as text. Because it is in text format, however, you cannot calculate with this number. - - -Format a cell with a number format such as \0000. This format can be assigned in the Format code field under the Format - Cells - Numbers tab, and defines the cell display as "always put a zero first and then the integer, having at least three places, and filled with zeros at the left if less than three digits". - - - -If you want to apply a numerical format to a column of numbers in text format (for example, text "000123" becomes number "123"), do the following: - - -Select the column in which the digits are found in text format. Set the cell format in that column as "Number". - - -Choose Edit - Find & Replace - - - -In the Search for box, enter ^[0-9] - - - -In the Replace with box, enter & - - - -Check Regular expressions - - - -Check Current selection only - - - -Click Replace All - - - -
-
- - -
- - +
+ There are various ways to enter integers starting with a zero: + + + Enter the number as text. The easiest way is to enter the number starting with an apostrophe (for example, '0987). The apostrophe will not appear in the cell, and the number will be formatted as text. Because it is in text format, however, you cannot calculate with this number. + + + Format a cell with a number format such as \0000. This format can be assigned in the Format code field under the Format - Cells - Numbers tab, and defines the cell display as "always put a zero first and then the integer, having at least three places, and filled with zeros at the left if less than three digits". + + + + If you want to apply a numerical format to a column of numbers in text format (for example, text "000123" becomes number "123"), do the following: + + + Select the column in which the digits are found in text format. Set the cell format in that column as "Number". + + + Choose Edit - Find & Replace + + + + In the Search for box, enter ^[0-9] + + + + In the Replace with box, enter & + + + + Check Regular expressions + + + + Check Current selection only + + + + Click Replace All + + + +
+
+ + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/numbers_text.xhp b/helpcontent2/source/text/scalc/guide/numbers_text.xhp index 5d8e0a1636..b5d5299423 100644 --- a/helpcontent2/source/text/scalc/guide/numbers_text.xhp +++ b/helpcontent2/source/text/scalc/guide/numbers_text.xhp @@ -41,9 +41,11 @@ -converting;text to numbers -formats; text as numbers - +formats; text as numbers + time format conversion + date formats;conversion + converting;text, into numbers +mw changed "converting;" and added two index entries Converting Text to Numbers
@@ -84,9 +86,12 @@ If only a time string is given, it may have an hours value of more than 24, while minutes and seconds can have a maximum value of 59. The conversion is done for single arguments only, as in =A1+A2, or ="1E2"+1. Cell range arguments are not affected, so SUM(A1:A2) differs from A1+A2 if at least one of the two cells contain a convertible string. Strings inside formulas are also converted, such as in ="1999-11-22"+42, which returns the date 42 days after November 22nd, 1999. Calculations involving localized dates as strings inside the formula return an error. For example, the localized date string "11/22/1999" or "22.11.1999" cannot be used for the automatic conversion. + Example + In A1 enter the text '1e2 (which is converted to the number 100 internally). + In A2 enter =A1+1 (which correctly results in 101).
- + Format - Cells - Numbers diff --git a/helpcontent2/source/text/scalc/guide/text_numbers.xhp b/helpcontent2/source/text/scalc/guide/text_numbers.xhp index 940a88fdf8..37ccfb1ad4 100644 --- a/helpcontent2/source/text/scalc/guide/text_numbers.xhp +++ b/helpcontent2/source/text/scalc/guide/text_numbers.xhp @@ -41,13 +41,12 @@ -numbers; as text +numbers;entering as text text formats; for numbers - numbers; entering without number formats formats; numbers as text cell formats; text/numbers formatting;numbers as text - +mw deleted "numbers; entering without..." and changed "numbers;as text" Formatting Numbers as Text @@ -57,8 +56,8 @@ If you decide to enter a number directly as text, enter an apostrophe (') first. For example, for years in column headings, you can enter '1999, '2000 and '2001. The apostrophe is not visible in the cell, it only indicates that the entry is to be recognized as a text. This is useful if, for example, you enter a telephone number or postal code that begins with a zero (0), because a zero (0) at the start of a sequence of digits is removed in normal number formats.
- - + + Format - Cells - Numbers
diff --git a/helpcontent2/source/text/schart/01/04030000.xhp b/helpcontent2/source/text/schart/01/04030000.xhp index 20ef489737..68c33ce303 100644 --- a/helpcontent2/source/text/schart/01/04030000.xhp +++ b/helpcontent2/source/text/schart/01/04030000.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.8 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -64,41 +64,46 @@ -Show value as number Displays the absolute values of the data points. -Number format +Number format Opens a dialog to select the number format. -Show value as percentage Displays the percentage of the data points in each column. -Percentage format +Percentage format Opens a dialog to select the percentage format. -Show category Shows the data point text labels. -Show legend key Displays the legend icons next to each data point label. -Separator +Separator Selects the separator between multiple text strings for the same object. -Placement +Placement Selects the placement of data labels relative to the objects. -Text Direction +Text Direction Specify the text direction for a paragraph that uses complex text layout (CTL). This feature is only available if complex text layout support is enabled. + +Rotate Text + Click in the dial to set the text orientation for the data labels. + +Enter the rotation angle for the data labels. A positive number rotates the text to the left and a negative number rotates the text to the right. \ No newline at end of file diff --git a/helpcontent2/source/text/shared/00/00000021.xhp b/helpcontent2/source/text/shared/00/00000021.xhp index a4b810299a..cb699afc17 100755 --- a/helpcontent2/source/text/shared/00/00000021.xhp +++ b/helpcontent2/source/text/shared/00/00000021.xhp @@ -226,7 +226,7 @@ ODF 1.2 - to be announced + - OpenOffice.org 3 or StarOffice 9 @@ -234,10 +234,10 @@ - ODF 1.2 enhanced + ODF 1.2 (Extended) - to be announced + - OpenOffice.org 3.2 or StarOffice 9.2 diff --git a/helpcontent2/source/text/shared/00/00040502.xhp b/helpcontent2/source/text/shared/00/00040502.xhp index d6fcd04818..0083ec417e 100644 --- a/helpcontent2/source/text/shared/00/00040502.xhp +++ b/helpcontent2/source/text/shared/00/00040502.xhp @@ -227,7 +227,7 @@ Choose Format - Object - Graphic - -Position and Size - Legend tab (only for textbox callouts, not for custom shapes callouts) +Position and Size - Callout tab (only for textbox callouts, not for custom shapes callouts)
Choose Edit - Points diff --git a/helpcontent2/source/text/shared/01/02100001.xhp b/helpcontent2/source/text/shared/01/02100001.xhp index 533a05b40d..79eb1411a1 100755 --- a/helpcontent2/source/text/shared/01/02100001.xhp +++ b/helpcontent2/source/text/shared/01/02100001.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -198,7 +198,8 @@ [a-e] - Represents any of the characters that are between a and e. + Represents any of the characters that are between a and e, including both start and end characters + The characters are ordered by their code numbers. @@ -214,7 +215,7 @@ [^a-s] - Represents any character that is not between a and s. + Represents everything that is not between a and s. @@ -231,7 +232,7 @@ | - Finds the terms that occur before or after the "|". For example, "this|that" finds "this" and "that". + Finds the terms that occur before the "|" and also finds the terms that occur after the "|". For example, "this|that" finds "this" and "that". @@ -239,7 +240,7 @@ {2} - Defines the number of times that the character in front of the opening bracket occurs. For example, "tre{2}" finds "tree". + Defines the number of times that the character in front of the opening bracket occurs. For example, "tre{2}" finds and selects "tree". @@ -247,7 +248,7 @@ {1,2} - Defines the number of times that the character in front of the opening bracket can occur. For example, "tre{1,2}" finds both "tree" and "treated". + Defines the minimum and maximum number of times that the character in front of the opening bracket can occur. For example, "tre{1,2}" finds and selects "tre" and "tree". @@ -333,7 +334,7 @@ Represents an uppercase character if Match case is selected in Options. - + @@ -348,7 +349,12 @@ $ means the match must end a paragraph.
- Wiki page about regular expressions in Writer + + + + + +Wiki page about regular expressions in Writer Wiki page about regular expressions in Calc
diff --git a/helpcontent2/source/text/shared/01/05020301.xhp b/helpcontent2/source/text/shared/01/05020301.xhp index 3c61a0231a..f8045f39ba 100644 --- a/helpcontent2/source/text/shared/01/05020301.xhp +++ b/helpcontent2/source/text/shared/01/05020301.xhp @@ -49,8 +49,8 @@ numbers; date, time and currency formats Euro; currency formats date formats - times, formats -mw made "time formats" a two level entry and deleted 2x "formats;" + times;formats +mw made "time formats" a two level entry and deleted 2x "formats;"mw corrected a typo in "times, formats" Number Format Codes Number format codes can consist of up to three sections separated by a semicolon (;). diff --git a/helpcontent2/source/text/shared/01/05340100.xhp b/helpcontent2/source/text/shared/01/05340100.xhp index 4049929f3e..64ce51b804 100644 --- a/helpcontent2/source/text/shared/01/05340100.xhp +++ b/helpcontent2/source/text/shared/01/05340100.xhp @@ -1,7 +1,8 @@ - - - + ************************************************************************ + --> + - - -Row Height -/text/shared/01/05340100.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - - - - + + Row Height + /text/shared/01/05340100.xhp + + + + -Row Height - -Changes the height of the current row, or the selected rows. +Row Height + Changes the height of the current row, or the selected rows. - -You can also change the height of a row by dragging the divider below the row header. To fit the row height to the cell contents, double-click the divider. + You can also change the height of a row by dragging the divider below the row header. To fit the row height to the cell contents, double-click the divider. -
- -
+
+ +
-Height -Enter the row height that you want to use. +Height + Enter the row height that you want to use. - -Default value -Automatic -Automatically adjusts the row height based on the current font. - - +Default value + Adjusts the row height to the size based on the default template. Existing contents may be shown vertically cropped. The height no longer increases automatically when you enter larger contents. + + \ No newline at end of file diff --git a/helpcontent2/source/text/shared/explorer/database/30000000.xhp b/helpcontent2/source/text/shared/explorer/database/30000000.xhp index 194cbc1abb..a3345a938c 100644 --- a/helpcontent2/source/text/shared/explorer/database/30000000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/30000000.xhp @@ -1,7 +1,4 @@ - - - - - + Adabas D Database @@ -44,11 +40,10 @@ Adabas D Database -Adabas D by Software AG is installed when you install the commercial office software by Sun Microsystems, Inc. -If you are using OpenOffice.org software, the Adabas D software package can be downloaded and installed separately (see www.adabas.com). -The Adabas D database that you may have installed together with $[officename] is a limited version of the database. For more information on Adabas, visit the Software AG Web site at http://www.softwareag.com/adabas/. +The Adabas D software package can be downloaded and installed separately (see www.adabas.com). +The free Adabas D database is a limited version of the database. For more information on Adabas, visit the Software AG Web site at http://www.softwareag.com/adabas/. About Adabas -The Adabas database that you may have installed together with $[officename] is restricted to a size of 100 MB, and a maximum of three users on a network. See the "License.txt" file in the Adabas directory for more details. The Adabas database must be installed in a separate directory from $[officename]. +The free Adabas database is restricted to a size of 100 MB, and a maximum of three users on a network. See the "License.txt" file in the Adabas directory for more details. The Adabas database must be installed in a separate directory from $[officename]. The name of an Adabas file cannot exceed 8 characters. The path to the Adabas file, including the file name, cannot exceed 30 characters, and must be compliant with the 7-bit ASCII code. Both the path and the file name cannot contain spaces. Under Windows, the Adabas setup application adds the DBROOT environment variable that contains the path information for the database. If the setup application finds this variable, it does not install the database. Create New Adabas Database @@ -66,76 +61,5 @@ Deleting an Adabas Database To delete the reference to an Adabas database, choose Tools - Options - %PRODUCTNAME Base - Databases. Select the database, and then click Delete. -To delete an Adabas database: - - -Determine which directories are referred to by the system variables DBCONFIG and DBWORK. Under Windows these variables are defined in the system settings or in the c:\Autoexec.bat file. - Under Unix these variables are defined in a startup script. - - - -In the $DBCONFIG$ directory, delete the three files that have the same name as the database, but with different extensions. For example, for a database named "Big", delete the "Big.sys", "Big.trs", and "Big.dat" files in the "C:\Adabas\". - - -In the $DBCONFIG$\Config directory, delete the file that has the same name as the database, for example, " C:\Adabas\Sql\Config\Big". - - -In the $DBWORKS$\Wrk directory, delete the directory that has the same name as the database., for example "C:\Adabas\Sql\Wrk\Big". - - -Starting and Shutting Down an Adabas Database - - -strt -d <DBNAME> -NoDBWindow -NoDBService -switches the database to COLD. - - -xutil -d <DBNAME> -u <CONTROLUSER>,<CONTROLPASSWORD> shutdown -switches the database to COLD. - - -xutil -d <DBNAME> -u <CONTROLUSER>,<CONTROLPASSWORD> restart -switches the database to WARM. - - -stp -d <DBNAME> -NoDBService -completely shuts down the database - - -Error Messages in an Adabas Database -The following is a list of possible error messages and solutions for working with the Adabas D database. -The database cannot be shut down / restarted as a user is still connected to it. -Close any other open tasks that show the database contents. On multi-user systems, ensure that all users are disconnected from the database, and then restart $[officename]. -Client unable to establish connection; -813 SERVERDB MUST BE RESTARTED -This error occurs if you try to access an Adabas D database that has not been started. Ensure that you have defined a Control User for the database, and then start the database. -Client unable to establish connection; -8022 USER ALREADY CONNECTED -This error occurs if you try to access an Adabas D database more than one time. -Errors occurring when writing the data in the database -Restart $[officename], and then change the database properties. -Running an Adabas Server on a Network -To run Adabas on a network, you need to install the Adabas server on one machine and the client on the workstations that you want to access the database from. -You can only create a new database on the server. -Enabling a Remote Connection - - -Under Windows, start the xtcpupd.exe support program on both the client and the server, and ensure that "Remote SQL via TCP/IP" is selected in the xtcpupd.exe dialog. - - -On the server, start the x_server program in adabas\bin -Adabas\bin directory. - - -Choose File - New - Database. - - -Click Connect to an existing database, and select "Adabas D" in the listbox. Click Next. - - -In the Name of the Adabas D database box, enter the name of the server, a colon, and the name of the database on the server, for example, computername:database. - - -Fill in the remaining pages of the Database Wizard. - - diff --git a/helpcontent2/source/text/shared/guide/digitalsign_send.xhp b/helpcontent2/source/text/shared/guide/digitalsign_send.xhp index b68bb1240f..28477dbd8c 100644 --- a/helpcontent2/source/text/shared/guide/digitalsign_send.xhp +++ b/helpcontent2/source/text/shared/guide/digitalsign_send.xhp @@ -47,7 +47,7 @@ Applying Digital Signatures MW created this file by splitting shared/guide/digital_signatures.xhp Getting a Certificate - You can get a certificate from a certification authority, which may be a private company or a governmental institution. Some certification authorities want money for their service, for example when they certify your identity. Other certificates are free of costs, for example those offered by some e-mail providers, which certify your e-mail address. A few of the companies that offer certificates to private persons are listed in the following, in alphabetical order: GlobalSign , Thawte, Verisign. + You can get a certificate from a certification authority, which may be a private company or a governmental institution. Some certification authorities want money for their service, for example when they certify your identity. Other certificates are free of costs, for example those offered by some e-mail providers, which certify your e-mail address. A few of the companies that offer certificates to private persons are listed in the following, in alphabetical order: GlobalSign, Verisign. Managing your Certificates diff --git a/helpcontent2/source/text/shared/guide/scripting.xhp b/helpcontent2/source/text/shared/guide/scripting.xhp index 1fc3d0f77a..959eaa2b00 100755 --- a/helpcontent2/source/text/shared/guide/scripting.xhp +++ b/helpcontent2/source/text/shared/guide/scripting.xhp @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: scripting.xhp,v $ - * $Revision: 1.17.4.1 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -35,200 +35,198 @@ - -Scripting %PRODUCTNAME -/text/shared/guide/scripting.xhp - - - + + Scripting %PRODUCTNAME + /text/shared/guide/scripting.xhp + + + assigning scripts -programming;scripting -form controls;assigning macros -pictures;assigning macros -hyperlinks;assigning macros -shortcut keys;assigning macros -controls;assigning macros (Basic) -menus;assigning macros -events;assigning scripts + programming;scripting + form controls;assigning macros + pictures;assigning macros + hyperlinks;assigning macros + shortcut keys;assigning macros + controls;assigning macros (Basic) + menus;assigning macros + events;assigning scripts MW deleted "programming;...", "scripting in programming", "BeanShell scripting", "Basic;..." and "java;..."MW added "controls;..", "menus;..." and "events;..." -Assigning Scripts in %PRODUCTNAME +Assigning Scripts in %PRODUCTNAME -You can assign custom scripts (macros) to menu items, icons, dialog controls, and events in %PRODUCTNAME. -%PRODUCTNAME internally supports the following scripting languages: - - -%PRODUCTNAME Basic - - -JavaScript - - -BeanShell - - - - -Python (not included with all distributions)i50641removed switch, added text - - -In addition, developers can use high-level languages, for example Java programming language, to control %PRODUCTNAME externally. See the API project at OpenOffice.org. -To assign a script to a new menu entry - - -Choose Tools - Customize, and click the Menus tab. - - -Click Add. - - -In the Category list box, scroll down and open the "%PRODUCTNAME Macros" entry. - - -You see entries for "%PRODUCTNAME Macros" (scripts in the share directory of your %PRODUCTNAME installation), "My Macros" (scripts in the user directory), and the current document. Open any one of them to see the supported scripting languages. - - -Open any scripting language entry to see the available scripts. Select a script. - - -A list of the script functions appears in the Commands list box. Select a function. - - -Click Add to create a new menu assignment. The new menu entry appears in the Entries list box. - - -To assign a script to a key combination - - -Choose Tools - Customize - Keyboard. - - -In the Category list box, scroll down and open the "%PRODUCTNAME Macros" entry. - - -You see entries for "%PRODUCTNAME Macros" (scripts in the share directory of your %PRODUCTNAME installation), "My Macros" (scripts in the user directory), and the current document. Open any one of them to see the supported scripting languages. - - -Open any scripting language entry to see the available scripts. Select any script. - - -A list of the script functions will appear in the Commands list box. Select any function. - - -Click the option button for %PRODUCTNAME or Writer (or whichever application is currently open). -Selecting the option button sets the scope of the new key combination to be applicable in all of %PRODUCTNAME or only in documents of the current module. - - -Select a key combination from the Shortcut keys list box and click Modify. - - -To assign a script to an event - - -Choose Tools - Customize - Events. - - -Click Macro button. - - -In the Library list box, scroll down and open the "%PRODUCTNAME Macros" entry. - - -You see entries for "%PRODUCTNAME Macros" (scripts in the share directory of your %PRODUCTNAME installation), "My Macros" (scripts in the user directory), and the current document. Open any one of them to see the supported scripting languages. - - -Open any scripting language entry to see the available scripts. Select any script. - - -A list of the script functions will appear in the Assigned Action list box. Select any function. - - -Select to save in %PRODUCTNAME or current document. -This sets the scope of the new event assignment to be applicable in all of %PRODUCTNAME or only in documents of the current module. - - -Select an event from the list and click OK. - - -To assign a script to an event for an embedded object - - -Select the embedded object, for example a chart, in your document. - - -Choose Format - Frame/Object - Macro. - - -In the Macros list box, open the %PRODUCTNAME Scripts entry. - - -You see entries for share (scripts in the share directory of your %PRODUCTNAME installation), user (scripts in the user directory), and the current document. Open any one of them to see the supported scripting languages. - - -Open any scripting language entry to see the available scripts. Select any script. - - -A list of the script functions will appear in the Existing macros in list box. Select any function. - - -Select an event from the list and click OK. - - -To assign a script to a hyperlink - - -Position the cursor inside the hyperlink. - - -Choose Insert - Hyperlink. - - -Click the Events button. - - -Select and assign as stated above. - - -To assign a script to a graphic - - -Select the graphic in your document. - - -Choose Format - Picture - Macro. - - -Select and assign as stated above. - - -To assign a script to a form control - - -Insert a form control, for example a button: Open the Form Controls toolbar, click the Push Button icon, drag open a button on your document. - - -With the form control selected, click Control on the Form Controls toolbar. - - -Click the Events tab of the Properties dialog. - - -Click one of the ... buttons to open a dialog where you can assign a script to the selected event. - - -To assign a script to a control in the %PRODUCTNAME Basic dialog - - -Open the %PRODUCTNAME Basic dialog editor, then create a dialog with a control on it. - - -Right-click the control, then choose Properties. - - -Click the Events tab of the Properties dialog. - - -Click one of the ... buttons to open a dialog where you can assign a script to the selected event. - - - - + You can assign custom scripts (macros) to menu items, icons, dialog controls, and events in %PRODUCTNAME. + %PRODUCTNAME internally supports the following scripting languages: + + + %PRODUCTNAME Basic + + + JavaScript + + + BeanShell + + + Python + + + In addition, developers can use high-level languages, for example Java programming language, to control %PRODUCTNAME externally. See the API project at OpenOffice.org. + To assign a script to a new menu entry + + + Choose Tools - Customize, and click the Menus tab. + + + Click Add. + + + In the Category list box, scroll down and open the "%PRODUCTNAME Macros" entry. + + + You see entries for "%PRODUCTNAME Macros" (scripts in the share directory of your %PRODUCTNAME installation), "My Macros" (scripts in the user directory), and the current document. Open any one of them to see the supported scripting languages. + + + Open any scripting language entry to see the available scripts. Select a script. + + + A list of the script functions appears in the Commands list box. Select a function. + + + Click Add to create a new menu assignment. The new menu entry appears in the Entries list box. + + + To assign a script to a key combination + + + Choose Tools - Customize - Keyboard. + + + In the Category list box, scroll down and open the "%PRODUCTNAME Macros" entry. + + + You see entries for "%PRODUCTNAME Macros" (scripts in the share directory of your %PRODUCTNAME installation), "My Macros" (scripts in the user directory), and the current document. Open any one of them to see the supported scripting languages. + + + Open any scripting language entry to see the available scripts. Select any script. + + + A list of the script functions will appear in the Commands list box. Select any function. + + + Click the option button for %PRODUCTNAME or Writer (or whichever application is currently open). + Selecting the option button sets the scope of the new key combination to be applicable in all of %PRODUCTNAME or only in documents of the current module. + + + Select a key combination from the Shortcut keys list box and click Modify. + + + To assign a script to an event + + + Choose Tools - Customize - Events. + + + Click Macro button. + + + In the Library list box, scroll down and open the "%PRODUCTNAME Macros" entry. + + + You see entries for "%PRODUCTNAME Macros" (scripts in the share directory of your %PRODUCTNAME installation), "My Macros" (scripts in the user directory), and the current document. Open any one of them to see the supported scripting languages. + + + Open any scripting language entry to see the available scripts. Select any script. + + + A list of the script functions will appear in the Assigned Action list box. Select any function. + + + Select to save in %PRODUCTNAME or current document. + This sets the scope of the new event assignment to be applicable in all of %PRODUCTNAME or only in documents of the current module. + + + Select an event from the list and click OK. + + + To assign a script to an event for an embedded object + + + Select the embedded object, for example a chart, in your document. + + + Choose Format - Frame/Object - Macro. + + + In the Macros list box, open the %PRODUCTNAME Scripts entry. + + + You see entries for share (scripts in the share directory of your %PRODUCTNAME installation), user (scripts in the user directory), and the current document. Open any one of them to see the supported scripting languages. + + + Open any scripting language entry to see the available scripts. Select any script. + + + A list of the script functions will appear in the Existing macros in list box. Select any function. + + + Select an event from the list and click OK. + + + To assign a script to a hyperlink + + + Position the cursor inside the hyperlink. + + + Choose Insert - Hyperlink. + + + Click the Events button. + + + Select and assign as stated above. + + + To assign a script to a graphic + + + Select the graphic in your document. + + + Choose Format - Picture - Macro. + + + Select and assign as stated above. + + + To assign a script to a form control + + + Insert a form control, for example a button: Open the Form Controls toolbar, click the Push Button icon, drag open a button on your document. + + + With the form control selected, click Control on the Form Controls toolbar. + + + Click the Events tab of the Properties dialog. + + + Click one of the ... buttons to open a dialog where you can assign a script to the selected event. + + + To assign a script to a control in the %PRODUCTNAME Basic dialog + + + Open the %PRODUCTNAME Basic dialog editor, then create a dialog with a control on it. + + + Right-click the control, then choose Properties. + + + Click the Events tab of the Properties dialog. + + + Click one of the ... buttons to open a dialog where you can assign a script to the selected event. + + + + \ No newline at end of file diff --git a/helpcontent2/source/text/shared/optionen/01010600.xhp b/helpcontent2/source/text/shared/optionen/01010600.xhp index 8a7fe55cdb..bf02b8b7c4 100755 --- a/helpcontent2/source/text/shared/optionen/01010600.xhp +++ b/helpcontent2/source/text/shared/optionen/01010600.xhp @@ -1,8 +1,8 @@ - - - + + + + - - -General -/text/shared/optionen/01010600.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - - - + + General + /text/shared/optionen/01010600.xhp + + + opening; dialog settings -saving; dialog settings -Open/Save dialogs -years; 2-digit options -Help Agent;options -Help;style sheets -mw changed "StarOffice Open/Save dialogs" to "Open/Save dialogs" - -
-General -Specifies the general settings for $[officename]. -
-
- -
+ saving; dialog settings + years; 2-digit options + Help Agent;options + Help;style sheets +mw changed "StarOffice Open/Save dialogs" to "Open/Save dialogs"removed index "Open/Save dialogs", see i105788 + +
+ General + Specifies the general settings for $[officename]. +
+
+ +
-Year (two digits) -Defines a date range, within which the system recognizes a two-digit year. -
-In $[officename], years are indicated by four digits, so that the difference between 1/1/99 and 1/1/01 is two years. This Year (two digits) setting allows the user to define the years in which two-digit dates are added to 2000. To illustrate, if you specify a date of 1/1/30 or later, the entry "1/1/20" is recognized as 1/1/2020 instead of 1/1/1920. -
-Help -Specifies the behavior of the installed help. +Year (two digits) + Defines a date range, within which the system recognizes a two-digit year. +
+ In $[officename], years are indicated by four digits, so that the difference between 1/1/99 and 1/1/01 is two years. This Year (two digits) setting allows the user to define the years in which two-digit dates are added to 2000. To illustrate, if you specify a date of 1/1/30 or later, the entry "1/1/20" is recognized as 1/1/2020 instead of 1/1/1920. +
+ Help + Specifies the behavior of the installed help. -Tips -Displays the icon names and more bubble help information, for example, chapter names when you scroll through a document with chapters. +Tips + Displays the icon names and more bubble help information, for example, chapter names when you scroll through a document with chapters. -Extended tips -Displays a help text when you rest the cursor on an icon, a menu command, or a control on a dialog. +Extended tips + Displays a help text when you rest the cursor on an icon, a menu command, or a control on a dialog. -Help Agent -Specifies that the Help Agent will be displayed automatically in selected situations. Click the Help Agent window to see a Help page with information about the current context. +Help Agent + Specifies that the Help Agent will be displayed automatically in selected situations. Click the Help Agent window to see a Help page with information about the current context. -Reset Help Agent -If you have not opened the Help Agent for a particular situation three times in succession, but rather have closed it or let it close automatically, the Help Agent for this situation is not shown again. -Click Reset Help Agent to restore the default list of situations for which the Help Agent is displayed. -$[officename] Help formatting +Reset Help Agent + If you have not opened the Help Agent for a particular situation three times in succession, but rather have closed it or let it close automatically, the Help Agent for this situation is not shown again. + Click Reset Help Agent to restore the default list of situations for which the Help Agent is displayed. + $[officename] Help formatting -Style sheet -Choose the style of $[officename] Help. -Open/Save dialogsUFI: see spec doc "Gnome file selector" +Style sheet + Choose the style of $[officename] Help. + Open/Save dialogsUFI: see spec doc "Gnome file selector" -Use $[officename] dialogs -Specifies whether $[officename] dialogs are used to open and save documents. Otherwise the dialogs of the operating system are used. +Use $[officename] dialogs + Specifies whether $[officename] dialogs are used to open and save documents. Otherwise the dialogs of the operating system are used. -When you open a file by an URL from the Windows file dialog, Windows will open a local copy of the file, located in the Internet Explorer cache. The %PRODUCTNAME file dialog opens the remote file. +When you open a file by an URL from the Windows file dialog, Windows will open a local copy of the file, located in the Internet Explorer cache. The %PRODUCTNAME file dialog opens the remote file. -The $[officename] dialogs for opening and saving documents are described in $[officename] Help. -Document status +The $[officename] dialogs for opening and saving documents are described in $[officename] Help. + Document status -Printing sets "document modified" status -Specifies whether the printing of the document counts as a modification. When this option is marked, the very next time the document is closed you are asked if the changes should be saved. The print date is then entered in the document properties as a change. - - +Printing sets "document modified" status + Specifies whether the printing of the document counts as a modification. When this option is marked, the very next time the document is closed you are asked if the changes should be saved. The print date is then entered in the document properties as a change. + + \ No newline at end of file diff --git a/helpcontent2/source/text/shared/optionen/01060500.xhp b/helpcontent2/source/text/shared/optionen/01060500.xhp index 8e12eb1056..7d63d5c6cf 100644 --- a/helpcontent2/source/text/shared/optionen/01060500.xhp +++ b/helpcontent2/source/text/shared/optionen/01060500.xhp @@ -1,8 +1,8 @@ - - + + + - - -Calculate -/text/shared/optionen/01060500.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - - - -
+ + Calculate + /text/shared/optionen/01060500.xhp + + + +
references; iterative (Calc) -calculating;iterative references (Calc) -iterative references in spreadsheets -recursions in spreadsheets -dates; default (Calc) -dates; start 1900/01/01 (Calc) -dates; start 1904/01/01 (Calc) -case sensitivity;comparing cell contents (Calc) -numbers; decimal places (Calc) -decimal places displayed (Calc) -precision as shown (Calc) -values; rounded as shown (Calc) -rounding precision (Calc) -search criteria for database functions in cells -Excel; search criteria -UFI: removed a double entrymw changed "cell contents;" to "case sensitivity;.." + calculating;iterative references (Calc) + iterative references in spreadsheets + recursions in spreadsheets + dates; default (Calc) + dates; start 1900/01/01 (Calc) + dates; start 1904/01/01 (Calc) + case sensitivity;comparing cell contents (Calc) + decimal places displayed (Calc) + precision as shown (Calc) + values; rounded as shown (Calc) + rounding precision (Calc) + 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. -
-
- -
-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. +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. +
+
+ +
+ 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. - -Example: calculating the cost of an item without the value-added tax. - - -Type the text 'Selling price' in cell A5, the text 'Net' in cell A6, and the text 'Value-added tax' in cell A7. - - -Now type a selling price (for example, 100) in cell B5. The net price should be shown in cell B6 and the value-added tax should be shown in cell B7. - - -You know that the value-added tax is calculated as 'net price times 15%' and that you arrive at the net price by deducting the value-added tax from the selling price. Type the formula =B5-B7 in B6 to calculate the net price, and type the formula =B6*0.15 in cell B7 to calculate the value-added tax. - - -Switch on the iterations to correctly calculate the formulas, otherwise a 'Circular reference' error message appears in the Status Bar. - - - - - - - -A - - -B - - - - -5 - - -Selling Price - - -100 - - - - -6 - - -Net - - -=B5-B7 - - - - -7 - - -Tax - - -=B6*0,15 - - -
+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. + + Example: calculating the cost of an item without the value-added tax. + + + Type the text 'Selling price' in cell A5, the text 'Net' in cell A6, and the text 'Value-added tax' in cell A7. + + + Now type a selling price (for example, 100) in cell B5. The net price should be shown in cell B6 and the value-added tax should be shown in cell B7. + + + You know that the value-added tax is calculated as 'net price times 15%' and that you arrive at the net price by deducting the value-added tax from the selling price. Type the formula =B5-B7 in B6 to calculate the net price, and type the formula =B6*0.15 in cell B7 to calculate the value-added tax. + + + Switch on the iterations to correctly calculate the formulas, otherwise a 'Circular reference' error message appears in the Status Bar. + + + + + + + + A + + + B + + + + + 5 + + + Selling Price + + + 100 + + + + + 6 + + + Net + + + =B5-B7 + + + + + 7 + + + Tax + + + =B6*0,15 + + +
-Steps -Sets the maximum number of iteration steps. +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. -Date -Select the start date for the internal conversion from days to numbers. +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. + Date + Select the start date for the internal conversion from days to numbers. -12/30/1899 (default) -Sets 12/30/1899 as day zero. +12/30/1899 (default) + 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. +01/01/1900 (StarCalc 1.0) + 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. +01/01/1904 + 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. - -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. +Case sensitive + 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. -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. +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. -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. +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. -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. - - - -.* in following position: - - -Search result: - - - - -win - - -Finds win, but not win95, os2win, or upwind - - - - -win.* - - -Finds win and win95, but not os2win or upwind - - - - -.*win - - -Finds win and os2win, but not win95 or upwind - - - - -.*win.* - - -Finds win, win95, os2win, and upwind - - -
+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. + + + + .* in following position: + + + Search result: + + + + + win + + + Finds win, but not win95, os2win, or upwind + + + + + win.* + + + Finds win and win95, but not os2win or upwind + + + + + .*win + + + Finds win and os2win, but not win95 or upwind + + + + + .*win.* + + + Finds win, win95, os2win, and upwind + + +
-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. + 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. +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. 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. - -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). - - +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. + + 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). + + \ No newline at end of file diff --git a/helpcontent2/source/text/shared/optionen/01130100.xhp b/helpcontent2/source/text/shared/optionen/01130100.xhp index 69f8c5eaa0..d21aa1b372 100755 --- a/helpcontent2/source/text/shared/optionen/01130100.xhp +++ b/helpcontent2/source/text/shared/optionen/01130100.xhp @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 01130100.xhp,v $ - * $Revision: 1.13.4.1 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -35,65 +35,70 @@ - -VBA Properties -/text/shared/optionen/01130100.xhp - - - -
+ + VBA Properties + /text/shared/optionen/01130100.xhp + + + +
Microsoft Office; importing/exporting VBA code -importing; Microsoft Office documents with VBA code -exporting; Microsoft Office documents with VBA code -loading; Microsoft Office documents with VBA code -saving; VBA code in Microsoft Office documents -VBA code; loading/saving documents with VBA code -Visual Basic for Applications; loading/saving documents with VBA code + importing; Microsoft Office documents with VBA code + exporting; Microsoft Office documents with VBA code + loading; Microsoft Office documents with VBA code + saving; VBA code in Microsoft Office documents + VBA code; loading/saving documents with VBA code + Visual Basic for Applications; loading/saving documents with VBA code - -VBA Properties -Specifies the general properties for loading and saving Microsoft Office documents with VBA (Visual Basic for Applications) code. -
-
- -
-Microsoft Word 97/2000/XP -Select the settings for Microsoft Word documents. -Help IDs got changed, but are not updated in hid.lst. So only numeric IDs here -Load Basic code -Loads and saves the Basic code from a Microsoft document as a special $[officename] Basic module with the document. The disabled Microsoft Basic code is visible in the $[officename] Basic IDE between Sub and End Sub. You can edit the code. When saving the document in $[officename] format, the Basic code is saved as well. When saving in another format, the Basic code from the $[officename] Basic IDE is not saved. +VBA Properties + Specifies the general properties for loading and saving Microsoft Office documents with VBA (Visual Basic for Applications) code. +
+
+ +
+ Microsoft Word 97/2000/XP + Select the settings for Microsoft Word documents. + + + +Load Basic code + Loads and saves the Basic code from a Microsoft document as a special $[officename] Basic module with the document. The disabled Microsoft Basic code is visible in the $[officename] Basic IDE between Sub and End Sub. You can edit the code. When saving the document in $[officename] format, the Basic code is saved as well. When saving in another format, the Basic code from the $[officename] Basic IDE is not saved. - -Save original Basic code -
-Specifies that the original Microsoft Basic code contained in the document is held in a special internal memory for as long as the document remains loaded in $[officename]. When saving the document in Microsoft format the Microsoft Basic is saved again with it in an unchanged form. -When saving in another format than Microsoft Format, the Microsoft Basic Code is not saved. For example, if the document contains Microsoft Basic Code and you save it in $[officename] format, you will be warned that the Microsoft Basic Code will not be saved. -The Save original Basic code checkbox takes precedence over the Load Basic code check box. If both boxes are marked and you edit the disabled Basic Code in the $[officename] Basic IDE, the original Microsoft Basic code will be saved when saving in the Microsoft format. A message appears to inform you of this. -To remove any possible Microsoft Basic macro viruses from the Microsoft document, unmark the Save Original Basic Code check box and save the document in Microsoft format. The document will be saved without the Microsoft Basic code. -
-Microsoft Excel 97/2000/XP -Specifies the settings for documents in Microsoft Excel. - -Load Basic code - - -Executable code -The VBA (Visual Basic for Applications) code will be loaded ready to be executed. If this checkbox is not checked, the VBA code will be commented out so it can be inspected, but will not run. - -Save original Basic code - -Microsoft PowerPoint 97/2000/XP -Specifies the settings for documents in Microsoft PowerPoint. - -Load Basic code - - -Save original Basic code - -
- - -Setting the default file format -
- - + + + +Save original Basic code +
+ Specifies that the original Microsoft Basic code contained in the document is held in a special internal memory for as long as the document remains loaded in $[officename]. When saving the document in Microsoft format the Microsoft Basic is saved again with the code in an unchanged form. + When saving in another format than Microsoft Format, the Microsoft Basic Code is not saved. For example, if the document contains Microsoft Basic Code and you save it in $[officename] format, you will be warned that the Microsoft Basic Code will not be saved. + The Save original Basic code checkbox takes precedence over the Load Basic code check box. If both boxes are marked and you edit the disabled Basic Code in the $[officename] Basic IDE, the original Microsoft Basic code will be saved when saving in the Microsoft format. A message appears to inform you of this. + To remove any possible Microsoft Basic macro viruses from the Microsoft document, unmark the Save Original Basic Code check box and save the document in Microsoft format. The document will be saved without the Microsoft Basic code. +
+ Microsoft Excel 97/2000/XP + Specifies the settings for documents in Microsoft Excel. + Load Basic code + + +Executable code + The VBA (Visual Basic for Applications) code will be loaded ready to be executed. If this checkbox is not checked, the VBA code will be commented out so it can be inspected, but will not run. + Save original Basic code + + Microsoft PowerPoint 97/2000/XP + Specifies the settings for documents in Microsoft PowerPoint. + Load Basic code + + Save original Basic code + +
+ + + Setting the default file format +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/smath/01/03090000.xhp b/helpcontent2/source/text/smath/01/03090000.xhp index 7e09e0b41e..5e99a8c484 100755 --- a/helpcontent2/source/text/smath/01/03090000.xhp +++ b/helpcontent2/source/text/smath/01/03090000.xhp @@ -50,7 +50,7 @@ This is a list of operators, functions, symbols and format options that can be inserted into the formula.
- Some examples show you the range of operations. You can find more examples in the Samples - Formulas folder of the Templates and Documents window. + Some examples show you the range of operations. The selection window is divided into two parts. Clicking a symbol at the top of the window displays its subordinate symbols in the lower half of the window. You can access the same functions in submenus through the context menu of the Commands window.
diff --git a/helpcontent2/source/text/swriter/01/04090200.xhp b/helpcontent2/source/text/swriter/01/04090200.xhp index 66da064bd8..9e143f2345 100755 --- a/helpcontent2/source/text/swriter/01/04090200.xhp +++ b/helpcontent2/source/text/swriter/01/04090200.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.8 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -74,18 +74,18 @@ - TRUE + TRUE - The condition is always met. You can also enter any value not equal to 0 as the conditional text. + The condition is always met. You can also enter any value not equal to 0 as the conditional text. - FALSE + FALSE - The condition is not met. You can also enter the value 0. + The condition is not met. You can also enter the value 0.
@@ -114,26 +114,26 @@ - x == 1 or x EQ 1 + x == 1 or x EQ 1 - The condition is true if "x" is equal to 1. + The condition is true if "x" is equal to 1. - x != 1 or x NEQ 1 + x != 1 or x NEQ 1 - The condition is true if "x" does not equal 1. + The condition is true if "x" does not equal 1. - sinx == 0 + sinx == 0 - The condition is true if "x" is a multiple of pi. + The condition is true if "x" is a multiple of pi.
@@ -142,20 +142,20 @@ - x == "ABC" or x EQ "ABC" + x == "ABC" or x EQ "ABC" - Checks if variable "x" contains (true) the "ABC" string, or not (false). + Checks if variable "x" contains (true) the "ABC" string, or not (false). - x == "" or x EQ "" - or - !x or NOT x + x == "" or x EQ "" + or + !x or NOT x - Checks if the variable "x" contains an empty string. + Checks if the variable "x" contains an empty string.
@@ -168,130 +168,130 @@ - Variable + Variable - Meaning + Meaning - user_firstname + user_firstname - First name + First name - user_lastname + user_lastname - Last name + Last name - user_initials + user_initials - Initials + Initials - user_company + user_company - Company + Company - user_street + user_street - Street + Street - user_country + user_country - Country + Country - user_zipcode + user_zipcode - Zip code + Zip code - user_city + user_city - City + City - user_title + user_title - Title + Title - user_position + user_position - Position + Position - user_tel_work + user_tel_work - Business telephone number + Business telephone number - user_tel_home + user_tel_home - Home telephone number + Home telephone number - user_fax + user_fax - Fax number + Fax number - user_email + user_email - E-mail address + E-mail address - user_state + user_state - State (not in all $[officename] versions) + State (not in all $[officename] versions)
@@ -351,13 +351,15 @@ Note the difference between the boolean NOT "!" and the comparative operator not equal "!=" (NEQ). When you refer to a database field in a condition, use the form Databasename.Tablename.Fieldname. If one of the names contains a character that is an operator, such as a minus sign (-), enclose the name in square brackets, for example, Databasename.[Table-name].Fieldname. Never use spaces inside field names.UFI: fixes bug #i25781# - but see #i25983#. Fixes also #i19571# - Example: Hiding an Empty Database Field + Example: Hiding an Empty Database Field You may want to create a condition that hides an empty field, for example, if the COMPANY field is empty for some of the data records. Select the Hidden Paragraph list entry, and type the following condition: Addressbook.Addresses.Company EQ "" or type the following NOT Addressbook.Addresses.Company If the COMPANY database field is empty, the condition is true and the paragraph is hidden. - To display hidden paragraphs on the screen, you can choose Tools - Options - %PRODUCTNAME Writer - Formatting Aids, and clear the Fields: Hidden paragraphs check box. + To display hidden paragraphs on the screen, you can choose Tools - Options - %PRODUCTNAME Writer - Formatting Aids, and enable the Fields: Hidden + paragraphs check box. Examples of Conditions in Fields The following examples use the Conditional text field, although they can be applied to any fields that can be linked to a condition. The syntax used for conditions is also used for the Hidden text, Hidden paragraph, Any record or Next record fields. diff --git a/helpcontent2/source/text/swriter/guide/auto_off.xhp b/helpcontent2/source/text/swriter/guide/auto_off.xhp index f46ea279bf..a6f67a2a3c 100755 --- a/helpcontent2/source/text/swriter/guide/auto_off.xhp +++ b/helpcontent2/source/text/swriter/guide/auto_off.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -94,7 +94,7 @@ Click the Custom Quotes tab - Clear the “Replace” check box(es). + Clear the "Replace" check box(es). To Stop Capitalizing the First Letter of a Sentence @@ -106,7 +106,7 @@ Click the Options tab. - Clear the “Capitalize first letter of every sentence” check box. + Clear the "Capitalize first letter of every sentence" check box. Click the Options tab. - Clear the “Apply border” check box. + Clear the "Apply border" check box. diff --git a/helpcontent2/source/text/swriter/guide/search_regexp.xhp b/helpcontent2/source/text/swriter/guide/search_regexp.xhp index 5d1d14e71c..e418f92685 100755 --- a/helpcontent2/source/text/swriter/guide/search_regexp.xhp +++ b/helpcontent2/source/text/swriter/guide/search_regexp.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -35,63 +35,63 @@ - -Using Wildcards in Text Searches -/text/swriter/guide/search_regexp.xhp - - - + + Using Wildcards in Text Searches + /text/swriter/guide/search_regexp.xhp + + + wildcards, see regular expressions -searching; with wildcards -regular expressions;searching -examples for regular expressions -characters;finding all -invisible characters;finding + searching; with wildcards + regular expressions;searching + examples for regular expressions + characters;finding all + invisible characters;finding mw deleted "wildcards;" and inserted wildcards crossreference Using Wildcards in Text Searches + oldref="15">Using Wildcards in Text Searches -Wildcards or placeholders can be used to search for some unspecified or even invisible characters. -You can use wildcards when you find and replace text in a document. For example, "s.n" finds "sun" and "son". - - -Choose Edit - Find & Replace. - - -Click More Options to expand the dialog. - - -Select the Regular expressions check box. - - -In the Search for box, type the search term and the wildcard(s) that you want to use in your search. - - -Click Find or Find All. - - -Regular Expression Examples - - -The wildcard for a single character is a period (.). - - -The wildcard for zero or more occurrences of the previous character is an asterisk. For example: "123*" finds "12" "123", and "1233". - - -The wildcard combination to search for zero or more occurrences of any character is a period and asterisk (.*). - - -The wildcard for the end of a paragraph is a dollar sign ($). The wildcard character combination for the start of a paragraph is a caret and a period (^.). - - -The wildcard for a tab character is \t. - - -You can only search for regular expressions within the same paragraph. That is, you cannot search for one term in a paragraph and a different term in the next paragraph. -
-List of Wildcards -
- + Wildcards or placeholders can be used to search for some unspecified or even invisible characters. + You can use wildcards when you find and replace text in a document. For example, "s.n" finds "sun" and "son". + + + Choose Edit - Find & Replace. + + + Click More Options to expand the dialog. + + + Select the Regular expressions check box. + + + In the Search for box, type the search term and the wildcard(s) that you want to use in your search. + + + Click Find or Find All. + + + Regular Expression Examples + + + The wildcard for a single character is a period (.). + + + The wildcard for zero or more occurrences of the previous character is an asterisk. For example: "123*" finds "12" "123", and "1233". + + + The wildcard combination to search for zero or more occurrences of any character is a period and asterisk (.*). + + + The wildcard for the end of a paragraph is a dollar sign ($). The wildcard character combination for the start of a paragraph is a caret and a period (^.). + + + The wildcard for a tab character is \t. + + + A search using a regular expression will work only within one paragraph. To search using a regular expression in more than one paragraph, do a separate search in each paragraph. +
+ List of Wildcards +
+ \ No newline at end of file diff --git a/helpcontent2/source/text/swriter/guide/tablemode.xhp b/helpcontent2/source/text/swriter/guide/tablemode.xhp index 389dd53ce1..a321d0213e 100755 --- a/helpcontent2/source/text/swriter/guide/tablemode.xhp +++ b/helpcontent2/source/text/swriter/guide/tablemode.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -42,33 +42,27 @@ table mode selection - proportional distribution of tables - relative distribution of table cells - tables; adapting the width by keyboard - cells; adapting the width by keyboard - keyboard;modifying the behavior of rows/columns - behavior of rows/columns +proportional distribution of tables +relative distribution of table cells +tables; adapting the width by keyboard +cells; adapting the width by keyboard +keyboard;modifying the behavior of rows/columns +behavior of rows/columns -Modifying Rows and Columns by Keyboard +Modifying Rows and Columns by Keyboard When you insert or delete cells, rows or columns in a table, the Behavior of rows/columns options determine how the neighboring elements are affected. For example, you can only insert new rows and columns into a table with fixed row and column dimensions if space permits. - Note that these properties are valid only for changes to the column width that are made using the keyboard. Using the mouse, you are free to make any column width changes.UFI: fixes bugtraq 4971582 - To set the Behavior of rows/columns - options for tables in text documents, choose Tools - Options - %PRODUCTNAME Writer - Table, or use the Fixed, Fixed/Proportional, and Variable icons on the Table - Bar. There are three display modes for tables: + Note that these properties are valid only for changes to the column width that are made using the keyboard. Using the mouse, you are free to make any column width changes. + To set the Behavior of rows/columns options for tables in text documents, choose Tools - Options - %PRODUCTNAME Writer - Table. There are three display modes for tables: - -Fixed - changes only affect the adjacent cell, and not the entire table. For example, when you widen a cell, the adjacent cell becomes narrower, but the width of the table remains constant. + Fixed - changes only affect the adjacent cell, and not the entire table. For example, when you widen a cell, the adjacent cell becomes narrower, but the width of the table remains constant. - -Fixed, proportional - changes affect the entire table, and wide cells shrink more than narrow cells. For example, when you widen a cell, the adjacent cells become proportionally narrower, but the width of the table remains constant. + Fixed, proportional - changes affect the entire table, and wide cells shrink more than narrow cells. For example, when you widen a cell, the adjacent cells become proportionally narrower, but the width of the table remains constant. - -Variable - changes affect the table size. For example, when you widen a cell, the width of the table increases. + Variable - changes affect the table size. For example, when you widen a cell, the width of the table increases. diff --git a/helpcontent2/source/text/swriter/guide/template_default.xhp b/helpcontent2/source/text/swriter/guide/template_default.xhp index 1d881647ae..430bac38db 100755 --- a/helpcontent2/source/text/swriter/guide/template_default.xhp +++ b/helpcontent2/source/text/swriter/guide/template_default.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -62,14 +62,13 @@ In the New Template box, type a name for the new template. - In the Categories - list, select "My Templates", and then click OK. + In the Categories list, select "My Templates", and then click OK. Choose File - Templates - Organize. - In the category list, double-click the "My Templates" folder. + In the Templates list, double-click the "My Templates" folder. Right-click the template that you created, and choose Set as Default Template. @@ -85,8 +84,7 @@ Choose File - Templates - Organize. - Right-click a folder in the category list, choose - Reset Default Template - Text Document. + Right-click a text file in any of the two lists, choose Reset Default Template - Text Document. Click Close. diff --git a/helpcontent2/source/text/swriter/guide/word_completion_adjust.xhp b/helpcontent2/source/text/swriter/guide/word_completion_adjust.xhp index 61b47f8df9..76bb788de3 100644 --- a/helpcontent2/source/text/swriter/guide/word_completion_adjust.xhp +++ b/helpcontent2/source/text/swriter/guide/word_completion_adjust.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -48,41 +48,41 @@ weekdays; automatically completing months; automatically completing mw copied two entries from word_completion.xhp and created three new entries -Fine-Tuning the Word Completion for Text Documents +Fine-Tuning the Word Completion for Text Documents MW created this guide by splitting word_completion.xhp -If you like it that $[officename] automatically completes the words that you frequently use, you can make further adjustments to refine that behavior. If you want, you can also save the current list of collected words so that it can be used in the next session. - To fine-tune the word completion choose Tools – AutoCorrect Options - Word Completion and select any of the following options: - To Insert an Additional Space Character - Select Append space. - The space character is appended after you type the first character of the next word after the auto-completed word. The space character is suppressed if the next character is a delimiter, such as a full stop or a new line character. - To Define the Accept Key - Choose the key to accept the suggested word using the Accept with list box. - To Select the Minimum Number of Characters - Use the Min. word length box to set the minimum number of characters a word must have to be collected into the list. - To Select the Scope of Collected Words - Select When closing a document, save the list for later use in other documents. - Now the list is also valid for other documents that you open. When you close the last %PRODUCTNAME document, the word list is deleted. - If you do not select the checkbox, the list is only valid as long as the current document is open. +If you like it that $[officename] automatically completes the words that you frequently use, you can make further adjustments to refine that behavior. If you want, you can also save the current list of collected words so that it can be used in the next session. + To fine-tune the word completion choose Tools – AutoCorrect Options - Word Completion and select any of the following options: + To Insert an Additional Space Character + Select Append space. + The space character is appended after you type the first character of the next word after the auto-completed word. The space character is suppressed if the next character is a delimiter, such as a full stop or a new line character. + To Define the Accept Key + Choose the key to accept the suggested word using the Accept with list box. + To Select the Minimum Number of Characters + Use the Min. word length box to set the minimum number of characters a word must have to be collected into the list. + To Select the Scope of Collected Words + Disable the option When closing a document, remove the words collected from it from the list. + Now the list is also valid for other documents that you open. When you close the last %PRODUCTNAME document, the word list is deleted. + If you enable the checkbox, the list is only valid as long as the current document is open. If you want the word list to exist longer than the current %PRODUCTNAME session, save it as a document, as described in the following section. - To Use the Word List for Further Sessions - If the automatic spellcheck option is enabled, only the words that are recognized by the spellcheck are collected. - Use the word list to always start with a defined set of technical terms for the word completion feature. + To Use the Word List for Further Sessions + If the automatic spellcheck option is enabled, only the words that are recognized by the spellcheck are collected. + Use the word list to always start with a defined set of technical terms for the word completion feature. - Open the text document that contains the terms that you want to use for word completion. - The word completion feature collects the words. + Open the text document that contains the terms that you want to use for word completion. + The word completion feature collects the words. - Select all or some of the words in the list. + Select all or some of the words in the list. - Use Command -Ctrl+C to copy all selected words into the clipboard. Paste the clipboard into a new document and save it to get a reference list of collected words. - Later you can open the reference list and automatically collect the words, so that the word completion feature starts with a defined set of words. + Use Command +Ctrl+C to copy all selected words into the clipboard. Paste the clipboard into a new document and save it to get a reference list of collected words. + Later you can open the reference list and automatically collect the words, so that the word completion feature starts with a defined set of words.
- Word Completion + Word Completion Using Word Completion
-- cgit