From d6cb61568afd30c4effc53b209716faec001412a Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Wed, 1 Nov 2023 08:54:06 -0300 Subject: tdf#155876 UI cmds Calc Insert menu (10-a) + refactoring Change-Id: Ia344ee8beb056dd42f1c53e4ba84b48107b730e7 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158757 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/00/00000404.xhp | 98 +++++++++++++++++++--------------- source/text/scalc/01/sparklines.xhp | 39 +++++++------- source/text/shared/01/ZoomOptimal.xhp | 2 +- source/text/shared/01/insert_chart.xhp | 2 +- 4 files changed, 76 insertions(+), 65 deletions(-) (limited to 'source/text') diff --git a/source/text/scalc/00/00000404.xhp b/source/text/scalc/00/00000404.xhp index acb8018706..a582672a59 100644 --- a/source/text/scalc/00/00000404.xhp +++ b/source/text/scalc/00/00000404.xhp @@ -20,7 +20,7 @@ - Insert Menu + Insert Menu /text/scalc/00/00000404.xhp @@ -29,18 +29,28 @@

Insert Menu

+ +
+ + Choose Insert - Sparkline. + + Choose Sparklines - Sparklines. + + On the Data menu of the Data tab, choose Sparklines - Sparklines. +
+
-Choose Sheet - Insert Cells. -Choose View - Toolbars and select the Insert Cells toolbar: +Choose Sheet - Insert Cells. +Choose View - Toolbars and select the Insert Cells toolbar:
- -Icon + +Icon -Insert Cells +Insert Cells
@@ -51,11 +61,11 @@ - -Icon + +Icon -Insert Cells Down +Insert Cells Down
@@ -65,11 +75,11 @@ - -Icon + +Icon -Insert Cells Right +Insert Cells Right
@@ -79,11 +89,11 @@ - -Icon + +Icon -Insert Rows +Insert Rows
@@ -93,67 +103,67 @@ - -Icon + +Icon -Insert Columns +Insert Columns
-Choose Sheet - Insert Sheet from File. +Choose Sheet - Insert Sheet from File.
-Choose Insert - Function. -CommandCtrl+F2 - On the Formula bar, click +Choose Insert - Function. +CommandCtrl+F2 + On the Formula bar, click
- -Icon + +Icon -Function Wizard +Function Wizard
-Insert - Function - Category Database +Insert - Function - Category Database -Insert - Function - Category Date & Time +Insert - Function - Category Date & Time -Insert - Function - Category Financial +Insert - Function - Category Financial -Insert - Function - Category Information +Insert - Function - Category Information -Insert - Function - Category Logical +Insert - Function - Category Logical -Insert - Function - Category Mathematical +Insert - Function - Category Mathematical -Insert - Function - Category Array +Insert - Function - Category Array -Insert - Function - Category Statistical +Insert - Function - Category Statistical -Insert - Function - Category Text +Insert - Function - Category Text -Insert - Function - Category Spreadsheet +Insert - Function - Category Spreadsheet -Insert - Function - Category Add-In +Insert - Function - Category Add-In -Insert - Function - Category Add-In +Insert - Function - Category Add-In -Choose Insert - Named Range or Expression. -Choose Sheet - External Links. +Choose Insert - Named Range or Expression. +Choose Sheet - External Links.
-Choose Sheet - Named Ranges and Expressions - Define. -CommandCtrl+F3 +Choose Sheet - Named Ranges and Expressions - Define. +CommandCtrl+F3
-Choose Sheet - Named Ranges and Expressions - Insert. -Choose Sheet - Named Ranges and Expressions - Create. -Choose Sheet - Named Ranges and Expressions - Labels. +Choose Sheet - Named Ranges and Expressions - Insert. +Choose Sheet - Named Ranges and Expressions - Create. +Choose Sheet - Named Ranges and Expressions - Labels. diff --git a/source/text/scalc/01/sparklines.xhp b/source/text/scalc/01/sparklines.xhp index 3671605cc8..a9126832fe 100644 --- a/source/text/scalc/01/sparklines.xhp +++ b/source/text/scalc/01/sparklines.xhp @@ -11,25 +11,26 @@ - Sparklines + Sparklines /text/scalc/01/sparklines.xhp - - - - - + + + + + sparklines - +

