From 6f107ecda99e339d61517de33c0d452c18dfac3e Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Tue, 5 Nov 2019 15:59:20 -0300 Subject: tdf#128503 Clarify numeric x regex conversion + refactoring headings Patch set 2 - reposition comment on regex vs. numberex - included in ref for regex, aka "regulaer" and available for all functions with search criteria - Rephrased regexnumex. Patch set 3 -Fix to comply w/ DTD Change-Id: I3f5a488bb05b5ea61709e574ca5d859634158bc4 Reviewed-on: https://gerrit.libreoffice.org/82094 Tested-by: Jenkins Reviewed-by: Eike Rathke Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/text/shared/00/00000001.xhp | 69 ++++++++++++++++++++------------------ 1 file changed, 37 insertions(+), 32 deletions(-) (limited to 'source/text/shared/00') diff --git a/source/text/shared/00/00000001.xhp b/source/text/shared/00/00000001.xhp index 10dc6d076b..6b716b3b58 100644 --- a/source/text/shared/00/00000001.xhp +++ b/source/text/shared/00/00000001.xhp @@ -25,7 +25,7 @@ -Frequently-Used Buttons +

Frequently-Used Buttons

@@ -36,21 +36,21 @@ -Cancel +

Cancel

Clicking Cancel closes a dialog without saving any changes made.
-Finish +

Finish

Applies all changes and closes the wizard.
-Toolbars +

Toolbars

By clicking the arrow next to some icons you open a toolbar. To move a toolbar, drag the title bar. As soon as you release the mouse button, the toolbar remains at the new position. Drag the title bar to another position, or drag to an edge of the window, where the toolbar will dock. Close a toolbar by clicking the Close Window icon. Make the toolbar visible again by choosing View - Toolbars - (toolbar name).
-Spin button +

Spin button

@@ -65,11 +65,11 @@
-Convert +

Convert

If you click forward through the dialog, this button is called Next. On the last page the button has the name Convert. The conversion is then performed by clicking the button.
-Context Menu +

Context Menu

To activate the context menu of an object, first click the object with the left mouse button to select it, and then, while holding down the Ctrl key or the Command and Option keys, click the mouse button again @@ -93,7 +93,7 @@ -Delete +

Delete

Deletes the selected element or elements after confirmation.
@@ -105,24 +105,24 @@ -Delete +

Delete

Deletes the selected element or elements without requiring confirmation.
-Metrics +

Metrics

You can enter values in the input fields in different units of measurement. The default unit is inches. However, if you want a space of exactly 1 cm, then type "1cm". Additional units are available according to the context, for example, 12 pt for a 12 point spacing. If the value of the new unit is unrealistic, the program uses a predefined maximum or minimum value.
-Close +

Close

Closes the dialog and saves all changes.
-Close +

Close

Closes the dialog.
-Apply +

Apply

Applies the modified or selected values without closing the dialog.
@@ -145,7 +145,7 @@ -Shrink / Maximize +

Shrink / Maximize

Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size. The dialog is automatically minimized when you click into a sheet with the mouse. As soon as you release the mouse button, the dialog is restored and the reference range defined with the mouse is highlighted in the document by a blue frame. @@ -173,7 +173,7 @@ -Preview Field +

Preview Field

Displays a preview of the current selection.
@@ -186,38 +186,38 @@ -Next +

Next

Click the Next button, and the wizard uses the current dialog settings and proceeds to the next step. If you are on the last step, this button becomes Create.
-Dialog Buttons -Reset +

Dialog Buttons

+

Reset

Resets modified values back to the tab page previous values. -Cancel +

Cancel

Closes dialog and discards all changes. -OK +

OK

Saves all changes and closes dialog.
-Resetin Tools - Options +

Resetin Tools - Options

Resets changes made to the current tab to those applicable when this dialog was opened.
-Resetall tab dialogs +

Resetall tab dialogs

Resets changes made to the current tab to those applicable when this dialog was opened. A confirmation query does not appear when you close the dialog.
-Standarde.g. in Format - Para StyleUFI: Name is Default on Tools-Options-Writer-Basic Fonts +

Standarde.g. in Format - Para StyleUFI: Name is Default on Tools-Options-Writer-Basic Fonts

Resets the values visible in the dialog back to the default installation values. - A confirmation does not appear before the defaults are reloaded. + A confirmation does not appear before the defaults are reloaded.
@@ -228,29 +228,34 @@ -Back +

Back

View the selections in the dialog made in the previous step. The current settings remain unchanged. This button can only be activated from page two on.
-Options +

Options

Click the Options label to expand the dialog to show further options. Click again to restore the dialog.
See also the following functions: -The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - Calculate. +
+ The search supports wildcards or regular expressions. With regular expressions enabled, you can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must either precede every character with a "\" character, or enclose the text into \Q...\E. You can switch the automatic evaluation of wildcards or regular expression on and off in %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - Calculate. +
+ When using functions where one or more arguments are search criteria strings that represents a regular expression, the first attempt is to convert the string criteria to numbers. For example, ".0" will convert to 0.0 and so on. If successful, the match will not be a regular expression match but a numeric match. However, when switching to a locale where the decimal separator is not the dot makes the regular expression conversion work. To force the evaluation of the regular expression instead of a numeric expression, use some expression that can not be misread as numeric, such as ".[0]" or ".\0" or "(?i).0". +
+
If an error occurs, the function returns a logical or numerical value. (This command is only accessible through the context menu). By double-clicking a tool, you can use it for multiple tasks. If you call the tool with a single-click, it reverts back to the last selection after completing the task. Press Shift+F1 and point to a control to learn more about that control.
-Options dialog buttons -OK +

Options dialog buttons

+

OK

Save the changes in the page and close the Options dialog. -Cancel +

Cancel

Close the Options dialog and discard all changes done. - +
-Some options cannot be reset once edited. Either edit back the changes manually or click Cancel and reopen the Options dialog. +Some options cannot be reset once edited. Either edit back the changes manually or click Cancel and reopen the Options dialog.
-- cgit