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/auxiliary/scalc.tree | 207 +++++++++++++++++++++++++++++++ 1 file changed, 207 insertions(+) create mode 100644 helpcontent2/source/auxiliary/scalc.tree (limited to 'helpcontent2/source/auxiliary/scalc.tree') diff --git a/helpcontent2/source/auxiliary/scalc.tree b/helpcontent2/source/auxiliary/scalc.tree new file mode 100644 index 000000000..04b1a7ba1 --- /dev/null +++ b/helpcontent2/source/auxiliary/scalc.tree @@ -0,0 +1,207 @@ + + + + + + Welcome to the %PRODUCTNAME Calc Help + %PRODUCTNAME Calc Features + Shortcut Keys (%PRODUCTNAME Calc Accessibility) + Shortcut Keys for Spreadsheets + Calculation Accuracy in %PRODUCTNAME Calc + Error Codes in %PRODUCTNAME Calc + Add-in for Programming in %PRODUCTNAME Calc + Instructions for Using %PRODUCTNAME Calc + + + + Menus + File + Edit + View + Insert + Format + Sheet + Data + Tools + Window + Help + + + Toolbars + Find Bar + Formatting Bar + Drawing Object Properties Bar + Text Formatting Bar + Formula Bar + Status Bar + Print Preview Bar + Image Bar + Tools Bar + Standard Bar + Table Data Bar + Form Navigation Bar + Query Design Bar + Form Design Toolbar + + + + Function Wizard + Functions by Category + Array Functions + Bit Operation Functions + Database Functions + Date + Time Functions + Financial Functions Part One + Financial Functions Part Two + Financial Functions Part Three + Information Functions + Logical Functions + Mathematical Functions + Statistics Functions + Statistical Functions Part One + Statistical Functions Part Two + Statistical Functions Part Three + Statistical Functions Part Four + Statistical Functions Part Five + Spreadsheet Functions + Text Functions + Add-in Functions + Add-in Functions, List of Analysis Functions Part One + Add-in Functions, List of Analysis Functions Part Two + Operators in %PRODUCTNAME Calc + User-Defined Functions + + + Inserting External Data in Table (WebQuery) + Saving and Opening Sheets in HTML + Importing and Exporting Text Files + Redacting a Spreadsheet + Automatic Redaction + + + Rotating Text + Writing Multi-line Text + Formatting Numbers as Text + Text Superscript / Subscript + Changing Row Height or Column Width + Applying Conditional Formatting + Highlighting Negative Numbers + Assigning Formats by Formula + Entering a Number with Leading Zeros + Formatting Spreadsheets + Formatting Numbers With Decimals + Naming Cells + Rotating Tables (Transposing) + Renaming Sheets + 19xx/20xx Years + Using Rounded Off Numbers + Cells in Currency Format + Using AutoFormat for Tables + Inserting and Editing Comments + Selecting Themes for Sheets + Entering Fractions + + + Applying Filters + Applying Advanced Filters + Applying AutoFilter + Applying Sort Lists + Removing Duplicate Values + + + Printing Rows or Columns on Every Page + Printing Sheets in Landscape Format + Printing Sheet Details + Defining Number of Pages for Printing + + + Defining Database Ranges + Filtering Cell Ranges + Sorting Data + + + Pivot Table + Creating Pivot Tables + Deleting Pivot Tables + Editing Pivot Tables + Filtering Pivot Tables + Selecting Pivot Table Output Ranges + Updating Pivot Tables + + + Pivot Chart + Creating Pivot Charts + Editing Pivot Charts + Filtering Pivot Charts + Updating Pivot Charts + Deleting Pivot Charts + + + Using Scenarios + + + Using Subtotals Tool + + + Addresses and References, Absolute and Relative + Referencing a Cell in Another Document + References to Other Sheets and Referencing URLs + Referencing Cells by Drag-and-Drop + Recognizing Names as Addressing + + + Changing Table Views + Displaying Formulas or Values + Freezing Rows or Columns as Headers + Navigating Through Sheets Tabs + Copying to Multiple Sheets + Only Copy Visible Cells + Selecting Multiple Cells + + + Calculating With Formulas + Copying Formulas + Entering Formulas + Displaying Formulas or Values + Calculating in Spreadsheets + Calculating With Dates and Times + Automatically Calculating Series + Calculating Time Differences + Entering Matrix Formulas + Using Wildcards in Formulas + + + Protecting Cells from Changes + Unprotecting Cells + + + Reading and Writing values to Ranges + Formatting Borders in Calc with Macros + + + Deactivating Automatic Changes + Consolidating Data + Applying Goal Seek + Using Linear and Non-Linear Solvers + Applying Multiple Operations + Applying Multiple Sheets + Validity of Cell Contents + + + -- cgit v1.2.3