[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/00/0405.xhp| 28 +++ source/text/scalc/01/0512.xhp| 49 ++- source/text/scalc/01/FormatSparklineMenu.xhp | 48 ++ source/text/scalc/02/0608.xhp| 29 +++ source/text/scalc/guide/design.xhp | 45 +--- source/text/scalc/main0105.xhp | 10 +++-- source/text/shared/01/themesdialog.xhp |3 + source/text/swriter/01/format_object.xhp |2 - 9 files changed, 137 insertions(+), 78 deletions(-) New commits: commit c099ceeaf1cb4651bbca712ba19d16ee4206ab0f Author: Olivier Hallot AuthorDate: Sat Dec 2 22:11:09 2023 -0300 Commit: Olivier Hallot CommitDate: Sun Dec 3 10:50:56 2023 +0100 tdf#155876 UI cmds Calc-Format menu (24) + Sparklines and more + refactoring Change-Id: Ie320018d7c3cf13d25bed7f6d7b6af4b2c9f9b26 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160251 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index e848307a37..3344595ebb 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -195,6 +195,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/FieldMenu \ helpcontent2/source/text/scalc/01/format_graphic \ helpcontent2/source/text/scalc/01/formula2value \ +helpcontent2/source/text/scalc/01/FormatSparklineMenu \ helpcontent2/source/text/scalc/01/ful_func \ helpcontent2/source/text/scalc/01/func_aggregate \ helpcontent2/source/text/scalc/01/func_arabic \ diff --git a/source/text/scalc/00/0405.xhp b/source/text/scalc/00/0405.xhp index 197c0f8984..4d0bce96ba 100644 --- a/source/text/scalc/00/0405.xhp +++ b/source/text/scalc/00/0405.xhp @@ -29,6 +29,34 @@ Format Menu + + + Choose Format - Sparklines. + + In a cell with sparklines, choose Sparklines. + + On the Data menu of the Data tab, choose Sparklines. + + + + Choose Format - Spreadsheet Themes. + + Choose Layout - Spreadsheet Themes. + + + + + + +Icon Themes + + + Choose Themes + + + + + Choose Format - Number Format. diff --git a/source/text/scalc/01/0512.xhp b/source/text/scalc/01/0512.xhp index 4e41c6dc61..2a8940be32 100644 --- a/source/text/scalc/01/0512.xhp +++ b/source/text/scalc/01/0512.xhp @@ -21,18 +21,21 @@ - Conditional Formatting + Conditional Formatting /text/scalc/01/0512.xhp - - - - - Conditional Formatting - Use Conditional Formatting to define range-based conditions that determine which cell style will be applied to each cell in a given range based on its contents. The cell style corresponding to the first condition that evaluates to true is applied. Cell styles applied through Conditional Formatting override cell styles applied manually using the Formatting Bar or the Styles sidebar. - You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If Condition 1 is true based on the current cell contents, the corresponding cell style is applied. Otherwise, Condition 2 is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format. + + + + + +Conditional Formatting +Use Conditional Formatting to define range-based conditions that determine which cell style will be applied to each cell in a given range based on its contents. + + The cell style corresponding to the first condition that evaluates to true is applied. Cell styles applied through Conditional Formatting override cell styles applied manually using the Formatting Bar or the Styles sidebar. + You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If Condition 1 is true based on the current cell contents, the corresponding cell style is applied. Otherwise, Condition 2 is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format. Conditional formats do not overwrite cell styles and direct formatting applied manually. They remain saved as cell properties and are applied when the cell matches no conditions or when you remove all conditional formats. To apply conditional formatting, AutoCalculate must be enabled. Choose Data - Calculate - AutoCalculate (you see a check
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |2 + source/text/scalc/00/0403.xhp | 47 -- source/text/scalc/01/0308.xhp | 28 - source/text/scalc/01/ToggleFormula.xhp| 31 +++ source/text/scalc/01/ViewHiddenColRow.xhp | 33 + source/text/scalc/main0103.xhp|5 +-- 6 files changed, 127 insertions(+), 19 deletions(-) New commits: commit 1a8338a2bf045393580e0db745e04b47624e4fea Author: Olivier Hallot AuthorDate: Sat Oct 28 12:38:01 2023 -0300 Commit: Olivier Hallot CommitDate: Sun Oct 29 13:28:52 2023 +0100 tdf#155876 UI cmds Calc-View menu (08) + refactoring Change-Id: I0f8fa1f36ff535fd21dd0aaab468b122c359c5fc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158595 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index ec54caffbe..1330d68b3b 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -317,10 +317,12 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/ODFF \ helpcontent2/source/text/scalc/01/TableSelectAll \ helpcontent2/source/text/scalc/01/text2columns \ +helpcontent2/source/text/scalc/01/ToggleFormula \ helpcontent2/source/text/scalc/01/ToggleSheetGrid \ helpcontent2/source/text/scalc/01/SelectUnprotectedCells \ helpcontent2/source/text/scalc/01/SelectVisibleColumns \ helpcontent2/source/text/scalc/01/SelectVisibleRows \ +helpcontent2/source/text/scalc/01/ViewHiddenColRow \ helpcontent2/source/text/scalc/01/zoom \ helpcontent2/source/text/scalc/01/xml_source \ helpcontent2/source/text/scalc/02/0601 \ diff --git a/source/text/scalc/00/0403.xhp b/source/text/scalc/00/0403.xhp index 83d704ec7a..86a5717177 100644 --- a/source/text/scalc/00/0403.xhp +++ b/source/text/scalc/00/0403.xhp @@ -44,9 +44,10 @@ + +View Grid Lines - Choose View - View Headers. @@ -66,7 +67,25 @@ -Choose View - Value Highlighting. + + + Choose View - Value Highlighting. + +Choose View - Value Highlighting +On the View menu of the View tab, choose Value Highlighting. + + + + Icon Value Highlighting + + + Value Highlighting + + + + +CommandCtrl + F8 + @@ -125,6 +144,30 @@ + + + Choose View - Hidden Row/Column Indicator. + + + + Choose View - Show Formula. + +Choose View - Show Formula +On the View menu of the View tab, choose Show Formula. + + + + +Icon Show Formula + + +Show Formula + + + + + CommandCtrl + ` + Choose View - Function List. diff --git a/source/text/scalc/01/0308.xhp b/source/text/scalc/01/0308.xhp index e8e5c07392..1140bda407 100644 --- a/source/text/scalc/01/0308.xhp +++ b/source/text/scalc/01/0308.xhp @@ -20,36 +20,36 @@ -Value Highlighting +Value Highlighting /text/scalc/01/0308.xhp - - - - + spreadsheets; value highlighting values;highlighting highlighting; values in sheets colors;values + - - + Value Highlighting -Displays cell contents in different colors, depending on type. +Displays cell contents in different colors, depending on type. -To remove the highlighting, unmark the menu entry. +To remove the highlighting, unmark the menu entry. - + + +By default: +Text cells are formatted in black, formulas in green, number cells in blue, and protected cells are shown with light grey background, no matter how their display is formatted. +These colors can be customized in %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME - Application Colors. +If this function is active, colors that you define in the document will not be displayed. When you deactivate the function, the user-defined colors are displayed again. + + -By default: -Text cells are formatted in black, formulas in green, number cells in blue, and protected cells are shown with light grey background, no matter how their display is formatted. -These colors can be customized in %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME - Application Colors. -If this function is active, colors that you define in the document will not be displayed. When you deactivate the function, the user-defined colors are displayed again. diff --git a/source/text/scalc/01/ToggleFormula.xhp b/source/text/scalc/01/ToggleFormula.xhp new file mode 100644 index 00..6aa5b2a1f6 --- /dev/null +++ b/source/text/scalc/01/ToggleFormula.xhp @@ -0,0 +1,31 @@ + + + + + + +Show Formula +/text/scalc/01/ToggleFormula.xhp + + + + + +Show Formula +Display the cell formula
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/00/0403.xhp | 41 +- source/text/scalc/01/0307.xhp | 31 -- source/text/scalc/01/ToggleSheetGrid.xhp | 35 + source/text/scalc/main0103.xhp|6 source/text/scalc/menu/sheet_tab_menu.xhp |3 +- 6 files changed, 91 insertions(+), 26 deletions(-) New commits: commit 53e7511706a73d0336ce183f614d53469836ef64 Author: Olivier Hallot AuthorDate: Thu Oct 26 21:32:02 2023 -0300 Commit: Olivier Hallot CommitDate: Fri Oct 27 13:41:19 2023 +0200 tdf#155876 UI cmds Calc-View menu (07) + refactoring Change-Id: I766345780bb12a3ba9d9c8c3135f77d4d04bc78d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158519 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 4beef8283f..ec54caffbe 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -317,6 +317,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/ODFF \ helpcontent2/source/text/scalc/01/TableSelectAll \ helpcontent2/source/text/scalc/01/text2columns \ +helpcontent2/source/text/scalc/01/ToggleSheetGrid \ helpcontent2/source/text/scalc/01/SelectUnprotectedCells \ helpcontent2/source/text/scalc/01/SelectVisibleColumns \ helpcontent2/source/text/scalc/01/SelectVisibleRows \ diff --git a/source/text/scalc/00/0403.xhp b/source/text/scalc/00/0403.xhp index 4a4fb2b360..83d704ec7a 100644 --- a/source/text/scalc/00/0403.xhp +++ b/source/text/scalc/00/0403.xhp @@ -26,7 +26,46 @@ View Menu -Choose View - Column Row Headers. + + + +Choose View - View Grid Lines. + + Choose View - View Grid Lines + On the View menu of the View tab, choose View Grid Lines. + + + + +Icon View Grid Lines + + +View Grid Lines + + + + + + + + + Choose View - View Headers. + + Choose View - View Headers + On the View menu of the View tab, choose View Headers. + + + + +Icon View Headers + + +View Headers + + + + + Choose View - Value Highlighting. diff --git a/source/text/scalc/01/0307.xhp b/source/text/scalc/01/0307.xhp index 289bb82cf2..b463634ac6 100644 --- a/source/text/scalc/01/0307.xhp +++ b/source/text/scalc/01/0307.xhp @@ -20,39 +20,32 @@ -Column Row Headers +Column Row Headers /text/scalc/01/0307.xhp - - - - + spreadsheets; displaying headers of columns/rows displaying; headers of columns/rows + - - -Column Row Headers -Shows column headers and row headers. + +View Headers +Shows column headers and row headers. - - -To hide the column and row headers, unmark this menu entry. - +To hide the column and row headers, unmark this menu entry. - + - - -You can also set the view of the column and row headers in %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - View. - +You can also set the view of the column and row headers in %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - View. + + + - diff --git a/source/text/scalc/01/ToggleSheetGrid.xhp b/source/text/scalc/01/ToggleSheetGrid.xhp new file mode 100644 index 00..b02334e87c --- /dev/null +++ b/source/text/scalc/01/ToggleSheetGrid.xhp @@ -0,0 +1,35 @@ + + + + + + +View Grid Lines +/text/scalc/01/ToggleSheetGrid.xhp + + + + +sheet;grid lines +grid lines;sheets + + + +View Grid Lines +Toggle the visibility of grid lines for the current sheet. + + + + + + + + + diff --git a/source/text/scalc/main0103.xhp b/source/text/scalc/main0103.xhp index d3545cd41c..3f419afb24 100644 --- a/source/text/scalc/main0103.xhp +++ b/source/text/scalc/main0103.xhp @@ -39,11 +39,7 @@ - - -View Grid lines -Toggle the visibility of grid lines for the current sheet. - + diff --git a/source/text/scalc/menu/sheet_tab_menu.xhp b/source/text/scalc/menu/sheet_tab_menu.xhp index de6e37b7b6..3367452428 100644 --- a/source/text/scalc/menu/sheet_tab_menu.xhp +++ b/source/text/scalc/menu/sheet_tab_menu.xhp @@ -38,7 +38,8 @@ - + + Sheet Events
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/00/0403.xhp | 69 +--- source/text/scalc/01/0309.xhp | 24 +-- source/text/scalc/01/0310.xhp | 26 ++-- source/text/scalc/01/NormalViewMode.xhp | 33 +++ source/text/scalc/main0103.xhp | 21 - 6 files changed, 130 insertions(+), 44 deletions(-) New commits: commit b41eeeaaa91ed78e387cfed551400984836164af Author: Olivier Hallot AuthorDate: Thu Oct 26 20:34:06 2023 -0300 Commit: Olivier Hallot CommitDate: Fri Oct 27 13:39:46 2023 +0200 tdf#155876 UI cmds Calc-View menu (06) + refactoring Change-Id: Ic6a1cf590f8952ef82e540459603a0a499732ecf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158518 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index c553800518..4beef8283f 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -287,6 +287,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/JumpToPrevTableSel \ helpcontent2/source/text/scalc/01/live_data_stream \ helpcontent2/source/text/scalc/01/MergeCellsMenu \ +helpcontent2/source/text/scalc/01/NormalViewMode \ helpcontent2/source/text/scalc/01/recalculate_hard \ helpcontent2/source/text/scalc/01/SelectColumn \ helpcontent2/source/text/scalc/01/SelectData \ diff --git a/source/text/scalc/00/0403.xhp b/source/text/scalc/00/0403.xhp index b58a32ebb2..4a4fb2b360 100644 --- a/source/text/scalc/00/0403.xhp +++ b/source/text/scalc/00/0403.xhp @@ -20,16 +20,73 @@ -View Menu +View Menu /text/scalc/00/0403.xhp View Menu -Choose View - Column Row Headers. -Choose View - Value Highlighting. -Choose View - Formula Bar. -Choose View - Page Break. -Choose View - Function List. +Choose View - Column Row Headers. +Choose View - Value Highlighting. + + + + Choose View - Formula Bar. + + Choose View - Formula Bar + On the View menu of the View tab, choose Formula Bar. + + + + +Icon Formula Bar + + +Formula Bar + + + + + + + + Choose View - Page Break. + + Choose View - Page Break + On the View menu of the View tab, choose Page Break. + + + + +Icon Page Break + + +Page Break + + + + + + + + Choose View - Normal + + Choose View - Normal View + Choose Layout - Normal View + On the View menu of the View tab, choose Normal. + + + + +Icon Normal View + + +Normal View + + + + + +Choose View - Function List. diff --git a/source/text/scalc/01/0309.xhp b/source/text/scalc/01/0309.xhp index c925dc7f5d..f914a428e9 100644 --- a/source/text/scalc/01/0309.xhp +++ b/source/text/scalc/01/0309.xhp @@ -20,31 +20,29 @@ -Formula Bar +Formula Bar /text/scalc/01/0309.xhp - - - - + formula bar;spreadsheets spreadsheets; formula bar - - - + + Formula Bar -Shows or hides the Formula Bar, which is used for entering and editing formulas. The Formula Bar is the most important tool when working with spreadsheets. +Shows or hides the Formula Bar, which is used for entering and editing formulas. The Formula Bar is the most important tool when working with spreadsheets. -To hide the Formula Bar, unmark the menu item. +To hide the Formula Bar, unmark the menu item. - + + +If the Formula Bar is hidden, you can still edit cells by activating the edit mode with F2. After editing cells, accept the changes by pressing Enter, or discard entries by pressing Esc. Esc is also used to exit the edit mode. + + -If the Formula Bar is hidden, you can still edit cells by activating the edit mode with F2. After editing cells, accept the changes by pressing Enter, or discard entries by pressing Esc. Esc is also used to exit the edit mode. - diff --git a/source/text/scalc/01/0310.xhp b/source/text/scalc/01/0310.xhp index 442711931c..84437f4e13 100644 --- a/source/text/scalc/01/0310.xhp +++ b/source/text/scalc/01/0310.xhp @@ -20,34 +20,34 @@ -Page Break View +Page Break View /text/scalc/01/0310.xhp - - + - - -Page Break View -Display the page breaks and print ranges in the sheet. Choose View - Normal to switch this mode off. +Page Break +Display the page breaks and print ranges in the sheet. +Choose View - Normal to switch this mode off. - + -The context menu of the page break preview contains functions for editing page breaks, including the following options: - +The context menu of the page break preview contains functions for editing page breaks, including the following options: + Delete Page Breaks -Deletes all manual breaks in the
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/00/0402.xhp|6 + source/text/scalc/01/SetInputMode.xhp| 36 +++ source/text/scalc/main0102.xhp |1 source/text/shared/optionen/01060300.xhp |1 5 files changed, 44 insertions(+), 1 deletion(-) New commits: commit 7d08444f187ddea8a983565fc2c7fb8b2a38176c Author: Olivier Hallot AuthorDate: Tue Oct 17 17:14:51 2023 -0300 Commit: Olivier Hallot CommitDate: Tue Oct 17 23:04:17 2023 +0200 tdf#155876 UI cmds Calc (04) + refactoring + Edit - cell edit mode Change-Id: I43bcbd6f0467f0e923450a3b74b197b7166db15c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158095 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 5dc4e85648..c553800518 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -291,6 +291,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/SelectColumn \ helpcontent2/source/text/scalc/01/SelectData \ helpcontent2/source/text/scalc/01/SelectRow \ +helpcontent2/source/text/scalc/01/SetInputMode \ helpcontent2/source/text/scalc/01/shared_spreadsheet \ helpcontent2/source/text/scalc/01/sheet_tab_color \ helpcontent2/source/text/scalc/01/solver \ diff --git a/source/text/scalc/00/0402.xhp b/source/text/scalc/00/0402.xhp index 670c386a3a..5fc250c4ff 100644 --- a/source/text/scalc/00/0402.xhp +++ b/source/text/scalc/00/0402.xhp @@ -154,6 +154,12 @@ Choose Edit - Select - Select Visible Columns. + + + Choose Edit - Cell Edit Mode. + + F2 + Choose Insert - Headers and Footers. Choose Insert - Headers and Footers - Header and Footer tabs. diff --git a/source/text/scalc/01/SetInputMode.xhp b/source/text/scalc/01/SetInputMode.xhp new file mode 100644 index 00..1c4d0418ae --- /dev/null +++ b/source/text/scalc/01/SetInputMode.xhp @@ -0,0 +1,36 @@ + + + + + + +Cell Edit Mode +/text/scalc/01/SetInputMode.xhp + + + + + +cell edit mode +F2;cell edit mode + + +Cell Edit Mode +Enable direct cell content editing. + + + + +The cell edit mode enabled on a cell with formula displays the formula expression instead of the result of the formula calculation. +In this mode, references to other cells are displayed in colors and the referenced cells have their borders highlighted with the same color. The highlighted cell displays handles on the corners to allow by dragging the handles, to extend the highlighted reference. The formula is automatically updated with the expression of the reference. +For example, a cell with formula =A1+B1 displays A1 in color 1 and B1 in color 2 (colors are defined internally). The cell A1 is highlighted in color 1 and B1 is highlighted in color 2. +Press Enter to end the cell edit mode. + + diff --git a/source/text/scalc/main0102.xhp b/source/text/scalc/main0102.xhp index 4e83358605..74c251bae1 100644 --- a/source/text/scalc/main0102.xhp +++ b/source/text/scalc/main0102.xhp @@ -46,6 +46,7 @@ + diff --git a/source/text/shared/optionen/01060300.xhp b/source/text/shared/optionen/01060300.xhp index ffb349e13e..01e459681f 100644 --- a/source/text/shared/optionen/01060300.xhp +++ b/source/text/shared/optionen/01060300.xhp @@ -66,7 +66,6 @@ Determines the direction that the cursor in the spreadsheet will move after you press the Enter key. - see i53756 Press Enter to switch to edit mode
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk| 10 + source/text/scalc/00/0402.xhp | 129 source/text/scalc/01/0219.xhp |6 - source/text/scalc/01/0221.xhp | 13 ++ source/text/scalc/01/EditSelectMenu.xhp | 39 +++ source/text/scalc/01/JumpToNextTableSel.xhp | 36 ++ source/text/scalc/01/JumpToPrevTableSel.xhp | 36 ++ source/text/scalc/01/SelectColumn.xhp | 32 + source/text/scalc/01/SelectData.xhp | 40 +++ source/text/scalc/01/SelectRow.xhp | 32 + source/text/scalc/01/SelectUnprotectedCells.xhp | 36 ++ source/text/scalc/01/SelectVisibleColumns.xhp | 36 ++ source/text/scalc/01/SelectVisibleRows.xhp | 34 ++ source/text/scalc/01/TableSelectAll.xhp | 37 ++ source/text/scalc/guide/cellcopy.xhp| 30 ++--- source/text/scalc/guide/multitables.xhp |2 source/text/scalc/main0102.xhp |1 source/text/shared/00/edit_menu.xhp |5 source/text/shared/01/0209.xhp |4 source/text/shared/01/pastespecialmenu.xhp | 16 +- 20 files changed, 544 insertions(+), 30 deletions(-) New commits: commit 020c1cb426fa951da23f51c1d93b59259ec87608 Author: Olivier Hallot AuthorDate: Tue Oct 17 11:55:45 2023 -0300 Commit: Olivier Hallot CommitDate: Tue Oct 17 19:45:34 2023 +0200 tdf#155876 UI cmds Calc (03) + refactoring + Edit - Select menu and commands Change-Id: I2c1e7c37cf40184391f04c29b0b6f49f43bef0e5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158087 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 2721534351..5dc4e85648 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -189,6 +189,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/databar_more_options \ helpcontent2/source/text/scalc/01/default_number_formats \ helpcontent2/source/text/scalc/01/duplicate_sheet \ +helpcontent2/source/text/scalc/01/EditSelectMenu \ helpcontent2/source/text/scalc/01/events_sheet \ helpcontent2/source/text/scalc/01/ex_data_stat_func \ helpcontent2/source/text/scalc/01/format_graphic \ @@ -282,9 +283,14 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_year \ helpcontent2/source/text/scalc/01/func_yearfrac \ helpcontent2/source/text/scalc/01/hide_sheet \ +helpcontent2/source/text/scalc/01/JumpToNextTableSel \ +helpcontent2/source/text/scalc/01/JumpToPrevTableSel \ helpcontent2/source/text/scalc/01/live_data_stream \ helpcontent2/source/text/scalc/01/MergeCellsMenu \ helpcontent2/source/text/scalc/01/recalculate_hard \ +helpcontent2/source/text/scalc/01/SelectColumn \ +helpcontent2/source/text/scalc/01/SelectData \ +helpcontent2/source/text/scalc/01/SelectRow \ helpcontent2/source/text/scalc/01/shared_spreadsheet \ helpcontent2/source/text/scalc/01/sheet_tab_color \ helpcontent2/source/text/scalc/01/solver \ @@ -307,7 +313,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/statistics_test_z \ helpcontent2/source/text/scalc/01/stat_data \ helpcontent2/source/text/scalc/01/ODFF \ +helpcontent2/source/text/scalc/01/TableSelectAll \ helpcontent2/source/text/scalc/01/text2columns \ +helpcontent2/source/text/scalc/01/SelectUnprotectedCells \ +helpcontent2/source/text/scalc/01/SelectVisibleColumns \ +helpcontent2/source/text/scalc/01/SelectVisibleRows \ helpcontent2/source/text/scalc/01/zoom \ helpcontent2/source/text/scalc/01/xml_source \ helpcontent2/source/text/scalc/02/0601 \ diff --git a/source/text/scalc/00/0402.xhp b/source/text/scalc/00/0402.xhp index 302ee6a74e..670c386a3a 100644 --- a/source/text/scalc/00/0402.xhp +++ b/source/text/scalc/00/0402.xhp @@ -26,6 +26,135 @@ Edit Menu + + + Choose Edit - Select. + + + + +Icon Select + + +Select + + + + + + + Choose Edit - Select - Select all Sheets. + + Open context menu of a sheet tab, choose Select all Sheets. + + + + +Icon Select all Sheets + + +Select all Sheets + + + + + + + + Choose Edit - Select - Select Sheets. + + + + +Icon Select Sheets + + +Select Sheets + + + + + + + +Choose Edit - Select - Select to Next Sheet. + + + + +Choose Edit - Select - Select to Previous Sheet. + + + + Choose Edit - Select - Select Row. + + On the Home menu of the Home tab, choose Select Row. + + + + +Icon Select Row + + +Select Row +
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/01/0506.xhp | 75 +++- source/text/scalc/01/MergeCellsMenu.xhp | 32 source/text/shared/01/05100100.xhp | 84 -- source/text/shared/01/05100200.xhp | 117 ++-- 5 files changed, 189 insertions(+), 120 deletions(-) New commits: commit f9f74aac7105208ded70127e5acd6cd2bae8b093 Author: Olivier Hallot AuthorDate: Wed Sep 6 09:32:59 2023 -0300 Commit: Olivier Hallot CommitDate: Wed Sep 6 15:34:54 2023 +0200 tdf#155875 UI cmds Writer/Table in Help(32) + refactoring + Table - merge menu (part 32) + includes Calc merge cells + Some pages will be revisited Change-Id: Ic6ebfedd363421ab33ad325609f2427cc2043998 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/156618 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 9557466f22..6192819d40 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -285,6 +285,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_yearfrac \ helpcontent2/source/text/scalc/01/hide_sheet \ helpcontent2/source/text/scalc/01/live_data_stream \ +helpcontent2/source/text/scalc/01/MergeCellsMenu \ helpcontent2/source/text/scalc/01/recalculate_hard \ helpcontent2/source/text/scalc/01/shared_spreadsheet \ helpcontent2/source/text/scalc/01/sheet_tab_color \ diff --git a/source/text/scalc/01/0506.xhp b/source/text/scalc/01/0506.xhp index d3d67b0e0b..efc09896dc 100644 --- a/source/text/scalc/01/0506.xhp +++ b/source/text/scalc/01/0506.xhp @@ -19,7 +19,7 @@ -Merge and Center Cells +Merge and Center Cells /text/scalc/01/0506.xhp @@ -27,62 +27,71 @@ - - toggle merge and center cells + +toggle merge and center cells - - - -Merge and Center Cells -This is a toggleable control that joins all cells in a rectangular selection into a single cell, or returns merged cells to the original individual cells. When merging it will format the merged cell as center aligned. -The control is shown toggled-on whenever there are merged cells in the selection, indicating that clicking the control will unmerge those cells. + + + + + + Merge and Center Cells + This is a toggleable control that joins all cells in a rectangular selection into a single cell, or returns merged cells to the original individual cells. When merging it will format the merged cell as center aligned. + + +The control is shown toggled-on whenever there are merged cells in the selection, indicating that clicking the control will unmerge those cells. Merging cells can lead to calculation errors in formulas in the table. + -Do one of the following: -In the Formatting toolbar, click: - - - - -Icon Merge and Center Cells - - -Merge and Center Cells - - - -Or, choose Format - Merge and Unmerge Cells - Merge and Center Cells. + + Choose Format - Merge and Unmerge Cells - Merge and Center Cells. + + Choose Home - Merge and Center Cells. + + + + + + Icon Merge and Center Cells + + +Merge and Center Cells + + + + -Cells cannot be merged again without first unmerging them. +Cells cannot be merged again without first unmerging them. Merging a cell selection that partially includes merged cells is generally possible with Unmerge Cells followed by Merge Cells, without altering the initial selection. The result will be largely depend on previous choices when merging cells made with the Merge Cells Dialog options described below. -Multiple selection is not supported, that is, the selection must be rectangular. +Multiple selection is not supported, that is, the selection must be rectangular. The merged cell receives the name and content of the first cell of the selection. If more than one cell to be merged has content the Merge Cells dialog opens. - - - + + + Merge Cells Dialog Options -Three options are available: +Three options are available: -Move the contents of the hidden cells into the first cell: The actual contents of the hidden cells are concatenated to the first cell, and hidden cells are emptied; the results of formulas referring to the hidden cells or the first cell will be updated. +Move the contents of the hidden cells into the first cell: The actual contents of the hidden cells are concatenated to the first cell, and hidden cells are emptied; the results of formulas referring to the hidden cells or the first cell will be updated. -Keep the contents of the hidden cells: The contents of the hidden cells are kept; the results of formulas referring to the hidden cells will not change. +Keep the contents of the hidden cells: The contents of the hidden cells are kept; the results of
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/00/sheet_menu.xhp | 25 +++- source/text/scalc/01/events_sheet.xhp | 103 ++ source/text/shared/01/06140500.xhp|6 + 4 files changed, 132 insertions(+), 3 deletions(-) New commits: commit 9b8794b4b681e2c4f148ca626c766d961e0e3078 Author: Olivier Hallot AuthorDate: Thu May 25 15:38:08 2023 -0300 Commit: Olivier Hallot CommitDate: Thu May 25 22:12:55 2023 +0200 Add Sheet Events Help page, update command paths Change-Id: I90d0b82c143d467e48aed65bb422c0323875ece2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152285 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 87956ac0c1..9165ee3fbb 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -193,6 +193,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/databar_more_options \ helpcontent2/source/text/scalc/01/default_number_formats \ helpcontent2/source/text/scalc/01/duplicate_sheet \ +helpcontent2/source/text/scalc/01/events_sheet \ helpcontent2/source/text/scalc/01/ex_data_stat_func \ helpcontent2/source/text/scalc/01/format_graphic \ helpcontent2/source/text/scalc/01/formula2value \ diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp index baafdb1132..7ddb37c708 100644 --- a/source/text/scalc/00/sheet_menu.xhp +++ b/source/text/scalc/00/sheet_menu.xhp @@ -182,8 +182,8 @@ -Move or copy sheet +Move or copy sheet Choose Sheet - Move or Copy Sheet. @@ -227,6 +227,29 @@ +Sheet events + + + Choose Sheet - Sheet Events + + Choose Layout - Sheet Events + + Choose Sheet Events + + + + + + Icon Sheet Events + + + +Sheet Events + + + + + Choose Sheet - Insert Rows - Rows Above. Choose Sheet - Insert Rows - Rows Below. Choose Sheet - Insert Columns - Columns Before. diff --git a/source/text/scalc/01/events_sheet.xhp b/source/text/scalc/01/events_sheet.xhp new file mode 100644 index 00..0624409b8d --- /dev/null +++ b/source/text/scalc/01/events_sheet.xhp @@ -0,0 +1,103 @@ + + + + + + +Sheet Events +/text/scalc/01/events_sheet.xhp + + + + +sheet;events +events;sheet only + + +Sheet Events +%PRODUCTNAME Calc specific sheet events. You can assign a macro to each sheet event. + + + + +The following table describes the events available in %PRODUCTNAME spreadsheets. + + + + +Event + + +Description + + + + +Activate Document + + +Worksheet has been activated (made visible). + + + + +Deactivate Document + + +Worksheet has been deactivated (made not visible). + + + + +Selection changed + + +Selection in sheet has been changed. + + + + +Double click + + +Double click in the sheet. + + + + +Right Click + + +Right click in the sheet. + + + + +Formulas calculated + + +Cells in sheet have been recalculated. + + + + +Contents changed + + +Cells in sheet have been changed. + + + + + + + + + diff --git a/source/text/shared/01/06140500.xhp b/source/text/shared/01/06140500.xhp index c5fd4deb87..c94993700b 100644 --- a/source/text/shared/01/06140500.xhp +++ b/source/text/shared/01/06140500.xhp @@ -34,7 +34,7 @@ - Events + Events Assigns macros to program events. The assigned macro runs automatically every time the selected event occurs. @@ -43,7 +43,7 @@ -The dialog box has reduced functionality when called from the Edit-Sheet menu of a spreadsheet. + Save In @@ -57,6 +57,7 @@ Assign Macro Opens the Macro Selector to assign a macro to the selected event. + Assign Component... Opens the Assign Component dialog to set a custom UNO command for the selected event. Component assignment is proposed for controls in the Dialog Editor. @@ -68,6 +69,7 @@ List of events Creating a Dialog Handler +
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |4 ++ source/text/scalc/00/sheet_menu.xhp | 26 +++-- source/text/scalc/01/0217.xhp| 22 +-- source/text/scalc/01/0218.xhp|7 ++- source/text/scalc/01/0221.xhp| 16 +++- source/text/scalc/01/0405.xhp| 61 --- source/text/scalc/01/05050100.xhp| 33 source/text/scalc/01/05050300.xhp| 30 +-- source/text/scalc/01/06060100.xhp|4 +- source/text/scalc/01/duplicate_sheet.xhp | 34 + source/text/scalc/01/hide_sheet.xhp | 37 ++ source/text/scalc/01/sheet_tab_color.xhp | 31 +++ source/text/scalc/guide/multitables.xhp | 19 +++-- source/text/scalc/main0103.xhp |3 + source/text/scalc/main0116.xhp |6 +-- source/text/shared/01/0209.xhp |2 - 16 files changed, 223 insertions(+), 112 deletions(-) New commits: commit 033dc1a727a6cb48419a08990a2b737058afd99f Author: Olivier Hallot AuthorDate: Mon May 22 16:24:23 2023 -0300 Commit: Olivier Hallot CommitDate: Mon May 22 21:28:30 2023 +0200 Calc Sheet Tab Navigator help page Change-Id: Ie79a7e1b6e3383d52660e48d145bec5ca7ca89af Reviewed-on: https://gerrit.libreoffice.org/c/help/+/152130 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 0019a72dce..87956ac0c1 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -192,6 +192,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/data_provider \ helpcontent2/source/text/scalc/01/databar_more_options \ helpcontent2/source/text/scalc/01/default_number_formats \ +helpcontent2/source/text/scalc/01/duplicate_sheet \ helpcontent2/source/text/scalc/01/ex_data_stat_func \ helpcontent2/source/text/scalc/01/format_graphic \ helpcontent2/source/text/scalc/01/formula2value \ @@ -283,9 +284,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_workday \ helpcontent2/source/text/scalc/01/func_year \ helpcontent2/source/text/scalc/01/func_yearfrac \ +helpcontent2/source/text/scalc/01/hide_sheet \ helpcontent2/source/text/scalc/01/live_data_stream \ helpcontent2/source/text/scalc/01/recalculate_hard \ helpcontent2/source/text/scalc/01/shared_spreadsheet \ +helpcontent2/source/text/scalc/01/sheet_tab_color \ helpcontent2/source/text/scalc/01/solver \ helpcontent2/source/text/scalc/01/solver_options \ helpcontent2/source/text/scalc/01/solver_options_algo \ @@ -423,6 +426,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/guide/webquery \ helpcontent2/source/text/scalc/guide/wildcards \ helpcontent2/source/text/scalc/guide/year2000 \ +helpcontent2/source/text/scalc/menu/sheet_tab_menu \ helpcontent2/source/text/scalc/main \ helpcontent2/source/text/scalc/main0100 \ helpcontent2/source/text/scalc/main0101 \ diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp index 875b1b2c6b..6541dcec90 100644 --- a/source/text/scalc/00/sheet_menu.xhp +++ b/source/text/scalc/00/sheet_menu.xhp @@ -20,22 +20,26 @@ -Sheet Menu +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 - Duplicate Sheet. +Choose Sheet - Sheet Tab Color. +Choose Sheet - Hide Sheet. +Choose Sheet - Show Sheet. +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 diff --git a/source/text/scalc/01/0217.xhp b/source/text/scalc/01/0217.xhp index 77c0fbacf2..229c85636d 100644 --- a/source/text/scalc/01/0217.xhp +++ b/source/text/scalc/01/0217.xhp @@ -1,6 +1,4 @@ - - - -Delete Sheet +Delete Sheet /text/scalc/01/0217.xhp @@ -30,21 +27,22 @@ -spreadsheets; deleting
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/01/04060104.xhp |2 source/text/scalc/01/04060109.xhp | 36 ++--- source/text/scalc/01/func_style.xhp | 73 4 files changed, 82 insertions(+), 30 deletions(-) New commits: commit 20d4c17ca1fb161bf5fccf3d94db93b0a4d322f2 Author: Rafael Lima AuthorDate: Tue Jan 10 19:42:50 2023 + Commit: Olivier Hallot CommitDate: Wed Jan 11 00:09:58 2023 + tdf#152412 Improve the STYLE function help page This patch creates a separate help page for the STYLE function and improves its text and examples. Change-Id: I3630fbc99ac822ea138f08283e92d88ffa4acaf8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/145299 Tested-by: Jenkins Reviewed-by: Mike Kaganski Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index e7ab38d663..452e16fd57 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -264,6 +264,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_second \ helpcontent2/source/text/scalc/01/func_skewp \ helpcontent2/source/text/scalc/01/func_searchb \ +helpcontent2/source/text/scalc/01/func_style \ helpcontent2/source/text/scalc/01/func_sum \ helpcontent2/source/text/scalc/01/func_sumifs \ helpcontent2/source/text/scalc/01/func_switch \ diff --git a/source/text/scalc/01/04060104.xhp b/source/text/scalc/01/04060104.xhp index d2b2f01014..65e0076dab 100644 --- a/source/text/scalc/01/04060104.xhp +++ b/source/text/scalc/01/04060104.xhp @@ -207,8 +207,10 @@ CURRENT function + CURRENT This function returns the result to date of evaluating the formula of which it is a part (in other words the result as far as that evaluation has got). Its main use is together with the STYLE() function to apply selected styles to a cell depending on the cell contents. + CURRENT() diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index e1ab74ace9..1e6d28d8e0 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -410,36 +410,12 @@ =LOOKUP(A1;D1:D100;F1:F100) searches the corresponding cell in range D1:D100 for the number you entered in A1. For the instance found, the index is determined, for example, the 12th cell in this range. Then, the contents of the 12th cell are returned as the value of the function (in the result vector). - -STYLE function - - -STYLE - Applies a style to the cell containing the formula. After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a color to a cell depending on the value. For example: =...+STYLE(IF(CURRENT()3;"red";"green")) applies the style "red" to the cell if the value is greater than 3, otherwise the style "green" is applied. Both cell formats, "red" and "green" have to be defined beforehand. - The STYLE function should not be used without a compelling reason. Its purpose is the use with asynchronous Add-In functions to visually notify about the availability of a result. In almost all other cases, using conditional formatting instead is a better choice. - - STYLE("Style" [; Time [; "Style2"]]) - -Style is the name of a cell style assigned to the cell. Style names must be entered in quotation marks. - -Time is an optional time range in seconds. If this parameter is missing the style will not be changed after a certain amount of time has passed. - -Style2 is the optional name of a cell style assigned to the cell after a certain amount of time has passed. If this parameter is missing "Default" is assumed. - - - - - -=STYLE("Invisible";60;"Default") formats the cell in transparent format for 60 seconds after the document was recalculated or loaded, then the Default format is assigned. Both cell formats have to be defined beforehand. - Since STYLE() has a numeric return value of zero, this return value gets appended to a string. This can be avoided using T() as in the following example: - -="Text"T(STYLE("myStyle")) - - See also CURRENT() for another example. - - -ORG.OPENOFFICE.STYLE - + + + + + + CHOOSE function diff --git a/source/text/scalc/01/func_style.xhp b/source/text/scalc/01/func_style.xhp new file mode 100644 index 00..7e1c168450 --- /dev/null +++ b/source/text/scalc/01/func_style.xhp @@ -0,0 +1,73 @@ + + + + + + +STYLE function +/text/scalc/01/func_style.xhp + + + + + + + + STYLE function + +STYLE
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |5 source/text/scalc/01/0512.xhp | 236 ++--- source/text/scalc/01/05120100.xhp | 241 ++ source/text/scalc/01/05120200.xhp | 27 source/text/scalc/01/05120300.xhp | 51 source/text/scalc/01/05120400.xhp | 81 source/text/scalc/01/05120500.xhp | 36 + 7 files changed, 509 insertions(+), 168 deletions(-) New commits: commit aefcd8e0945387c36ae5a80b6815763cae2a3022 Author: Olivier Hallot AuthorDate: Sun Sep 11 20:56:47 2022 -0300 Commit: Olivier Hallot CommitDate: Mon Sep 12 17:03:25 2022 +0200 tdf#119421 Refactor conditional formatting Help pages * Still work to be done with other CF pages floating around * Strucutred the entry page for the CF dialog * Split conditions descriptions into sub-pages Many thanks to Roman Kuznetsov for the inputs. Change-Id: I5a9d91ab34febc127eb7dc762258428629ec5477 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/139783 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 3b3df75b3..e7ab38d66 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -115,6 +115,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/0510 \ helpcontent2/source/text/scalc/01/0511 \ helpcontent2/source/text/scalc/01/0512 \ +helpcontent2/source/text/scalc/01/05120100 \ +helpcontent2/source/text/scalc/01/05120200 \ +helpcontent2/source/text/scalc/01/05120300 \ +helpcontent2/source/text/scalc/01/05120400 \ +helpcontent2/source/text/scalc/01/05120500 \ helpcontent2/source/text/scalc/01/0602 \ helpcontent2/source/text/scalc/01/0603 \ helpcontent2/source/text/scalc/01/06030100 \ diff --git a/source/text/scalc/01/0512.xhp b/source/text/scalc/01/0512.xhp index 9abe1ee3e..28d08990c 100644 --- a/source/text/scalc/01/0512.xhp +++ b/source/text/scalc/01/0512.xhp @@ -1,183 +1,83 @@ - + - - - - Conditional Formatting - /text/scalc/01/0512.xhp - - - - - - - -Conditional Formatting - Use Conditional Formatting to define range-based conditions that determine which cell style will be applied to each cell in a given range based on its contents. The cell style corresponding to the first condition that evaluates to true is applied. Cell styles applied through Conditional Formatting override cell styles applied manually using the Formatting Bar or the Styles sidebar. - - - - You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If Condition 1 is true based on the current cell contents, the corresponding cell style is applied. Otherwise, Condition 2 is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format. - Conditional formats do no overwrite cell styles and direct formatting applied manually. They remain saved as cell properties and are applied when the cell matches no conditions or when you remove all conditional formats. + + + Conditional Formatting + /text/scalc/01/0512.xhp + + + + + + + + Conditional Formatting + Use Conditional Formatting to define range-based conditions that determine which cell style will be applied to each cell in a given range based on its contents. The cell style corresponding to the first condition that evaluates to true is applied. Cell styles applied through Conditional Formatting override cell styles applied manually using the Formatting Bar or the Styles sidebar. + + + + You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If Condition 1 is true based on the current cell contents, the corresponding cell style is applied. Otherwise, Condition 2 is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format. + Conditional formats do no overwrite cell styles and direct formatting applied manually. They remain saved as cell properties and are applied when the cell matches no conditions or when you remove all conditional formats. To apply conditional formatting, AutoCalculate must be enabled. Choose Data - Calculate - AutoCalculate (you see a check mark next to the command when AutoCalculate is enabled). -conditional formatting; conditions - - -Condition list + + Cell range + Range + Defines the range of cells concerned by the conditional
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/guide/datapilot.xhp |8 +- source/text/scalc/guide/datapilot_createtable.xhp |7 +- source/text/scalc/guide/datapilot_deletetable.xhp |9 +-- source/text/scalc/guide/datapilot_edittable.xhp |5 + source/text/scalc/guide/datapilot_filtertable.xhp | 15 - source/text/scalc/guide/datapilot_formatting.xhp | 64 ++ source/text/scalc/guide/datapilot_grouping.xhp| 12 +--- source/text/scalc/guide/datapilot_tipps.xhp |8 +- source/text/scalc/guide/datapilot_updatetable.xhp |8 +- 10 files changed, 102 insertions(+), 35 deletions(-) New commits: commit 4e1b00e5d940b647b550b3314985ebb775be2543 Author: Olivier Hallot AuthorDate: Fri Jun 24 18:25:25 2022 -0300 Commit: Adolfo Jayme Barrientos CommitDate: Mon Jun 27 04:54:10 2022 +0200 tdf#149218 Add pivot table formatting help page Change-Id: I807b0e62998bac85cf0cf348d57cb1f99b1dc742 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/136411 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index a40e388d9..3b3df75b3 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -353,6 +353,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/guide/database_sort \ helpcontent2/source/text/scalc/guide/datapilot \ helpcontent2/source/text/scalc/guide/datapilot_createtable \ +helpcontent2/source/text/scalc/guide/datapilot_formatting \ helpcontent2/source/text/scalc/guide/datapilot_deletetable \ helpcontent2/source/text/scalc/guide/datapilot_edittable \ helpcontent2/source/text/scalc/guide/datapilot_filtertable \ diff --git a/source/text/scalc/guide/datapilot.xhp b/source/text/scalc/guide/datapilot.xhp index e69454dd3..6391a629e 100644 --- a/source/text/scalc/guide/datapilot.xhp +++ b/source/text/scalc/guide/datapilot.xhp @@ -1,6 +1,4 @@ - - - @@ -30,8 +27,8 @@ pivot table function; introduction DataPilot, see pivot table function -Pivot Table - +Pivot Table + The pivot table (formerly known as DataPilot) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports. A table that has been created as a pivot table is an interactive table. Data can be arranged, rearranged or summarized according to different points of view. @@ -39,6 +36,7 @@ + diff --git a/source/text/scalc/guide/datapilot_createtable.xhp b/source/text/scalc/guide/datapilot_createtable.xhp index 4610d1709..92a25abd2 100644 --- a/source/text/scalc/guide/datapilot_createtable.xhp +++ b/source/text/scalc/guide/datapilot_createtable.xhp @@ -30,8 +30,8 @@ pivot tables pivot table function; calling up and applying -Creating Pivot Tables - +Creating Pivot Tables + Position the cursor within a range of cells containing values, row and column headings. @@ -65,11 +65,12 @@ Exit the Pivot Table dialog by pressing OK. A Filter button will now be inserted, or a page button for every data field that you dropped in the Filters area. The pivot table is inserted further down. - + + diff --git a/source/text/scalc/guide/datapilot_deletetable.xhp b/source/text/scalc/guide/datapilot_deletetable.xhp index e22c6bf36..29e849cb7 100644 --- a/source/text/scalc/guide/datapilot_deletetable.xhp +++ b/source/text/scalc/guide/datapilot_deletetable.xhp @@ -30,16 +30,17 @@ pivot table function; deleting tables deleting;pivot tables -Deleting Pivot Tables - +Deleting Pivot Tables + In order to delete a pivot table, click any cell in the pivot table, then choose Delete in the context menu. - If you delete a pivot table linked to a pivot chart, the pivot chart is also deleted. A dialog box opens to confirm the pivot chart deletion. - + If you delete a pivot table linked to a pivot chart, the pivot chart is also deleted. A dialog box opens to confirm the pivot chart deletion. + + diff --git a/source/text/scalc/guide/datapilot_edittable.xhp b/source/text/scalc/guide/datapilot_edittable.xhp index eb13ac691..ab0385e56 100644 --- a/source/text/scalc/guide/datapilot_edittable.xhp +++ b/source/text/scalc/guide/datapilot_edittable.xhp @@ -30,8 +30,8 @@ pivot table function; editing tables editing;pivot tables -Editing Pivot Tables - +Editing Pivot Tables + Click one of the buttons in the pivot table and hold the mouse button down. A special symbol will appear next to the mouse pointer. By dragging the button to a different position in the same row
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|3 - source/text/scalc/01/sparklines.xhp | 91 source/text/scalc/main0104.xhp |1 3 files changed, 94 insertions(+), 1 deletion(-) New commits: commit 396d82a4d705d7b473f767816f970bffec74d33e Author: Olivier Hallot AuthorDate: Thu Jun 2 14:56:48 2022 -0300 Commit: Adolfo Jayme Barrientos CommitDate: Mon Jun 6 03:45:28 2022 +0200 tdf#148817 Sparklines Help page. + add bookmark entry + update Calc Insert menu help page Change-Id: I76315d7c35a2a98731ef92d9090ebcba41f9e004 Co-authored-by: Tomaž Vajngerl Co-authored-by: Roman Kuznetsov Reviewed-on: https://gerrit.libreoffice.org/c/help/+/135324 Tested-by: Adolfo Jayme Barrientos Reviewed-by: Adolfo Jayme Barrientos diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 63116c9a0..a40e388d9 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -278,10 +278,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_yearfrac \ helpcontent2/source/text/scalc/01/live_data_stream \ helpcontent2/source/text/scalc/01/recalculate_hard \ -helpcontent2/source/text/scalc/01/solver \ helpcontent2/source/text/scalc/01/shared_spreadsheet \ +helpcontent2/source/text/scalc/01/solver \ helpcontent2/source/text/scalc/01/solver_options \ helpcontent2/source/text/scalc/01/solver_options_algo \ +helpcontent2/source/text/scalc/01/sparklines \ helpcontent2/source/text/scalc/01/statistics \ helpcontent2/source/text/scalc/01/statistics_anova \ helpcontent2/source/text/scalc/01/statistics_correlation \ diff --git a/source/text/scalc/01/sparklines.xhp b/source/text/scalc/01/sparklines.xhp new file mode 100644 index 0..05acb1c61 --- /dev/null +++ b/source/text/scalc/01/sparklines.xhp @@ -0,0 +1,91 @@ + + + + + + +Sparklines +/text/scalc/01/sparklines.xhp + + + + + + + +sparklines + + +Sparklines +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. + +Choose Insert – Sparklines + +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. +Properties +Type: select the sparkline type in the drop-down list. Choices are: + + +Line: draws a line between data values. + + +Column: draws a bar for each data value. + + +Stacked: also known as win/loss. Displays equally sized bars indicating positive and negative values. + + +Line width: enter the line width 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. + + +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. + + +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. +Right-to-left: check to display the sparklines reverse order of the data. +Colors +Series: select the main color for the sparklines. +Negative points: check and select the color for negative points. +High points: check and select the color for high points. +Low points: check and select the color for low points. +Marker: check and select the color for data points (line type only). +First point: check and select the color for first point. +Last point: check and select the color for last point. + +Axes +Display X axis: check to show the X axis for sparklines. +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. + + +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. + + +
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/00/0406.xhp |3 + source/text/scalc/01/shared_spreadsheet.xhp | 47 source/text/scalc/main0106.xhp |5 ++ source/text/shared/guide/collab.xhp | 21 ++-- 5 files changed, 66 insertions(+), 11 deletions(-) New commits: commit 15250e5e03742751ec8b78b5f1a8eb339e66950d Author: Olivier Hallot AuthorDate: Mon Mar 14 13:58:56 2022 -0300 Commit: Olivier Hallot CommitDate: Tue Mar 15 00:10:36 2022 +0100 tdf#147977 Add Share Spreadsheet help page Change-Id: Ic4d77dd4b33d3e0bd74c48a195a3d97b2ad647e4 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/131553 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index de4304d99..7e70a9fec 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -278,6 +278,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/live_data_stream \ helpcontent2/source/text/scalc/01/recalculate_hard \ helpcontent2/source/text/scalc/01/solver \ +helpcontent2/source/text/scalc/01/shared_spreadsheet \ helpcontent2/source/text/scalc/01/solver_options \ helpcontent2/source/text/scalc/01/solver_options_algo \ helpcontent2/source/text/scalc/01/statistics \ diff --git a/source/text/scalc/00/0406.xhp b/source/text/scalc/00/0406.xhp index 7c90749a1..6fee82076 100644 --- a/source/text/scalc/00/0406.xhp +++ b/source/text/scalc/00/0406.xhp @@ -50,6 +50,9 @@ Choose Tools - Solver. Choose Tools - Solver, click Options button. Choose Tools - Scenarios. + +Choose Tools - Share Spreadsheet + Choose Tools - Protect Sheet. Choose Tools - Protect Spreadsheet Structure. diff --git a/source/text/scalc/01/shared_spreadsheet.xhp b/source/text/scalc/01/shared_spreadsheet.xhp new file mode 100644 index 0..919d77b87 --- /dev/null +++ b/source/text/scalc/01/shared_spreadsheet.xhp @@ -0,0 +1,47 @@ + + + + + + +page_title +/text/scalc/01/shared_spreadsheet.xhp + + + + +share spreadsheet +spreadsheet;collaboration +spreadsheet;share + + + +Share Spreadsheet +Sharing a spreadsheet allows several users to open the same file for editing at the same time. + + + + +The spreadsheet needs to be on a shared drive, server, website, or similar. Some conditions must be met on operating systems with user permission management: + + +The shared file needs to reside in a location which is accessible by all collaborators. + + +The file permissions for both the document and the corresponding lock file need to be set so that all collaborators can create, delete, and change the files. + + +In order to correctly identify the changes, each collaborator should enter their name in %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME - User Data on the Menu bar. + + + + + + diff --git a/source/text/scalc/main0106.xhp b/source/text/scalc/main0106.xhp index 8336e9019..65815915b 100644 --- a/source/text/scalc/main0106.xhp +++ b/source/text/scalc/main0106.xhp @@ -47,10 +47,13 @@ Scenarios + + + + - Customize diff --git a/source/text/shared/guide/collab.xhp b/source/text/shared/guide/collab.xhp index ec2695ce2..3d9515b35 100644 --- a/source/text/shared/guide/collab.xhp +++ b/source/text/shared/guide/collab.xhp @@ -1,4 +1,5 @@ - + +
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|2 + source/text/scalc/00/0406.xhp | 15 +++- source/text/scalc/01/04060106.xhp | 10 +++-- source/text/scalc/01/0608.xhp | 12 ++ source/text/scalc/01/calculate.xhp |7 ++- source/text/scalc/01/formula2value.xhp | 36 +++ source/text/scalc/01/recalculate_hard.xhp | 37 source/text/shared/optionen/01060900.xhp| 21 --- source/text/shared/optionen/detailedcalculation.xhp |2 + 9 files changed, 113 insertions(+), 29 deletions(-) New commits: commit 4ac52bffa0d4055a8c18d1a25d15a68eae00adee Author: Olivier Hallot AuthorDate: Fri Feb 18 22:09:31 2022 -0300 Commit: Eike Rathke CommitDate: Wed Feb 23 22:48:58 2022 +0100 tdf#145898 Formula to Value and Recalculate Hard Review of the Data - Calculate submenu - Added Recalculate Hard page - Added Formula to value page - Links and embed for navigation - Some precisions regarding non-volatile functions Change-Id: Ic39b61feb851b9cc7c8cb2ae6907651a64a81a6e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/130180 Tested-by: Jenkins Reviewed-by: Eike Rathke diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index fd7d20600..de4304d99 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -187,6 +187,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/databar_more_options \ helpcontent2/source/text/scalc/01/ex_data_stat_func \ helpcontent2/source/text/scalc/01/format_graphic \ +helpcontent2/source/text/scalc/01/formula2value \ helpcontent2/source/text/scalc/01/ful_func \ helpcontent2/source/text/scalc/01/func_aggregate \ helpcontent2/source/text/scalc/01/func_arabic \ @@ -275,6 +276,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_year \ helpcontent2/source/text/scalc/01/func_yearfrac \ helpcontent2/source/text/scalc/01/live_data_stream \ +helpcontent2/source/text/scalc/01/recalculate_hard \ 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/00/0406.xhp b/source/text/scalc/00/0406.xhp index 045c12d52..7c90749a1 100644 --- a/source/text/scalc/00/0406.xhp +++ b/source/text/scalc/00/0406.xhp @@ -25,7 +25,7 @@ -Tools Menu +Tools Menu Choose Tools - Detective. @@ -55,11 +55,22 @@ Choose Data - Calculate - Recalculate. -F9 +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/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index e2f2d1885..753b9f131 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1476,7 +1476,8 @@ =RANDBETWEEN(20;30) returns an integer of between 20 and 30.see also RAND - + + random numbers non-volatile; between limits RANDBETWEEN.NV function @@ -1486,7 +1487,7 @@ Returns an non-volatile integer random number in a specified range. RANDBETWEEN.NV(Bottom; Top) -Returns an non-volatile integer random number between integers Bottom and Top (both inclusive). A non-volatile function is not recalculated at new input events or pressing F9. However, the function is recalculated when pressing F9 with the cursor on the cell containing the function, when opening the file, and when Top or Bottom are recalculated. +Returns an non-volatile integer random number between integers Bottom and Top (both inclusive). A non-volatile function is not recalculated at new input events or pressing F9. However, the function is recalculated when pressing F9 with the cursor on the cell containing the function, when opening the file, when using the Recalculate Hard command (Shift+CommandCtrl+F9) and when Top or Bottom are recalculated. =RANDBETWEEN.NV(20;30) returns a non-volatile integer between 20 and 30. =RANDBETWEEN.NV(A1;30) returns a non-volatile integer between the value of cell A1 and 30. The function is recalculated when the contents of cell A1 change. @@ -1524,7 +1525,8 @@ =RAND() returns a random number between 0 and 1.see also RANDBETWEEN - + + random numbers non-volatile;between 0 and 1 RAND.NV function @@ -1534,7 +1536,7 @@ Returns a non-volatile random number between 0 and 1. RAND.NV() -This function produces a non-volatile random number on input. A non-volatile function is not recalculated at new
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|2 + source/text/scalc/01/04060106.xhp | 51 -- source/text/scalc/01/func_rounddown.xhp | 52 ++ source/text/scalc/01/func_trunc.xhp | 54 4 files changed, 115 insertions(+), 44 deletions(-) New commits: commit 6b1075e1e032be5bb6cba1dbdcc11de2a1824add Author: Rafael Lima AuthorDate: Tue Jan 11 20:22:12 2022 +0100 Commit: Olivier Hallot CommitDate: Wed Jan 19 00:10:20 2022 +0100 tdf#145332 Improve help pages for TRUNC and ROUNDDOWN Since TRUNC and ROUNDDOWN perform the same function, the help pages are now more consistent. The help pages were created in separate files. Change-Id: I68092c61f2cb80c66e798c188d9c4172de5d48c0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128244 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 9a896f147..9c6be8ef6 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -251,6 +251,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_regex \ helpcontent2/source/text/scalc/01/func_replaceb \ helpcontent2/source/text/scalc/01/func_roman \ +helpcontent2/source/text/scalc/01/func_rounddown \ helpcontent2/source/text/scalc/01/func_roundsig \ helpcontent2/source/text/scalc/01/func_second \ helpcontent2/source/text/scalc/01/func_skewp \ @@ -262,6 +263,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_time \ helpcontent2/source/text/scalc/01/func_timevalue \ helpcontent2/source/text/scalc/01/func_today \ +helpcontent2/source/text/scalc/01/func_trunc \ helpcontent2/source/text/scalc/01/func_value \ helpcontent2/source/text/scalc/01/func_weekday \ helpcontent2/source/text/scalc/01/func_webservice \ diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 61e035574..e2f2d1885 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -35,7 +35,7 @@ -Mathematical Functions +Mathematical Functions This category contains the Mathematical functions for Calc. To open the Function Wizard, choose Insert - Function. @@ -606,29 +606,9 @@ =COMBINA(3;2) returns 6.see also COMBIN - - - TRUNC function - decimal places;cutting off - -mw added one entry - - -TRUNC -Truncates a number by removing decimal places. - - -TRUNC(Number[; Count]) -Returns Number with at most Count decimal places. Excess decimal places are simply removed, irrespective of sign. -TRUNC(Number; 0) behaves as INT(Number) for positive numbers, but effectively rounds towards zero for negative numbers. -The visible decimal places of the result are specified in %PRODUCTNAME - Preferences -Tools - Options - %PRODUCTNAME Calc - Calculate. - - -=TRUNC(1.239;2) returns 1.23. The 9 is lost. -=TRUNC(-1.234999;3) returns -1.234. All the 9s are lost.see also INT, ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND -=TRUNC(-45.67) returns -45. The default value for Count is 0. -Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/TRUNC; name="TRUNC_Wiki">TRUNC wiki page for more details about this function. + + TRUNC + @@ -892,26 +872,9 @@ =ROUND(987.65;-2) returns 1000.see also INT, TRUNC, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND - - - ROUNDDOWN function - - - - -ROUNDDOWN -Rounds a number down, toward zero, to a certain precision. - - -ROUNDDOWN(Number [; Count]) -Returns Number rounded down (towards zero) to Count decimal places. If Count is omitted or zero, the function rounds down to an integer. If Count is negative, the function rounds down to the next 10, 100, 1000, etc. -This function rounds towards zero. See ROUNDUP and ROUND for alternatives. - - -=ROUNDDOWN(1.234;2) returns 1.23. -=ROUNDDOWN(45.67;0) returns 45. -=ROUNDDOWN(-45.67) returns -45. -=ROUNDDOWN(987.65;-2) returns 900.see also INT, TRUNC, ROUND, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND + + ROUNDDOWN + diff --git a/source/text/scalc/01/func_rounddown.xhp b/source/text/scalc/01/func_rounddown.xhp new file mode 100644 index 0..c346c4402 --- /dev/null +++ b/source/text/scalc/01/func_rounddown.xhp @@ -0,0 +1,52 @@ + + + + + + +ROUNDDOWN function +/text/scalc/01/func_rounddown.xhp + + + + + +ROUNDDOWN function +numbers;rounding down + + + ROUNDDOWN function + +Rounds down a number while keeping a specified number of decimal digits. + + This function is equivalent to the TRUNC function. + + + +ROUNDDOWN(Number [; Count]) + + +Number: The number to be rounded down. +Count: Optional paramenter that defines the number of decimal places to be kept. The default value is 0 (zero). +Use negative values for Count
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |2 + source/text/scalc/01/04060110.xhp | 30 +-- source/text/scalc/01/func_asc.xhp | 42 ++ source/text/scalc/01/func_jis.xhp | 41 + 4 files changed, 87 insertions(+), 28 deletions(-) New commits: commit f0f2cba1d40a248f3cc24ecaa60d403586894780 Author: Rafael Lima AuthorDate: Wed Nov 24 16:24:40 2021 +0200 Commit: Olivier Hallot CommitDate: Wed Nov 24 23:16:32 2021 +0100 tdf#143846 Separate help pages for ASC/JIS text functions Change-Id: I9b5ae9b14ea98fe9edbf84a433ad4b7ed3bfcf39 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/125720 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 617223bfe..9a896f147 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -189,6 +189,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/ful_func \ helpcontent2/source/text/scalc/01/func_aggregate \ helpcontent2/source/text/scalc/01/func_arabic \ +helpcontent2/source/text/scalc/01/func_asc \ helpcontent2/source/text/scalc/01/func_averageif \ helpcontent2/source/text/scalc/01/func_averageifs \ helpcontent2/source/text/scalc/01/func_ceiling \ @@ -230,6 +231,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_imsinh \ helpcontent2/source/text/scalc/01/func_imtan \ helpcontent2/source/text/scalc/01/func_isoweeknum \ +helpcontent2/source/text/scalc/01/func_jis \ helpcontent2/source/text/scalc/01/func_maxifs \ helpcontent2/source/text/scalc/01/func_minifs \ helpcontent2/source/text/scalc/01/func_minute \ diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 2fe9ef745..9ddbcf00a 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -75,20 +75,7 @@ - - ASC function - -i79585 - - -ASC -The ASC function converts full-width to half-width ASCII and katakana characters. Returns a text string. -See https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions; name="wiki.documentfoundation.org Calc/Features/JIS and ASC functions">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions for a conversion table. - - -ASC("Text") - Text is the text that contains characters to be converted. -See also JIS function. + @@ -325,20 +312,7 @@ - - JIS function - - - - -JIS -The JIS function converts half-width to full-width ASCII and katakana characters. Returns a text string. -See https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions; name="wiki.documentfoundation.org Calc/Features/JIS and ASC functions">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions for a conversion table. - - -JIS("Text") - Text is the text that contains characters to be converted. -See also ASC function. + diff --git a/source/text/scalc/01/func_asc.xhp b/source/text/scalc/01/func_asc.xhp new file mode 100644 index 0..c828efb66 --- /dev/null +++ b/source/text/scalc/01/func_asc.xhp @@ -0,0 +1,42 @@ + + + + + + +ASC Function +/text/scalc/01/func_asc.xhp + + + + + + + ASC function + text functions;katakana characters + +ASC +Converts double-byte (full-width) characters to single-byte (half-width) ASCII and katakana characters. + + See https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions; name="wiki.documentfoundation.org Calc/Features/JIS and ASC functions">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions for a conversion table. + + ASC(Text) + Text: the text string that contains characters to be converted. + Applying the ASC function to a string composed of single-byte characters will return the input string without any modifications. + + =ASC("LibreOffice") returns the string "LibreOffice". No modifications were made because all characters are single-byte characters. + =ASC("ライト") returns the string "ライト", which is composed of single-byte characters. + + + + + + + diff --git a/source/text/scalc/01/func_jis.xhp b/source/text/scalc/01/func_jis.xhp new file mode 100644 index 0..ef94de403 --- /dev/null +++ b/source/text/scalc/01/func_jis.xhp @@ -0,0 +1,41 @@ + + + + + + +JIS Function +/text/scalc/01/func_jis.xhp + + + + + + + JIS function + +JIS +Converts single-byte (half-width) ASCII or katakana characters to double-byte (full-width) characters. + + See https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions; name="wiki.documentfoundation.org Calc/Features/JIS and ASC functions">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions for a conversion table. + + JIS(Text) + Text: the
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/04060106.xhp | 15 +++ source/text/scalc/01/func_sum.xhp | 48 ++ 3 files changed, 54 insertions(+), 10 deletions(-) New commits: commit 9077a2887221677690282917c66c7af8e3e37121 Author: Steve Fanning AuthorDate: Fri Nov 5 12:28:17 2021 +0200 Commit: Olivier Hallot CommitDate: Tue Nov 9 15:01:58 2021 +0100 Improve Example section of help description for Calc's SUM() function The ability to use SUM in an array formula is important but the help description of an example array formula is uncharacteristically long. Now that the wiki has a more specific example, it is appropriate to shorten the Example section of this help topic. Also moved SUM description to its own XHP file. Change-Id: Ic062686c53a1ae8b81100e2b49781aaa79e6ee50 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124696 Tested-by: Jenkins Reviewed-by: Eike Rathke Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 0bc4bd0cd..617223bfe 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -253,6 +253,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_second \ helpcontent2/source/text/scalc/01/func_skewp \ helpcontent2/source/text/scalc/01/func_searchb \ +helpcontent2/source/text/scalc/01/func_sum \ helpcontent2/source/text/scalc/01/func_sumifs \ helpcontent2/source/text/scalc/01/func_switch \ helpcontent2/source/text/scalc/01/func_textjoin \ diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index acd376eae..a245b9d28 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1033,16 +1033,11 @@ -If you enter the numbers 2; 3 and 4 in the Number 1; 2 and 3 text boxes, 9 will be returned as the result. -=SUM(A1;A3;B5) calculates the sum of the three cells. =SUM (A1:E10) calculates the sum of all cells in the A1 to E10 cell range. -Conditions linked by AND can be used with the function SUM() in the following manner: -Example assumption: You have entered invoices into a table. Column A contains the date value of the invoice, column B the amounts. You want to find a formula that you can use to return the total of all amounts only for a specific month, e.g. only the amount for the period =2008-01-01 to 2008-02-01. The range with the date values covers A1:A40, the range containing the amounts to be totaled is B1:B40. C1 contains the start date, 2008-01-01, of the invoices to be included and C2 the date, 2008-02-01, that is no longer included. -Enter the following formula as an array formula: -=SUM((A1:A40=C1)*(A1:A40C2)*B1:B40) -In order to enter this as an array formula, you must press the Shift+Command -+ Ctrl+ Enter keys instead of simply pressing the Enter key to close the formula. The formula will then be shown in the Formula bar enclosed in braces. -{=SUM((A1:A40=C1)*(A1:A40C2)*B1:B40)} -The formula is based on the fact that the result of a comparison is 1 if the criterion is met and 0 if it is not met. The individual comparison results will be treated as an array and used in matrix multiplication, and at the end the individual values will be totaled to give the result matrix. +=SUM(2;3;4) returns 9. +=SUM(A1;A3;B5) calculates the sum of the three cells. +=SUM(A1:E10) calculates the sum of all cells in the A1 to E10 cell range. +A formula such as =SUM((A1:A40=C1)*(A1:A40C2)*B1:B40) may be entered as an array formula by pressing the Shift+Command+Ctrl+Enter keys instead of simply pressing the Enter key to finish entering the formula. The formula will then be shown in the Formula bar enclosed in braces and operates by multiplying corresponding elements of the arrays together and returning their sum. +Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM; name="SUM_Wiki">SUM wiki page for more details about this function. diff --git a/source/text/scalc/01/func_sum.xhp b/source/text/scalc/01/func_sum.xhp new file mode 100644 index 0..389c0bcc4 --- /dev/null +++ b/source/text/scalc/01/func_sum.xhp @@ -0,0 +1,48 @@ + + + + + + +SUM Function +/text/scalc/01/func_sum.xhp + + + + + + + SUM function + adding;numbers in cell ranges + +SUM +Adds a set of numbers. + + + + SUM() + + + + =SUM(2;3;4) returns 9. + =SUM(A1;A3;B5) calculates the sum of the three cells. + =SUM(A1:E10) calculates the sum of all cells in the A1 to E10 cell range. + A formula such as =SUM((A1:A40=C1)*(A1:A40C2)*B1:B40) may be entered as an array formula by pressing the Shift+Command+Ctrl+Enter keys instead of simply pressing the Enter key to finish entering the formula. The formula will then be shown in the Formula bar enclosed in braces and operates by multiplying
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |2 + source/text/scalc/01/04060110.xhp| 45 +++--- source/text/scalc/01/func_arabic.xhp | 42 +++ source/text/scalc/01/func_roman.xhp | 46 +++ 4 files changed, 95 insertions(+), 40 deletions(-) New commits: commit c37c5f2131d0fe893d7de8995e7deb73262988aa Author: Rafael Lima AuthorDate: Thu Oct 14 16:36:35 2021 +0200 Commit: Olivier Hallot CommitDate: Thu Oct 21 20:01:05 2021 +0200 Related tdf#143846 Improve Arabic/Roman help pages Change-Id: I4be244dba35f137c1b7d356aab658c5e08604e51 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/123523 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index f2e840a5a..0bc4bd0cd 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -188,6 +188,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/format_graphic \ helpcontent2/source/text/scalc/01/ful_func \ helpcontent2/source/text/scalc/01/func_aggregate \ +helpcontent2/source/text/scalc/01/func_arabic \ helpcontent2/source/text/scalc/01/func_averageif \ helpcontent2/source/text/scalc/01/func_averageifs \ helpcontent2/source/text/scalc/01/func_ceiling \ @@ -247,6 +248,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_rawsubtract \ helpcontent2/source/text/scalc/01/func_regex \ helpcontent2/source/text/scalc/01/func_replaceb \ +helpcontent2/source/text/scalc/01/func_roman \ helpcontent2/source/text/scalc/01/func_roundsig \ helpcontent2/source/text/scalc/01/func_second \ helpcontent2/source/text/scalc/01/func_skewp \ diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 7b33f7139..2fe9ef745 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -65,28 +65,13 @@ Beware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the Double Quotes area of the Tools - AutoCorrect Options - Localized Options dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Uncheck the Replace toggle button to disable the feature. - - - - - - - ARABIC function - - - - -ARABIC -Calculates the value of a Roman number. The value range must be between 0 and 3999. + - -ARABIC("Text") - Text is the text that represents a Roman number. + - - =ARABIC("MXIV") returns 1014 - =ARABIC("MMII") returns 2002 + + @@ -614,27 +599,7 @@ - - ROMAN function - - - - -ROMAN -Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4. - - -ROMAN(Number [; Mode]) - Number is the number that is to be converted into a Roman numeral. - Mode (optional) indicates the degree of simplification. The higher the value, the greater is the simplification of the Roman number. - - - =ROMAN(999) returns CMXCIX - =ROMAN(999;0) returns CMXCIX - =ROMAN (999;1) returns LMVLIV - =ROMAN(999;2) returns XMIX - =ROMAN(999;3) returns VMIV - =ROMAN(999;4) returns IM + diff --git a/source/text/scalc/01/func_arabic.xhp b/source/text/scalc/01/func_arabic.xhp new file mode 100644 index 0..b827428e8 --- /dev/null +++ b/source/text/scalc/01/func_arabic.xhp @@ -0,0 +1,42 @@ + + + + + + +ARABIC Function +/text/scalc/01/func_arabic.xhp + + + + + + + ARABIC function + text functions;convert roman numbers + +ARABIC +Returns the numeric value corresponding to a Roman number expressed as text. + + The largest Roman number that can be converted is MMMCMXCIX (or one of its simplified versions), which is equivalent to 3999. + + ARABIC(Text) + Text: text representing a Roman number. + + =ARABIC("MXIV") returns the numeric value 1014. + =ARABIC("MMII") returns the numeric value 2002. + =ARABIC("") returns 0. + + + + + + + diff --git a/source/text/scalc/01/func_roman.xhp b/source/text/scalc/01/func_roman.xhp new file mode 100644 index 0..4600ab3fc --- /dev/null +++ b/source/text/scalc/01/func_roman.xhp @@ -0,0 +1,46 @@ + + + + + + +ROMAN Function +/text/scalc/01/func_roman.xhp + + + + + + + ROMAN function + text functions;convert to roman numbers + +ROMAN +Converts a number into a Roman numeral. The value range must be
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/04060110.xhp | 17 + source/text/scalc/01/func_datevalue.xhp | 53 ++ source/text/scalc/01/func_numbervalue.xhp |8 +--- source/text/scalc/01/func_timevalue.xhp | 42 +++ source/text/scalc/01/func_value.xhp | 47 ++ 6 files changed, 99 insertions(+), 69 deletions(-) New commits: commit 3a58cb35bdb6e11e7a80759b59d4c68fcd3c6be7 Author: Rafael Lima AuthorDate: Thu Aug 12 16:01:36 2021 +0200 Commit: Olivier Hallot CommitDate: Tue Aug 17 09:34:30 2021 +0200 Improve VALUE function help page The help page for the VALUE function is created as a separate help page func_value.xhp. This patch also refactors related help pages NUMBERVALUE, DATEVALUE and TIMEVALUE. Their main header was instead of . Change-Id: Ic67893f0c35a58a19f13af1d34d68956e901a4a6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/120361 Tested-by: Jenkins Reviewed-by: Steve Fanning Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 3cca39631..149c66d34 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -259,6 +259,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_time \ helpcontent2/source/text/scalc/01/func_timevalue \ helpcontent2/source/text/scalc/01/func_today \ +helpcontent2/source/text/scalc/01/func_value \ helpcontent2/source/text/scalc/01/func_weekday \ helpcontent2/source/text/scalc/01/func_webservice \ helpcontent2/source/text/scalc/01/func_weeknum \ diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 55a130d20..7b33f7139 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -794,22 +794,9 @@ - - VALUE function - - - - -VALUE -Converts a text string into a number. - - -VALUE("Text") - Text is the text to be converted to a number. - - - =VALUE("4321") returns 4321. + + diff --git a/source/text/scalc/01/func_datevalue.xhp b/source/text/scalc/01/func_datevalue.xhp index ea24c23be..963c85926 100644 --- a/source/text/scalc/01/func_datevalue.xhp +++ b/source/text/scalc/01/func_datevalue.xhp @@ -21,32 +21,31 @@ - - DATEVALUE - /text/scalc/01/func_datevalue.xhp - - - -DATEVALUE function - - -DATEVALUE - - Returns the internal date number for text in quotes. - The internal date number is returned as a number. The number is determined by the date system that is used by $[officename] to calculate dates. - If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion. - - - DATEVALUE("Text") - - Text is a valid date expression and must be entered with quotation marks. - - - - - =DATEVALUE("1954-07-20") yields 19925. - + +DATEVALUE +/text/scalc/01/func_datevalue.xhp + + + + +DATEVALUE function + + + DATEVALUE + Returns the internal date number for text in quotes. + The internal date number is returned as a number. The number is determined by the date system that is used by $[officename] to calculate dates. + If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion. + + + DATEVALUE("Text") + Text is a valid date expression and must be entered with quotation marks. + + + + +=DATEVALUE("1954-07-20") yields 19925. + - - + + diff --git a/source/text/scalc/01/func_numbervalue.xhp b/source/text/scalc/01/func_numbervalue.xhp index a0ccbe172..18d9d976a 100644 --- a/source/text/scalc/01/func_numbervalue.xhp +++ b/source/text/scalc/01/func_numbervalue.xhp @@ -28,11 +28,7 @@ NUMBERVALUE function - - -NUMBERVALUE - - +NUMBERVALUE Converts the string representation of a number into a locale-independent numeric value. @@ -57,7 +53,7 @@ Refer to the https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE; name="NUMBERVALUE_Wiki">NUMBERVALUE wiki page for more details about this function. - + diff --git a/source/text/scalc/01/func_timevalue.xhp b/source/text/scalc/01/func_timevalue.xhp index 7e6f442d5..87bd8da08 100644 --- a/source/text/scalc/01/func_timevalue.xhp +++ b/source/text/scalc/01/func_timevalue.xhp @@ -18,29 +18,29 @@ * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - -TIMEVALUE -/text/scalc/01/func_timevalue.xhp - + +TIMEVALUE +/text/scalc/01/func_timevalue.xhp + - -TIMEVALUE function - - -TIMEVALUE -TIMEVALUE returns the internal time number from a text enclosed by quotes and which may
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/04060116.xhp | 332 -- source/text/scalc/01/ful_func.xhp | 68 - source/text/scalc/01/func_convert.xhp | 1741 ++ 4 files changed, 1792 insertions(+), 350 deletions(-) New commits: commit 774b852c14a4a8df49c9ad35e609d8060b9b46a1 Author: Rafael Lima AuthorDate: Sat May 8 15:56:59 2021 +0200 Commit: Olivier Hallot CommitDate: Fri May 21 01:12:12 2021 +0200 tdf#141929 Improve CONVERT help and move to a separate file Updates the content of the CONVERT help page to better match the description in the wiki, focusing in unit measurement and prefix tables. Also moves the CONVERT help page to a separate file and removes it from the original location 04060116.xhp. Change-Id: I591ce3d2cd36e224daf5d00593418cba7832e574 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/115209 Tested-by: Jenkins Reviewed-by: Steve Fanning Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 0535a0ca2..3cca39631 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -196,6 +196,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_countifs \ helpcontent2/source/text/scalc/01/func_color \ helpcontent2/source/text/scalc/01/func_concat \ +helpcontent2/source/text/scalc/01/func_convert \ helpcontent2/source/text/scalc/01/func_date \ helpcontent2/source/text/scalc/01/func_datedif \ helpcontent2/source/text/scalc/01/func_datevalue \ diff --git a/source/text/scalc/01/04060116.xhp b/source/text/scalc/01/04060116.xhp index 9d554aa81..06141e181 100644 --- a/source/text/scalc/01/04060116.xhp +++ b/source/text/scalc/01/04060116.xhp @@ -383,329 +383,17 @@ =OCT2HEX(144;4) returns 0064. - -CONVERT function - - -CONVERT - Converts a value from one unit of measure to the corresponding value in another unit of measure. Enter the units of measures directly as text in quotation marks or as a reference. If you enter the units of measure in cells, they must correspond exactly with the following list which is case sensitive: For example, in order to enter a lower case l (for liter) in a cell, enter the apostrophe ' immediately followed by l. - - - - Property - - - Units - - - - - Weight - - - g, sg, lbm, u, ozm, stone, ton, grain, pweight, hweight, shweight, brton - - - - - Length - - - m, mi, Nmi, in, ft, yd, ang, Pica, ell, parsec, lightyear, survey_mi - - - - - Time - - - yr, day, hr, mn, sec, s - - - - - Pressure - - - Pa, atm, at, mmHg, Torr, psi - - - - - Force - - - N, dyn, dy, lbf, pond - - - - - Energy - - - J, e, c, cal, eV, ev, HPh, Wh, wh, flb, BTU, btu - - - - - Power - - - W, w, HP, PS - - - - - Field strength - - - T, ga - - - - - Temperature - - - C, F, K, kel, Reau, Rank - - - - - Volume - - - l, L, lt, tsp, tbs, oz, cup, pt, us_pt, qt, gal, m3, mi3, Nmi3, in3, ft3, yd3, ang3, Pica3, barrel, bushel, regton, Schooner, Middy, Glass - - - - - Area - - - m2, mi2, Nmi2, in2, ft2, yd2, ang2, Pica2, Morgen, ar, acre, ha - - - - - Speed - - - m/s, m/sec, m/h, mph, kn, admkn - - - - - Information - - - bit, byte -
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 + source/text/scalc/00/0407.xhp |6 -- source/text/scalc/01/0510.xhp |2 +- source/text/scalc/01/0709.xhp |6 -- source/text/scalc/01/07090100.xhp | 37 + source/text/scalc/main0103.xhp| 27 --- 6 files changed, 63 insertions(+), 16 deletions(-) New commits: commit 7b32fca7c38328a20a6bc7cd781c219bfde3916c Author: Olivier Hallot AuthorDate: Tue Feb 2 22:44:30 2021 -0300 Commit: Olivier Hallot CommitDate: Wed Feb 3 15:56:51 2021 +0100 tdf#140111 Synch Help page w/ Calc View menu Change-Id: I3e3d19f3ba3229843811528ce5376fea53795556 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110335 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 9ce1909e4..0535a0ca2 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -138,6 +138,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/0613 \ helpcontent2/source/text/scalc/01/0708 \ helpcontent2/source/text/scalc/01/0709 \ +helpcontent2/source/text/scalc/01/07090100 \ helpcontent2/source/text/scalc/01/1201 \ helpcontent2/source/text/scalc/01/12010100 \ helpcontent2/source/text/scalc/01/1202 \ diff --git a/source/text/scalc/00/0407.xhp b/source/text/scalc/00/0407.xhp index aea740854..1e21e09df 100644 --- a/source/text/scalc/00/0407.xhp +++ b/source/text/scalc/00/0407.xhp @@ -26,7 +26,9 @@ Window Menu -Choose >View - Split Window. -Choose View - Freeze Rows and Columns. +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/source/text/scalc/01/0510.xhp b/source/text/scalc/01/0510.xhp index befc16a8d..edea55a1b 100644 --- a/source/text/scalc/01/0510.xhp +++ b/source/text/scalc/01/0510.xhp @@ -38,7 +38,7 @@ styles; in Calc -Styles in Calc +Styles Use the Styles deck of the Sidebar to assign styles to cells and pages. You can apply, update, and modify existing styles or create new styles. The Styles dockable window can remain open while editing the document. diff --git a/source/text/scalc/01/0709.xhp b/source/text/scalc/01/0709.xhp index 9d2c9eca0..07064520c 100644 --- a/source/text/scalc/01/0709.xhp +++ b/source/text/scalc/01/0709.xhp @@ -31,14 +31,16 @@ -Freeze Rows and Columns +Freeze Rows and Columns Divides the sheet at the top left corner of the active cell and the area to the top left is no longer scrollable. + + + - diff --git a/source/text/scalc/01/07090100.xhp b/source/text/scalc/01/07090100.xhp new file mode 100644 index 0..7e7587324 --- /dev/null +++ b/source/text/scalc/01/07090100.xhp @@ -0,0 +1,37 @@ + + + + + + +Freeze Cells +/text/scalc/01/07090100.xhp + + + + +freezing;first row +freezing;first column +freezing;cells + + +Freeze Cells +Freezes the first column or the first row of the current spreadsheet. + + + + + + + + + + + diff --git a/source/text/scalc/main0103.xhp b/source/text/scalc/main0103.xhp index 50783fffa..31ba401e6 100644 --- a/source/text/scalc/main0103.xhp +++ b/source/text/scalc/main0103.xhp @@ -31,42 +31,47 @@ -View +View This menu contains commands for controlling the on-screen display of the document. -Normal +Normal Displays the normal layout view of the sheet. -Page Break +Page Break + -Grid Lines for Sheet -Toggle the visibility of grid lines for the current sheet. +View Grid lines +Toggle the visibility of grid lines and for the current sheet. + -Show Formula +Show Formula Display the cell formula expression instead of the calculated result. - - + + + + + -Gallery +Gallery - + -Zoom +Zoom ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/databar_more_options.xhp | 73 ++ 2 files changed, 74 insertions(+) New commits: commit d3699ebe29792a680cc965f5bdaa5b8a9432b8aa Author: Balaharipreetha Muthu AuthorDate: Wed Jan 13 19:25:55 2021 +0100 Commit: Olivier Hallot CommitDate: Thu Jan 14 15:18:47 2021 +0100 tdf#139436 Add Help page for Format - Conditional - Data bar - More Options dialog Change-Id: I83faa2d1edb8f5cba08a7b1054bd66fc17f835b9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109129 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 4c730d72a..9ce1909e4 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -184,6 +184,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/cell_styles \ helpcontent2/source/text/scalc/01/data_form \ helpcontent2/source/text/scalc/01/data_provider \ +helpcontent2/source/text/scalc/01/databar_more_options \ helpcontent2/source/text/scalc/01/ex_data_stat_func \ helpcontent2/source/text/scalc/01/format_graphic \ helpcontent2/source/text/scalc/01/ful_func \ diff --git a/source/text/scalc/01/databar_more_options.xhp b/source/text/scalc/01/databar_more_options.xhp new file mode 100644 index 0..f76ded414 --- /dev/null +++ b/source/text/scalc/01/databar_more_options.xhp @@ -0,0 +1,73 @@ + + + + + + +Databar More Options +/text/scalc/01/databar_more_options.xhp + + + + + + +conditional formatting;data bar options +data bar formatting;data bar options +data bar options;conditional formatting + + Databar More Options +Entry Values + Minimum: Set the minimum value for which the databar does not start filling. + Maximum: Set the maximum value for which the databar gets completely filled. + The options for setting the minimum and maximum are: +Automatic: Automatically sets the minimum and maximum value based on the values in the data set. + + + Minimum: Automatically sets the minimum value in the data set as minimum. + + + Maximum: Automatically sets the maximum value in the data set for maximum. + + + Percentile: Set the minimum and maximum as percentile value. + + + Value: Set the minimum and maximum as a specific value. + + + Formula: Set the minimum and maximum as a formula. + + + Bar Colors + Positive: Set the color for positive values. It is set to blue be default. + Negative: Set the color for negative values. It is set to red by default. + Fill: Choose between color and gradient to fill with solid color or gradient. + Axis + Position of vertical axis: Set the position of vertical axis in the cell. + + +Automatic: Set the axis automatically + + +Middle: Set the vertical position to be in the middle of the cell. + + +None: Set the data bar to have no visible vertical axis + + + Color of vertical axis: Choose the color of the vertical axis. + Bar Lengths + Minimum bar length(%): Set the minimum length of the databar in percentage with respect to the cell length. + Maximum bar length(%): Set the maximum length of the databar in percentage with respect to the cell length. + Display bar only + Only databar is shown. Value becomes hidden. + + \ No newline at end of file ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/guide/change_image_anchor.xhp | 45 2 files changed, 46 insertions(+) New commits: commit d8e499a2dafadafc7cf90869f1046e1df8c2d3f4 Author: Balaharipreetha Muthu AuthorDate: Fri Dec 11 03:28:35 2020 +0100 Commit: Olivier Hallot CommitDate: Thu Dec 17 00:09:57 2020 +0100 tdf#116381 - Add help file - anchor types for an image in Calc Change-Id: Ib2d9cbd0607e47f1adeb74f5c4a31e984d07197a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107545 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index c339ed099..4c730d72a 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -328,6 +328,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/guide/cellstyle_by_formula \ helpcontent2/source/text/scalc/guide/cellstyle_conditional \ helpcontent2/source/text/scalc/guide/cellstyle_minusvalue \ +helpcontent2/source/text/scalc/guide/change_image_anchor \ helpcontent2/source/text/scalc/guide/consolidate \ helpcontent2/source/text/scalc/guide/csv_files \ helpcontent2/source/text/scalc/guide/csv_formula \ diff --git a/source/text/scalc/guide/change_image_anchor.xhp b/source/text/scalc/guide/change_image_anchor.xhp new file mode 100644 index 0..854e7d196 --- /dev/null +++ b/source/text/scalc/guide/change_image_anchor.xhp @@ -0,0 +1,45 @@ + + + + + + +Change Image Anchor in Calc +/text/scalc/guide/change_image_anchor.xhp + + + + +anchor;image + + +Change Anchor of Image + +When you insert an image in Calc, it gets anchored to the cell by default and does not resize when moved. + +The image could be anchored in three different ways: + + + + To Cell: When the image is anchored to cell, the image will move along with the cell( while copying, sorting or inserting cells). + +To Cell(resize with cell): When resize with cell option is selected, the image would move along with the cell. Also the size of the image will be altered according to the size of the destination cell. The aspect ratio of original image is maintained as long as the image fits into the cell. + +To Page: When the image is anchored to page, ordering of cells or pasting in other cells do not affect the image position in the page. + + + + + To Change the anchor of an imageInsert Image Dialog - Anchor. Or, +on the context menu of the image choose - Anchor + + The original size of the image and cell is preserved while pasting the entire row or entire column for both "To Cell" and "To Cell(resize with cell)" option. + + \ No newline at end of file ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/00/0405.xhp |7 +++- source/text/scalc/01/0502.xhp |6 +--- source/text/scalc/01/0507.xhp | 12 ++-- source/text/scalc/01/0510.xhp | 29 --- source/text/scalc/01/cell_styles.xhp| 38 + source/text/scalc/guide/print_title_row.xhp |9 ++ source/text/scalc/main0105.xhp | 18 ++-- source/text/schart/01/05010100.xhp | 13 +++- source/text/schart/01/05010200.xhp | 14 ++--- source/text/schart/01/05020100.xhp | 11 +++ source/text/schart/01/05020200.xhp |8 + source/text/schart/01/0503.xhp | 14 ++--- source/text/schart/01/05040100.xhp | 14 ++--- source/text/schart/01/05040200.xhp | 14 - source/text/shared/01/0502.xhp |4 +- source/text/shared/01/05020100.xhp | 21 ++ source/text/shared/01/05020300.xhp | 13 ++-- source/text/shared/01/05040100.xhp | 42 source/text/shared/01/05340405.xhp | 13 ++-- source/text/simpress/01/0509m.xhp |3 -- source/text/swriter/01/05130002.xhp |1 22 files changed, 162 insertions(+), 143 deletions(-) New commits: commit 5e74f53b93134f1174f477fcbf54e93f06a4c707 Author: Olivier Hallot AuthorDate: Wed Jul 1 09:40:51 2020 -0300 Commit: Olivier Hallot CommitDate: Wed Jul 1 16:36:37 2020 +0200 tdf#134376 Add Calc cell style Help page Change-Id: I57f32bdfc4435cbe21b7cca1cb5170892e69447d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/97622 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index d0599281e..c339ed099 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -181,6 +181,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/12120200 \ helpcontent2/source/text/scalc/01/12120300 \ helpcontent2/source/text/scalc/01/calculate \ +helpcontent2/source/text/scalc/01/cell_styles \ helpcontent2/source/text/scalc/01/data_form \ helpcontent2/source/text/scalc/01/data_provider \ helpcontent2/source/text/scalc/01/ex_data_stat_func \ diff --git a/source/text/scalc/00/0405.xhp b/source/text/scalc/00/0405.xhp index beedce6e7..a3fe793be 100644 --- a/source/text/scalc/00/0405.xhp +++ b/source/text/scalc/00/0405.xhp @@ -28,8 +28,11 @@ -Format Menu -Choose Format - Cells. +Format Menu + +Choose Format - Cells. +Press CommandCtrl+1. + Choose Format - Cells - Cell Protection tab. Choose Format - Rows. Choose Format - Rows - Optimal Height. diff --git a/source/text/scalc/01/0502.xhp b/source/text/scalc/01/0502.xhp index 513f08ac6..da4e8bb76 100644 --- a/source/text/scalc/01/0502.xhp +++ b/source/text/scalc/01/0502.xhp @@ -39,10 +39,8 @@ -Numbers - -Font - + + diff --git a/source/text/scalc/01/0507.xhp b/source/text/scalc/01/0507.xhp index 61b7c6092..945b0ff83 100644 --- a/source/text/scalc/01/0507.xhp +++ b/source/text/scalc/01/0507.xhp @@ -27,10 +27,18 @@ + +style;page +page;style +format;page +formatting;page + + Page Style - Opens a dialog where you can define the appearance of all pages in your document. - + +Opens a dialog where you can define the appearance of all pages in your document. + diff --git a/source/text/scalc/01/0510.xhp b/source/text/scalc/01/0510.xhp index 8de45e742..befc16a8d 100644 --- a/source/text/scalc/01/0510.xhp +++ b/source/text/scalc/01/0510.xhp @@ -20,25 +20,25 @@ -Styles +Styles in Calc /text/scalc/01/0510.xhp - - Stylist, see Styles window - Styles window - formats; Styles window - formatting; Styles window - paint can for applying styles +Stylist, see Styles window +Styles window +formats; Styles window +formatting; Styles window +paint can for applying styles +styles in spreadsheets +styles; in Calc - -Styles +Styles in Calc Use the Styles deck of the Sidebar to assign styles to cells and pages. You can apply, update, and modify existing styles or create new styles. The Styles dockable window can remain open while editing the document. @@ -57,11 +57,9 @@ Double-click the style in the Styles window. - - -Cell Styles -Displays the list of the available Cell Styles for indirect cell formatting. + +Displays the list of the available Cell Styles. @@ -75,8 +73,8 @@ -Page Styles -Displays the Page Styles available for indirect page formatting. +Page Styles +Displays the Page Styles available. @@ -105,7 +103,6 @@ - How to apply a new style with the paint can: diff --git
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/01/04060106.xhp | 50 --- source/text/scalc/01/func_floor.xhp | 113 3 files changed, 114 insertions(+), 50 deletions(-) New commits: commit ef21ad9a4c0d9fb787392c5a6d24ebe9bb77309e Author: Steve Fanning AuthorDate: Tue Apr 7 18:15:02 2020 -0300 Commit: Olivier Hallot CommitDate: Thu Apr 9 00:33:31 2020 +0200 tdf#131960 Clarification of FLOOR functions + refactor, grouping all FLOOR variants into one file Change-Id: I522674c51de531054991457cdc19a2245df4244d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91856 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index aeee43364..d8660002b 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -204,6 +204,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_eomonth \ helpcontent2/source/text/scalc/01/func_error_type \ helpcontent2/source/text/scalc/01/func_findb \ +helpcontent2/source/text/scalc/01/func_floor \ helpcontent2/source/text/scalc/01/func_forecastetsadd \ helpcontent2/source/text/scalc/01/func_forecastetsmult \ helpcontent2/source/text/scalc/01/func_forecastetsstatadd \ diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 0bd8172ee..36bde5f4d 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1420,56 +1420,6 @@ =ODD(-3.1) returns -5.see also CEILING, FLOOR, EVEN, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP - - - FLOOR.PRECISE function - FLOOR.XCL function - rounding;down to nearest multiple of significance - -mw added one entry - - - -FLOOR.PRECISE -Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance - - -FLOOR.PRECISE(Number; Significance) -Number is the number that is to be rounded down. -Significance is the value to whose multiple the number is to be rounded down. - - -=FLOOR.PRECISE( -11;-2) returns -12see also CEILING, EVEN, ODD, MROUND,INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP - - - - - FLOOR function - FLOOR.MATH function - rounding;down to nearest multiple of significance - -mw added one entry - - - -FLOOR -Rounds a number down to the nearest multiple of Significance. - - -FLOOR(Number; Significance; Mode) -Number is the number that is to be rounded down. -Significance is the value to whose multiple the number is to be rounded down. -Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero. - -If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero. - - - -=FLOOR( -11;-2) returns -12 -=FLOOR( -11;-2;0) returns -12 -=FLOOR( -11;-2;1) returns -10see also CEILING, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP - - SIGN function diff --git a/source/text/scalc/01/func_floor.xhp b/source/text/scalc/01/func_floor.xhp new file mode 100644 index 0..e56c0598b --- /dev/null +++ b/source/text/scalc/01/func_floor.xhp @@ -0,0 +1,113 @@ + + + + + + +FLOOR Functions +/text/scalc/01/func_floor.xhp + + + +FLOOR Functions + + + +FLOOR function +rounding;down to nearest multiple of significance + +mw added one entry + +FLOOR +Rounds a number to the nearest multiple of a significance value. +For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs. + +FLOOR(Number[; Significance[; Mode]]) + +Number is the number that is to be rounded, or a reference to a cell containing the number. + +Significance (optional) is the value, or a reference to a cell containing the value, to whose multiple Number is to be rounded. It defaults to +1 or -1 depending on the sign of Number. +Mode (optional) is a number, or a reference to a cell containing a number. The function only uses Mode if both Number and Significance are negative. Then if Mode is given and not
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/04060106.xhp | 99 - source/text/scalc/01/func_ceiling.xhp | 132 ++ 3 files changed, 133 insertions(+), 99 deletions(-) New commits: commit 2d238deabf589c10ab89b495d3f9e2c57a8efda0 Author: Steve Fanning AuthorDate: Tue Apr 7 15:34:09 2020 -0300 Commit: Olivier Hallot CommitDate: Thu Apr 9 00:32:33 2020 +0200 tdf#131960 Clarification of CEILING function + refactor, grouping all CEILING variants into one file Change-Id: Ie82a1c72c8eab69457391ccc82543497fe168fa2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91855 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 32fe1d62e..aeee43364 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -189,6 +189,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_aggregate \ helpcontent2/source/text/scalc/01/func_averageif \ helpcontent2/source/text/scalc/01/func_averageifs \ +helpcontent2/source/text/scalc/01/func_ceiling \ helpcontent2/source/text/scalc/01/func_countifs \ helpcontent2/source/text/scalc/01/func_color \ helpcontent2/source/text/scalc/01/func_concat \ diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index a34aba2f3..0bd8172ee 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -688,105 +688,6 @@ =LOG10(5) returns the base-10 logarithm of 5 (approximately 0.69897).see also LOG, LN, POWER - - - CEILING function - rounding;up to multiples of significance - -mw added one entry - - -CEILING -Rounds a number up to the nearest multiple of Significance. - - -CEILING(Number; Significance; Mode) -Number is the number that is to be rounded up. -Significance is the number to whose multiple the value is to be rounded up. -Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero. -If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero. - - -=CEILING(-11;-2) returns -10 -=CEILING(-11;-2;0) returns -10 -=CEILING(-11;-2;1) returns -12see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP - - - - - CEILING.PRECISE function - rounding;up to multiples of significance - -mw added one entry - - -CEILING.PRECISE -Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance - - -CEILING.PRECISE(Number; Significance) -Number (required) is the number that is to be rounded up. -Significance (optional) is the number to whose multiple the value is to be rounded up. - - -=CEILING.PRECISE(-11;-2) returns -10see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP - - - - -CEILING.MATH function - - -CEILING.MATH -Rounds a number up to the nearest multiple of Significance. - -CEILING.MATH(Number; Significance; Mode) -Number is the number that is to be rounded up. -Significance is the number to whose multiple the value is to be rounded up. -Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero. -This function exists for interoperability with Microsoft Excel 2013 or newer. - -=CEILING.MATH(-10;-3) returns -9 -=CEILING.MATH(-10;-3;0) returns -9 -=CEILING.MATH(-10;-3;1) returns -12 - - - -CEILING.XCL function - - -CEILING.XCL -Rounds a number away from zero to the nearest multiple of Significance. - - -CEILING.XCL(Number; Significance) -Number is the number that is to be rounded. -Significance is the number to whose multiple the value is to be rounded. -This function exists for interoperability with Microsoft Excel 2007 or older versions. - -=CEILING.XCL(1;3) returns 3 -=CEILING.XCL(7;4) returns 8 -=CEILING.XCL(-10;-3) returns -12 - - - - ISO.CEILING function - rounding;up to multiples of significance - -mw added one entry - - -ISO.CEILING -Rounds a number
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk| 11 source/text/scalc/01/stat_data.xhp | 18 source/text/scalc/01/statistics.xhp | 1712 source/text/scalc/01/statistics_anova.xhp | 271 +++ source/text/scalc/01/statistics_correlation.xhp | 101 + source/text/scalc/01/statistics_covariance.xhp | 97 + source/text/scalc/01/statistics_descriptive.xhp | 240 +++ source/text/scalc/01/statistics_exposmooth.xhp | 177 ++ source/text/scalc/01/statistics_fourier.xhp | 22 source/text/scalc/01/statistics_movingavg.xhp | 155 ++ source/text/scalc/01/statistics_regression.xhp | 19 source/text/scalc/01/statistics_sampling.xhp| 234 +++ source/text/scalc/01/statistics_test_chisqr.xhp | 91 + source/text/scalc/01/statistics_test_f.xhp | 191 ++ source/text/scalc/01/statistics_test_t.xhp | 211 ++ source/text/scalc/01/statistics_test_z.xhp | 188 ++ source/text/scalc/main0112.xhp |1 17 files changed, 2020 insertions(+), 1719 deletions(-) New commits: commit e1032e5082161441a37473e22582f6eb6938c102 Author: Olivier Hallot AuthorDate: Fri Mar 20 16:32:20 2020 -0300 Commit: Olivier Hallot CommitDate: Fri Mar 20 20:35:16 2020 +0100 Refactor Data analysis Calc help page Comply with menu Data > Statistics Change-Id: I06a5ed00ef162064ea2768f3040511e53c3f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90837 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 61401028c..d2a7e20c0 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -265,8 +265,19 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/solver \ helpcontent2/source/text/scalc/01/solver_options \ helpcontent2/source/text/scalc/01/statistics \ +helpcontent2/source/text/scalc/01/statistics_anova \ +helpcontent2/source/text/scalc/01/statistics_correlation \ +helpcontent2/source/text/scalc/01/statistics_covariance \ +helpcontent2/source/text/scalc/01/statistics_descriptive \ +helpcontent2/source/text/scalc/01/statistics_exposmooth \ helpcontent2/source/text/scalc/01/statistics_fourier \ +helpcontent2/source/text/scalc/01/statistics_movingavg \ helpcontent2/source/text/scalc/01/statistics_regression \ +helpcontent2/source/text/scalc/01/statistics_sampling \ +helpcontent2/source/text/scalc/01/statistics_test_chisqr \ +helpcontent2/source/text/scalc/01/statistics_test_f \ +helpcontent2/source/text/scalc/01/statistics_test_t \ +helpcontent2/source/text/scalc/01/statistics_test_z \ helpcontent2/source/text/scalc/01/stat_data \ helpcontent2/source/text/scalc/01/ODFF \ helpcontent2/source/text/scalc/01/text2columns \ diff --git a/source/text/scalc/01/stat_data.xhp b/source/text/scalc/01/stat_data.xhp index 4c88b0d0b..c47cccf20 100644 --- a/source/text/scalc/01/stat_data.xhp +++ b/source/text/scalc/01/stat_data.xhp @@ -28,7 +28,23 @@ Select whether the input data has columns or rows layout. - + + + + + + + + + + + + + + + + + The following data will be used as example diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp index e48774db3..a81feab1b 100644 --- a/source/text/scalc/01/statistics.xhp +++ b/source/text/scalc/01/statistics.xhp @@ -19,1707 +19,31 @@ --> - + Data Statistics in Calc /text/scalc/01/statistics.xhp -Data Statistics in Calc -Use the data statistics in Calc to perform complex data analysis -To work on a complex statistical or engineering analysis, you can save steps and time by using Calc Data Statistics. You provide the data and parameters for each analysis, and the set of tools uses the appropriate statistical or engineering functions to calculate and display the results in an output table. - - -Analysis toolpack;sampling -sampling;Analysis toolpack -Data statistics;sampling - - - -Sampling -Create a table with data sampled from another table. - -Choose Data - Statistics - Sampling - -Sampling allows you to pick data from a source table to fill a target table. The sampling can be random or in a periodic basis. -Sampling is done row-wise. That means, the sampled data will pick the whole line of the source table and copy into a line of the target table. -Sampling Method -Random: Picks exactly Sample Size lines of the source table in a random way. -Sample size: Number of lines sampled from the source table. -Periodic: Picks lines in a pace defined by Period. -Period: the number of lines to skip periodically when sampling. - -The following data will be used as example of source data table for sampling: - - - - - -A - - -B - - -C - - - - -1 - - -11 - - -21 - - -31 - - - - -2 - - -12 - - -22 - - -32 - - - - -3 - - -13 - - -23 - - -33 - - - - -4 - - -14 - - -24 - - -34 - - - - -5 -
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/00/0412.xhp | 324 +++--- source/text/scalc/01/0607.xhp |5 source/text/scalc/01/0608.xhp |6 source/text/scalc/01/1201.xhp | 18 - source/text/scalc/01/1202.xhp | 14 - source/text/scalc/01/1203.xhp |9 source/text/scalc/01/12030100.xhp | 25 -- source/text/scalc/01/1204.xhp | 13 - source/text/scalc/01/12040100.xhp |9 source/text/scalc/01/1205.xhp | 14 - source/text/scalc/01/1206.xhp | 20 + source/text/scalc/01/1207.xhp | 21 + source/text/scalc/01/1209.xhp |7 source/text/scalc/01/1210.xhp |9 source/text/scalc/01/1212.xhp |9 source/text/scalc/01/calculate.xhp| 31 ++ source/text/scalc/01/data_form.xhp| 26 +- source/text/scalc/01/data_provider.xhp|7 source/text/scalc/01/live_data_stream.xhp |6 source/text/scalc/01/text2columns.xhp | 22 +- source/text/scalc/01/xml_source.xhp | 23 +- source/text/scalc/guide/autofilter.xhp|5 source/text/scalc/main0112.xhp| 47 +--- source/text/shared/02/1201.xhp| 32 -- source/text/shared/02/1202.xhp| 28 -- source/text/shared/main0212.xhp |9 source/text/shared/main0213.xhp |4 28 files changed, 371 insertions(+), 373 deletions(-) New commits: commit 562631aa3b0f0a6055e899e8b36491bee52fcb73 Author: Olivier Hallot AuthorDate: Fri Mar 20 11:01:08 2020 -0300 Commit: Olivier Hallot CommitDate: Fri Mar 20 15:16:11 2020 +0100 Review, refactor Calc Data Menu Help pages - update to latest menu entries - embed headings from individual Help files - WIP: Statistics menu entry will come later Change-Id: I66a2627b7bea65945210b6dcc2d1c3ed8783aec9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90796 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index eeca4db24..61401028c 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -180,6 +180,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/12120100 \ helpcontent2/source/text/scalc/01/12120200 \ helpcontent2/source/text/scalc/01/12120300 \ +helpcontent2/source/text/scalc/01/calculate \ helpcontent2/source/text/scalc/01/data_form \ helpcontent2/source/text/scalc/01/data_provider \ helpcontent2/source/text/scalc/01/ex_data_stat_func \ diff --git a/source/text/scalc/00/0412.xhp b/source/text/scalc/00/0412.xhp index 476ce5e28..c6de85323 100644 --- a/source/text/scalc/00/0412.xhp +++ b/source/text/scalc/00/0412.xhp @@ -1,162 +1,172 @@ - + - - -Data Menu -/text/scalc/00/0412.xhp - - - -Data Menu -Choose Data - Text to Columns. -Choose Data - Define Range. -Choose Data - Select Range. -Choose Data - Sort - -Choose Data - Sort - Sort Criteria tab. - On Standard bar, click - - - - - -Icon - - -Sort Ascending - - - - - -Icon - - -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 -
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |3 ++ source/text/scalc/01/04060110.xhp |8 ++--- source/text/scalc/01/func_findb.xhp| 45 ++ source/text/scalc/01/func_replaceb.xhp | 48 + source/text/scalc/01/func_searchb.xhp | 46 +++ 5 files changed, 146 insertions(+), 4 deletions(-) New commits: commit 1a28d0647ccd790bac0c1dbdad6eda44a5c8eaa1 Author: Olivier Hallot AuthorDate: Mon Nov 11 21:58:34 2019 -0300 Commit: Olivier Hallot CommitDate: Tue Nov 12 14:34:11 2019 +0100 Add FINDB, SEARCHB and REPLACEB Help pages Change-Id: Ie8a7c5762f41484d36837008226cc446584e3110 Reviewed-on: https://gerrit.libreoffice.org/82481 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 2fcc39a4e..538b4ecad 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -201,6 +201,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_edate \ helpcontent2/source/text/scalc/01/func_eomonth \ helpcontent2/source/text/scalc/01/func_error_type \ +helpcontent2/source/text/scalc/01/func_findb \ helpcontent2/source/text/scalc/01/func_forecastetsadd \ helpcontent2/source/text/scalc/01/func_forecastetsmult \ helpcontent2/source/text/scalc/01/func_forecastetsstatadd \ @@ -236,9 +237,11 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_now \ helpcontent2/source/text/scalc/01/func_rawsubtract \ helpcontent2/source/text/scalc/01/func_regex \ +helpcontent2/source/text/scalc/01/func_replaceb \ helpcontent2/source/text/scalc/01/func_roundsig \ helpcontent2/source/text/scalc/01/func_second \ helpcontent2/source/text/scalc/01/func_skewp \ +helpcontent2/source/text/scalc/01/func_searchb \ helpcontent2/source/text/scalc/01/func_sumifs \ helpcontent2/source/text/scalc/01/func_switch \ helpcontent2/source/text/scalc/01/func_textjoin \ diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 664d23885..5e24c67a8 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -349,7 +349,7 @@ -LEFTB +LEFTB Returns the first characters of a DBCS text. @@ -391,7 +391,7 @@ -LENB +LENB For double-byte character set (DBCS) languages, returns the number of bytes used to represent the characters in a text string. @@ -451,7 +451,7 @@ -MIDB +MIDB Returns a text string of a DBCS text. The parameters specify the starting position and the number of characters. @@ -564,7 +564,7 @@ -RIGHTB +RIGHTB Returns the last character or characters of a text with double bytes characters sets (DBCS). diff --git a/source/text/scalc/01/func_findb.xhp b/source/text/scalc/01/func_findb.xhp new file mode 100644 index 0..0ab9ead47 --- /dev/null +++ b/source/text/scalc/01/func_findb.xhp @@ -0,0 +1,45 @@ + + + + + + +FINDB Function +/text/scalc/01/func_findb.xhp + + + + + + +FINDB Function +find text;FINDB Function + +FINDB +Returns the starting position of a given text, using byte positions. FINDB is case sensitive. + + + +FINDB( Find Text ; Text ; Position ) +Find Text: The text or text expression to be found. +Text: the text in which the search is to be made. +Position: The position in the text where the search starts. + +=FINDB("ᄫᄬ";"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ";17) returns 19. + + + + + + + + + + diff --git a/source/text/scalc/01/func_replaceb.xhp b/source/text/scalc/01/func_replaceb.xhp new file mode 100644 index 0..52966391c --- /dev/null +++ b/source/text/scalc/01/func_replaceb.xhp @@ -0,0 +1,48 @@ + + + + + + +REPLACEB Function +/text/scalc/01/func_replaceb.xhp + + + + + + +REPLACEB Function +replace text;REPLACEB Function + +REPLACEB +Returns text where an old text is replaced with a new text, using byte positions. + + + +REPLACEB( Text ; Position ; Length ; NewText ) +Text: A text expression or reference to a cell containing a text expression in which the characters are to be replaced. +Position: the character position from which text is to be replaced. +Length: the number of characters to be replaced. +NewText: the text to be inserted. + + +=REPLACEB("ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ";4;1;"ab") returns "ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ" . + + + + + + + + + + + diff --git a/source/text/scalc/01/func_searchb.xhp b/source/text/scalc/01/func_searchb.xhp new file mode 100644
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |4 ++ source/text/scalc/01/func_color.xhp |2 - source/text/scalc/01/func_concat.xhp | 40 ++ source/text/scalc/01/func_ifs.xhp| 47 +++ source/text/scalc/01/func_switch.xhp | 42 +++ source/text/scalc/01/func_textjoin.xhp | 45 + source/text/scalc/01/func_webservice.xhp |6 +-- 7 files changed, 182 insertions(+), 4 deletions(-) New commits: commit 7b20c74a33942157b02b99353aa98e45f7c0a111 Author: Olivier Hallot AuthorDate: Thu Apr 25 23:42:20 2019 -0300 Commit: Olivier Hallot CommitDate: Sat Apr 27 14:08:21 2019 +0200 tdf#99517 help for CONCAT, TEXTJOIN, IFS, SWITCH CONCAT, TEXTJOIN, IFS, SWITCH Change-Id: Ic1d74ac8b810bd0c0d4b4f570baab1d1e270f912 Reviewed-on: https://gerrit.libreoffice.org/71339 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 6bdbc1e56..152b32238 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -190,6 +190,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_averageifs \ helpcontent2/source/text/scalc/01/func_countifs \ helpcontent2/source/text/scalc/01/func_color \ +helpcontent2/source/text/scalc/01/func_concat \ helpcontent2/source/text/scalc/01/func_date \ helpcontent2/source/text/scalc/01/func_datedif \ helpcontent2/source/text/scalc/01/func_datevalue \ @@ -209,6 +210,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_forecastetsseason \ helpcontent2/source/text/scalc/01/exponsmooth_embd \ helpcontent2/source/text/scalc/01/func_hour \ +helpcontent2/source/text/scalc/01/func_ifs \ helpcontent2/source/text/scalc/01/func_imcot \ helpcontent2/source/text/scalc/01/func_imcos \ helpcontent2/source/text/scalc/01/func_imcosh \ @@ -237,6 +239,8 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_second \ helpcontent2/source/text/scalc/01/func_skewp \ helpcontent2/source/text/scalc/01/func_sumifs \ +helpcontent2/source/text/scalc/01/func_switch \ +helpcontent2/source/text/scalc/01/func_textjoin \ helpcontent2/source/text/scalc/01/func_time \ helpcontent2/source/text/scalc/01/func_timevalue \ helpcontent2/source/text/scalc/01/func_today \ diff --git a/source/text/scalc/01/func_color.xhp b/source/text/scalc/01/func_color.xhp index 7b631e917..fced92ec0 100644 --- a/source/text/scalc/01/func_color.xhp +++ b/source/text/scalc/01/func_color.xhp @@ -32,7 +32,7 @@ colors;calculating in spreadsheets COLOR function - COLOR + COLOR Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system. The result depends on the color system used by your computer. diff --git a/source/text/scalc/01/func_concat.xhp b/source/text/scalc/01/func_concat.xhp new file mode 100644 index 0..2aaa63240 --- /dev/null +++ b/source/text/scalc/01/func_concat.xhp @@ -0,0 +1,40 @@ + + + + + + +CONCAT function +/text/scalc/01/func_concat.xhp + + + + + + +CONCAT function + +CONCAT +Concatenates one or more strings + +CONCAT is an enhancement of CONCATENATE, as CONCAT also accepts ranges as arguments, like B2:E5, K:K or K:M. +When ranges are used, the cells are traversed row by row (from top to bottom) to concatenate. + + +CONCAT( string1[, string2][, …] ) +string1[, string2][, …] are strings or references to cells or ranges that contains strings to concatenate. + +=CONCAT("Hello ", A1:C3) concatenates the string "Hello" with all strings in range A1:C3. + + +CONCATENATE + + + diff --git a/source/text/scalc/01/func_ifs.xhp b/source/text/scalc/01/func_ifs.xhp new file mode 100644 index 0..61349e747 --- /dev/null +++ b/source/text/scalc/01/func_ifs.xhp @@ -0,0 +1,47 @@ + + + + + + +IFS function +/text/scalc/01/func_ifs.xhp + + + + + + +IFS function + +IFS +IFS is a multiple IF-function. + + + +IFS( expression1, result1[, expression2, result2][, …] ) +expression1, expression2, ... are any boolean values or expressions that can be TRUE or FALSE +result1, result2, ... are the values that are returned if the logical test is TRUE +IFS( expression1, result1, expression2, result2, expression3, result3 ) is executed as +IF expression1 is TRUE +THEN result1 +ELSE IF expression2 is TRUE +THEN result2 +ELSE IF expression3
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/01/04060110.xhp |4 +++ source/text/scalc/01/func_regex.xhp | 44 3 files changed, 49 insertions(+) New commits: commit 7c62f2e63ed7a43014b3a4655bc73153110aedcb Author: Olivier Hallot AuthorDate: Thu Nov 15 13:39:59 2018 -0200 Commit: Eike Rathke CommitDate: Fri Nov 16 19:16:39 2018 +0100 tdf#121084 Help page for Calc REGEX function * honor DTD * follow erAck advise Change-Id: Ib911888fbc5aae9c4a749c9343218081df9f6783 Reviewed-on: https://gerrit.libreoffice.org/63430 Tested-by: Jenkins Reviewed-by: Eike Rathke diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index b04311c82..d55d6abbf 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -231,6 +231,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_numbervalue \ helpcontent2/source/text/scalc/01/func_now \ helpcontent2/source/text/scalc/01/func_rawsubtract \ +helpcontent2/source/text/scalc/01/func_regex \ helpcontent2/source/text/scalc/01/func_roundsig \ helpcontent2/source/text/scalc/01/func_second \ helpcontent2/source/text/scalc/01/func_skewp \ diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 162145bd2..6f50c9096 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -492,6 +492,10 @@ =PROPER("open office") returns Open Office. + + + + REPLACE function diff --git a/source/text/scalc/01/func_regex.xhp b/source/text/scalc/01/func_regex.xhp new file mode 100644 index 0..f83cfac18 --- /dev/null +++ b/source/text/scalc/01/func_regex.xhp @@ -0,0 +1,44 @@ + + + + + + +REGEX Function +/text/scalc/01/func_regex.xhp + + + + + + +REGEX function +regular expressions;extracting in spreadsheets +regular expressions;REGEX function + +REGEX +Matches and extracts or optionally replaces text using regular expressions. + + +REGEX( Text ; Expression [ ; [ Replacement ] [ ; Flags ] ] ) +Text: A text or reference to a cell where the regular expression is to be applied. +Expression: A text representing the regular expression, using https://userguide.icu-project.org/strings/regexp; name="ICU REGEXP">ICU regular expressions. If there is no match, #N/A is returned. +Replacement: Optional. The replacement text and references to capture groups. If there is no match, Text is returned unmodified. +Flags: Optional. "g" replaces all matches of Expression in Text, not extracted. If there is no match, Text is returned unmodified. + +=REGEX("123456ABCDEF";"[:digit:]";"Z") returns "Z23456ABCDEF", where the first match of a digit is replaced by "Z". +=REGEX("123456ABCDEF";"[:digit:]";"Z";"g") returns "ZZABCDEF", where all digits were replaced by "Z". +=REGEX("123456ABCDEF";"[1|2|6]";"";"g") returns "345ABCDEF", where any occurrence of "1", "2" or "6" is replaced by the empty string, thus deleted. + +List of regular expressions +https://userguide.icu-project.org/strings/regexp; name="ICU REGEXP">ICU regular expressions + + + ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/04060101.xhp | 48 +-- source/text/scalc/01/04060103.xhp | 56 ++-- source/text/scalc/01/04060104.xhp | 88 +++ source/text/scalc/01/04060105.xhp | 28 +- source/text/scalc/01/04060106.xhp | 266 +++--- source/text/scalc/01/04060107.xhp | 52 ++-- source/text/scalc/01/04060109.xhp | 82 +++--- source/text/scalc/01/04060110.xhp | 138 +-- source/text/scalc/01/04060111.xhp | 26 +- source/text/scalc/01/04060115.xhp | 76 +++--- source/text/scalc/01/04060116.xhp | 84 +++--- source/text/scalc/01/04060118.xhp | 76 +++--- source/text/scalc/01/04060119.xhp | 96 +++ source/text/scalc/01/04060120.xhp | 24 - source/text/scalc/01/04060181.xhp | 100 source/text/scalc/01/04060182.xhp | 96 +++ source/text/scalc/01/04060183.xhp | 60 ++-- source/text/scalc/01/04060184.xhp | 120 - source/text/scalc/01/04060185.xhp | 160 ++--- source/text/scalc/01/04060199.xhp |8 source/text/scalc/01/common_func.xhp | 25 ++ source/text/scalc/01/ex_data_stat_func.xhp|2 source/text/scalc/01/exponsmooth_embd.xhp |2 source/text/scalc/01/func_aggregate.xhp |4 source/text/scalc/01/func_averageif.xhp |2 source/text/scalc/01/func_averageifs.xhp |2 source/text/scalc/01/func_countifs.xhp|2 source/text/scalc/01/func_date.xhp|4 source/text/scalc/01/func_datedif.xhp |4 source/text/scalc/01/func_datevalue.xhp |4 source/text/scalc/01/func_day.xhp |4 source/text/scalc/01/func_days.xhp|4 source/text/scalc/01/func_days360.xhp |4 source/text/scalc/01/func_eastersunday.xhp|4 source/text/scalc/01/func_edate.xhp |4 source/text/scalc/01/func_eomonth.xhp |4 source/text/scalc/01/func_error_type.xhp |4 source/text/scalc/01/func_forecastetsadd.xhp |2 source/text/scalc/01/func_forecastetsmult.xhp |2 source/text/scalc/01/func_forecastetspiadd.xhp|2 source/text/scalc/01/func_forecastetspimult.xhp |2 source/text/scalc/01/func_forecastetsseason.xhp |2 source/text/scalc/01/func_forecastetsstatadd.xhp |2 source/text/scalc/01/func_forecastetsstatmult.xhp |2 source/text/scalc/01/func_hour.xhp|4 source/text/scalc/01/func_isoweeknum.xhp |4 source/text/scalc/01/func_maxifs.xhp |2 source/text/scalc/01/func_minifs.xhp |2 source/text/scalc/01/func_minute.xhp |4 source/text/scalc/01/func_month.xhp |4 source/text/scalc/01/func_networkdays.intl.xhp|4 source/text/scalc/01/func_networkdays.xhp |4 source/text/scalc/01/func_now.xhp |4 source/text/scalc/01/func_numbervalue.xhp |4 source/text/scalc/01/func_second.xhp |4 source/text/scalc/01/func_sumifs.xhp |2 source/text/scalc/01/func_time.xhp|4 source/text/scalc/01/func_timevalue.xhp |4 source/text/scalc/01/func_today.xhp |4 source/text/scalc/01/func_webservice.xhp | 12 source/text/scalc/01/func_weekday.xhp |4 source/text/scalc/01/func_weeknum.xhp |4 source/text/scalc/01/func_weeknum_ooo.xhp |4 source/text/scalc/01/func_weeknumadd.xhp |4 source/text/scalc/01/func_workday.intl.xhp|4 source/text/scalc/01/func_workday.xhp |4 source/text/scalc/01/func_year.xhp|4 source/text/scalc/01/func_yearfrac.xhp|4 source/text/scalc/01/stat_data.xhp|8 source/text/scalc/01/statistics.xhp |2 71 files changed, 956 insertions(+), 930 deletions(-) New commits: commit b358fb9b95915743d8666b238acb8e117c8751ce Author: Olivier Hallot AuthorDate: Sat Sep 29 15:26:04 2018 -0300 Commit: Olivier Hallot CommitDate: Tue Oct 2 08:54:16 2018 +0200 Reduce L10N workload for repetitive strings Change 'Syntax' and 'Examples' heading into an embedded string translated only once. Change-Id: Iac2eef8fedbaa4461aa2f941af7f065a3b16fb2d Reviewed-on: https://gerrit.libreoffice.org/61143 Tested-by: Jenkins Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 9daadf9a6..b04311c82 100644 ---
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |2 source/text/scalc/01/func_averageifs.xhp |2 source/text/scalc/01/func_countifs.xhp |2 source/text/scalc/01/func_maxifs.xhp | 70 +++ source/text/scalc/01/func_minifs.xhp | 70 +++ source/text/scalc/01/func_sumifs.xhp |2 6 files changed, 145 insertions(+), 3 deletions(-) New commits: commit a25c0c5dc1b55a7c4d9338843676dafdf98d86ed Author: Olivier Hallot Date: Thu May 31 15:11:59 2018 -0300 tdf#117933 help pages for MAXIFS,MINIFS Change-Id: Ib0b27e4f00468b33a9a112ac0dc0967750570b18 Reviewed-on: https://gerrit.libreoffice.org/55143 Tested-by: Jenkins Reviewed-by: Sophia Schröder Reviewed-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index ad9218de2..eba3ef23b 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -219,6 +219,8 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_imsinh \ helpcontent2/source/text/scalc/01/func_imtan \ helpcontent2/source/text/scalc/01/func_isoweeknum \ +helpcontent2/source/text/scalc/01/func_maxifs \ +helpcontent2/source/text/scalc/01/func_minifs \ helpcontent2/source/text/scalc/01/func_minute \ helpcontent2/source/text/scalc/01/func_month \ helpcontent2/source/text/scalc/01/common_func_workdaysintl \ diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp index 749a8641e..a0a94c292 100644 --- a/source/text/scalc/01/func_averageifs.xhp +++ b/source/text/scalc/01/func_averageifs.xhp @@ -58,7 +58,7 @@ If the range of values for calculating the mean and any range for finding criter =AVERAGEIFS(C2:C6;A2:A6;E2".*";B2:B6;""MAX(B2:B6)) If E2 = pen, the function returns 65, because the link to the cell is substituted with its content. -AVERAGE, AVERAGEA, , , , MAX, MIN +AVERAGE, AVERAGEA, , , , , , MAX, MIN diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp index b5d10dc22..bb0280dc4 100644 --- a/source/text/scalc/01/func_countifs.xhp +++ b/source/text/scalc/01/func_countifs.xhp @@ -58,7 +58,7 @@ If ranges for arguments Range and Criterion have unequ =COUNTIFS(A2:A6;E2".*";B2:B6;""MAX(B2:B6)) If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above. -COUNT, COUNTIF, COUNTA, , , MAX, MIN +COUNT, COUNTIF, COUNTA, , , , , MAX, MIN diff --git a/source/text/scalc/01/func_maxifs.xhp b/source/text/scalc/01/func_maxifs.xhp new file mode 100644 index 0..238f9cfb4 --- /dev/null +++ b/source/text/scalc/01/func_maxifs.xhp @@ -0,0 +1,70 @@ + + + + + + +MAXIFS function +/text/scalc/01/func_maxifs.xhp + + + + + + + + MAXIFS function + maximum;satisfying conditions + +MAXIFS function +Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges. + + +Syntax +MAXIFS( Max_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2 [;...]]) + +Max_Range – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum. +Criterion_range1 – required argument. A range of cells, a named range or a label of a column or a row containing values for finding the corresponding criterion. +Criterion1 – required argument. A string expression of the conditon that defines what cells should be used to calculate the maximum. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options). +Criterion_range2 – Optional. Criterion_range2 and all the following mean the same as Criterion_range1. +Criterion2 – Optional. Criterion2 and all the following mean the same as Criterion1. +Max_Range and Criterion_range1, Criterion_range2... must have the same size, otherwise the function returns err:502 - Invalid argument. + +The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Max_Range is taken into calculation of the maximum. + +The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them. + + + +If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero). + + +In all examples below, ranges for maximum calculation contain the row #6, but it is ignored, because it contains text. + +Simple usage +=MAXIFS(B2:B6;B2:B6;"35") +Calculates the maximum of values of the range B2:B6 that are greater than or equal to 20. Returns 35. The fifth row does not meet the criterion. +=MAXIFS(C2:C6;B2:B6;"=20";C2:C6;"90") +Calculates the maximum of values of the range C2:C6 that are lower than 90
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/func_roundsig.xhp | 44 + 2 files changed, 45 insertions(+) New commits: commit 1c33fe883610dd1137593fb52d07b2535ad29748 Author: Olivier HallotDate: Tue Feb 20 17:37:11 2018 -0300 tdf#115440 Help page for ROUNDSIG function in Calc With contributions of j...@psilosoph.de and dh_twri...@mail.ru Change-Id: I8885edd02fbe240cf9c287d085ea84da041b51dc Reviewed-on: https://gerrit.libreoffice.org/50061 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index ffa8ac033..7af1131cb 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -228,6 +228,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_numbervalue \ helpcontent2/source/text/scalc/01/func_now \ helpcontent2/source/text/scalc/01/func_rawsubtract \ +helpcontent2/source/text/scalc/01/func_roundsig \ helpcontent2/source/text/scalc/01/func_second \ helpcontent2/source/text/scalc/01/func_skewp \ helpcontent2/source/text/scalc/01/func_sumifs \ diff --git a/source/text/scalc/01/func_roundsig.xhp b/source/text/scalc/01/func_roundsig.xhp new file mode 100644 index 0..574db4cf5 --- /dev/null +++ b/source/text/scalc/01/func_roundsig.xhp @@ -0,0 +1,44 @@ + + + + + +ROUNDSIG Function +/text/scalc/01/func_roundsig.xhp + + + + + + +ROUNDSIG Function + +ROUNDSIG +Returns a number rounded to a specified number of significant decimal digits of its normalized floating point notation. + + +ROUNDSIG( Value; Digits ) +Value: the number to be rounded. +Digits: the number of decimal places to round. + +Digits must be an integer greater than 0. + + + +=ROUNDSIG(123.456789; 5) returns 123.46. +=ROUNDSIG(0.000123456789; 5) returns 1.2346E-4 +=ROUNDSIG(123456789012345; 2) returns 1.2E13 +=ROUNDSIG(123456789; 4) returns 12350 or 123.5E6 + +See also ROUND, MROUND, ROUNDUP, ROUNDDOWN. + + + + ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/data_provider.xhp | 53 + 2 files changed, 54 insertions(+) New commits: commit 52ba0e435c17651f788021b74567c52e5c2b926f Author: Olivier HallotDate: Sun Sep 24 15:19:57 2017 -0300 Placeholder for Calc 'data provider' help page Change-Id: I3238c9b6e02486289463990e17ed3c59ca856b06 Reviewed-on: https://gerrit.libreoffice.org/42717 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 5c2dd189e..ffa8ac033 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -180,6 +180,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/12120200 \ helpcontent2/source/text/scalc/01/12120300 \ helpcontent2/source/text/scalc/01/data_form \ +helpcontent2/source/text/scalc/01/data_provider \ helpcontent2/source/text/scalc/01/ex_data_stat_func \ helpcontent2/source/text/scalc/01/format_graphic \ helpcontent2/source/text/scalc/01/ful_func \ diff --git a/source/text/scalc/01/data_provider.xhp b/source/text/scalc/01/data_provider.xhp new file mode 100644 index 0..60922c45d --- /dev/null +++ b/source/text/scalc/01/data_provider.xhp @@ -0,0 +1,53 @@ + + + + + + +Data Provider for Spreadsheet +/text/scalc/01/data_provider.xhp + + + + + + + + + + data provider;for spreadsheets + + + +Data Provider for Spreadsheets +Data Provider for Spreadsheets + + + + +Menu Data â Data Provider... + + + + +Data Provider + + + + ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/data_form.xhp | 56 + 2 files changed, 57 insertions(+) New commits: commit bba68b1547105a25f16b752fd3035f51c1ed3625 Author: Olivier HallotDate: Sun Sep 24 12:39:32 2017 -0300 Placeholder for Calc 'data form' help page Change-Id: I134c0f9148854c23a1252bbcb2d85b43b3654dd2 Reviewed-on: https://gerrit.libreoffice.org/42711 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 7de32b6aa..5c2dd189e 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -179,6 +179,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/12120100 \ helpcontent2/source/text/scalc/01/12120200 \ helpcontent2/source/text/scalc/01/12120300 \ +helpcontent2/source/text/scalc/01/data_form \ helpcontent2/source/text/scalc/01/ex_data_stat_func \ helpcontent2/source/text/scalc/01/format_graphic \ helpcontent2/source/text/scalc/01/ful_func \ diff --git a/source/text/scalc/01/data_form.xhp b/source/text/scalc/01/data_form.xhp new file mode 100644 index 0..edf69ed9e --- /dev/null +++ b/source/text/scalc/01/data_form.xhp @@ -0,0 +1,56 @@ + + + + + + +Data Form for Spreadsheet +/text/scalc/01/data_form.xhp + + + + + + + + + + data forms;for spreadsheets + data forms;insert data in spreadsheets + insert data;data forms for spreadsheets + spreadsheet;form to insert data + + + +Data Forms for Spreasheets +Data Forms for Spreasheets + + + + +Menu Data â Form... + + + + +Form + + + + ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |2 +- source/text/scalc/01/04060102.xhp |2 +- source/text/scalc/01/func_networkdays.intl.xhp |4 ++-- source/text/scalc/01/func_networkdays.xhp |4 ++-- source/text/scalc/01/func_workday.intl.xhp |4 ++-- source/text/scalc/01/func_workday.xhp |2 +- 6 files changed, 9 insertions(+), 9 deletions(-) New commits: commit 4af60691995a58d513552e5e14677f680827e155 Author: Olivier HallotDate: Sat Apr 22 18:43:48 2017 -0300 Correct WOKDAYS.INTL -> WORKDAY.INTL Unit #117795772 from pootle Change-Id: Iced6c310194bbfa63d8607abd5002f7656de87e0 Reviewed-on: https://gerrit.libreoffice.org/36821 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index f857bb52c..6e1c0502f 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -222,7 +222,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/common_func_workdaysintl \ helpcontent2/source/text/scalc/01/func_networkdays \ helpcontent2/source/text/scalc/01/func_networkdays.intl \ -helpcontent2/source/text/scalc/01/func_workdays.intl \ +helpcontent2/source/text/scalc/01/func_workday.intl \ helpcontent2/source/text/scalc/01/func_numbervalue \ helpcontent2/source/text/scalc/01/func_now \ helpcontent2/source/text/scalc/01/func_rawsubtract \ diff --git a/source/text/scalc/01/04060102.xhp b/source/text/scalc/01/04060102.xhp index e99aa7b31..66cd568d5 100644 --- a/source/text/scalc/01/04060102.xhp +++ b/source/text/scalc/01/04060102.xhp @@ -169,7 +169,7 @@ - + diff --git a/source/text/scalc/01/func_networkdays.intl.xhp b/source/text/scalc/01/func_networkdays.intl.xhp index 11fbf61f3..69cff76c8 100644 --- a/source/text/scalc/01/func_networkdays.intl.xhp +++ b/source/text/scalc/01/func_networkdays.intl.xhp @@ -56,10 +56,10 @@ NETWORKDAYS -WORKDAYS.INTL +WORKDAY.INTL WORKDAYS Date functions - \ No newline at end of file + diff --git a/source/text/scalc/01/func_networkdays.xhp b/source/text/scalc/01/func_networkdays.xhp index e5f4d201f..b87f796fe 100644 --- a/source/text/scalc/01/func_networkdays.xhp +++ b/source/text/scalc/01/func_networkdays.xhp @@ -50,10 +50,10 @@ =NETWORKDAYS(DATE(2016;9;12); DATE(2016;9;25); ; {1;0;0;0;1;1;1}) returns 6 workdays. NETWORKDAYS.INTL -WORKDAYS.INTL +WORKDAY.INTL WORKDAYS Date functions - \ No newline at end of file + diff --git a/source/text/scalc/01/func_workdays.intl.xhp b/source/text/scalc/01/func_workday.intl.xhp similarity index 97% rename from source/text/scalc/01/func_workdays.intl.xhp rename to source/text/scalc/01/func_workday.intl.xhp index c27256dae..855cc68dc 100644 --- a/source/text/scalc/01/func_workdays.intl.xhp +++ b/source/text/scalc/01/func_workday.intl.xhp @@ -21,7 +21,7 @@ WORKDAY.INTL -/text/scalc/01/func_workdays.intl.xhp +/text/scalc/01/func_workday.intl.xhp @@ -35,7 +35,7 @@ -WORKDAY.INTL +WORKDAY.INTL The result is a date number that can be formatted as a date. User can see the date of a day that is a certain number of workdays away from the start date (before or after). There are options to define weekend days and holidays. The optional weekend parameter (or a string) can be used to define the weekend days (or the non-working days in each week). Also, optionally, the user can define a holiday list. The weekend days and user-defined holidays are not counted as working days. diff --git a/source/text/scalc/01/func_workday.xhp b/source/text/scalc/01/func_workday.xhp index 93be30a7e..15224c15c 100644 --- a/source/text/scalc/01/func_workday.xhp +++ b/source/text/scalc/01/func_workday.xhp @@ -48,7 +48,7 @@ NETWORKDAYS NETWORKDAYS.INTL -WORKDAYS.INTL +WORKDAY.INTL Date functions ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/00/0406.xhp| 96 +--- source/text/scalc/01/0699.xhp| 46 --- source/text/scalc/guide/auto_off.xhp | 104 ++- source/text/scalc/main0106.xhp | 46 --- 5 files changed, 119 insertions(+), 174 deletions(-) New commits: commit 8291b5b5f748af4eeb68797193e9c84d11ecbda5 Author: Olivier HallotDate: Thu Mar 30 14:13:33 2017 -0300 tdf#106861 - fix Autoinput entry in menu, plus - Reorder Calc tools menu help page - Remove ref to "Cell contents" - Move Recalculate to Data menu Change-Id: Id6165db40a99316eae9768955b6cdbb9d5f05afb Reviewed-on: https://gerrit.libreoffice.org/35922 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 625811584..f857bb52c 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -135,7 +135,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/0607 \ helpcontent2/source/text/scalc/01/0608 \ helpcontent2/source/text/scalc/01/0613 \ -helpcontent2/source/text/scalc/01/0699 \ helpcontent2/source/text/scalc/01/0708 \ helpcontent2/source/text/scalc/01/0709 \ helpcontent2/source/text/scalc/01/1201 \ diff --git a/source/text/scalc/00/0406.xhp b/source/text/scalc/00/0406.xhp index e2c0436e8..8b3de9116 100644 --- a/source/text/scalc/00/0406.xhp +++ b/source/text/scalc/00/0406.xhp @@ -1,7 +1,5 @@ - - - + +--> - - - -Tools Menu -/text/scalc/00/0406.xhp - + +Tools Menu +/text/scalc/00/0406.xhp + + -Tools Menu -Choose Tools - Detective - + + +Tools Menu +Choose Tools - Detective + -Choose Tools - Detective - Trace Precedents - -Shift+F7 +Choose Tools - Detective - Trace Precedents +Shift+F7 -Menu Tools - Language - Hyphenation - -Choose Tools - Detective - Remove Precedents - +Menu Tools - Language - Hyphenation +Choose Tools - Detective - Remove Precedents + -Choose Tools - Detective - Trace Dependents - -Shift+F5 +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, Options button - -Choose Tools - Scenarios - -Choose Tools - Protect Sheet -Choose Tools - Protect Spreadsheet -Choose Tools - Cell Contents - +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, Options button +Choose Tools - Scenarios +Choose Tools - Protect Sheet +Choose Tools - Protect Spreadsheet + -Choose Tools - Cell Contents - Recalculate - -F9 +Choose Data - Calculate - Recalculate +F9 -Choose Data - Calculate - AutoCalculate - -Choose Tools - Cell Contents - AutoInput - +Choose Data - Calculate - AutoCalculate +Choose Tools - AutoInput - + + \ No newline at end of file diff --git a/source/text/scalc/01/0699.xhp b/source/text/scalc/01/0699.xhp deleted file mode 100644 index b91383f40..0 --- a/source/text/scalc/01/0699.xhp +++ /dev/null @@ -1,46 +0,0 @@ - - - - - - - - -Cell Contents -/text/scalc/01/0699.xhp - - -Sun Microsystems, Inc. - - - - - - - Cell Contents - Opens a submenu with commands to calculate tables and activate AutoInput. - - - - - - - - - diff --git a/source/text/scalc/guide/auto_off.xhp b/source/text/scalc/guide/auto_off.xhp index dbc58cda3..7ac4ebcaa 100644 --- a/source/text/scalc/guide/auto_off.xhp +++ b/source/text/scalc/guide/auto_off.xhp @@ -1,6 +1,5 @@ - - +--> - - Deactivating Automatic Changes - /text/scalc/guide/auto_off.xhp - - - -deactivating; automatic changes - tables; deactivating automatic changes in - AutoInput function on/off - text in cells;AutoInput function - cells; AutoInput function of text - input support in spreadsheets - changing; input in cells - AutoCorrect function;cell contents - cell input;AutoInput function - lowercase letters;AutoInput function (in cells) - capital letters;AutoInput function (in cells) - date formats;avoiding conversion
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/04060106.xhp |4 +++ source/text/scalc/01/func_rawsubtract.xhp | 34 ++ 3 files changed, 39 insertions(+) New commits: commit 75c62b4a8207e56c9998429a07760350badc9ded Author: liongoldDate: Mon Nov 21 20:43:37 2016 + tdf#101140 Adding Help for RAWSUBTRACT function Change-Id: I8eba1c661a31766a5fd84489e4a7db46d5570f73 Reviewed-on: https://gerrit.libreoffice.org/31086 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index e9cb083..6258115 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -226,6 +226,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_workdays.intl \ helpcontent2/source/text/scalc/01/func_numbervalue \ helpcontent2/source/text/scalc/01/func_now \ +helpcontent2/source/text/scalc/01/func_rawsubtract \ helpcontent2/source/text/scalc/01/func_second \ helpcontent2/source/text/scalc/01/func_skewp \ helpcontent2/source/text/scalc/01/func_sumifs \ diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 93f9f27..eb746e3 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -912,6 +912,10 @@ =RADIANS(90) returns 1.5707963267949, which is PI/2 to Calc's accuracy.see also DEGREES + + + + ROUND function diff --git a/source/text/scalc/01/func_rawsubtract.xhp b/source/text/scalc/01/func_rawsubtract.xhp new file mode 100644 index 000..eb6935a --- /dev/null +++ b/source/text/scalc/01/func_rawsubtract.xhp @@ -0,0 +1,34 @@ + + + + + +RAWSUBTRACT function +text/scalc/01/func_rawsubtract.xhp + + + + + + +rawsubtract;subtraction +RAWSUBTRACT function + +RAWSUBTRACT +Subtracts a set of numbers and gives the result without eliminating small roundoff errors. + +RAWSUBTRACT(Minuend, Subtrahend1, Subtrahend2, ...) +Subtracts the subtrahend(s) from the minuend without eliminating roundoff errors. The function should be called with at least two parameters. + +RAWSUBTRACT(0.987654321098765, 0.9876543210987) returns 6.53921361504217E-14 +RAWSUBTRACT(0.987654321098765) returns Err:511 (Missing variable) because RAWSUBTRACT requires a minimum of two numbers. + + + \ No newline at end of file ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |8 source/text/scalc/01/04060185.xhp | 22 + source/text/scalc/01/exponsmooth_embd.xhp | 386 ++ source/text/scalc/01/func_forecastetsadd.xhp | 62 +++ source/text/scalc/01/func_forecastetsmult.xhp | 63 +++ source/text/scalc/01/func_forecastetspiadd.xhp| 66 +++ source/text/scalc/01/func_forecastetspimult.xhp | 66 +++ source/text/scalc/01/func_forecastetsseason.xhp | 58 +++ source/text/scalc/01/func_forecastetsstatadd.xhp | 64 +++ source/text/scalc/01/func_forecastetsstatmult.xhp | 63 +++ 10 files changed, 858 insertions(+) New commits: commit 9dc3878117e8d2c4e6e6cf09b41fb2e06867a477 Author: Olivier HallotDate: Tue Mar 8 11:28:49 2016 -0300 tdf#97021 Help pages for FORECAST.ETS functions Write help page for FORECAST.ETS.* Calc functions Change-Id: I4fc3a0f18bb09e033b011206c41bec841e0d01f5 Reviewed-on: https://gerrit.libreoffice.org/23093 Reviewed-by: Caolán McNamara Tested-by: Caolán McNamara diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 9b480ea..4574dfc 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -198,6 +198,14 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_edate \ helpcontent2/source/text/scalc/01/func_eomonth \ helpcontent2/source/text/scalc/01/func_error_type \ +helpcontent2/source/text/scalc/01/func_forecastetsadd \ +helpcontent2/source/text/scalc/01/func_forecastetsmult \ +helpcontent2/source/text/scalc/01/func_forecastetsstatadd \ +helpcontent2/source/text/scalc/01/func_forecastetsstatmult \ +helpcontent2/source/text/scalc/01/func_forecastetspiadd \ +helpcontent2/source/text/scalc/01/func_forecastetspimult \ +helpcontent2/source/text/scalc/01/func_forecastetsseason \ +helpcontent2/source/text/scalc/01/exponsmooth_embd \ helpcontent2/source/text/scalc/01/func_hour \ helpcontent2/source/text/scalc/01/func_imcot \ helpcontent2/source/text/scalc/01/func_imcos \ diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 7926cbf..bb83598 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -133,6 +133,28 @@ =FORECAST(50;A1:A50;B1;B50) returns the Y value expected for the X value of 50 if the X and Y values in both references are linked by a linear trend. + +regression lines;FORECAST.LINEAR function + extrapolations + FORECAST.LINEAR function + + +FORECAST.LINEAR + Extrapolates future values based on existing x and y values. + Syntax + FORECAST(Value; DataY; DataX) + +Value is the x value, for which the y value on the linear regression is to be returned. + +DataY is the array or range of known y's. + +DataX is the array or range of known x's. + Example + +=FORECAST.LINEAR(50;A1:A50;B1;B50) returns the Y value expected for the X value of 50 if the X and Y values in both references are linked by a linear trend. + STDEV function standard deviations in statistics;based on a sample diff --git a/source/text/scalc/01/exponsmooth_embd.xhp b/source/text/scalc/01/exponsmooth_embd.xhp new file mode 100644 index 000..ecb8389 --- /dev/null +++ b/source/text/scalc/01/exponsmooth_embd.xhp @@ -0,0 +1,386 @@ + + + + + + +embeded text for exponential smoothing +/text/scalc/01/exponsmooth_embd.xhp + + + + + Exponential Smoothing is a method to smooth real values in time series in order to forecast probable future values. + +Exponential Triple Smoothing (ETS) is a set of algorithms in which both trend and periodical (seasonal) influences are processed. Exponential Double Smoothing (EDS) is an algorithm like ETS, but without the periodical influences. EDS produces linear forecasts. + +See the http://en.wikipedia.org/wiki/Exponential_smoothing;>Wikipedia on Exponential smoothing algorithms for more information. + + + +target (mandatory): A date, time or numeric single value or range. The data point/range for which to calculate a forecast. + + + +values (mandatory): A numeric array or range. values are the historical values, for which you want to forecast the next points. + + + +timeline (mandatory): A numeric array or range. The time line (x-value) range for the historical values. +The time line doesn't have to to be sorted, the functions will sort it for calculations. The time line values must have a consistent step between them. If a constant step can't be identified in the sorted time line, the functions will return the #NUM! error. If the ranges of the time line and historical values aren't of same size, the functions will return
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/00/0404.xhp |4 -- source/text/scalc/00/sheet_menu.xhp | 38 ++ source/text/scalc/01/0403.xhp | 60 ++-- source/text/scalc/01/0404.xhp | 52 --- source/text/scalc/main0104.xhp |2 - source/text/scalc/main0116.xhp |5 +++ 7 files changed, 116 insertions(+), 46 deletions(-) New commits: commit fd91f34b3106eea47e8378a672d5a42fe2920b00 Author: Stanislav HoracekDate: Tue Feb 16 22:31:53 2016 +0100 tdf#97807 Calc menu changes for inserting rows and columns Change-Id: I7eda4072001961c19ff6f502b71d76ac989f634a Reviewed-on: https://gerrit.libreoffice.org/22405 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index bf50e99..9b480ea 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -25,6 +25,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/00/0406 \ helpcontent2/source/text/scalc/00/0407 \ helpcontent2/source/text/scalc/00/0412 \ +helpcontent2/source/text/scalc/00/sheet_menu \ helpcontent2/source/text/scalc/01/0112 \ helpcontent2/source/text/scalc/01/0211 \ helpcontent2/source/text/scalc/01/0212 \ diff --git a/source/text/scalc/00/0404.xhp b/source/text/scalc/00/0404.xhp index dfa6bc6..f1d8673 100644 --- a/source/text/scalc/00/0404.xhp +++ b/source/text/scalc/00/0404.xhp @@ -119,10 +119,6 @@ -Choose Insert - Rows - -Choose Insert - Columns - Choose Insert - Sheet Choose Insert - Sheet from file diff --git a/source/text/scalc/00/sheet_menu.xhp b/source/text/scalc/00/sheet_menu.xhp new file mode 100644 index 000..7095e4d --- /dev/null +++ b/source/text/scalc/00/sheet_menu.xhp @@ -0,0 +1,38 @@ + + + + + + +Sheet Menu +/scalc/00/sheet_menu.xhp + + + + + + +Sheet Menu +Choose Sheet - Insert Rows - Rows Above +Choose Sheet - Insert Rows - Rows Below +Choose Sheet - Insert Columns - Columns Left +Choose Sheet - Insert Columns - Columns Right + + + \ No newline at end of file diff --git a/source/text/scalc/01/0403.xhp b/source/text/scalc/01/0403.xhp index a73c58f..25e153b 100644 --- a/source/text/scalc/01/0403.xhp +++ b/source/text/scalc/01/0403.xhp @@ -1,6 +1,5 @@ - - + +--> - - -Rows -/text/scalc/01/0403.xhp - - -Sun Microsystems, Inc. - + +Insert Rows +/text/scalc/01/0403.xhp + + - - - - spreadsheets; inserting rowsrows; insertinginserting; rows -Rows - Inserts a new row above the active cell. The number of rows inserted correspond to the number of rows selected. The existing rows are moved downward. - - - + + + + spreadsheets; inserting rows + rows; inserting + inserting; rows + + + + + + + +Insert Rows +Insert rows above or below the active cell. The number of rows inserted corresponds to the number of rows selected. If no row is selected, one row is inserted. The existing rows are moved downward. + +Rows Above +Inserts a new row above the active cell. + + + - - + +Rows Below +Inserts a new row below the active cell. + + + + + + + \ No newline at end of file diff --git a/source/text/scalc/01/0404.xhp b/source/text/scalc/01/0404.xhp index d4de739..721f658 100644 --- a/source/text/scalc/01/0404.xhp +++ b/source/text/scalc/01/0404.xhp @@ -1,6 +1,5 @@ - - - +--> + - -Columns -/text/scalc/01/0404.xhp - + +Insert Columns +/text/scalc/01/0404.xhp + + - -spreadsheets; inserting columns -inserting; columns -columns; inserting + + + + spreadsheets; inserting columns + inserting; columns + columns; inserting - - -Columns -Inserts a new column to the left of the active cell. The number of columns inserted corresponds to the number of columns selected. The existing columns are moved to the right. + + + + + + +Insert Columns +Inserts columns to the left or to the right of the active cell. The number of columns inserted corresponds to the number of columns selected. If no column is selected, one column is inserted. The existing columns are moved to the right. + +Columns Left +Inserts a new column to the left of the active cell. + + + + +Columns Right +Inserts a new column to the right of the active cell. + - + - + + \ No newline at end of file diff --git a/source/text/scalc/main0104.xhp b/source/text/scalc/main0104.xhp index 96a0e56..59c46c0 100644 --- a/source/text/scalc/main0104.xhp +++ b/source/text/scalc/main0104.xhp @@ -38,8 +38,6 @@ Cells - - Sheet diff --git a/source/text/scalc/main0116.xhp b/source/text/scalc/main0116.xhp index edcd8c9..8d739d9 100644 --- a/source/text/scalc/main0116.xhp +++ b/source/text/scalc/main0116.xhp @@ -34,6
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/01/04060185.xhp |4 ++ source/text/scalc/01/func_skewp.xhp | 53 3 files changed, 58 insertions(+) New commits: commit 8259390d2d978d37dc73e8e2cb0f1fcd0299afdf Author: Olivier HallotDate: Fri Feb 12 14:41:48 2016 -0200 tdf#95281 Help page for the SKEWP function Write help page for SKEWP spreadsheet function Change-Id: Ib7fc372bc2be4c55663a6ab58f488aa204631d20 Reviewed-on: https://gerrit.libreoffice.org/22322 Reviewed-by: David Tardon Tested-by: David Tardon diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 2d8f35a..bf50e99 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -215,6 +215,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_numbervalue \ helpcontent2/source/text/scalc/01/func_now \ helpcontent2/source/text/scalc/01/func_second \ +helpcontent2/source/text/scalc/01/func_skewp \ helpcontent2/source/text/scalc/01/func_sumifs \ helpcontent2/source/text/scalc/01/func_time \ helpcontent2/source/text/scalc/01/func_timevalue \ diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp index 856665d..7926cbf 100644 --- a/source/text/scalc/01/04060185.xhp +++ b/source/text/scalc/01/04060185.xhp @@ -106,6 +106,10 @@ =SKEW(A1:A50) calculates the value of skew for the data referenced. + + + + regression lines;FORECAST function extrapolations diff --git a/source/text/scalc/01/func_skewp.xhp b/source/text/scalc/01/func_skewp.xhp new file mode 100644 index 000..8f2a833 --- /dev/null +++ b/source/text/scalc/01/func_skewp.xhp @@ -0,0 +1,53 @@ + + + + + + +SKEWP function +text/scalc/01/func_skewp.xhp + + + + + + + skewness;population + SKEWP function + +SKEWP +Calculates the skewness of a distribution using the population of a random variable. + +SKEWP(Number1; Number2;..., Number30) +Number1, Number2, ..., Number30 are up to 30 numerical values or ranges. +Calculates the skewness of a distribution using the population, i.e. the possible outcomes, of a random variable. The sequence shall contain three numbers at least. + + +SKEWP(2;3;1;6;8;5) returns 0.2828158928 + +SKEWP(A1:A6) returns 0.2828158928, when the range A1:A6 contains {2;3;1;6;8;5} +SKEWP(Number1;Number2) returns zero allways, if Number1 and Number2 results in two numbers. +SKEWP(Number1) returns Err:502 (Invalid argument) if Number1 results in one number, because SKEWP cannot be calculated with one value. + + + +SKEW + + + \ No newline at end of file ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/01/04060106.xhp |4 ++ source/text/scalc/01/func_color.xhp | 49 3 files changed, 54 insertions(+) New commits: commit e53a0d788c6a34d9375e33adc2e9946e2348ad23 Author: Olivier HallotDate: Thu Feb 11 19:42:16 2016 -0200 tdf#95282 Help page for the COLOR function Write help page for COLOR spreadsheet functions Change-Id: I2a34cb2b1f25f3d0013a93dff320b70d76a1f4d6 Reviewed-on: https://gerrit.libreoffice.org/22300 Reviewed-by: David Tardon Tested-by: David Tardon diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 02b5688..2d8f35a 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -186,6 +186,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_averageif \ helpcontent2/source/text/scalc/01/func_averageifs \ helpcontent2/source/text/scalc/01/func_countifs \ +helpcontent2/source/text/scalc/01/func_color \ helpcontent2/source/text/scalc/01/func_date \ helpcontent2/source/text/scalc/01/func_datedif \ helpcontent2/source/text/scalc/01/func_datevalue \ diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 7860d0a..35112f1 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1108,6 +1108,10 @@ See COUNTIF() for some more syntax examples that can be used with SUMIF(). + + + + diff --git a/source/text/scalc/01/func_color.xhp b/source/text/scalc/01/func_color.xhp new file mode 100644 index 000..978b42f --- /dev/null +++ b/source/text/scalc/01/func_color.xhp @@ -0,0 +1,49 @@ + + + + + + +COLOR function +text/scalc/01/func_color.xhp + + + + + + + Color;numerical value + Color;calculating in spreadsheet + COLOR function + +COLOR +Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system.The result depends on the color system used by your computer. + +COLOR(Red; Green; Blue; Alpha) +Red, Green and Blue â required arguments. The value for the red, green and blue components of the color. The values must be between 0 and 255. Zero means no color component and 255 means full color component. +Alpha â optional argument. The value for the alpha channel or alpha composite. Alpha is a integer value between 0 and 255. The value of zero for alpha means the color is fully transparent, whereas a value of 255 in the alpha channel gives a fully opaque color. + +COLOR(255;255;255;1) returns 33554431 +COLOR(0;0;255;0) returns 255 +COLOR(0;0;255;255) returns 4278190335 +COLOR(0;0;400;0) returns Err:502 (Invalid argument) because the blue value is greater than 255. + + + + \ No newline at end of file ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/stat_data.xhp | 1184 ++--- source/text/scalc/01/statistics.xhp|3 source/text/scalc/01/statistics_regression.xhp | 327 ++ 4 files changed, 997 insertions(+), 518 deletions(-) New commits: commit df2eefa2ce5e5db43df453ba1c2fb52abb88e08e Author: Olivier HallotDate: Thu Jan 21 18:49:23 2016 -0200 tdf#96868 Help page for data statistics regression Change-Id: I7c0e236c1d19572b682d5b6c120ce604f6e39de8 Reviewed-on: https://gerrit.libreoffice.org/22144 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index efce395..02b5688 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -229,6 +229,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/solver \ helpcontent2/source/text/scalc/01/solver_options \ helpcontent2/source/text/scalc/01/statistics \ +helpcontent2/source/text/scalc/01/statistics_regression \ helpcontent2/source/text/scalc/01/stat_data \ helpcontent2/source/text/scalc/01/ODFF \ helpcontent2/source/text/scalc/01/text2columns \ diff --git a/source/text/scalc/01/stat_data.xhp b/source/text/scalc/01/stat_data.xhp index 31e5611..f11b62c 100644 --- a/source/text/scalc/01/stat_data.xhp +++ b/source/text/scalc/01/stat_data.xhp @@ -1,4 +1,4 @@ - + +--> - -Data -/text/scalc/01/stat_data.xhp - + +Data +/text/scalc/01/stat_data.xhp + + + + -Data + +Data Input Range: The reference of the range of the data to analyze. Results to: The reference of the top left cell of the range where the results will be displayed. + -Grouped By + +Grouped By Select whether the input data has columns or rows layout. + -Example + +Example The following data will be used as example + - - - - -A - - -B - - -C - - - - -1 - - -Maths - - -Physics - - -Biology - - - - -2 - - -47 - - -67 - - -33 - - - - -3 - - -36 - - -68 - - -42 - - - - -4 - - -40 - - -65 - - -44 - - - - -5 - - -39 - - -64 - - -60 - - - - -6 - - - - -38 - - -43 - - - - -7 - - -47 - - -84 - - -62 - - - - -8 - - -29 - - -80 - - -51 - - - - -9 - - -27 - - -49 - - -40 - - - - -10 - - -57 - - -49 - - -12 - - - - -11 - - -56 - - -33 - - -60 - - - - -12 - - -57 - - - - - - - - -13 - - -26 - - - - - - + + + + + A + + + B + + + C + + + + + 1 + + + Maths + + + Physics + + + Biology + + + + + 2 + + + 47 + + + 67 + + + 33 + + + + + 3 + + + 36 + + + 68 + + + 42 + + + + + 4 + + + 40 + + + 65 + + + 44 + + + + + 5 + + + 39 + + + 64 + + + 60 + + + + + 6 + + + + + 38 + + + 43 + + + + + 7 + + + 47 + + + 84 + + + 62 + + + + + 8 + + + 29 + + + 80 + + + 51 + + + + + 9 + + + 27 + + + 49 + + + 40 + + + + + 10 + + + 57 + + + 49 + + + 12 + + + + + 11 + + + 56 + + + 33 + + + 60 + + + + + 12 + + + 57 + + + + + + + + + 13 + + + 26 + + + + + + + + -Example + +Example The following table has two time series, one representing an impulse function at time t=0 and the other an impulse function at time t=2. + - - - - -A - - -B - - - - -1 - - -1 - - -0 - - - - -2 - - -0 - - -0 - - - - -3 - - -0 - - -1 - - - - -4 - - -0 - - -0 - - - - -5 - - -0 - - -0 - - - - -6 - - -0 - - -0 - - - - -7 - - -0 - - -0 - - - - -8 - - -0 - - -0 - - - - -9 - - -0 - - -0 - - - - -10 - - -0 - - -0 - - - - -11 - - -0 - - -0 - - - - -12 - - -0 - - -0 - - - - -13 - - -0 - - -0 - - + + + + + A + + + B + + + + + 1 + + + 1 + + + 0 + + + + + 2 + + + 0 + + + 0 + + + + + 3 + + + 0 + + + 1 + + + + + 4 + + + 0 + + + 0 + + + + + 5 + + + 0 + + + 0 + + + + + 6 + + + 0 + + + 0 + + + + + 7 + + + 0 + + + 0 + + + + + 8 + + + 0 + + + 0 + + + + + 9 + + + 0 + + + 0 +
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |2 + source/text/scalc/01/04060102.xhp | 12 ++- source/text/scalc/01/func_isoweeknum.xhp | 46 +++ source/text/scalc/01/func_weeknum.xhp | 29 - source/text/scalc/01/func_weeknum_ooo.xhp | 51 ++ source/text/scalc/01/func_weeknumadd.xhp | 14 6 files changed, 138 insertions(+), 16 deletions(-) New commits: commit 71a3f0e66fb6fb37f73fe3841a36ba00bec5beaa Author: Eike RathkeDate: Fri Jan 8 11:24:40 2016 +0100 tdf#85433 help content for WEEKNUM, ISOWEEKNUM, WEEKNUM_EXCEL2003, WEEKNUM_OOO Change-Id: I92995b4de6fe18d981757f0d273ddce5c11b1559 diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 975c527..efce395 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -207,6 +207,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_imsin \ helpcontent2/source/text/scalc/01/func_imsinh \ helpcontent2/source/text/scalc/01/func_imtan \ +helpcontent2/source/text/scalc/01/func_isoweeknum \ helpcontent2/source/text/scalc/01/func_minute \ helpcontent2/source/text/scalc/01/func_month \ helpcontent2/source/text/scalc/01/func_networkdays \ @@ -220,6 +221,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_weekday \ helpcontent2/source/text/scalc/01/func_webservice \ helpcontent2/source/text/scalc/01/func_weeknum \ +helpcontent2/source/text/scalc/01/func_weeknum_ooo \ helpcontent2/source/text/scalc/01/func_weeknumadd \ helpcontent2/source/text/scalc/01/func_workday \ helpcontent2/source/text/scalc/01/func_year \ diff --git a/source/text/scalc/01/04060102.xhp b/source/text/scalc/01/04060102.xhp index db41ffd..9ff462d 100644 --- a/source/text/scalc/01/04060102.xhp +++ b/source/text/scalc/01/04060102.xhp @@ -38,7 +38,7 @@ -The functions whose names end with _ADD return the same results as the corresponding Microsoft Excel functions. Use the functions without _ADD to get results based on international standards. For example, the WEEKNUM function calculates the week number of a given date based on international standard ISO 8601, while WEEKNUM_ADD returns the same week number as Microsoft Excel.UFI: see #33784# +The functions whose names end with _ADD or _EXCEL2003 return the same results as the corresponding Microsoft Excel 2003 functions without the suffix. Use the functions without suffix to get results based on international standards. $[officename] internally handles a date/time value as a numerical value. If you assign the numbering format "Number" to a date or time value, it is converted to a number. For example, 01/01/2000 12:00 PM, converts to 36526.5. The value preceding the decimal point corresponds to the date; the value following the decimal point corresponds to the time. If you do not want to see this type of numerical date or time representation, change the number format (date or time) accordingly. To do this, select the cell containing the date or time value, call its context menu and select Format Cells. The Numbers tab page contains the functions for defining the number format. Date base for day zero @@ -130,11 +130,21 @@ + + + + + + + + + + diff --git a/source/text/scalc/01/func_isoweeknum.xhp b/source/text/scalc/01/func_isoweeknum.xhp new file mode 100644 index 000..3e283be --- /dev/null +++ b/source/text/scalc/01/func_isoweeknum.xhp @@ -0,0 +1,46 @@ + + + + + + + + + + +ISOWEEKNUM +/text/scalc/01/func_isoweeknum.xhp + + + +ISOWEEKNUM function + +ISOWEEKNUM + +ISOWEEKNUM calculates the week number of the year for the internal date value. +The International Standard ISO 8601 has decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any year is the week that contains the January 4th. +Syntax +ISOWEEKNUM(Number) + +Number is the internal date number. +Examples +=ISOWEEKNUM(DATE(1995;1;1)) returns 52. Week 1 starts on Monday, 1995-01-02. +=ISOWEEKNUM(DATE(1999;1;1)) returns 53. Week 1 starts on Monday, 1999-01-04. + + diff --git a/source/text/scalc/01/func_weeknum.xhp b/source/text/scalc/01/func_weeknum.xhp index 58d1f93..a19848f 100644 --- a/source/text/scalc/01/func_weeknum.xhp +++ b/source/text/scalc/01/func_weeknum.xhp @@ -33,18 +33,31 @@ WEEKNUM -WEEKNUM calculates the week number of the year for the internal date value. -The International Standard ISO 8601 has decreed that Monday shall be the first day of the week. A week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie. That means that week number 1 of any
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk | 11 +++ source/text/scalc/01/04060116.xhp| 110 +-- source/text/scalc/01/ODFF.xhp|2 source/text/scalc/01/ful_func.xhp| 67 + source/text/scalc/01/func_imcos.xhp | 76 source/text/scalc/01/func_imcosh.xhp | 76 source/text/scalc/01/func_imcot.xhp | 78 source/text/scalc/01/func_imcsc.xhp | 80 + source/text/scalc/01/func_imcsch.xhp | 80 + source/text/scalc/01/func_imsec.xhp | 80 + source/text/scalc/01/func_imsech.xhp | 80 + source/text/scalc/01/func_imsin.xhp | 76 source/text/scalc/01/func_imsinh.xhp | 77 source/text/scalc/01/func_imtan.xhp | 78 14 files changed, 940 insertions(+), 31 deletions(-) New commits: commit 5d7d8ae940137262e8fd575a2214bf0baf0e9c1f Author: tageziDate: Fri Oct 23 00:59:22 2015 +0300 A description of trigonometric function IM* In ODFF a phrase was rewrote in func_imsec.xhp and func_imsinh.xhp typos are corrected in AllLangHelp_scalc.mk typo is correctedo Change-Id: Ieecb11deae5a8b1da56cdaadc9f75ef08b211e3c Reviewed-on: https://gerrit.libreoffice.org/19429 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 09735b8..975c527 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -181,6 +181,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/12120300 \ helpcontent2/source/text/scalc/01/ex_data_stat_func \ helpcontent2/source/text/scalc/01/format_graphic \ +helpcontent2/source/text/scalc/01/ful_func \ helpcontent2/source/text/scalc/01/func_aggregate \ helpcontent2/source/text/scalc/01/func_averageif \ helpcontent2/source/text/scalc/01/func_averageifs \ @@ -196,6 +197,16 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_eomonth \ helpcontent2/source/text/scalc/01/func_error_type \ helpcontent2/source/text/scalc/01/func_hour \ +helpcontent2/source/text/scalc/01/func_imcot \ +helpcontent2/source/text/scalc/01/func_imcos \ +helpcontent2/source/text/scalc/01/func_imcosh \ +helpcontent2/source/text/scalc/01/func_imcsc \ +helpcontent2/source/text/scalc/01/func_imcsch \ +helpcontent2/source/text/scalc/01/func_imsec \ +helpcontent2/source/text/scalc/01/func_imsech \ +helpcontent2/source/text/scalc/01/func_imsin \ +helpcontent2/source/text/scalc/01/func_imsinh \ +helpcontent2/source/text/scalc/01/func_imtan \ helpcontent2/source/text/scalc/01/func_minute \ helpcontent2/source/text/scalc/01/func_month \ helpcontent2/source/text/scalc/01/func_networkdays \ diff --git a/source/text/scalc/01/04060116.xhp b/source/text/scalc/01/04060116.xhp index 92448cf..0a9872e 100644 --- a/source/text/scalc/01/04060116.xhp +++ b/source/text/scalc/01/04060116.xhp @@ -105,21 +105,46 @@ =IMARGUMENT("3+4j") returns 0.927295. - -IMCOS function - - -IMCOS - The result is the cosine of a complex number. - Syntax - IMCOS("ComplexNumber") - - Example - -=IMCOS("3+4j") returns -27.03-3.85i (rounded). - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + IMDIV function @@ -241,21 +266,46 @@ =IMREAL("1+3j") returns 1. - -IMSIN function - - -IMSIN - The result is the sine of a complex number. - Syntax - IMSIN("ComplexNumber") - - Example - -=IMSIN("3+4j") returns 3.85+27.02j (rounded). - + + + + + + + + + + + + + + + + + + + +
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/04060109.xhp|4 source/text/scalc/01/func_error_type.xhp | 129 +++ 3 files changed, 134 insertions(+) New commits: commit bd002743972148b9a2dca39248e9f0f406c34eea Author: tageziDate: Mon Oct 12 19:48:10 2015 +0300 Added description the ERROR.TYPE function func_error_type.xhp is NEW and contains the description maybe, need to add more good examples AllLangHelp_scalc.mk added the link to the file 04060109.xhp added the link to name and description on the function Change-Id: Ic178c3198ffa91bf02dcf611013347ca7814ab30 Reviewed-on: https://gerrit.libreoffice.org/19361 Reviewed-by: Caolán McNamara Tested-by: Caolán McNamara diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 0c180ca..09735b8 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -194,6 +194,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_eastersunday \ helpcontent2/source/text/scalc/01/func_edate \ helpcontent2/source/text/scalc/01/func_eomonth \ +helpcontent2/source/text/scalc/01/func_error_type \ helpcontent2/source/text/scalc/01/func_hour \ helpcontent2/source/text/scalc/01/func_minute \ helpcontent2/source/text/scalc/01/func_month \ diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 0abddba..aab9735 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -178,6 +178,10 @@ oldref="44">Example If cell A1 displays Err:518, the function =ERRORTYPE(A1) returns the number 518. + + + + INDEX function diff --git a/source/text/scalc/01/func_error_type.xhp b/source/text/scalc/01/func_error_type.xhp new file mode 100644 index 000..4933739 --- /dev/null +++ b/source/text/scalc/01/func_error_type.xhp @@ -0,0 +1,129 @@ + + + + + + +ERROR.TYPE function +text/scalc/01/func_error_type.xhp + + + + + + + + + ERROR.TYPE function + index of the Error type + + +ERROR.TYPE function +Returns a number representing a specific Error type, or the error value #N/A, if there is no error. + + +Syntax +ERROR.TYPE(Error_value) +Error_value â required argument. The error value or a reference to a cell, whose value needs to be processed. + + + + + Error value + + + Returns + + + + + Err:511 + + + 1 + + + + + #DIV/0! + + + 2 + + + + + #VALUE! + + + 3 + + + + + #REF! + + + 4 + + + + + #NAME? + + + 5 + + + + + #NUM! + + + 6 + + + + + #N/A + + + 7 + + + + + Anything else + + + #N/A + + + + + +Examples +Simple usage +=ERROR.TYPE(#N/A) +Returns 7, because 7 is the index number of the error value #N/A. +=ERROR.TYPE(A3) +If A3 contains an expression equivavlent to the division by zero, the function returns 2, because 2 is the index number of the error value #DIV/0! +More advanced way +If in division A1 by A2, A2 can turn to zero, you can handle the situation as follows: +=IF(ISERROR(A1/A2);IF(ERROR.TYPE(A1/A2)=2;"the denominator can't be equal to zero");A1/A2) +The ISERROR function returns TRUE or FALSE depending on whether there is an error or not. If the error takes place, the function IF addresses to the second argument, if there is no error, it returns the result of the division. The second argument checks the index number representing the specific Error type, and if it is equal to 2, it returns the specified text "the denominator can't be zero" or 0 otherwise. Thus, clear text would signify the division by zero, the result of the division would appear when the division is successful, or if there is, for example, an error of another type, zero would be returned. +If the ERROR.TYPE function is used as condition of the IF function and the ERROR.TYPE returns #N/A, the IF function returns #N/A as well. Use ISERROR to avoid it as shown in the example above. + +ISERROR, NA, IF +Error codes + + + + \ No newline at end of file ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/04060181.xhp|4 + source/text/scalc/01/func_averageifs.xhp |4 - source/text/scalc/01/func_countifs.xhp | 65 +++ source/text/scalc/01/func_sumifs.xhp |4 - 5 files changed, 74 insertions(+), 4 deletions(-) New commits: commit 0b6f8089829c49f01e35ce7bb11d5e0e0dfc70f2 Author: tageziDate: Fri Oct 9 23:54:35 2015 +0300 Added description COUNTIFS function func_countifs.xhp is new In func_averageifs.xhp and func_averageifs.xhp: added the link to COUNTIFS corrected some typos Change-Id: I2f9980d331bac807b1e1e03af24b5660c0081118 Reviewed-on: https://gerrit.libreoffice.org/19288 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 6395e91..0c180ca 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -184,6 +184,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_aggregate \ helpcontent2/source/text/scalc/01/func_averageif \ helpcontent2/source/text/scalc/01/func_averageifs \ +helpcontent2/source/text/scalc/01/func_countifs \ helpcontent2/source/text/scalc/01/func_date \ helpcontent2/source/text/scalc/01/func_datedif \ helpcontent2/source/text/scalc/01/func_datevalue \ diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp index 56f748e..53bbbfb 100644 --- a/source/text/scalc/01/04060181.xhp +++ b/source/text/scalc/01/04060181.xhp @@ -131,6 +131,10 @@ oldref="547">COUNTIF To count only negative numbers: =COUNTIF(A1:A10;"0") + + + + B function probabilities of samples with binomial distribution diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp index bc450f0..6fb9092 100644 --- a/source/text/scalc/01/func_averageifs.xhp +++ b/source/text/scalc/01/func_averageifs.xhp @@ -30,7 +30,7 @@ AVERAGEIFS(Average_range; Criterion_range1; Criterion1 [; Criterion_range2; Criterion2 [; ...]]) Average_range â required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean. Criterion_range1 â required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion. -Criterion1 â required argument. A condition in the form of expression or cell reference with expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers or regular expressions. +Criterion1 â required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers or regular expressions. Criterion_range2 â Optional. Criterion_range2 and all the following mean the same as Criterion_range1. Criterion2 â Optional. Criterion2 and all the following mean the same as Criterion1. The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Average_range is taken into calculation of the mean. @@ -58,7 +58,7 @@ If the range of values for calculating the mean and any range for finding criter =AVERAGEIFS(C2:C6;A2:A6;E2".*";B2:B6;""MAX(B2:B6)) If E2 = pen, the function returns 65, because the link to the cell is substituted with its content. -AVERAGE, AVERAGEA, , , MAX, MIN +AVERAGE, AVERAGEA, , , MAX, MIN diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp new file mode 100644 index 000..faa7a0b --- /dev/null +++ b/source/text/scalc/01/func_countifs.xhp @@ -0,0 +1,65 @@ + + + + + + +COUNTIFS function +text/scalc/01/func_countifs.xhp + + + + + + + + COUNTIFS function + counting row;satisfying criteria + counting column;satisfying criteria + +COUNTIFS function +Returns the count of rows or columns that meet criteria in multiple ranges. + +Syntax +COUNTIFS(Range1; Criterion1 [; Range2; Criterion2 [; ...]]) +Range1 â required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for counting and finding the corresponding criterion. +Criterion1 â required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used for counting. The expression can contain text, numbers or regular expressions. +Criterion_range2 â Optional. Criterion_range2 and all the following mean the same as Criterion_range1. +Criterion2 â Optional. Criterion2 and all the following mean the same as Criterion1.
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/04060184.xhp|4 + source/text/scalc/01/func_averageif.xhp | 40 +-- source/text/scalc/01/func_averageifs.xhp | 64 +++ 4 files changed, 89 insertions(+), 20 deletions(-) New commits: commit 27b584d0126fce1c74b6f89d3ce766ea46fa622c Author: tageziDate: Tue Oct 6 23:41:14 2015 +0300 Added discription AVERAGEIFS func_averageif.xhp - corrected typos added ODF 1.2 added the link to AVERAGEIFS UPD1 added the function in the 04060184.xhp file UPD2 Changed in accordance with the comment of Olivier (08.10 12:47 AM) UPD3 corrected some typos Change-Id: I659991e24418f5328780ca67eef5d3e939e22e7d Reviewed-on: https://gerrit.libreoffice.org/19236 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 8ecad3e..96f873a 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -183,6 +183,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/format_graphic \ helpcontent2/source/text/scalc/01/func_aggregate \ helpcontent2/source/text/scalc/01/func_averageif \ +helpcontent2/source/text/scalc/01/func_averageifs \ helpcontent2/source/text/scalc/01/func_date \ helpcontent2/source/text/scalc/01/func_datedif \ helpcontent2/source/text/scalc/01/func_datevalue \ diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index 4e12e57..d517a3f 100644 --- a/source/text/scalc/01/04060184.xhp +++ b/source/text/scalc/01/04060184.xhp @@ -170,6 +170,10 @@ oldref="162">Example + + + + MODE function most common value diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp index a772961..b47eec2 100644 --- a/source/text/scalc/01/func_averageif.xhp +++ b/source/text/scalc/01/func_averageif.xhp @@ -27,46 +27,46 @@ Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values. Syntax -AVERAGEIF(Range; Criteria [; Average_Range ]) +AVERAGEIF(Range; Criterion [; Average_Range ]) Range â required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition. -Criteria â required argument. A condition in the form of expression or cell reference with expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers or regular expressions. +Criterion â required argument. A condition in the form of expression or a cell reference with expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers or regular expressions. Average_Range â optional. It is a range of values for calculating the mean. Note that if the Average_Range is not specified, Range is used for both, the calculation of the mean and the search according to the condition. If the Average_Range is specified, the Range is used only for the condition test, while Average_Range is used for the mean calculation. -The Criteria needs to be a string expression, in particular, the Criteria needs to be enclosed in quotation marks ("Criteria") with the exception of the names of functions, cell references and an operation of a string concatenation (). +The Criterion needs to be a string expression, in particular, the Criterion needs to be enclosed in quotation marks ("Criterion") with the exception of the names of functions, cell references and an operation of a string concatenation (). If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell. If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error. -In all calculations below, range for average calculation contains the row #6, but it is ignored because it contains text. +In all calculations below, range for average calculation contains the row #6, but it is ignored, because it contains text. Simple usage -=AVERAGEIF(B6:B6;"35") +=AVERAGEIF(B2:B6;"35") Calculates the average for values of the range B2:B6 that are less than 35. Returns 19, because the second row does not participate in the calculation. -=AVERAGEIF(B2:B6;""MAX(B2:B6)) +=AVERAGEIF(B2:B6;""MAX(B2:B6)) Calculates the average for values of the same range that are less than the maximum value of this range. Returns 19, because the largest value (the second row) does not participate in the calculation. -=AVERAGEIF(B2:B6;""SMALL(B2:B6;1))
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/04060106.xhp|4 + source/text/scalc/01/func_averageifs.xhp |3 - source/text/scalc/01/func_sumifs.xhp | 72 +++ 4 files changed, 79 insertions(+), 1 deletion(-) New commits: commit 595364469b3f741b355c4d1193e711aa9063d33e Author: tageziDate: Thu Oct 8 22:23:57 2015 +0300 Added description SUMIFS function func_sumifs.xhp is new In func_averageifs.xhp added the link to SUMIFS added a string in Note about operators Change-Id: Ied9617bbd0dd33cf5fc2afa01f20b018dd5cffd0 Reviewed-on: https://gerrit.libreoffice.org/19257 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 96f873a..6395e91 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -200,6 +200,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_numbervalue \ helpcontent2/source/text/scalc/01/func_now \ helpcontent2/source/text/scalc/01/func_second \ +helpcontent2/source/text/scalc/01/func_sumifs \ helpcontent2/source/text/scalc/01/func_time \ helpcontent2/source/text/scalc/01/func_timevalue \ helpcontent2/source/text/scalc/01/func_today \ diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 2cb6846..fb526b3 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1053,6 +1053,10 @@ oldref="443">Example =SUMIF(A1:A10;"0";B1:10) - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are 0. See COUNTIF() for some more syntax examples that can be used with SUMIF(). + + + + TAN function diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp index 93ae633..bc450f0 100644 --- a/source/text/scalc/01/func_averageifs.xhp +++ b/source/text/scalc/01/func_averageifs.xhp @@ -35,6 +35,7 @@ Criterion2 â Optional. Criterion2 and all the following mean the same as Criterion1. The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Average_range is taken into calculation of the mean. The Criterion needs to be a string expression, in particular, the Criterion needs to be enclosed in quotation marks ("Criterion") with the exception of the names of functions, cell references and the operator of a string concatenation (). +The operators equal to (=), not equal to (>), greater than (>), greater than or equal to (>=), less than (), and less than or equal to (=) can be used in criterion arguments for comparison of numbers. The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for it. If a cell in a range of values for calculating the mean is empty or contains text, the function AVERAGEIFS ignores this cell. If a cell contains TRUE, it is treated as 1, if a cell contains FALSE â as 0 (zero). @@ -57,7 +58,7 @@ If the range of values for calculating the mean and any range for finding criter =AVERAGEIFS(C2:C6;A2:A6;E2".*";B2:B6;""MAX(B2:B6)) If E2 = pen, the function returns 65, because the link to the cell is substituted with its content. -AVERAGE, AVERAGEA, , MAX, MIN +AVERAGE, AVERAGEA, , , MAX, MIN diff --git a/source/text/scalc/01/func_sumifs.xhp b/source/text/scalc/01/func_sumifs.xhp new file mode 100644 index 000..2e0e44c --- /dev/null +++ b/source/text/scalc/01/func_sumifs.xhp @@ -0,0 +1,72 @@ + + + + + + +SUMIFS function +text/scalc/01/func_sumifs.xhp + + + + + + + + SUMIFS function + sum;satisfying conditions + +SUMIFS function +Returns the sum of the values of cells in a range that meets multiple criteria in multiple ranges. + + +Syntax +SUMIFS( Sum_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2 [;...]]) + +Sum_Range â required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum. +Criterion_range1 â required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion. +Criterion1 â required argument. A condition in the form of expression or cell reference with expression that defines what cells should be used to calculate the sum. The expression can contain text, numbers or regular expressions. +Criterion_range2 â Optional. Criterion_range2 and all the following mean the same as Criterion_range1. +Criterion2 â Optional. Criterion2 and all the following mean the same as Criterion1. + +The logical relation between criteria can be defined as logical AND
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |2 source/text/scalc/01/04060184.xhp |4 source/text/scalc/01/ex_data_stat_func.xhp | 125 + source/text/scalc/01/func_averageif.xhp| 72 4 files changed, 203 insertions(+) New commits: commit 7c74f4a55c7171419a78aa18f6d8842fe4f62833 Author: tageziDate: Sat Sep 26 20:56:19 2015 +0300 Added description and examples of the AVERAGEIF function UPD: Changed in accordance with the comment of Olivier Hallot (Sep 29 7:31 PM) Added value for the missing ID (string 80) UPD2: typo: forboth -> for both table for an example was moved to a separate file the attribute "role" of the tag "paragraph" for all an example has been changed from "paragraph" to "example" UDP3: double IDs was deleted in ex_data_stat_func.xhp Change-Id: I31b377715db133bfaab59047f9613171db8659e1 Reviewed-on: https://gerrit.libreoffice.org/1 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 90abc10..8ecad3e 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -179,8 +179,10 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/12120100 \ helpcontent2/source/text/scalc/01/12120200 \ helpcontent2/source/text/scalc/01/12120300 \ +helpcontent2/source/text/scalc/01/ex_data_stat_func \ helpcontent2/source/text/scalc/01/format_graphic \ helpcontent2/source/text/scalc/01/func_aggregate \ +helpcontent2/source/text/scalc/01/func_averageif \ helpcontent2/source/text/scalc/01/func_date \ helpcontent2/source/text/scalc/01/func_datedif \ helpcontent2/source/text/scalc/01/func_datevalue \ diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp index a52a06f..4e12e57 100644 --- a/source/text/scalc/01/04060184.xhp +++ b/source/text/scalc/01/04060184.xhp @@ -166,6 +166,10 @@ oldref="162">Example =AVERAGEA(A1:A50) + + + + MODE function most common value diff --git a/source/text/scalc/01/ex_data_stat_func.xhp b/source/text/scalc/01/ex_data_stat_func.xhp new file mode 100644 index 000..b85b770 --- /dev/null +++ b/source/text/scalc/01/ex_data_stat_func.xhp @@ -0,0 +1,125 @@ + + + + + + +Examples Dataset for Statistical Functions +/text/scalc/01/ex_data_stat_func.xhp + + + + +Examples Dataset for a family of the AVERAGE + +Examples +Consider the following table + + + + + + A + + + B + + + C + + + + + 1 + + + Product Name + + + Sales + + + Revenue + + + + + 2 + + + pencil + + + 20 + + + 65 + + + + + 3 + + + pen + + + 35 + + + 85 + + + + + 4 + + + notebook + + + 20 + + + 190 + + + + + 5 + + + book + + + 17 + + + 180 + + + + + 6 + + + pencil-case + + + not + + + not + + + + + + diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp new file mode 100644 index 000..a772961 --- /dev/null +++ b/source/text/scalc/01/func_averageif.xhp @@ -0,0 +1,72 @@ + + + + + + +AVERAGEIF function +/text/scalc/01/func_averageif.xhp + + + + + + + + AVERAGEIF function + arithmetic mean;satisfying condition + +AVERAGEIF function +Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values. + +Syntax +AVERAGEIF(Range; Criteria [; Average_Range ]) +Range â required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition. +Criteria â required argument. A condition in the form of expression or cell reference with expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers or regular expressions. +Average_Range â optional. It is a range of values for calculating the mean. +Note that if the Average_Range is not specified, Range is used for both, the calculation of the mean and the search according to the condition. If the Average_Range is specified, the Range is used only for the condition test, while Average_Range is used for the mean calculation. +The Criteria needs to be a string expression, in particular, the Criteria needs to be enclosed in quotation marks ("Criteria") with the exception of the names of functions, cell references and an operation of a string
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/01/04060106.xhp |4 source/text/scalc/01/func_aggregate.xhp | 454 3 files changed, 459 insertions(+) New commits: commit fa9b83defffcd6a10aacf8f97106cd17054855cc Author: tageziDate: Thu Sep 24 08:39:22 2015 +0300 tdf#85228 Added description of AGGREGATE function UPD: Changed in accordance with the comment of Regina (10:36 PM) UPD: Corrected separators in the syntax UPD: set up tags Change-Id: I05993ffec8af8dd1e997b3d2ae92ba0226b1bf28 Reviewed-on: https://gerrit.libreoffice.org/18821 Reviewed-by: Regina Henschel Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 9afb052..90abc10 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -180,6 +180,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/12120200 \ helpcontent2/source/text/scalc/01/12120300 \ helpcontent2/source/text/scalc/01/format_graphic \ +helpcontent2/source/text/scalc/01/func_aggregate \ helpcontent2/source/text/scalc/01/func_date \ helpcontent2/source/text/scalc/01/func_datedif \ helpcontent2/source/text/scalc/01/func_datevalue \ diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index d08f30c..2cb6846 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -131,6 +131,10 @@ oldref="85">Example =ACOTH(1.1) returns inverse hyperbolic cotangent of 1.1, approximately 1.52226.see also ACOSH, ASINH, ATANH, COSH, SINH, TANH, COTH + + + + ASIN function diff --git a/source/text/scalc/01/func_aggregate.xhp b/source/text/scalc/01/func_aggregate.xhp new file mode 100644 index 000..4d8e26b --- /dev/null +++ b/source/text/scalc/01/func_aggregate.xhp @@ -0,0 +1,454 @@ + + + + + + +AGGREGATE function +/text/scalc/01/func_aggregate.xhp + + + + + + + + + + AGGREGATE function + + + +AGGREGATE function +This function returns an aggregate result of the calculations in the range. You can use different aggregate functions listed below. The Aggregate function enables you to omit hidden rows, errors, SUBTOTAL and other AGGREGATE function results in the calculation. + +AGGREGATE function is applied to vertical ranges of data with activated AutoFilter. If AutoFilter is not activated, automatic recalculation of the function result does not work for newly hidden rows. It is not supposed to work with horizontal ranges, however it can be applied to them as well, but with limitations. In particular, the AGGREGATE function applied to a horizontal data range does not recognize hiding columns, however correctly omits errors and results of SUBTOTAL and other AGGREGATE functions embedded into the row. + +Syntax +AGGREGATE(Function; Option; Ref1 [; Ref2 [; â¦]]) +or +AGGREGATE(Function; Option; Array [; k]) +Function â obligatory argument. A function index or a reference to a cell with value from 1 to 19, in accordance with the following table. + + + + + Function index + + + Function applied + + + + + 1 + + + AVERAGE + + + + + 2 + + + COUNT + + + + + 3 + + + COUNTA + + + + + 4 + + + MAX + + + + + 5 + + + MIN + + + + + 6 + + + PRODUCT + + + + + 7 + + + STDEV.S + + + + + 8 + + + STDEV.P + + + + + 9 + + + SUM + + + + + 10 + + + VAR.S + + + + + 11 + + + VAR.P + + + + + 12 + + + MEDIAN + + + + + 13 + + + MODE.SNGL + + + + + 14 + + + LARGE + + + + + 15 + + + SMALL + + + + + 16 + + + PERCENTILE.INC + + + + + 17 + + + QUARTILE.INC + + + + + 18 + + + PERCENTILE.EXC + + + + + 19 + + + QUARTILE.EXC + + + + +Option â obligatory argument. An option index or reference to a cell with value from 0 to 7 determines what to ignore in the range for the function. + + + + + Option index + + + Option applied + + + + + 0 + + + Ignore only nested SUBTOTAL and AGGREGATE functions + + + + + 1 + + + Ignore only hidden rows, nested SUBTOTAL and AGGREGATE functions + + + + + 2 + + + Ignore only errors, nested SUBTOTAL and AGGREGATE functions + + + + +
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/01/ODFF.xhp | 35 + source/text/scalc/01/func_timevalue.xhp | 85 +++- 3 files changed, 76 insertions(+), 45 deletions(-) New commits: commit fd9b00bd84e3fe1a0aa087f5355aa0fcd27ef95f Author: Olivier Hallot olivier.hal...@edx.srv.br Date: Fri Jun 5 16:37:28 2015 -0300 Promote ODF Formula standard in Calc function help Insert ODF Formula standard citation in Calc functions where it applies. In this example, function TIMEVALUE is a standard ODF Formula 1.2 function. Many other functions qualify to be a ODFF function. But since Excel is changing its function names, not every Calc function is and ODFF funciton. Change-Id: Ib764d780f9f66c8a7adaba8954d91fc9b4d70410 Reviewed-on: https://gerrit.libreoffice.org/16110 Reviewed-by: Caolán McNamara caol...@redhat.com Tested-by: Caolán McNamara caol...@redhat.com diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 49434ca..9987151 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -210,6 +210,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/solver_options \ helpcontent2/source/text/scalc/01/statistics \ helpcontent2/source/text/scalc/01/stat_data \ +helpcontent2/source/text/scalc/01/ODFF \ helpcontent2/source/text/scalc/01/text2columns \ helpcontent2/source/text/scalc/02/0213 \ helpcontent2/source/text/scalc/02/0214 \ diff --git a/source/text/scalc/01/ODFF.xhp b/source/text/scalc/01/ODFF.xhp new file mode 100644 index 000..85aebf9 --- /dev/null +++ b/source/text/scalc/01/ODFF.xhp @@ -0,0 +1,35 @@ +?xml version=1.0? +helpdocument version=1.0 +!--*** + * + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * License); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + * + ***-- + +meta +topic id=topic_0506201512363995 +title xml-lang=en-US id=titODFF/title +filenametext/scalc/01/ODFF.xhp/filename +/topic +/meta +body +section id=odff +paragraph id=hd_id110 role=note xml-lang=en-USThis function is a standard Open Document Formula version 1.2 function./paragraph +/section +/body +/helpdocument \ No newline at end of file diff --git a/source/text/scalc/01/func_timevalue.xhp b/source/text/scalc/01/func_timevalue.xhp index 97f35db..d986caf 100644 --- a/source/text/scalc/01/func_timevalue.xhp +++ b/source/text/scalc/01/func_timevalue.xhp @@ -1,51 +1,46 @@ -?xml version=1.0 encoding=UTF-8? +?xml version=1.0? helpdocument version=1.0 - -!-- - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the License); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - -- +!--*** + * + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * License); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + *
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/05/OpenCL_options.xhp | 59 2 files changed, 60 insertions(+) New commits: commit b3fb9849fa298bf36ffb5a9967a109f40f0e5021 Author: Olivier Hallot olivier.hal...@edx.srv.br Date: Tue Dec 30 14:05:35 2014 -0200 fdo#86637 (part) OpenCL options help page Change-Id: I8adfb16d4eb4dd4342673b6707ecc1015bf9 Reviewed-on: https://gerrit.libreoffice.org/13702 Reviewed-by: Caolán McNamara caol...@redhat.com Tested-by: Caolán McNamara caol...@redhat.com diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 3f33401..49434ca 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -232,6 +232,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/04/0102 \ helpcontent2/source/text/scalc/05/0214 \ helpcontent2/source/text/scalc/05/empty_cells \ +helpcontent2/source/text/scalc/05/OpenCL_options \ helpcontent2/source/text/scalc/guide/address_auto \ helpcontent2/source/text/scalc/guide/auto_off \ helpcontent2/source/text/scalc/guide/autofilter \ diff --git a/source/text/scalc/05/OpenCL_options.xhp b/source/text/scalc/05/OpenCL_options.xhp new file mode 100644 index 000..2237263 --- /dev/null +++ b/source/text/scalc/05/OpenCL_options.xhp @@ -0,0 +1,59 @@ +?xml version=1.0 encoding=UTF-8? +!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + -- + + +helpdocument version=1.0 +meta +topic id=opencloptions indexer=include status=PUBLISH +title id=tit xml-lang=en-USOpenCL Options/title +filename/text/scalc/05/OpenCL_options.xhp/filename +/topic +/meta +body +bookmark xml-lang=en-US branch=index id=bm_id3146799bookmark_valueOpenCl;options/bookmark_value +/bookmark +bookmark xml-lang=en-US branch=hid/modules/scalc/ui/formulacalculationoptions/FormulaCalculationOptions id=bm_id2745673 localize=false/ +paragraph role=heading id=hd_id1502121 xml-lang=en-US level=1 l10n=NEWvariable id=empty_cellslink href=text/scalc/05/OpenCL_options.xhpOpenCL Options/link +/variable/paragraph +paragraph role=note id=par_id5293740 xml-lang=en-US l10n=NEWThis page is under construction/paragraph +paragraph role=paragraph id=par_id2733542 xml-lang=en-US l10n=NEWOpenCL: the open standard for parallel programming of heterogeneous systems./paragraph + + section id=howtoget +paragraph role=paragraph id=par_id2752992 xml-lang=en-US l10n=U oldref=26 + variable id=sam01Menu emphTools - Options - LibreOffice Calc - Formula/emph, and in section emphDetailed Calculation Settings/emph press emphDetails.../emph button/variable +/paragraph + /section +paragraph role=paragraph id=par_id8266853 xml-lang=en-US l10n=NEW +OpenCL⢠is the first open, royalty-free standard for cross-platform, parallel programming of modern processors found in personal computers, servers and handheld/embedded devices. OpenCL (Open Computing Language) greatly improves speed and responsiveness for a wide spectrum of applications in numerous market categories from gaming and entertainment to scientific and medical software/paragraph +paragraph role=note id=par_id5293741 xml-lang=en-US l10n=NEWfor more information on OpenCL, visit link href=http://www.khronos.org/opencl/;the OpenCL site/link/paragraph +paragraph role=heading id=par_id4238715 xml-lang=en-US level=2Contents to Numbers/paragraph +paragraph role=heading id=par_id8277230 xml-lang=en-US l10n=NEW level=3Conversion from text to number/paragraph +paragraph role=paragraph id=par_id396740 xml-lang=en-US l10n=NEWHow to treat text when encountered as operand in an arithmetic operation or as argument to a function that expects a number instead. Unambiguous conversion is possible for integer numbers including exponents and ISO 8601 dates and times in their extended formats with separators. Fractional numeric values with decimal separators or dates other than ISO 8601 are locale dependent. Note that in locale dependent conversions the resulting numeric value may differ between locales!/paragraph +paragraph role=paragraph id=par_id4086428 xml-lang=en-US l10n=NEWemphGenerate #VALUE! error:/emph Text found where numeric data is expected will generate #VALUE! error. Example: item type=input123.45/item will generate a #VALUE! error, while item type=input123.45/item not./paragraph +paragraph role=paragraph id=par_id9024628 xml-lang=en-US l10n=NEWemphTreat as zero:/emph Any text found where numeric data is expected will be considered as a number of value zero. Example: item type=input123.45/item will map to zero, while item type=input123.45/item not./paragraph +paragraph role=paragraph id=par_id3067110 xml-lang=en-US l10n=NEWemphConvert only
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/func_webservice.xhp | 47 +++ 2 files changed, 48 insertions(+) New commits: commit eb0f507b5eb59c6b9a86d8f65e23fb9f0a3e790e Author: Olivier Hallot olivier.hal...@edx.srv.br Date: Sat Sep 13 16:39:13 2014 -0300 Fix FDO#80441 Help pages for WEBSERVICES function Also FILTERXML. Many thanks to Leif Lodahl for the help Change-Id: I241610db69eab0cc2490492520288bc6b154c21b Reviewed-on: https://gerrit.libreoffice.org/11435 Reviewed-by: Thomas Arnhold tho...@arnhold.org Tested-by: Thomas Arnhold tho...@arnhold.org diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index b20a026..3f33401 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -200,6 +200,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_timevalue \ helpcontent2/source/text/scalc/01/func_today \ helpcontent2/source/text/scalc/01/func_weekday \ +helpcontent2/source/text/scalc/01/func_webservice \ helpcontent2/source/text/scalc/01/func_weeknum \ helpcontent2/source/text/scalc/01/func_weeknumadd \ helpcontent2/source/text/scalc/01/func_workday \ diff --git a/source/text/scalc/01/func_webservice.xhp b/source/text/scalc/01/func_webservice.xhp new file mode 100644 index 000..03a0692 --- /dev/null +++ b/source/text/scalc/01/func_webservice.xhp @@ -0,0 +1,47 @@ +?xml version=1.0 encoding=UTF-8? +!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + -- +helpdocument version=1.0 + meta + topic id=textscalc01func_webservice indexer=include status=PUBLISH + title id=tit xml-lang=en-USWEBSERVICE/title + filename/text/scalc/01/func_webservice.xhp/filename + /topic + /meta + body + section id=webservice + bookmark xml-lang=en-US branch=index id=bm_id3149012bookmark_valueWEBSERVICE function/bookmark_value + /bookmark + bookmark xml-lang=en-US branch=hid/SC_HID_FUNC_WEBSERVICE id=bm_id3150028 localize=false/ + paragraph role=heading id=hd_id3149012 xml-lang=en-US level=2 l10n=U oldref=186WEBSERVICE/paragraph + paragraph role=paragraph id=par_id3149893 xml-lang=en-US l10n=U oldref=187ahelp hid=HID_FUNC_WEBSERVICEGet some web content from a URI./ahelp/paragraph + paragraph role=heading id=hd_id3146944 xml-lang=en-US level=3 l10n=U oldref=188Syntax/paragraph + paragraph role=code id=par_id3154844 xml-lang=en-US l10n=U oldref=189WEBSERVICE(URI)/paragraph + paragraph role=paragraph id=par_id3147469 xml-lang=en-US l10n=U oldref=190emphURI: /emph URI text of the web service./paragraph + paragraph role=heading id=hd_id3150141 xml-lang=en-US level=3 l10n=U oldref=193Example/paragraph + paragraph role=paragraph id=par_id3146142 xml-lang=en-US l10n=CHG oldref=195=WEBSERVICE(http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dkamp;mode=xmlamp;units=metric;) /paragraph + paragraph role=paragraph id=par_id3146143 xml-lang=en-USReturns the web page content of http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dkamp;mode=xmlamp;units=metric;/paragraph + /section + section id=filterxml + bookmark xml-lang=en-US branch=index id=bm_id2949012 + bookmark_valueFILTERXML function/bookmark_value + /bookmark + bookmark xml-lang=en-US branch=hid/SC_HID_FUNC_FILTERXML id=bm_id2950028 localize=false/ + paragraph role=heading id=hd_id2949012 xml-lang=en-US level=2 l10n=U oldref=186FILTERXML/paragraph + paragraph role=paragraph id=par_id2949893 xml-lang=en-US l10n=U oldref=187ahelp hid=HID_FUNC_FILTERXMLApply a XPath expression to a XML document./ahelp/paragraph + paragraph role=heading id=hd_id2946944 xml-lang=en-US level=3 l10n=U oldref=188Syntax/paragraph + paragraph role=code id=par_id2954844 xml-lang=en-US l10n=U oldref=189FILTERXML(XML Document; XPath expression)/paragraph + paragraph role=paragraph id=par_id2947469 xml-lang=en-US l10n=U oldref=190emphXML Document (required):/emph String containing a valid XML stream./paragraph + paragraph role=paragraph id=par_id2847469 xml-lang=en-US l10n=U oldref=190emphXPath expression (required):/emph String containing a valid XPath expression./paragraph + paragraph role=heading id=hd_id2950141 xml-lang=en-US level=3 l10n=U oldref=193Example/paragraph + paragraph role=paragraph id=par_id2946142 xml-lang=en-US l10n=CHG oldref=195=FILTERXML(WEBSERVICE(http://api.openweathermap.org/data/2.5/forecast?q=Copenhagen,dkamp;mode=xmlamp;units=metric;);number(/weatherdata/forecast/time[2]/temperature/@value))/paragraph + paragraph role=paragraph id=par_id2946143 xml-lang=en-US Returns information on
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/02140700.xhp | 219 ++ 2 files changed, 220 insertions(+) New commits: commit c124f21d9c10bd56bfe8c1b1e89a898c360372a0 Author: Olivier Hallot olivier.hal...@edx.srv.br Date: Sat Aug 23 17:22:38 2014 -0300 FDO#80453 Help page for Edit-Fill-Random Numbers Help page for Calc's Edit - Fill - Random numbers Change-Id: Iab6c86f77d5bdc170af2e6cdf208470b0ce1db9f Reviewed-on: https://gerrit.libreoffice.org/11097 Reviewed-by: Joren De Cuyper jore...@libreoffice.org Tested-by: Joren De Cuyper jore...@libreoffice.org diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 69ba36e..b20a026 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -36,6 +36,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/02140400 \ helpcontent2/source/text/scalc/01/02140500 \ helpcontent2/source/text/scalc/01/02140600 \ +helpcontent2/source/text/scalc/01/02140700 \ helpcontent2/source/text/scalc/01/0215 \ helpcontent2/source/text/scalc/01/0216 \ helpcontent2/source/text/scalc/01/0217 \ diff --git a/source/text/scalc/01/02140700.xhp b/source/text/scalc/01/02140700.xhp new file mode 100644 index 000..fff36fb --- /dev/null +++ b/source/text/scalc/01/02140700.xhp @@ -0,0 +1,219 @@ +?xml version=1.0? +helpdocument version=1.0 +!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the License); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + -- + +meta +topic id=ID indexer=Indexer status=PUBLISH +title xml-lang=en-US id=titFill Random Numbers/title +filenametext/scalc/01/02140700.xhp/filename +/topic +/meta +body +bookmark xml-lang=en-US branch=hid/modules/scalc/ui/randomnumbergenerator/RandomNumberGeneratorDialog id=bm_id3150791 localize=false/ +paragraph id=hd_id2308201415431520596 role=heading xml-lang=en-US level=1Fill Random Numbers/paragraph +paragraph id=par_id2308201415431525817 role=paragraph xml-lang=en-USPopulate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters./paragraph +bookmark xml-lang=en-US branch=index id=bm_id2308201416102526759 +bookmark_valuefill range;random numbers/bookmark_value +bookmark_valuerandom rumbers;fill range/bookmark_value +bookmark_valuerandom rumbers;distribution/bookmark_value +/bookmark +section id=howtoget +paragraph id=par_id2308201415500176457 role=paragraph xml-lang=en-USMenu item type=menuitemEdit â Fill â Random Numbers/item/paragraph +/section +paragraph id=hd_id2308201415431233475 role=heading xml-lang=en-US level=2Data/paragraph +paragraph id=hd_id2308201415431883475 role=heading xml-lang=en-US level=3Cell Range/paragraph +paragraph id=par_id230820141543181 role=paragraph xml-lang=en-USDefine the range of cells to fill with random numbers. If you have previously selected a range, it will be displayed here./paragraph +paragraph id=hd_id2308201415431850229 role=heading xml-lang=en-US level=2Random number generator/paragraph +paragraph id=hd_id2308201415431880497 role=heading xml-lang=en-US level=3Distribution/paragraph +bookmark xml-lang=en-US branch=hid/modules/scalc/ui/randomnumbergenerator/RandomNumberGeneratorDialog/distribution-combo id=bm_id2308201416384294287 localize=false/ +paragraph id=par_id2308201415431874867 role=paragraph xml-lang=en-USahelp hid=The distribution function for the random number generator./ahelp/paragraph +paragraph id=par_id2308201416441240058 role=paragraph xml-lang=en-USValid distributions function are/paragraph +list type=unordered +listitem +paragraph id=par_id2308201415431818046 role=ul_item xml-lang=en-USUniform/paragraph +/listitem +listitem +paragraph id=par_id2308201415431825918 role=ul_item xml-lang=en-USUniform Integer/paragraph +/listitem +listitem +paragraph id=par_id2308201415431836211 role=ul_item xml-lang=en-USNormal/paragraph +/listitem +listitem +paragraph id=par_id2308201415431849631 role=ul_item xml-lang=en-USCauchy/paragraph +/listitem +listitem +paragraph id=par_id2308201415431835163 role=ul_item xml-lang=en-USBernoulli/paragraph +/listitem +listitem +paragraph id=par_id2308201415431855317
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/01/stat_data.xhp | 386 source/text/scalc/01/statistics.xhp | 1729 +++- 3 files changed, 1879 insertions(+), 237 deletions(-) New commits: commit ba90edc72a3eedc95f2a2bd2c6923b860cc3e4d8 Author: Olivier Hallot olivier.hal...@edx.srv.br Date: Wed Aug 20 21:36:38 2014 -0300 Fix fdo#80338 Help pages for Data Statistics This is a text to get a mimnimum help for Calc Data Statistics. It can be improved with better english and better maths. Change-Id: I3771ed89c560df1e4e23835f5a15d8cfc47282cd Reviewed-on: https://gerrit.libreoffice.org/11051 Reviewed-by: Caolán McNamara caol...@redhat.com Tested-by: Caolán McNamara caol...@redhat.com diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 07ca0ad..69ba36e 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -207,6 +207,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/solver \ helpcontent2/source/text/scalc/01/solver_options \ helpcontent2/source/text/scalc/01/statistics \ +helpcontent2/source/text/scalc/01/stat_data \ helpcontent2/source/text/scalc/01/text2columns \ helpcontent2/source/text/scalc/02/0213 \ helpcontent2/source/text/scalc/02/0214 \ diff --git a/source/text/scalc/01/stat_data.xhp b/source/text/scalc/01/stat_data.xhp new file mode 100644 index 000..5263a70 --- /dev/null +++ b/source/text/scalc/01/stat_data.xhp @@ -0,0 +1,386 @@ +?xml version=1.0 encoding=UTF-8? +!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the License); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + -- +helpdocument version=1.0 + body +section id=data + paragraph id=hd_id200820141553364965 role=heading xml-lang=en-US level=3Data/paragraph + paragraph id=par_id2008201415533682345 role=paragraph xml-lang=en-USemphInput Range/emph: The reference of the range of the data to analyze./paragraph + paragraph id=par_id2008201415533690271 role=paragraph xml-lang=en-USemphResults to/emph: The reference of the top left cell of the range where the results will be displayed./paragraph +/section +section id=grouped + paragraph id=hd_id2008201415533630182 role=heading xml-lang=en-US level=3Grouped By/paragraph + paragraph id=par_id2008201415533694478 role=paragraph xml-lang=en-USSelect whether the input data has emphcolumns/emph or emphrows/emph layout./paragraph +/section +section id=sampledata01 + paragraph id=hd_id2008201415533366360 role=heading xml-lang=en-US level=3Example/paragraph + paragraph id=par_id2008201415533343874 role=paragraph xml-lang=en-USThe following data will be used as example /paragraph + table id=Tabela3 +tablerow + tablecell colspan= rowspan= +/tablecell + tablecell colspan= rowspan= +paragraph id=par_id2008201415533312589 role=tablehead xml-lang=en-USA/paragraph + /tablecell + tablecell colspan= rowspan= +paragraph id=par_id200820141558155 role=tablehead xml-lang=en-USB/paragraph + /tablecell + tablecell colspan= rowspan= +paragraph id=par_id2008201415533321020 role=tablehead xml-lang=en-USC/paragraph + /tablecell +/tablerow +tablerow + tablecell colspan= rowspan= +paragraph id=par_id2008201415533376551 role=tablehead xml-lang=en-US1/paragraph + /tablecell + tablecell colspan= rowspan= +paragraph id=par_id200820141553335121 role=tablehead xml-lang=en-USMaths/paragraph + /tablecell + tablecell colspan= rowspan= +paragraph id=par_id2008201415533379519 role=tablehead xml-lang=en-USPhysics/paragraph + /tablecell + tablecell colspan= rowspan= +paragraph id=par_id20082014155644 role=tablehead xml-lang=en-USBiology/paragraph + /tablecell +/tablerow +tablerow + tablecell colspan= rowspan= +paragraph id=par_id2008201415533318687 role=tablehead xml-lang=en-US2/paragraph + /tablecell + tablecell colspan= rowspan= +paragraph
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk|1 source/text/scalc/01/statistics.xhp | 257 2 files changed, 258 insertions(+) New commits: commit 135498091966f63d582929446a084b41d3ffd4da Author: Olivier Hallot olivier.hal...@edx.srv.br Date: Sat Aug 2 21:35:44 2014 -0300 Partial fix for fdo#80338: help for calc statistics Entry page for Calc Data statistics. This is work in progress and the help content should be completed with the correct information. Change-Id: I34f67a2b10d76bb1da6a9b9f4e24d4242396cbe4 Reviewed-on: https://gerrit.libreoffice.org/10703 Reviewed-by: David Tardon dtar...@redhat.com Tested-by: David Tardon dtar...@redhat.com diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index c4ba90b..07ca0ad 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -206,6 +206,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_yearfrac \ helpcontent2/source/text/scalc/01/solver \ helpcontent2/source/text/scalc/01/solver_options \ +helpcontent2/source/text/scalc/01/statistics \ helpcontent2/source/text/scalc/01/text2columns \ helpcontent2/source/text/scalc/02/0213 \ helpcontent2/source/text/scalc/02/0214 \ diff --git a/source/text/scalc/01/statistics.xhp b/source/text/scalc/01/statistics.xhp new file mode 100644 index 000..f1c3bb7 --- /dev/null +++ b/source/text/scalc/01/statistics.xhp @@ -0,0 +1,257 @@ +?xml version=1.0 encoding=UTF-8? + + +!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the License); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + -- + +helpdocument version=1.0 +meta +topic id=statistics indexer=include status=PUBLISH +title id=tit xml-lang=en-USData Statistics/title +filename/text/scalc/01/statistics.xhp/filename +/topic +/meta +body +paragraph role=heading id=hd_id1 xml-lang=en-US level=1 l10n=U oldref=1Data Statistics/paragraph +section id=datasampling +bookmark xml-lang=en-US branch=index id=bm_id2764278 + bookmark_valueAnalysis toolpack;sampling/bookmark_value + bookmark_valuesampling;Analysis toolpack/bookmark_value + bookmark_valueData statistics;sampling/bookmark_value +/bookmark +bookmark xml-lang=en-US branch=hid/modules/scalc/ui/samplingdialog/SamplingDialog id=bm_id2745673 localize=false/ +paragraph role=heading id=hd_id2753032 xml-lang=en-US level=2 l10n=U oldref=1Sampling/paragraph +paragraph role=paragraph id=par_id2756327 xml-lang=en-US l10n=U oldref=2 + ahelp hid=/modules/scalc/ui/samplingdialog/SamplingDialog(to-do)/ahelp/paragraph +section id=howtoget + paragraph role=paragraph id=par_id2752992 xml-lang=en-US l10n=U oldref=26 +variable id=sam01Menu emphData - Statistics - Sampling.../emph/variable/paragraph +/section +paragraph role=paragraph id=par_id2756923 xml-lang=en-US l10n=U oldref=4 + (To do) +/paragraph +bookmark xml-lang=en-US branch=hid/modules/scalc/ui/samplingdialog/input-range-label id=bm_id2748663 localize=false/ +paragraph role=heading id=hd_id2753895 xml-lang=en-US level=3 l10n=U oldref=5Input Range/paragraph +paragraph role=paragraph id=par_id2750400 xml-lang=en-US l10n=U oldref=6ahelp hid=modules/scalc/ui/samplingdialog/input-range-labelSelect the input data range./ahelp/paragraph +bookmark xml-lang=en-US branch=hid/modules/scalc/ui/samplingdialog/output-range-label id=bm_id263984 localize=false/ +paragraph role=heading id=hd_id2754704 xml-lang=en-US level=3 l10n=CHG oldref=7Results to/paragraph +paragraph role=paragraph id=par_id2753967 xml-lang=en-US l10n=CHG oldref=8ahelp hid=modules/scalc/ui/samplingdialog/output-range-labelSelects the upper left cell where the samples will be displayed./ahelp/paragraph +bookmark xml-lang=en-US branch=hid/modules/scalc/ui/samplingdialog/groupedby-columns-radio id=bm_id2739518 localize=false/ +/section + +section id=descriptivestatistics +bookmark xml-lang=en-US branch=index id=bm_id01001 + bookmark_valueAnalysis toolpack;descriptive statistics/bookmark_value + bookmark_valuedescriptive statistics;Analysis toolpack/bookmark_value + bookmark_valueData statistics;descriptive statistics/bookmark_value +/bookmark +bookmark xml-lang=en-US
[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
AllLangHelp_scalc.mk |1 source/text/scalc/01/func_numbervalue.xhp | 48 ++ 2 files changed, 49 insertions(+) New commits: commit 0b6e8e1c94332513d8f49fc9975f31c6be860847 Author: Olivier Hallot olivier.hal...@edx.srv.br Date: Sat Jun 28 22:32:17 2014 -0300 Fix fdo#80656. Help for NUMBERVALUE Calc function Change-Id: Iab3c6e2a82162f5b6cbd1a2e80e76e7df36b2042 Reviewed-on: https://gerrit.libreoffice.org/9959 Reviewed-by: Caolán McNamara caol...@redhat.com Tested-by: Caolán McNamara caol...@redhat.com diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 097dc2d..c4ba90b 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -192,6 +192,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_minute \ helpcontent2/source/text/scalc/01/func_month \ helpcontent2/source/text/scalc/01/func_networkdays \ +helpcontent2/source/text/scalc/01/func_numbervalue \ helpcontent2/source/text/scalc/01/func_now \ helpcontent2/source/text/scalc/01/func_second \ helpcontent2/source/text/scalc/01/func_time \ diff --git a/source/text/scalc/01/func_numbervalue.xhp b/source/text/scalc/01/func_numbervalue.xhp new file mode 100644 index 000..45006a9 --- /dev/null +++ b/source/text/scalc/01/func_numbervalue.xhp @@ -0,0 +1,48 @@ +?xml version=1.0 encoding=UTF-8? +helpdocument version=1.0 + !-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the License); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + -- + meta +topic id=textscalc01func_numbervaluexml indexer=include status=PUBLISH + title xml-lang=en-US id=titNUMBERVALUE /title + filename/text/scalc/01/func_numbervalue.xhp/filename +/topic + /meta + body +bookmark xml-lang=en-US branch=index id=bm_id3145621 + bookmark_valueNUMBERVALUE function/bookmark_value +/bookmark +bookmark xml-lang=en-US branch=hid/SC_HID_FUNC_NUMBERVALUE id=bm_id3163820 localize=false/ +paragraph xml-lang=en-US id=hd_id3145621 role=heading level=2 l10n=U oldref=18 + variable id=datevalue +link href=text/scalc/01/func_numbervalue.xhpNUMBERVALUE/link + /variable +/paragraph +paragraph xml-lang=en-US id=par_id3145087 role=paragraph l10n=U oldref=19 + ahelp hid=HID_FUNC_NUMBERVALUEConvert text to number, in a locale-independent way./ahelp +/paragraph +paragraph xml-lang=en-US id=par_id3149281 role=paragraph l10n=CHG oldref=20Constraints: LEN(decimal_separator) = 1, decimal_separator shall not appear in group_separator/paragraph +paragraph xml-lang=en-US id=hd_id3156294 role=heading level=3 l10n=U oldref=21Syntax/paragraph +paragraph xml-lang=en-US id=par_id3149268 role=code l10n=U oldref=22NUMBERVALUE(Text;decimal_separator;group_separator)/paragraph +paragraph xml-lang=en-US id=par_id3154819 role=paragraph l10n=U oldref=23emphText/emph is a valid number expression and must be entered with quotation marks./paragraph +paragraph xml-lang=en-US id=par_id3154820 role=paragraph l10n=U oldref=23emphdecimal_separator/emph (optional) defines the character used as the decimal separator./paragraph +paragraph xml-lang=en-US id=par_id3154821 role=paragraph l10n=U oldref=23emphgroup_separator/emph (optional) defines the character(s) used as the group separator./paragraph +paragraph xml-lang=en-US id=hd_id3156309 role=heading level=3 l10n=U oldref=24Example/paragraph +paragraph xml-lang=en-US id=par_id3155841 role=paragraph l10n=CHG oldref=25item type=input=NUMBERVALUE(123.456;.;,)/item yields 123.456/paragraph + /body +/helpdocument ___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits