From 3a46c3ed3dac763cca328715a4aed82a35f4145f Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Fri, 15 Dec 2023 19:14:29 -0300 Subject: tdf#155876 UI cmds Calc-Sheet menu (32) + Sheet menu for Calc: manage Names + untangle manage names and define names + refactoring Change-Id: I27fe448ae251cb98a829e92c307fc31ad3b2c967 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160845 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 2a305eedde1c9f9e1ba4af534688b4f83ea814d8) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160854 --- AllLangHelp_scalc.mk | 1 + source/text/scalc/00/00000404.xhp | 63 ++++++++- source/text/scalc/01/04070000.xhp | 19 ++- source/text/scalc/01/04070100.xhp | 109 +++++++-------- source/text/scalc/01/04070200.xhp | 2 +- source/text/scalc/01/04070300.xhp | 44 +++--- source/text/scalc/01/04070400.xhp | 48 ++++--- source/text/scalc/01/ManageNames.xhp | 49 +++++++ source/text/scalc/main0116.xhp | 3 +- source/text/shared/00/00000001.xhp | 262 +++++++++++++++++------------------ 10 files changed, 353 insertions(+), 247 deletions(-) create mode 100644 source/text/scalc/01/ManageNames.xhp diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 6fd3c5f682..8b630a5e2f 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -291,6 +291,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/JumpToNextTableSel \ helpcontent2/source/text/scalc/01/JumpToPrevTableSel \ helpcontent2/source/text/scalc/01/live_data_stream \ + helpcontent2/source/text/scalc/01/ManageNames \ helpcontent2/source/text/scalc/01/MergeCellsMenu \ helpcontent2/source/text/scalc/01/NormalViewMode \ helpcontent2/source/text/scalc/01/recalculate_hard \ diff --git a/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp index 7473556970..52a29b8dc8 100644 --- a/source/text/scalc/00/00000404.xhp +++ b/source/text/scalc/00/00000404.xhp @@ -262,7 +262,12 @@ Insert - Function - Category Add-In -Choose Insert - Named Range or Expression. + +
+ + Choose Insert - Named Range or Expression. + Choose Sheet - Named Range or Expression +
+
+ + Choose Sheet - Named Ranges and Expressions - Manage. + + Choose Insert - Manage Names. + Choose Data - Manage Names. + On the Insert menu of the Insert tab, choose Manage. + + + + + Icon Manage Names + + + Manage Names + + +
+ + CommandCtrl + F3 +

Other

+ On the drop-down list in the Name Box of the Formula Bar, select Manage Names. +
+
-Choose Sheet - Named Ranges and Expressions - Define. -CommandCtrl+F3 + + Choose Sheet - Named Ranges and Expressions - Define. + + Choose Insert - Define Name. + Choose Data - Define Name. + On the Insert menu of the Insert tab, choose Define. + + + + + Icon Define Name + + + Define Name + + +
+

Other

+ On the Name Box of the Formula Bar, insert a name for the selected cells range and press Enter.
@@ -295,7 +341,14 @@ On the Insert menu of the Insert tab, choose Named Ranges and Expressions.
-Choose Sheet - Named Ranges and Expressions - Create. -Choose Sheet - Named Ranges and Expressions - Labels. +
+ + Choose Sheet - Named Ranges and Expressions - Create. +
+ +
+ + Choose Sheet - Named Ranges and Expressions - Labels. +
diff --git a/source/text/scalc/01/04070000.xhp b/source/text/scalc/01/04070000.xhp index af57b50a4d..fc9c04a2e4 100644 --- a/source/text/scalc/01/04070000.xhp +++ b/source/text/scalc/01/04070000.xhp @@ -27,21 +27,20 @@ -
+

Named Ranges and Expressions

Allows you to name the different sections of your spreadsheet document. By naming the different sections, you can easily navigate through the spreadsheet documents and find specific information.
- +
-

Define

- -

Insert

- -

Apply

- -

Labels

- + + + + + + + diff --git a/source/text/scalc/01/04070100.xhp b/source/text/scalc/01/04070100.xhp index 03db97a285..5d03d25b26 100644 --- a/source/text/scalc/01/04070100.xhp +++ b/source/text/scalc/01/04070100.xhp @@ -22,66 +22,67 @@ -Define Names +Define Names /text/scalc/01/04070100.xhp - - - - - -

