From e9c7414e4fd17c6f2ffbe6208db2c741fe33e803 Mon Sep 17 00:00:00 2001 From: Dione Maddern Date: Mon, 18 Nov 2024 15:56:37 +0100 Subject: tdf#162504 Create help page for Number Format pane Create new page source/text/scalc/sidebar_number_format.xhp to describe the features of the Number Format pane in the Properties sidebar deck. In AllLangHelp_scalc.mk - Add new file source/text/scalc/sidebar_number_format.xhp to repository. In source/text/scalc/01/default_number_formats.xhp - Add variable and section tags so that content can be easily linked and embedded in other pages. - Remove old comments In source/text/shared/01/05020300.xhp - Add variable and section tags so that content can be easily linked and embedded in other pages. - Remove old comments In /home/dione/libreoffice/helpcontent2/source/text/shared/01/sidebar_properties.xhp THIS PAGE IS A WIP AND WILL NOT BE LINKED IN HELP UNTIL IT IS FINISHED - Embed description of the help page for Number Formats - Added index bookmarks (Currently commented out) - Updated application switches to hide the desription of the Paragraph pane for CALC and BASE. Change-Id: I7e1849ddc41cad7fd5d4b6c57e8a03186eb6575f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/176720 Tested-by: Jenkins Tested-by: Olivier Hallot Reviewed-by: Olivier Hallot --- AllLangHelp_scalc.mk | 1 + source/text/scalc/01/default_number_formats.xhp | 81 ++++++----- source/text/scalc/sidebar_number_format.xhp | 130 +++++++++++++++++ source/text/shared/01/05020300.xhp | 178 ++++++++++++++++-------- source/text/shared/01/sidebar_properties.xhp | 29 +++- 5 files changed, 326 insertions(+), 93 deletions(-) create mode 100644 source/text/scalc/sidebar_number_format.xhp diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index b22994f520..4824307ddc 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -346,6 +346,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/SheetCommentMenu \ helpcontent2/source/text/scalc/01/sheet_tab_color \ helpcontent2/source/text/scalc/01/ShowNote \ + helpcontent2/source/text/scalc/sidebar_number_format \ helpcontent2/source/text/scalc/01/solver \ helpcontent2/source/text/scalc/01/solver_options \ helpcontent2/source/text/scalc/01/solver_options_algo \ diff --git a/source/text/scalc/01/default_number_formats.xhp b/source/text/scalc/01/default_number_formats.xhp index 7fed8f8e92..350ecdcd64 100644 --- a/source/text/scalc/01/default_number_formats.xhp +++ b/source/text/scalc/01/default_number_formats.xhp @@ -16,8 +16,8 @@
- -

Number Format

+ +

Number Format

Default number formats.
@@ -25,8 +25,10 @@
-

Number format: General

- Applies the default number format to the selected cells. +

Number format: General

+
+ Applies the default number format to the selected cells. +
Choose Format - Number Format - General. @@ -48,8 +50,10 @@
-

Number format: Number

- Applies the default decimal number format to the selected cells. +

Number format: Number

+
+ Applies the default decimal number format to the selected cells. +
Choose Format - Number Format - Number. @@ -74,8 +78,10 @@
-

Number format: Percent

- Applies the percentage format to the selected cells. +

Number format: Percent

+
+ Applies the percentage format to the selected cells. +
Choose Format - Number Format - Percent. @@ -99,8 +105,10 @@
-

Number format: Currency

- Applies the default currency format to the selected cells. +

Number format: Currency

+
+ Applies the default currency format to the selected cells. +
Choose Format - Number Format - Currency. @@ -120,11 +128,12 @@ CommandCtrl + Shift + 4
- +
- -

Number Format : Date

- Applies the default date format to the selected cells. +

Number Format : Date

+
+ Applies the default date format to the selected cells. +
Choose Format - Number Format - Date. @@ -147,10 +156,12 @@
+
- -

Number Format: Time

