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/00/00000004.xhp | 33 ++++ helpcontent2/source/text/scalc/00/00000402.xhp | 58 +++++++ helpcontent2/source/text/scalc/00/00000403.xhp | 35 +++++ helpcontent2/source/text/scalc/00/00000404.xhp | 161 +++++++++++++++++++ helpcontent2/source/text/scalc/00/00000405.xhp | 82 ++++++++++ helpcontent2/source/text/scalc/00/00000406.xhp | 82 ++++++++++ helpcontent2/source/text/scalc/00/00000407.xhp | 34 ++++ helpcontent2/source/text/scalc/00/00000412.xhp | 172 +++++++++++++++++++++ .../source/text/scalc/00/avail_release.xhp | 87 +++++++++++ helpcontent2/source/text/scalc/00/sheet_menu.xhp | 46 ++++++ 10 files changed, 790 insertions(+) create mode 100644 helpcontent2/source/text/scalc/00/00000004.xhp create mode 100644 helpcontent2/source/text/scalc/00/00000402.xhp create mode 100644 helpcontent2/source/text/scalc/00/00000403.xhp create mode 100644 helpcontent2/source/text/scalc/00/00000404.xhp create mode 100644 helpcontent2/source/text/scalc/00/00000405.xhp create mode 100644 helpcontent2/source/text/scalc/00/00000406.xhp create mode 100644 helpcontent2/source/text/scalc/00/00000407.xhp create mode 100644 helpcontent2/source/text/scalc/00/00000412.xhp create mode 100644 helpcontent2/source/text/scalc/00/avail_release.xhp create mode 100644 helpcontent2/source/text/scalc/00/sheet_menu.xhp (limited to 'helpcontent2/source/text/scalc/00') diff --git a/helpcontent2/source/text/scalc/00/00000004.xhp b/helpcontent2/source/text/scalc/00/00000004.xhp new file mode 100644 index 000000000..640164de3 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000004.xhp @@ -0,0 +1,33 @@ + + + + + + + To access this function... + /text/scalc/00/00000004.xhp + + + +To access this function... +More explanations on top of this page. +In the %PRODUCTNAME Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.UFI: see #i43239# and #i3879# +Codes greater than 127 may depend on your system's character mapping (for example iso-8859-1, iso-8859-2, Windows-1252, Windows-1250), and hence may not be portable. + + diff --git a/helpcontent2/source/text/scalc/00/00000402.xhp b/helpcontent2/source/text/scalc/00/00000402.xhp new file mode 100644 index 000000000..60b867523 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000402.xhp @@ -0,0 +1,58 @@ + + + + + + + Edit Menu + /text/scalc/00/00000402.xhp + + + +Edit Menu +Choose Insert - Headers and Footers. +Choose Insert - Headers and Footers - Header and Footer tabs. +Choose Sheet - Fill Cells. +Choose Sheet - Fill Cells - Down. +Choose Sheet - Fill Cells - Right. +Choose Sheet - Fill Cells - Up. +Choose Sheet - Fill Cells - Left. +Choose Sheet - Fill Cells - Sheets. +Choose Sheet - Fill Cells - Series. + +
+Choose Sheet - Clear Cells. +Backspace +
+Choose Sheet - Delete Cells. + +
+Choose Sheet - Delete Sheet. +Open context menu for a sheet tab. +
+ +
+Choose Sheet - Move or Copy Sheet. +Open context menu for a sheet tab. +
+
+ Choose Edit - Cell Protection to activate sheet protection with current cell protection settings. +
+ + diff --git a/helpcontent2/source/text/scalc/00/00000403.xhp b/helpcontent2/source/text/scalc/00/00000403.xhp new file mode 100644 index 000000000..66c4ce3c6 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000403.xhp @@ -0,0 +1,35 @@ + + + + + + + View Menu + /text/scalc/00/00000403.xhp + + + +View Menu +Choose View - Column & Row Headers. +Choose View - Value Highlighting. +Choose View - Formula Bar or View - Toolbars - Formula Bar. +Choose View - Page Break. +Choose View - Function List. + + diff --git a/helpcontent2/source/text/scalc/00/00000404.xhp b/helpcontent2/source/text/scalc/00/00000404.xhp new file mode 100644 index 000000000..d9873d31c --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000404.xhp @@ -0,0 +1,161 @@ + + + + + + + Insert Menu + /text/scalc/00/00000404.xhp + + + Sun Microsystems, Inc. + + + +

