From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/02/02130000.xhp | 51 +++++++++++++++ helpcontent2/source/text/scalc/02/02140000.xhp | 59 ++++++++++++++++++ helpcontent2/source/text/scalc/02/02150000.xhp | 50 +++++++++++++++ helpcontent2/source/text/scalc/02/02160000.xhp | 49 +++++++++++++++ helpcontent2/source/text/scalc/02/02170000.xhp | 49 +++++++++++++++ helpcontent2/source/text/scalc/02/06010000.xhp | 61 ++++++++++++++++++ helpcontent2/source/text/scalc/02/06030000.xhp | 86 ++++++++++++++++++++++++++ helpcontent2/source/text/scalc/02/06040000.xhp | 55 ++++++++++++++++ helpcontent2/source/text/scalc/02/06050000.xhp | 40 ++++++++++++ helpcontent2/source/text/scalc/02/06060000.xhp | 57 +++++++++++++++++ helpcontent2/source/text/scalc/02/06070000.xhp | 57 +++++++++++++++++ helpcontent2/source/text/scalc/02/06080000.xhp | 56 +++++++++++++++++ helpcontent2/source/text/scalc/02/08010000.xhp | 39 ++++++++++++ helpcontent2/source/text/scalc/02/08080000.xhp | 45 ++++++++++++++ helpcontent2/source/text/scalc/02/10050000.xhp | 59 ++++++++++++++++++ helpcontent2/source/text/scalc/02/10060000.xhp | 58 +++++++++++++++++ helpcontent2/source/text/scalc/02/18010000.xhp | 75 ++++++++++++++++++++++ helpcontent2/source/text/scalc/02/18020000.xhp | 56 +++++++++++++++++ 18 files changed, 1002 insertions(+) create mode 100644 helpcontent2/source/text/scalc/02/02130000.xhp create mode 100644 helpcontent2/source/text/scalc/02/02140000.xhp create mode 100644 helpcontent2/source/text/scalc/02/02150000.xhp create mode 100644 helpcontent2/source/text/scalc/02/02160000.xhp create mode 100644 helpcontent2/source/text/scalc/02/02170000.xhp create mode 100644 helpcontent2/source/text/scalc/02/06010000.xhp create mode 100644 helpcontent2/source/text/scalc/02/06030000.xhp create mode 100644 helpcontent2/source/text/scalc/02/06040000.xhp create mode 100644 helpcontent2/source/text/scalc/02/06050000.xhp create mode 100644 helpcontent2/source/text/scalc/02/06060000.xhp create mode 100644 helpcontent2/source/text/scalc/02/06070000.xhp create mode 100644 helpcontent2/source/text/scalc/02/06080000.xhp create mode 100644 helpcontent2/source/text/scalc/02/08010000.xhp create mode 100644 helpcontent2/source/text/scalc/02/08080000.xhp create mode 100644 helpcontent2/source/text/scalc/02/10050000.xhp create mode 100644 helpcontent2/source/text/scalc/02/10060000.xhp create mode 100644 helpcontent2/source/text/scalc/02/18010000.xhp create mode 100644 helpcontent2/source/text/scalc/02/18020000.xhp (limited to 'helpcontent2/source/text/scalc/02') diff --git a/helpcontent2/source/text/scalc/02/02130000.xhp b/helpcontent2/source/text/scalc/02/02130000.xhp new file mode 100644 index 000000000..9c3cd10c7 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/02130000.xhp @@ -0,0 +1,51 @@ + + + + + +Number format: Currency +/text/scalc/02/02130000.xhp + + +Sun Microsystems, Inc. + + + +
+ +

Number format: Currency

+ Applies the default currency format to the selected cells. +
+
+ + + + Currency Number Format Icon + + + Number Format: Currency + + +
+
+
+ Format - Cells - Numbers. +
+ + diff --git a/helpcontent2/source/text/scalc/02/02140000.xhp b/helpcontent2/source/text/scalc/02/02140000.xhp new file mode 100644 index 000000000..20cfb1bde --- /dev/null +++ b/helpcontent2/source/text/scalc/02/02140000.xhp @@ -0,0 +1,59 @@ + + + + + +Number format: Percent +/text/scalc/02/02140000.xhp + + +Sun Microsystems, Inc. + + + +
+ +

