summaryrefslogtreecommitdiff
path: root/AllLangHelp_scalc.mk
AgeCommit message (Collapse)Author
2021-11-24tdf#143846 Separate help pages for ASC/JIS text functionsRafael Lima
Change-Id: I9b5ae9b14ea98fe9edbf84a433ad4b7ed3bfcf39 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/125720 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-11-09Improve Example section of help description for Calc's SUM() functionSteve Fanning
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 <erack@redhat.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-10-21Related tdf#143846 Improve Arabic/Roman help pagesRafael Lima
Change-Id: I4be244dba35f137c1b7d356aab658c5e08604e51 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/123523 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-10-01tdf#33749 - revised help text for merge and split in CalcRoss Johnson
The earlier change (reverted) overlooked the difference between "Merge Cells" and "Merge and Center Cells", leaving users without adequate means to merge cells while retaining text alignment. This patch restores previous usability and moves forward to resolve the issues raised in this bug report. Reverted the two changes from earlier work on tdf#33749: 1) Cell context menu back to 7.2 2) Format - Merge Cells menu back to 7.2 3) Help pages to reflect that Moving forward with the following changes: 1) Rename "Split Cells" to "Unmerge Cells" (Calc only) 2) Add "Merge Cells" and "Unmerge Cells" to the Formatting toolbar alongside "Merge and Center Cells". 3) Re-label the Format - Merge Cells menu to Format - Merge and Unmerge Cells. 4) Help pages to reflect core including fixing the duplicate entry in the built help/hid2file.js by consolidating the relevant Calc and Writer help pages together to remove the duplicate bookmark hid branch value. Removed the module specific version. 5) Removed duplicate entry from helpers/unocmds.txt. Change-Id: Ica50f507eea74acd430bef3042fb9739d1cff7b2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122810 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-08-27Create help page about how to Remove Duplicates in CalcRafael Lima
This patch creates a new "guide" page on how to remove Duplicate values in Calc. This is a question I see being frequently asked in forums and I could not find any entry in the Help that explained how this can be done. Change-Id: I6e115739752fdc1f5aa35cf45f041655b3e614be Reviewed-on: https://gerrit.libreoffice.org/c/help/+/121067 Tested-by: Jenkins Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-08-18tdf#142574 Create help page on "wildcards"Rafael Lima
This patch creates the wildcards.xhp help page and makes the required adaptations in tree files to disambiguate "wildcards" and "regular expressions" in the help system. Change-Id: I82f1e192b6bf9e605fc3cfde50b648ce902cefdb Reviewed-on: https://gerrit.libreoffice.org/c/help/+/120573 Tested-by: Jenkins Reviewed-by: Steve Fanning <stevemfanning@yahoo.co.uk> Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2021-08-17Improve VALUE function help pageRafael Lima
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 <h2> instead of <h1>. Change-Id: Ic67893f0c35a58a19f13af1d34d68956e901a4a6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/120361 Tested-by: Jenkins Reviewed-by: Steve Fanning <stevemfanning@yahoo.co.uk> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-05-21tdf#141929 Improve CONVERT help and move to a separate fileRafael Lima
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 <stevemfanning@yahoo.co.uk> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-02-03tdf#140111 Synch Help page w/ Calc View menuOlivier Hallot
Change-Id: I3e3d19f3ba3229843811528ce5376fea53795556 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110335 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-01-14tdf#139436 Add Help page for Format - Conditional - Data bar - More Options ↵Balaharipreetha Muthu
dialog Change-Id: I83faa2d1edb8f5cba08a7b1054bd66fc17f835b9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109129 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-12-17tdf#116381 - Add help file - anchor types for an image in CalcBalaharipreetha Muthu
Change-Id: Ib2d9cbd0607e47f1adeb74f5c4a31e984d07197a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107545 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-07-01tdf#134376 Add Calc cell style Help pageOlivier Hallot
Change-Id: I57f32bdfc4435cbe21b7cca1cb5170892e69447d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/97622 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-05-22tdf81599 Better Help pages for Calc SolversOlivier Hallot
Add information on algorithms paramenters Change-Id: I36f330593687efa616594e397cb7d6054c2198ed Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94703 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-09tdf#131960 Clarification of FLOOR functionsSteve Fanning
+ 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 <olivier.hallot@libreoffice.org>
2020-04-09tdf#131960 Clarification of CEILING functionSteve Fanning
+ 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 <olivier.hallot@libreoffice.org>
2020-03-26tdf#126923 Add guide for subtotals toolOlivier Hallot
Change-Id: I941214be272d6e959c1129b074891bb6f229ba26 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91079 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-20Refactor Data analysis Calc help pageOlivier Hallot
Comply with menu Data > Statistics Change-Id: I06a5ed00ef162064ea2768f3040511e599993c3f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90837 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-20Review, refactor Calc Data Menu Help pagesOlivier Hallot
- 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 <olivier.hallot@libreoffice.org>
2019-11-30tdf#92084 Help Pages for OPT_* Calc functionsSteve Fanning
Note: The OPT_* functions implemented in release 4.0 have no HID_ defined. Dummy HID contants were inserted waiting for tdf#129115. Change-Id: Iac253a86ff8cbf8fd1a222c6326abc7e0c9f4f76 Signed-off-by: Olivier Hallot <olivier.hallot@libreoffice.org> Reviewed-on: https://gerrit.libreoffice.org/84122 Tested-by: Jenkins
2019-11-12Add FINDB, SEARCHB and REPLACEB Help pageslibreoffice-6-4-branch-pointOlivier Hallot
Change-Id: Ie8a7c5762f41484d36837008226cc446584e3110 Reviewed-on: https://gerrit.libreoffice.org/82481 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-07-02Add Help for FOURIER calc function and analysisOlivier Hallot
Refactor sample tables, Mute l10n for numbers FOURIER function Fourier analysis Sample file Change-Id: If5361fe009ec380e9cdd6f3e24184471c1451421 Reviewed-on: https://gerrit.libreoffice.org/74914 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-04-27tdf#99517 help for CONCAT, TEXTJOIN, IFS, SWITCHOlivier Hallot
CONCAT, TEXTJOIN, IFS, SWITCH Change-Id: Ic1d74ac8b810bd0c0d4b4f570baab1d1e270f912 Reviewed-on: https://gerrit.libreoffice.org/71339 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2019-03-04tdf#123803 Add relelase info in Calc functionsOlivier Hallot
Patch is for REGEX function available since release 6.2 To add release information to other functions look at the diff in func_regex.xhp and adjust the release. It should be straightforward: <embed href="text/scalc/00/avail_release.xhp#M.N"/> where M is version and N is release. Patch tweaked to minimize translation effort (only one string) Change-Id: I4f5f826c936e65c1050a4d3b71379b53d50e0984 Reviewed-on: https://gerrit.libreoffice.org/68688 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-11-16tdf#121084 Help page for Calc REGEX functionOlivier Hallot
* honor DTD * follow erAck advise Change-Id: Ib911888fbc5aae9c4a749c9343218081df9f6783 Reviewed-on: https://gerrit.libreoffice.org/63430 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2018-10-02Reduce L10N workload for repetitive stringsOlivier Hallot
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 <olivier.hallot@libreoffice.org>
2018-09-04Refactor pages for string <-> numbers/refs/datesOlivier Hallot
Change-Id: I988850bd09ed2877bc98a3fda7ddff4b3ffbcff6 Reviewed-on: https://gerrit.libreoffice.org/59595 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
2018-06-02tdf#117933 help pages for MAXIFS,MINIFSOlivier Hallot
Change-Id: Ib0b27e4f00468b33a9a112ac0dc0967750570b18 Reviewed-on: https://gerrit.libreoffice.org/55143 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Sophia Schröder <sophia.schroeder@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-05-01tdf#106623 Write help page for PIVOT CHARTOlivier Hallot
+ Added example file + with inputs from Tomasz Vajngerl + remove a spurious character slipped in set 1 + fix DTD issue 01 Change-Id: I13ebce0241a2ae1e7dcac29945403607da0d1dfa Reviewed-on: https://gerrit.libreoffice.org/53692 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-24Add sample files for complex trigon functionsOlivier Hallot
Same sample file for all trignometric & hiperbolic complex functions. Minimal impact in translation Change-Id: I15e3a5388cfdef919e269274c255ccca6b07f987 Reviewed-on: https://gerrit.libreoffice.org/53340 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-02-20tdf#115440 Help page for ROUNDSIG function in CalcOlivier Hallot
With contributions of jag@psilosoph.de and dh_twriter@mail.ru Change-Id: I8885edd02fbe240cf9c287d085ea84da041b51dc Reviewed-on: https://gerrit.libreoffice.org/50061 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-09-24Placeholder for Calc 'data provider' help pageOlivier Hallot
Change-Id: I3238c9b6e02486289463990e17ed3c59ca856b06 Reviewed-on: https://gerrit.libreoffice.org/42717 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-09-24Placeholder for Calc 'data form' help pageOlivier Hallot
Change-Id: I134c0f9148854c23a1252bbcb2d85b43b3654dd2 Reviewed-on: https://gerrit.libreoffice.org/42711 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-09-24Placeholder for Calc 'XML source' help pageOlivier Hallot
Awaiting for more contents Change-Id: Ie43002a9abf255d81c7cd77fe5d453c490f7bdb5 Reviewed-on: https://gerrit.libreoffice.org/42710 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-09-24placeholder for Calc 'data stream' help pageOlivier Hallot
Awaiting for more contents Change-Id: Ia44adb3f25f26df5b2f0ec360ac9d0cc421d8fe3 Reviewed-on: https://gerrit.libreoffice.org/42709 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-04-24Correct WOKDAYS.INTL -> WORKDAY.INTLOlivier Hallot
Unit #117795772 from pootle Change-Id: Iced6c310194bbfa63d8607abd5002f7656de87e0 Reviewed-on: https://gerrit.libreoffice.org/36821 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2017-03-30tdf#106861 - fix Autoinput entry in menu, plusOlivier Hallot
- 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 <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2016-12-05tdf#101140 Adding Help for RAWSUBTRACT functionliongold
Change-Id: I8eba1c661a31766a5fd84489e4a7db46d5570f73 Reviewed-on: https://gerrit.libreoffice.org/31086 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2016-10-24tdf#80439 Help pages for (NET)WORKDAYS.INTLChandanathil P. Geevan
removed useless file replaced commas with semicolons in function expression Change-Id: I76ce8945d7f5d51f7b356dc8063db1b4623e905b Reviewed-on: https://gerrit.libreoffice.org/30217 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2016-03-09tdf#97021 Help pages for FORECAST.ETS functionsOlivier Hallot
Write help page for FORECAST.ETS.* Calc functions Change-Id: I4fc3a0f18bb09e033b011206c41bec841e0d01f5 Reviewed-on: https://gerrit.libreoffice.org/23093 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2016-02-18tdf#97807 Calc menu changes for inserting rows and columnsStanislav Horacek
Change-Id: I7eda4072001961c19ff6f502b71d76ac989f634a Reviewed-on: https://gerrit.libreoffice.org/22405 Reviewed-by: Olivier Hallot <ohallot@collabora.co.uk> Tested-by: Olivier Hallot <ohallot@collabora.co.uk>
2016-02-16tdf#95281 Help page for the SKEWP functionOlivier Hallot
Write help page for SKEWP spreadsheet function Change-Id: Ib7fc372bc2be4c55663a6ab58f488aa204631d20 Reviewed-on: https://gerrit.libreoffice.org/22322 Reviewed-by: David Tardon <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com>
2016-02-16tdf#95282 Help page for the COLOR functionOlivier Hallot
Write help page for COLOR spreadsheet functions Change-Id: I2a34cb2b1f25f3d0013a93dff320b70d76a1f4d6 Reviewed-on: https://gerrit.libreoffice.org/22300 Reviewed-by: David Tardon <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com>
2016-02-09tdf#96868 Help page for data statistics regressionOlivier Hallot
Change-Id: I7c0e236c1d19572b682d5b6c120ce604f6e39de8 Reviewed-on: https://gerrit.libreoffice.org/22144 Reviewed-by: Olivier Hallot <ohallot@collabora.co.uk> Tested-by: Olivier Hallot <ohallot@collabora.co.uk>
2016-01-08tdf#85433 help content for WEEKNUM, ISOWEEKNUM, WEEKNUM_EXCEL2003, WEEKNUM_OOOEike Rathke
Change-Id: I92995b4de6fe18d981757f0d273ddce5c11b1559
2015-10-26A description of trigonometric function IM*tagezi
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 <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2015-10-14Added description the ERROR.TYPE functiontagezi
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 <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
2015-10-10Added description COUNTIFS functiontagezi
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 <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2015-10-08Added description SUMIFS functiontagezi
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 <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2015-10-08Added discription AVERAGEIFStagezi
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 <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2015-10-03Added description and examples of the AVERAGEIF functiontagezi
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/18888 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
generated by cgit (git 2.34.1) at 2024-05-21 19:57:27 +0000