Define Names

-Opens a dialog where you can specify a name for a selected area or a name for a formula expression. - -Use the mouse to define ranges or type the reference into the Define Name dialog fields. + + + + +
+

Define Names

+ Opens a dialog where you can specify a name for a selected area or a name for a formula expression. +
+ +Use the mouse to define ranges or type the reference into the Define Name dialog fields.
-The Sheet Area box on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here. - - -

Name

-Enter the name of the area for which you want to define a reference or a formula expression. All area names already defined in the spreadsheet are listed in the text field above. If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames. - - -

Range or formula expression

-The reference of the selected area name is shown here as an absolute value. -To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document. To insert a new named formula, type the formula expression. - - - -

Scope

-Select the scope of the named range or named formula. Document (Global) means the name is valid for the whole document. Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet. - - -

Range options

-Allows you to specify the Area type (optional) for the reference. -Defines additional options related to the type of reference area. - - -

Print range

-Defines the area as a print range. - - -

Filter

-Defines the selected area to be used in an advanced filter. - - -

Repeat column

-Defines the area as a repeating column. - - -

Repeat row

-Defines the area as a repeating row. - - -

Add

-Click the Add button to add a new defined name. - - - -Select a named range or named formula from the list to modify its properties. +The Sheet Area box on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here. + +
+

Name

+ Enter the name of the area for which you want to define a reference or a formula expression. All area names already defined in the spreadsheet are listed in the text field above. If you click a name on the list, the corresponding reference in the document will be shown with a blue frame. If multiple cell ranges belong to the same area name, they are displayed with different colored frames. +
+ + +
+

Range or formula expression

+ The reference of the selected area name is shown here as an absolute value. + To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document. To insert a new named formula, type the formula expression. + +
+ + +
+

Scope

+ Select the scope of the named range or named formula. Document (Global) means the name is valid for the whole document. Any other sheet name selected will restrict the scope of the named range or formula expression to that sheet. +
+ + + +
+

Range options

+ Allows you to specify the Area type (optional) for the reference. + Defines additional options related to the type of reference area. + +

Print range

+ Defines the area as a print range. + +

Filter

+ Defines the selected area to be used in an advanced filter. + +

Repeat column

+ Defines the area as a repeating column. + +

Repeat row

+ Defines the area as a repeating row. + +

Add

+ Click the Add button to add a new defined name. +
+ diff --git a/source/text/scalc/01/04070200.xhp b/source/text/scalc/01/04070200.xhp index d634bae21a..761a9c5ed9 100644 --- a/source/text/scalc/01/04070200.xhp +++ b/source/text/scalc/01/04070200.xhp @@ -35,7 +35,7 @@
-

Named Range or Expression

+

Insert Name

Inserts a defined named cell range at the current cursor's position with the Paste Names dialog.
You can only insert a cell area after having defined a name for the area. diff --git a/source/text/scalc/01/04070300.xhp b/source/text/scalc/01/04070300.xhp index 76fa81909f..95ddb6c055 100644 --- a/source/text/scalc/01/04070300.xhp +++ b/source/text/scalc/01/04070300.xhp @@ -1,6 +1,4 @@ - - - -Creating Names +Creating Names /text/scalc/01/04070300.xhp @@ -30,32 +27,35 @@ -cell ranges;creating names automatically +cell ranges;creating names automatically names; for cell ranges - - - -

Creating Names

-Allows you to automatically name multiple cell ranges. - + + + + +
+

Create Names

+Allows you to automatically name multiple cell ranges. +
+
- +
-Select the area containing all the ranges that you want to name. Then choose Sheet - Named Ranges and Expressions - Create. This opens the Create Names dialog, from which you can select the naming options that you want. +Select the area containing all the ranges that you want to name. Then choose Sheet - Named Ranges and Expressions - Create. This opens the Create Names dialog, from which you can select the naming options that you want.

Create names from

-Defines which part of the spreadsheet is to be used for creating the name. - +Defines which part of the spreadsheet is to be used for creating the name. +

Top row