Number format: Percent

+Applies the percentage format to the selected cells. +
+
+ + + + +Icon + + +Number Format: Percent + + +
+ +
+percentage calculations + +You can also enter a percentage sign (%) after a number in a cell: +1% corresponds to 0.01 +1 + 16% corresponds to 116% or 1.16 +1%% corresponds to 0.0001 +
+Format - Cells - Numbers +
+ + diff --git a/helpcontent2/source/text/scalc/02/02150000.xhp b/helpcontent2/source/text/scalc/02/02150000.xhp new file mode 100644 index 000000000..ac6bb9fda --- /dev/null +++ b/helpcontent2/source/text/scalc/02/02150000.xhp @@ -0,0 +1,50 @@ + + + + + +Number format: Default +/text/scalc/02/02150000.xhp + + +Sun Microsystems, Inc. + + + +
+ +

Number format: Default

+ Applies the default number format to the selected cells. +
+
+ + + + Icon Standard Format + + + Number Format: Standard + + +
+
+
+ Format - Cells - Numbers. +
+ diff --git a/helpcontent2/source/text/scalc/02/02160000.xhp b/helpcontent2/source/text/scalc/02/02160000.xhp new file mode 100644 index 000000000..05622e11b --- /dev/null +++ b/helpcontent2/source/text/scalc/02/02160000.xhp @@ -0,0 +1,49 @@ + + + + + +Number Format: Add Decimal Place +/text/scalc/02/02160000.xhp + + +Sun Microsystems, Inc. + + + +
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. +
+
+ + + + +Icon Add Decimal Place + + +Number Format: Add Decimal Place + + +
+
+ + diff --git a/helpcontent2/source/text/scalc/02/02170000.xhp b/helpcontent2/source/text/scalc/02/02170000.xhp new file mode 100644 index 000000000..e2e2b59ee --- /dev/null +++ b/helpcontent2/source/text/scalc/02/02170000.xhp @@ -0,0 +1,49 @@ + + + + + +Number Format: Delete Decimal Place +/text/scalc/02/02170000.xhp + + +Sun Microsystems, Inc. + + + +
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. +
+
+ + + + +Icon Delete Decimal Place + + +Number Format: Delete Decimal Place + + +
+
+ + diff --git a/helpcontent2/source/text/scalc/02/06010000.xhp b/helpcontent2/source/text/scalc/02/06010000.xhp new file mode 100644 index 000000000..9399da39c --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06010000.xhp @@ -0,0 +1,61 @@ + + + + + + + + +Name Box +/text/scalc/02/06010000.xhp + + +Sun Microsystems, Inc. + + + +
+formula bar; sheet area names +sheet area names +showing; cell references +cell references; showing + + + +Name Box +Displays the reference for the current cell, the range of the selected cells, or the name of the area. You can also select a range of cells, and then type a name for that range into the Name Box.UFI: fixes #i28238# +
+
+ + + + +Combo box sheet area + + + +Name Box + + +
+ +
+To jump to a particular cell, or to select a cell range, type the cell reference, or cell range reference in this box, for example, F1, or A1:C4. You can also enter full name of a sheet; the tooltip then changes to "Go To Sheet", and pressing Enter switches to that sheet. + + diff --git a/helpcontent2/source/text/scalc/02/06030000.xhp b/helpcontent2/source/text/scalc/02/06030000.xhp new file mode 100644 index 000000000..cbc1f81b9 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06030000.xhp @@ -0,0 +1,86 @@ + + + + + + + + + Sum + /text/scalc/02/06030000.xhp + + + +
+functions;sum function icon + formula bar;sum function + sum icon + AutoSum button, see sum icon + +MW inserted a cross-reference +

Select Function