Sparklines

- Sparklines are small data charts displayed inside a cell. + Opens the Sparklines Properties dialog to define sparklines properties.
- Sparklines are defined for one cell, but multiple sparklines can be joined together into a group. The group shares the same properties for rendering the sparkline. The unique data that is defined only for one sparkline is the data range, that a sparkline will use for rendering.
- Choose Insert - Sparkline. +
+ Sparklines are small data charts displayed inside a cell. + Sparklines are defined for one cell, but multiple sparklines can be joined together into a group. The group shares the same properties for rendering the sparkline. The unique data that is defined only for one sparkline is the data range, that a sparkline will use for rendering.

Data

Input range: enter the cell range of the data. Use the shrink button to select the data range with the mouse. Output range: select the cell range to receive the sparkline. Use the shrink button to select the cell range with the mouse. @@ -37,26 +38,26 @@ Type: select the sparkline type in the drop-down list. Choices are: - Line: draws a line between data values. + Line: draws a line between data values. - Column: draws a bar for each data value. + Column: draws a bar for each data value. - Stacked: also known as win/loss. Displays equally sized bars indicating positive and negative values. + Stacked: also known as win/loss. Displays equally sized bars indicating positive and negative values. Line thickness: enter the line thickness number manually or use the spin button. Display empty cells as: choices are available in the drop-down list: - Gap: the missing data is not displayed. The line type discontinues in the gap and the column is not displayed. + Gap: the missing data is not displayed. The line type discontinues in the gap and the column is not displayed. - Zero: the missing data is displayed as value zero. + Zero: the missing data is displayed as value zero. - Span: for line type only, draws a continuous line connecting the previous value to the next value. + Span: for line type only, draws a continuous line connecting the previous value to the next value. Display hidden: check to show all columns or stacks in the range even when the data is in hidden cells. If unchecked, the hidden data is ignored. @@ -75,13 +76,13 @@ Vertical minimum, Vertical maximum: check to set the minimum (maximum) value for the Y axis. Select one of following: - Individual: sets automatically the minimum (maximum) value for each sparkline based on the sparkline data range values. + Individual: sets automatically the minimum (maximum) value for each sparkline based on the sparkline data range values. - Group: sets the minimum (maximum) value based on the lower and higher values found in the group of sparklines. + Group: sets the minimum (maximum) value based on the lower and higher values found in the group of sparklines. - Custom: enter the minimum (maximum) value for the sparkline group. Enter the minimum (maximum) values or use the spin buttons. + Custom: enter the minimum (maximum) value for the sparkline group. Enter the minimum (maximum) values or use the spin buttons.
diff --git a/source/text/shared/01/ZoomOptimal.xhp b/source/text/shared/01/ZoomOptimal.xhp index 1bf415979a..9dae5a8f56 100644 --- a/source/text/shared/01/ZoomOptimal.xhp +++ b/source/text/shared/01/ZoomOptimal.xhp @@ -18,7 +18,7 @@
-

Zoom Optimal

+

Optimal

Resizes the display to include all of the objects on the slidepage.
diff --git a/source/text/shared/01/insert_chart.xhp b/source/text/shared/01/insert_chart.xhp index cf411830ab..671b3ae260 100644 --- a/source/text/shared/01/insert_chart.xhp +++ b/source/text/shared/01/insert_chart.xhp @@ -21,7 +21,7 @@ Chart - /text/shared/menu/insert_chart.xhp + /text/shared/01/insert_chart.xhp -- cgit