-Creates the range names from the header row of the selected range. Each column receives a separated name and cell reference. - +Creates the range names from the header row of the selected range. Each column receives a separated name and cell reference. +

Left Column

-Creates the range names from the entries in the first column of the selected sheet range. Each row receives a separated name and cell reference. - +Creates the range names from the entries in the first column of the selected sheet range. Each row receives a separated name and cell reference. +

Bottom row

-Creates the range names from the entries in the last row of the selected sheet range. Each column receives a separated name and cell reference. - +Creates the range names from the entries in the last row of the selected sheet range. Each column receives a separated name and cell reference. +

Right Column

-Creates the range names from the entries in the last column of the selected sheet range. Each row receives a separated name and cell reference. +Creates the range names from the entries in the last column of the selected sheet range. Each row receives a separated name and cell reference. diff --git a/source/text/scalc/01/04070400.xhp b/source/text/scalc/01/04070400.xhp index 6ed548c49d..60fef5b4a8 100644 --- a/source/text/scalc/01/04070400.xhp +++ b/source/text/scalc/01/04070400.xhp @@ -22,45 +22,47 @@ -Define Label Range +Define Label Range /text/scalc/01/04070400.xhp -sheets; defining label ranges +sheets; defining label ranges label ranges in sheets - - - -Define Label Range - -Opens a dialog in which you can define a label range. - + + + + +
+

Define Label Range

+ Opens a dialog in which you can define a label range. +
+
- +
-The cell contents of a label range can be used like names in formulas - $[officename] recognizes these names in the same manner that it does the predefined names of the weekdays and months. These names are automatically completed when typed into a formula. In addition, the names defined by label ranges will have priority over names defined by automatically generated ranges. -You can set label ranges that contain the same labels on different sheets. $[officename] first searches the label ranges of the current sheet and, following a failed search, the ranges of other sheets. - - +The cell contents of a label range can be used like names in formulas - $[officename] recognizes these names in the same manner that it does the predefined names of the weekdays and months. These names are automatically completed when typed into a formula. In addition, the names defined by label ranges will have priority over names defined by automatically generated ranges. +You can set label ranges that contain the same labels on different sheets. $[officename] first searches the label ranges of the current sheet and, following a failed search, the ranges of other sheets. + +

Range

-Displays the cell reference of each label range. In order to remove a label range from the list box, select it and then click Delete. +Displays the cell reference of each label range. In order to remove a label range from the list box, select it and then click Delete. - +

Contains column labels

-Includes column labels in the current label range. - +Includes column labels in the current label range. +

Contains row labels

-Includes row labels in the current label range. - +Includes row labels in the current label range. +

For data range

-Sets the data range for which the selected label range is valid. To modify it, click in the sheet and select another range with the mouse. +Sets the data range for which the selected label range is valid. To modify it, click in the sheet and select another range with the mouse. - +

Add

-Adds the current label range to the list. +Adds the current label range to the list.
diff --git a/source/text/scalc/01/ManageNames.xhp b/source/text/scalc/01/ManageNames.xhp new file mode 100644 index 0000000000..c2b14007d0 --- /dev/null +++ b/source/text/scalc/01/ManageNames.xhp @@ -0,0 +1,49 @@ + + + + + + + Manage Names + /text/scalc/01/ManageNames.xhp + + + + + + +
+

Manage Names

+ Opens a dialog where you can manage names in the spreadsheet. +
+ +
+ +
+ +

Names area

+ Select a named range or named formula from the list to modify its properties. + + + + + + + + + + + + + + + + + diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp index 9e525c979e..4afdc0506d 100644 --- a/source/text/scalc/main0116.xhp +++ b/source/text/scalc/main0116.xhp @@ -49,10 +49,11 @@ + + -

Move or Copy Sheet

diff --git a/source/text/shared/00/00000001.xhp b/source/text/shared/00/00000001.xhp index caac6a48fa..b1f508f692 100644 --- a/source/text/shared/00/00000001.xhp +++ b/source/text/shared/00/00000001.xhp @@ -20,223 +20,223 @@ - Frequently-Used Buttons + Frequently-Used Buttons /text/shared/00/00000001.xhp

Frequently-Used Buttons

- +

Help

Click the Help button to open the help page associated with the currently open dialog.
- - - - - - - - - - + + + + + + + + + +