- Applies the default time format to the selected cells. +

Number Format: Time

+
+ Applies the default time format to the selected cells. +
Choose Format - Number Format - Time. @@ -171,10 +182,12 @@
+
- -

Number Format: Scientific

- Applies the default scientific format to the selected cells. +

Number Format: Scientific

+
+ Applies the default scientific format to the selected cells. +
Choose Format - Number Format - Scientific. @@ -198,8 +211,10 @@
-

Number Format: Thousands Separator

- Applies the thousand separator to the number in the selected cells. +

Number Format: Thousands Separator

+
+ Applies the thousand separator to the number in the selected cells. +
Choose Format - Number Format - Thousands Separator. @@ -217,11 +232,12 @@
-
mw copied three index entries to Calc guide format_value.xhp - -

Number Format: Delete Decimal Place

- Removes one decimal place from the numbers in the selected cells. - + +
+

Number Format: Delete Decimal Place

+
+ Removes one decimal place from the numbers in the selected cells. +
@@ -234,11 +250,12 @@
- -
mw copied three index entries to Calc guide format_value.xhp - -

Number Format: Add Decimal Place

- Adds one decimal place to the numbers in the selected cells. + +
+

Number Format: Add Decimal Place

+
+ Adds one decimal place to the numbers in the selected cells. +
diff --git a/source/text/scalc/sidebar_number_format.xhp b/source/text/scalc/sidebar_number_format.xhp new file mode 100644 index 0000000000..8a8d9afa64 --- /dev/null +++ b/source/text/scalc/sidebar_number_format.xhp @@ -0,0 +1,130 @@ + + + + + + + Number Format + /text/scalc/sidebar_number_format.xhp + + + + +
+

Number Format

+
+ Use the Number Format panel to set the number format for a cell or range. +
+
+
+ + OptionAlt + 1 + + Open the Properties sidebar deck and expand the Number Format pane. + +
+ +
+

Format as Number

+
+ +
+
+
+ + + Icon General Number Format + + + Format as Number + + +
+
+
+
+

Format as Percent

+ +
+
+ + + + + Icon Number Format: Percent + + + + Format as Percent + + +
+
+ +
+

Format as Currency

+
+ +
+
+ + + + Currency Number Format Icon + + + Format as Currency + + +
+
+ + To apply a different currency format, click the Format as Currency icon, select a currency from the list, and click OK. +
+ +
+

Category

+
+ Select a default format from the dropdown list. +
+
+ +
+

+ +
+ +
+

+ +
+ +
+

+ +
+ +
+

+ +
+ +
+

+ +
+
+ + + + +
+ + diff --git a/source/text/shared/01/05020300.xhp b/source/text/shared/01/05020300.xhp index eb9a643766..e6530af33c 100644 --- a/source/text/shared/01/05020300.xhp +++ b/source/text/shared/01/05020300.xhp @@ -31,8 +31,6 @@ currencies;format codes defaults; number formats - mw transferred "format codes;" to Calc guide Format_value_userdef.xhp and "numbers;" and "cells;" to Calc guide Format_table.xhp. Changed "currencies;" - @@ -57,80 +55,144 @@ Select a category from the list, and then select a formatting style in the Format box. - The default currency format for a cell is determined by the regional settings of your operating system. +
+ The default currency format for a cell is determined by the regional settings of your operating system. +
-

Format

- Select how you want the contents of the selected cell(s) field to be displayed. The code for the selected option is displayed in the Format code box. +
+

Format

+
+ Select how you want the contents of the selected cell(s) field to be displayed. The code for the selected option is displayed in the Format code box. +
+
-

Currency category list boxes

- Select a currency, and then scroll to the top of the Format list to view the formatting options for the currency. +
+

Currency category list boxes

+
+ Select a currency, and then scroll to the top of the Format list to view the formatting options for the currency. +
The format code for currencies uses the form [$xxx-nnn], where xxx is the currency symbol, and nnn the country code. Special banking symbols, such as EUR (for Euro), do not require the country code. The currency format is not dependent on the language that you select in the Language box.
+
-