+ Insert a function of a cell range into the current cell. The function can be Sum, Average, Minimum, Maximum and Count. Click in a cell, click this icon, select the function in the drop down list and optionally adjust the cell range. Or select some cells into which the function value will be inserted, then click the icon. The function result is added at the bottom of the range. +
+
+ + + + +Icon Select Function + + + + Select Function + + +
+
+

Select Function applied with no selected range

+$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a function, you can combine it with the new one to yield the function applied to the range data. If the range contains filters, the Subtotal function is inserted instead of the selected function. + Click the Accept icon to use the formula displayed in the input line or Cancel. + + + + +Accept Icon + + + + Accept + + +
+ + + + +Icon Cancel + + + + Cancel + + +
+ +

Select Function applied on a selected range

+When the selected range has two or more rows, the function is calculated for each column. The results are placed in empty cells on the first available row below the range, one result per column. +When the selected range has one row, the function result is placed in the first available cell on the right of the selected range. + + diff --git a/helpcontent2/source/text/scalc/02/06040000.xhp b/helpcontent2/source/text/scalc/02/06040000.xhp new file mode 100644 index 000000000..bc96cf5f1 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06040000.xhp @@ -0,0 +1,55 @@ + + + + + + + + +Function +/text/scalc/02/06040000.xhp + + + +
+formula bar; functions +functions; formula bar icon + + +Function +Adds a formula to the current cell. Click this icon, and then enter the formula in the Input line. +
+This icon is only available when the Input line box is not active. +
+ + + + +Icon + + + +Function + + +
+ +
+ + diff --git a/helpcontent2/source/text/scalc/02/06050000.xhp b/helpcontent2/source/text/scalc/02/06050000.xhp new file mode 100644 index 000000000..a9f181f43 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06050000.xhp @@ -0,0 +1,40 @@ + + + + + + + + +Input line +/text/scalc/02/06050000.xhp + + +Sun Microsystems, Inc. + + + +
+ +Input line +Enter the formula that you want to add to the current cell. You can also click the Function Wizard icon to insert a predefined function into the formula. +
+ + + diff --git a/helpcontent2/source/text/scalc/02/06060000.xhp b/helpcontent2/source/text/scalc/02/06060000.xhp new file mode 100644 index 000000000..a12414c27 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06060000.xhp @@ -0,0 +1,57 @@ + + + + + + + + +Cancel +/text/scalc/02/06060000.xhp + + +Sun Microsystems, Inc. + + + +
+formula bar; canceling inputs +functions; canceling input icon + + +Cancel +Clears the contents of the Input line, or cancels the changes that you made to an existing formula. +
+
+ + + + +Icon + + + +Cancel + + +
+ +
+ + diff --git a/helpcontent2/source/text/scalc/02/06070000.xhp b/helpcontent2/source/text/scalc/02/06070000.xhp new file mode 100644 index 000000000..fc429343f --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06070000.xhp @@ -0,0 +1,57 @@ + + + + + + + + +Accept +/text/scalc/02/06070000.xhp + + +Sun Microsystems, Inc. + + + +
+formula bar; accepting inputs +functions; accepting input icon + + +Accept +Accepts the contents of the Input line, and then inserts the contents into the current cell. +
+
+ + + + +Icon + + + +Accept + + +
+ +
+ + diff --git a/helpcontent2/source/text/scalc/02/06080000.xhp b/helpcontent2/source/text/scalc/02/06080000.xhp new file mode 100644 index 000000000..651d6fdf0 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/06080000.xhp @@ -0,0 +1,56 @@ + + + + + + + + +Theme Selection +/text/scalc/02/06080000.xhp + + +Sun Microsystems, Inc. + + + + +Theme Selection +Applies a formatting style to the selected cells. + The styles include font, border, and background color information. +
+ + + + +Icon + + + +Choose Themes + + +
+ +
+ +Click the formatting theme that you want to apply, and then click OK. + + + diff --git a/helpcontent2/source/text/scalc/02/08010000.xhp b/helpcontent2/source/text/scalc/02/08010000.xhp new file mode 100644 index 000000000..39b648223 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/08010000.xhp @@ -0,0 +1,39 @@ + + + + + + + + +Position in document +/text/scalc/02/08010000.xhp + + +Sun Microsystems, Inc. + + + +
+ +Position in document +Displays the number of the current sheet and the total number of sheets in the spreadsheet. +
+ + diff --git a/helpcontent2/source/text/scalc/02/08080000.xhp b/helpcontent2/source/text/scalc/02/08080000.xhp new file mode 100644 index 000000000..0b73bdfac --- /dev/null +++ b/helpcontent2/source/text/scalc/02/08080000.xhp @@ -0,0 +1,45 @@ + + + + + + + + +Standard Formula, Date/Time, Error Warning +/text/scalc/02/08080000.xhp + + +Sun Microsystems, Inc. + + + +
+formulas;status bar +MW changed index entry + +Standard Formula, Date/Time, Error Warning +Displays information about the current document. By default, the SUM of the contents of the selected cells is displayed. +
+To change the default formula that is displayed, right-click the field, and then choose the formula that you want. The available formulas are: Average, count of values (COUNTA), count of numbers (COUNT), Maximum, Minimum, Sum, or None. +
+Error codes +
+ + diff --git a/helpcontent2/source/text/scalc/02/10050000.xhp b/helpcontent2/source/text/scalc/02/10050000.xhp new file mode 100644 index 000000000..a6b9f0d58 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/10050000.xhp @@ -0,0 +1,59 @@ + + + + + + + + +Zoom In +/text/scalc/02/10050000.xhp + + +Sun Microsystems, Inc. + + + +
+page views; increasing scales +increasing scales in page view +zooming;enlarging page views +mw deleted "scaling;" + +Zoom In +Enlarges the screen display of the current document. The current zoom factor is displayed on the Status Bar. +
+The maximum zoom factor is 400%. +
+ + + + +Icon + + + +Zoom In + + +
+ +
+ + diff --git a/helpcontent2/source/text/scalc/02/10060000.xhp b/helpcontent2/source/text/scalc/02/10060000.xhp new file mode 100644 index 000000000..2ed616c7e --- /dev/null +++ b/helpcontent2/source/text/scalc/02/10060000.xhp @@ -0,0 +1,58 @@ + + + + + + + + +Zoom Out +/text/scalc/02/10060000.xhp + + +Sun Microsystems, Inc. + + + +
+page views;reducing scales +zooming;reducing page views +mw deleted "scaling;" + +Zoom Out +Reduces the screen display of the current document. The current zoom factor is displayed on the Status Bar. +
+The minimum zoom factor is 20%. +
+ + + + +Icon + + + +Zooming Out + + +
+ +
+ + diff --git a/helpcontent2/source/text/scalc/02/18010000.xhp b/helpcontent2/source/text/scalc/02/18010000.xhp new file mode 100644 index 000000000..f6c5fb777 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/18010000.xhp @@ -0,0 +1,75 @@ + + + + + + + + + + +Insert +/text/scalc/02/18010000.xhp + + + +
+inserting; objects, toolbar icon + + +Insert +Click the arrow next to the icon to open the Insert toolbar, where you can add graphics and special characters to the current sheet. +
+Tools bar icon: +
+ + + + +Icon + + + +Insert + + +
+
+You can select the following icons: +Floating Frame + + +Special Character + + +From File + + + + +Formula + + +Chart + +OLE Object + + + + diff --git a/helpcontent2/source/text/scalc/02/18020000.xhp b/helpcontent2/source/text/scalc/02/18020000.xhp new file mode 100644 index 000000000..c930837f1 --- /dev/null +++ b/helpcontent2/source/text/scalc/02/18020000.xhp @@ -0,0 +1,56 @@ + + + + + + + + +Insert Cells +/text/scalc/02/18020000.xhp + + +Sun Microsystems, Inc. + + + +
+inserting; cells, toolbar icon + + +Insert Cells +Click the arrow next to the icon to open the Insert Cells toolbar, where you can insert cells, rows, and columns into the current sheet. +
+Tools bar icon: + +You can select the following icons: +Insert Cells Down + + +Insert Cells Right + + +Rows + + +Columns + + + + -- cgit v1.2.3