Cancel

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

Finish

- Applies all changes and closes the wizard. + Applies all changes and closes the wizard.

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). + 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

- In form controls, a spin button is a property of a numerical field, currency field, date field, or time field. If the property "Spin button" is enabled, the field shows a pair of symbols with arrows pointing to opposing directions, either vertically or horizontally. + In form controls, a spin button is a property of a numerical field, currency field, date field, or time field. If the property "Spin button" is enabled, the field shows a pair of symbols with arrows pointing to opposing directions, either vertically or horizontally. - In the Basic IDE, a spin button is the name used for the numerical field together with the two arrow symbols. + In the Basic IDE, a spin button is the name used for the numerical field together with the two arrow symbols. -You can type a numerical value into the field next to the spin button, or select the value with the Up Arrow or Down Arrow symbols on the spin button. On the keyboard you can press the Up Arrow and Down Arrow keys to increase or reduce the value. You can press the Page Up and Page Down keys to set the maximum and minimum value. -If the field next to the spin button defines numerical values, you can also define a measurement unit, for example, 1 cm or 5 mm, 12 pt or 2". +You can type a numerical value into the field next to the spin button, or select the value with the Up Arrow or Down Arrow symbols on the spin button. On the keyboard you can press the Up Arrow and Down Arrow keys to increase or reduce the value. You can press the Page Up and Page Down keys to set the maximum and minimum value. +If the field next to the spin button defines numerical values, you can also define a measurement unit, for example, 1 cm or 5 mm, 12 pt or 2".

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. + 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

-To activate the context menu of an object, first click the object with the +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 click the right mouse button. Some context menus can be called even if the object has not been selected. Context menus are found just about everywhere in $[officename].
- - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + +

Delete

- Deletes the selected element or elements after confirmation. + Deletes the selected element or elements after confirmation.
- - - - - - - - + + + + + + + +

Delete

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

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. + 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

- Closes the dialog and saves all changes. + Closes the dialog and saves all changes.

Close

- Closes the dialog. + Closes the dialog.
- +

Apply

- Applies the modified or selected values without closing the dialog. + Applies the modified or selected values without closing the dialog.
-This option appears only for Paragraph Style, Frame Style, and Page Style. +This option appears only for Paragraph Style, Frame Style, and Page Style.
-This option appears only for Paragraph Style and Character Style. +This option appears only for Paragraph Style and Character Style.
- - - - - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + + + + +

Shrink / Expand

- 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 Expand 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. + 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 Expand 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. - Icon shrink + Icon shrink - Shrink + Shrink - Icon Expand + Icon Expand - Expand + Expand
- - - - - + + + + +

Preview Field

- Displays a preview of the current selection. + Displays a preview of the current selection.

Preview

- - - - - - - + + + + + + + - +

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. + 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

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

Cancel

- Closes dialog and discards all changes. + Closes dialog and discards all changes.
- +

OK

- Saves all changes and closes dialog. + Saves all changes and closes dialog.
- +

Resetin Tools - Options

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

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. + 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.
- - - + + +

StandardUFI: Name is Default on Tools-Options-Writer-Basic Fonts

- Resets the values visible in the dialog back to the default installation values. + Resets the values visible in the dialog back to the default installation values. A confirmation does not appear before the defaults are reloaded.
@@ -256,42 +256,42 @@ Values for the current tab are set to those found in the corresponding tab of the style specified in “Inherit from” in Organizer. In all cases, also when “Inherit from” is “- None -”, current tab values specified in “Contains” are removed.
-This option appears only for Paragraph Style, Character Style, and Frame Style. +This option appears only for Paragraph Style, Character Style, and Frame Style.
- - - - - - - - + + + + + + + +

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. + 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

- Click the Options label to expand the dialog to show further options. Click again to restore the dialog. + Click the Options label to expand the dialog to show further options. Click again to restore the dialog.
-See also the following functions: +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 regular expression metacharacter or operator 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 regular expression metacharacter or operator 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. +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

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

Cancel

-Close the Options dialog and discard all changes done. +Close the Options dialog and discard all changes done.

Apply

Applies the modified or selected values without closing the Options dialog. -- cgit