Insert Menu

+
+Choose Sheet - Insert Cells. +Choose View - Toolbars and select the Insert Cells toolbar: +
+ + + + +Icon + + +Insert Cells + + +
+ +
+
+
+ + + + +Icon + + +Insert Cells Down + + +
+ +
+
+ + + + +Icon + + +Insert Cells Right + + +
+ +
+
+ + + + +Icon + + +Insert Rows + + +
+ +
+
+ + + + +Icon + + +Insert Columns + + +
+ +
+Choose Sheet - Insert Sheet. +Choose Sheet - Insert Sheet from File. +
+Choose Insert - Function. +CommandCtrl+F2 + On the Formula bar, click +
+ + + + +Icon + + +Function Wizard + + +
+ +
+
+Insert - Function - Category Database + +Insert - Function - Category Date & Time + +Insert - Function - Category Financial + +Insert - Function - Category Information + +Insert - Function - Category Logical + +Insert - Function - Category Mathematical + +Insert - Function - Category Array + +Insert - Function - Category Statistical + +Insert - Function - Category Text + +Insert - Function - Category Spreadsheet + +Insert - Function - Category Add-In + +Insert - Function - Category Add-In + +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 - Insert. +Choose Sheet - Named Ranges and Expressions - Create. +Choose Sheet - Named Ranges and Expressions - Labels. + + diff --git a/helpcontent2/source/text/scalc/00/00000405.xhp b/helpcontent2/source/text/scalc/00/00000405.xhp new file mode 100644 index 000000000..13ee92fbe --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000405.xhp @@ -0,0 +1,82 @@ + + + + + + + Format Menu + /text/scalc/00/00000405.xhp + + + Sun Microsystems, Inc. + + + +

Format Menu

+
+ Choose Format - Cells. + Press CommandCtrl+1. +
+Choose Format - Cells - Cell Protection tab. +Choose Format - Rows. +Choose Format - Rows - Optimal Height. +
+Choose Format - Rows - Hide. +Choose Format - Columns - Hide. +Choose Sheet - Hide Sheet. +
+
+Choose Format - Rows - Show. +Choose Format - Columns - Show. +
+Choose Format - Columns. +
+Choose Format - Columns - Optimal Width. +Double-click right column separator in column headers. +
+Choose Sheet. +Choose Sheet - Rename Sheet. +Choose Sheet - Show Sheet. +Choose Format - Page. +Choose Format - Page - Sheet tab. +Choose Format - Print Ranges. +Choose Format - Print Ranges - Define. +Choose Format - Print Ranges - Add. +Choose Format - Print Ranges - Clear. +Choose Format - Print Ranges - Edit. +
+Choose Format - AutoFormat Styles. + On the Tools bar, click +
+ + + + +AutoFormat Styles Icon + + +AutoFormat + + +
+
+
+Choose Format - Conditional. + + diff --git a/helpcontent2/source/text/scalc/00/00000406.xhp b/helpcontent2/source/text/scalc/00/00000406.xhp new file mode 100644 index 000000000..64239b361 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000406.xhp @@ -0,0 +1,82 @@ + + + + + + + Tools Menu + /text/scalc/00/00000406.xhp + + + +

Tools Menu