Language

- - - - - Specifies the language setting for the selected fields. With the language set to Default, $[officename] automatically applies the number formats associated with the system default language. - - - Specifies the language setting for the selected cells. - - Specifies the language setting for the selected field. - - - - - The language setting ensures that date and currency formats, as well as decimal and thousands separators, are preserved even when the document is opened in an operating system that uses a different default language setting. - - - -

Source format

- Uses the same number format as the cells containing the data for the chart. - - -

Options

- Specify the options for the selected format. +
+

Language

+
+ + + + + Specifies the language setting for the selected fields. With the language set to Default, $[officename] automatically applies the number formats associated with the system default language. + + + Specifies the language setting for the selected cells. + + Specifies the language setting for the selected field. + + + + The language setting ensures that date and currency formats, as well as decimal and thousands separators, are preserved even when the document is opened in an operating system that uses a different default language setting. +
+
+
+ + + +

Source format

+
+ Uses the same number format as the cells containing the data for the chart. +
+ + +
+
+

Options

+
+ Specify the options for the selected format. +
+
-

Decimal places

- Enter the number of decimal places that you want to display. +
+

Decimal places

+
+ Enter the number of decimal places that you want to display. +
+
-

Denominator places

- With fraction format, enter the number of places for the denominator that you want to display. +
+

Denominator places

+
+ With fraction format, enter the number of places for the denominator that you want to display. +
+
-

Leading zeroes

- Enter the maximum number of zeroes to display in front of the decimal point. +
+

Leading zeroes

+
+ Enter the maximum number of zeroes to display in front of the decimal point. +
+
-

Negative numbers red

- Changes the font color of negative numbers to red. +
+

Negative numbers red

+
+ Changes the font color of negative numbers to red. +
+
-

Thousands separator

- Inserts a separator between thousands. The type of separator that is used depends on your locale settings. +
+

Thousands separator

+
+ Inserts a separator between thousands. The type of separator that is used depends on your locale settings. +
+
-

Engineering notation

- With scientific format, Engineering notation ensures that exponent is a multiple of 3. +
+

Engineering notation

+
+ With scientific format, Engineering notation ensures that exponent is a multiple of 3. +
+
-

Format code

- Displays the number format code for the selected format. You can also enter a custom format. The following options are only available for user-defined number formats. +
+

Format code

+
+ Displays the number format code for the selected format. You can also enter a custom format. The following options are only available for user-defined number formats. +
+
-

Add

- Adds the number format code that you entered to the user-defined category. +
+

Add

+
+ Adds the number format code that you entered to the user-defined category. +
+
-

Edit Comment

- Adds a comment to the selected number format. - -

Delete

- Deletes the selected number format. The changes are effective after you restart $[officename]. +
+

Edit Comment

+
+ Adds a comment to the selected number format. +
+
+ +

Delete

+
+ Deletes the selected number format. The changes are effective after you restart $[officename]. +
+
-

Name line

- Enter a comment for the selected number format, and then click outside this box. - -
- Number format codes: custom format codes defined by user. +
+

Name line

+
+ Enter a comment for the selected number format, and then click outside this box.
+
+ +
+ Number format codes: custom format codes defined by user. +
diff --git a/source/text/shared/01/sidebar_properties.xhp b/source/text/shared/01/sidebar_properties.xhp index 39172b6314..6713a50f4b 100644 --- a/source/text/shared/01/sidebar_properties.xhp +++ b/source/text/shared/01/sidebar_properties.xhp @@ -16,9 +16,13 @@ + - -

Properties Sidebar

+ +

Properties Sidebar

The Properties sidebar provides quick access to options for formatting the layout and the contents of a document.
@@ -59,6 +63,8 @@ + + @@ -76,6 +82,23 @@ - + + + + + + + + + + + +
+ +
+ + + + -- cgit