summaryrefslogtreecommitdiffstats
path: root/AllLangHelp_scalc.mk
Commit message (Collapse)AuthorAgeFilesLines
* tdf81599 Better Help pages for Calc SolversOlivier Hallot2020-05-221-0/+1
| | | | | | | | | 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>
* tdf#131960 Clarification of FLOOR functionsSteve Fanning2020-04-091-0/+1
| | | | | | | | | + 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>
* tdf#131960 Clarification of CEILING functionSteve Fanning2020-04-091-0/+1
| | | | | | | | | + 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>
* tdf#126923 Add guide for subtotals toolOlivier Hallot2020-03-261-0/+1
| | | | | | | Change-Id: I941214be272d6e959c1129b074891bb6f229ba26 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91079 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Refactor Data analysis Calc help pageOlivier Hallot2020-03-201-0/+11
| | | | | | | | | 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>
* Review, refactor Calc Data Menu Help pagesOlivier Hallot2020-03-201-0/+1
| | | | | | | | | | | - 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>
* tdf#92084 Help Pages for OPT_* Calc functionsSteve Fanning2019-11-301-0/+4
| | | | | | | | | | | 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
* Add FINDB, SEARCHB and REPLACEB Help pageslibreoffice-6-4-branch-pointOlivier Hallot2019-11-121-0/+3
| | | | | | | Change-Id: Ie8a7c5762f41484d36837008226cc446584e3110 Reviewed-on: https://gerrit.libreoffice.org/82481 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Add Help for FOURIER calc function and analysisOlivier Hallot2019-07-021-0/+2
| | | | | | | | | | | | | 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>
* tdf#99517 help for CONCAT, TEXTJOIN, IFS, SWITCHOlivier Hallot2019-04-271-0/+4
| | | | | | | | | 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>
* tdf#123803 Add relelase info in Calc functionsOlivier Hallot2019-03-041-0/+1
| | | | | | | | | | | | | | | | | | | 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>
* tdf#121084 Help page for Calc REGEX functionOlivier Hallot2018-11-161-0/+1
| | | | | | | | | | * 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>
* Reduce L10N workload for repetitive stringsOlivier Hallot2018-10-021-0/+1
| | | | | | | | | | 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>
* Refactor pages for string <-> numbers/refs/datesOlivier Hallot2018-09-041-1/+0
| | | | | | | Change-Id: I988850bd09ed2877bc98a3fda7ddff4b3ffbcff6 Reviewed-on: https://gerrit.libreoffice.org/59595 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
* tdf#117933 help pages for MAXIFS,MINIFSOlivier Hallot2018-06-021-0/+2
| | | | | | | | 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>
* tdf#106623 Write help page for PIVOT CHARTOlivier Hallot2018-05-011-0/+6
| | | | | | | | | | | | + 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>
* Add sample files for complex trigon functionsOlivier Hallot2018-04-241-0/+1
| | | | | | | | | | | | 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>
* tdf#115440 Help page for ROUNDSIG function in CalcOlivier Hallot2018-02-201-0/+1
| | | | | | | | | | | 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>
* Placeholder for Calc 'data provider' help pageOlivier Hallot2017-09-241-0/+1
| | | | | | | 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>
* Placeholder for Calc 'data form' help pageOlivier Hallot2017-09-241-0/+1
| | | | | | | 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>
* Placeholder for Calc 'XML source' help pageOlivier Hallot2017-09-241-0/+1
| | | | | | | | | 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>
* placeholder for Calc 'data stream' help pageOlivier Hallot2017-09-241-0/+1
| | | | | | | | | 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>
* Correct WOKDAYS.INTL -> WORKDAY.INTLOlivier Hallot2017-04-241-1/+1
| | | | | | | | | 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>
* tdf#106861 - fix Autoinput entry in menu, plusOlivier Hallot2017-03-301-1/+0
| | | | | | | | | | | - 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>
* tdf#101140 Adding Help for RAWSUBTRACT functionliongold2016-12-051-0/+1
| | | | | | | 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>
* tdf#80439 Help pages for (NET)WORKDAYS.INTLChandanathil P. Geevan2016-10-241-0/+3
| | | | | | | | | | 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>
* tdf#97021 Help pages for FORECAST.ETS functionsOlivier Hallot2016-03-091-0/+8
| | | | | | | | | 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>
* tdf#97807 Calc menu changes for inserting rows and columnsStanislav Horacek2016-02-181-0/+1
| | | | | | | 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>
* tdf#95281 Help page for the SKEWP functionOlivier Hallot2016-02-161-0/+1
| | | | | | | | | 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>
* tdf#95282 Help page for the COLOR functionOlivier Hallot2016-02-161-0/+1
| | | | | | | | | 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>
* tdf#96868 Help page for data statistics regressionOlivier Hallot2016-02-091-0/+1
| | | | | | | 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>
* tdf#85433 help content for WEEKNUM, ISOWEEKNUM, WEEKNUM_EXCEL2003, WEEKNUM_OOOEike Rathke2016-01-081-0/+2
| | | | Change-Id: I92995b4de6fe18d981757f0d273ddce5c11b1559
* A description of trigonometric function IM*tagezi2015-10-261-0/+11
| | | | | | | | | | | 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>
* Added description the ERROR.TYPE functiontagezi2015-10-141-0/+1
| | | | | | | | | | | | 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>
* Added description COUNTIFS functiontagezi2015-10-101-0/+1
| | | | | | | | | | | 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>
* Added description SUMIFS functiontagezi2015-10-081-0/+1
| | | | | | | | | | | 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>
* Added discription AVERAGEIFStagezi2015-10-081-0/+1
| | | | | | | | | | | | | | 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>
* Added description and examples of the AVERAGEIF functiontagezi2015-10-031-0/+2
| | | | | | | | | | | | | | | 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>
* tdf#85228 Added description of AGGREGATE functiontagezi2015-09-291-0/+1
| | | | | | | | | | | | UPD: Changed in accordance with the comment of Regina (10:36 PM) UPD: Corrected separators in the syntax UPD: set up tags <item> Change-Id: I05993ffec8af8dd1e997b3d2ae92ba0226b1bf28 Reviewed-on: https://gerrit.libreoffice.org/18821 Reviewed-by: Regina Henschel <rb.henschel@t-online.de> Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
* tdf#92825 Fix calc's main menubar entriesYousuf Philips2015-09-061-0/+1
| | | | | | | Change-Id: I573b25efe928883f140bdeb127aaa9b7c7436bbc Reviewed-on: https://gerrit.libreoffice.org/18356 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
* Promote ODF Formula standard in Calc function helpOlivier Hallot2015-07-081-0/+1
| | | | | | | | | | | 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 <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
* fdo#86637 (part) OpenCL options help pageOlivier Hallot2015-01-051-0/+1
| | | | | | | Change-Id: I8adfb122226d4eb4dd4342673b6707ecc1015bf9 Reviewed-on: https://gerrit.libreoffice.org/13702 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
* Fix FDO#80441 Help pages for WEBSERVICES functionOlivier Hallot2014-09-131-0/+1
| | | | | | | | | | Also FILTERXML. Many thanks to Leif Lodahl for the help Change-Id: I241610db69eab0cc2490492520288bc6b154c21b Reviewed-on: https://gerrit.libreoffice.org/11435 Reviewed-by: Thomas Arnhold <thomas@arnhold.org> Tested-by: Thomas Arnhold <thomas@arnhold.org>
* FDO#80453 Help page for Edit-Fill-Random NumbersOlivier Hallot2014-08-241-0/+1
| | | | | | | | | Help page for Calc's Edit - Fill - Random numbers Change-Id: Iab6c86f77d5bdc170af2e6cdf208470b0ce1db9f Reviewed-on: https://gerrit.libreoffice.org/11097 Reviewed-by: Joren De Cuyper <jorendc@libreoffice.org> Tested-by: Joren De Cuyper <jorendc@libreoffice.org>
* Fix fdo#80338 Help pages for Data StatisticsOlivier Hallot2014-08-221-0/+1
| | | | | | | | | | 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 <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
* Partial fix for fdo#80338: help for calc statisticsOlivier Hallot2014-08-041-0/+1
| | | | | | | | | 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 <dtardon@redhat.com> Tested-by: David Tardon <dtardon@redhat.com>
* Fix fdo#80656. Help for NUMBERVALUE Calc functionOlivier Hallot2014-06-301-0/+1
| | | | | | | Change-Id: Iab3c6e2a82162f5b6cbd1a2e80e76e7df36b2042 Reviewed-on: https://gerrit.libreoffice.org/9959 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
* gbuildize helpcontent2David Tardon2013-02-261-0/+338
dmake is dead, long live gbuild! Change-Id: I636ea4ed7ee08a748b96973ae076a5e47928d4ca