+Choose Tools - Detective. + +
+Choose Tools - Detective - Trace Precedents. +Shift+F9 +
+Menu Tools - Language - Hyphenation. +Choose Tools - Detective - Remove Precedents. + +
+Choose Tools - Detective - Trace Dependents. +Shift+F5 +
+Choose Tools - Detective - Remove Dependents. +Choose Tools - Detective - Remove All Traces. +Choose Tools - Detective - Trace Error. +Choose Tools - Detective - Fill Mode. +Choose Tools - Detective - Mark Invalid Data. +Choose Tools - Detective - Refresh Traces. +Choose Tools - Detective - AutoRefresh. +Choose Tools - Goal Seek. +Choose Tools - Solver. +Choose Tools - Solver, click Options button. +Choose Tools - Scenarios. + +Choose Tools - Forms. + +Choose Tools - Share Spreadsheet + +Choose Tools - Protect Sheet. +Choose Tools - Protect Spreadsheet Structure. + +
+Choose Data - Calculate - Recalculate. +Press F9 +
+ +
+Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - Formula. +
+ +
+ Choose Data - Calculate - Recalculate hard. + Press Shift+CommandCtrl+F9 +
+ +
+ Select a formula cell or a formula cell range and choose Data - Calculate - Formula to values +
+ +Choose Data - Calculate - AutoCalculate. +Choose Tools - AutoInput. + + diff --git a/helpcontent2/source/text/scalc/00/00000407.xhp b/helpcontent2/source/text/scalc/00/00000407.xhp new file mode 100644 index 000000000..c6ba07932 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000407.xhp @@ -0,0 +1,34 @@ + + + + + + + Window Menu + /text/scalc/00/00000407.xhp + + + +

Window Menu

+Choose View - Split Window. +Choose View - Freeze Rows and Columns. +Choose View - Freeze Cells - Freeze First Column +Choose View - Freeze Cells - Freeze First Row + + diff --git a/helpcontent2/source/text/scalc/00/00000412.xhp b/helpcontent2/source/text/scalc/00/00000412.xhp new file mode 100644 index 000000000..50de754f2 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000412.xhp @@ -0,0 +1,172 @@ + + + + + + + Data Menu + /text/scalc/00/00000412.xhp + + + +

Data Menu

+ Choose Data - Text to Columns. + Choose Data - Define Range. + Choose Data - Select Range. + Choose Data - Sort.... + Choose Data - Sort Ascending + Choose Data - Sort Descending +
+ Choose Data - Sort - Sort Criteria tab. + On Standard bar, click +
+
+ + + + + Icon Sort Ascending + + + + Sort Ascending + + +
+
+
+ + + + + Icon Sort Descending + + + + Sort Descending + + +
+
+
+
+ Choose Data - Sort - Options tab. + Choose Data - More Filters. +
+ Choose Data - AutoFilter. + On Tools bar or Table Data bar, click +
+ + + + + Icon + + + AutoFilter + + +
+
+
+ Choose Data - More Filters - Advanced Filter... . +
+ Choose Data - More Filters - Standard Filter... - Options label. + Choose Data - More Filters - Advanced Filter... - Options label. +
+
+ Choose Data - More Filters - Reset Filter. + On Table Data bar, click Reset Filter/Sort. + + + + + Icon + + + Reset Filter/Sort + + +
+
+ Choose Data - More Filter - Hide AutoFilter. + Choose Data - Subtotals. + Choose Data - Subtotals - 1st, 2nd, 3rd Group tabs. + Choose Data - Subtotals - Options tab. + Choose Data - Validity. + Menu Data - Validity - Criteria tab. + Choose Data - Validity - Input Help tab. + Choose Data - Validity - Error Alert tab. + Choose Data - Multiple Operations. + Choose Data - Consolidate. + Choose Data - Group and Outline. + Choose Data - Group and Outline - Hide Details. + Choose Data - Group and Outline - Show Details. +
+ Choose Data - Group and Outline - Group. + F12 + On Tools bar, click +
+ + + + + Icon + + + Group + + +
+
+
+
+ Choose Data - Group and Outline - Ungroup. + CommandCtrl+F12 + On Tools bar, click +
+ + + + + Icon + + + Ungroup + + +
+
+
+ Choose Data - Group and Outline - AutoOutline. + Choose Data - Group and Outline - Remove Outline. + Choose Data - Group and Outline - Show Details (for some pivot tables). + Choose Data - Pivot Table. + Choose Insert - Pivot Table. + Choose Insert - Pivot Table, in the Select Source dialog choose the option Data source registered in $[officename]. +
+ Choose Insert - Pivot Table, in the Select Source dialog choose the option Current selection. + Choose Insert - Pivot Table, in the Select Source dialog choose the option Data source registered in $[officename], click OK to see Select Data Source dialog. +
+ Choose Data - Pivot Table - Refresh. + Choose Data - Pivot Table - Delete. + Choose Data - Refresh Range. + Choose Data - Group and Outline - Group. + + diff --git a/helpcontent2/source/text/scalc/00/avail_release.xhp b/helpcontent2/source/text/scalc/00/avail_release.xhp new file mode 100644 index 000000000..75383ea1a --- /dev/null +++ b/helpcontent2/source/text/scalc/00/avail_release.xhp @@ -0,0 +1,87 @@ + + + + + + + Available since release + /text/scalc/00/avail_release.xhp + + + + +
+ This function is available since %PRODUCTNAME 3.3. +
+
+ This function is available since %PRODUCTNAME 3.4. +
+
+ This function is available since %PRODUCTNAME 3.5. +
+
+ This function is available since %PRODUCTNAME 3.6. +
+
+ This function is available since %PRODUCTNAME 4.0. +
+
+ This function is available since %PRODUCTNAME 4.1. +
+
+ This function is available since %PRODUCTNAME 4.2. +
+
+ This function is available since %PRODUCTNAME 4.3. +
+
+ This function is available since %PRODUCTNAME 4.4. +
+
+ This function is available since %PRODUCTNAME 5.0. +
+
+ This function is available since %PRODUCTNAME 5.1. +
+
+ This function is available since %PRODUCTNAME 5.2. +
+
+ This function is available since %PRODUCTNAME 5.3. +
+
+ This function is available since %PRODUCTNAME 5.4. +
+
+ This function is available since %PRODUCTNAME 6.0. +
+
+ This function is available since %PRODUCTNAME 6.1. +
+
+ This function is available since %PRODUCTNAME 6.2. +
+
+ This function is available since %PRODUCTNAME 6.3. +
+
+ This function is available since %PRODUCTNAME 6.4. +
+
+ This function is available since %PRODUCTNAME 7.0. +
+
+ This function is available since %PRODUCTNAME 7.1. +
+
+ This function is available since %PRODUCTNAME 7.2. +
+ + diff --git a/helpcontent2/source/text/scalc/00/sheet_menu.xhp b/helpcontent2/source/text/scalc/00/sheet_menu.xhp new file mode 100644 index 000000000..875b1b2c6 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/sheet_menu.xhp @@ -0,0 +1,46 @@ + + + + + + + Sheet Menu + /text/scalc/00/sheet_menu.xhp + + + +

Sheet Menu

+Choose Sheet - Insert Rows - Rows Above. +Choose Sheet - Insert Rows - Rows Below. +Choose Sheet - Insert Columns - Columns Before. +Choose Sheet - Insert Columns - Columns After. +Choose Sheet - Insert Page Break. +Choose Sheet - Insert Page Break - Row Break. +Choose Sheet - Insert Page Break - Column Break. +Choose Sheet - Delete Page Break. +Choose Sheet - Delete Page Break - Row Break. +Choose Sheet - Delete Page Break - Column Break. + +Choose Sheet - Cell Comments - Edit Comment +Choose Sheet - Cell Comments - Hide Comment +Choose Sheet - Cell Comments - Show Comment +Choose Sheet - Cell Comments - Delete Comment +Choose Sheet - Cell Comments - Delete All Comments + + -- cgit v1.2.3