summaryrefslogtreecommitdiff
path: root/source/text/scalc
AgeCommit message (Collapse)Author
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-08-27Refactor help page on empty cellsOlivier Hallot
Change-Id: I8bff8e56804fae90a71fb35c0a67b015356c2138 Reviewed-on: https://gerrit.libreoffice.org/59585 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-08-27Review date and time functions help pagesOlivier Hallot
fix some formatting issues Add note and warning on date parsing Mute l10n in some tables with constants Change-Id: I86b4e7651ac89e2d2c8e2e658a8bdfd8f185ab60 Reviewed-on: https://gerrit.libreoffice.org/59582 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-08-23tdf#119009 Clarify DATEDIF date parsingOlivier Hallot
Change-Id: Ia0fa5110beb5914f7acb70046ef09e337f2fb30d Reviewed-on: https://gerrit.libreoffice.org/59406 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-08-17Add MACOSX for =INFO("system")Olivier Hallot
Change-Id: I23bd4706bf7f0eba4334e15c21e750b2f2cf2883 Reviewed-on: https://gerrit.libreoffice.org/59266 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-08-17Mute l10n in numeric table and InfoType stringsOlivier Hallot
Numeric cell are not to be translated InfoType either. Change-Id: I320b78c2c84212ece5c080e47c78cef2550ae066 Reviewed-on: https://gerrit.libreoffice.org/59263 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-08-16Fix excel syntax descriptionMike Kaganski
Change-Id: Iaaf38a33373eb910785a4a5d1fc45649523726e9 Reviewed-on: https://gerrit.libreoffice.org/57897 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-08-01Revert "tdf#118187 Text for INDIRECT() in wrong place"Mike Kaganski
... and clarify the context in the example instead. This reverts commit 184324625ea1e803007b9c41ce625ae6014573f1. Change-Id: Ie51c3b960a2262e5751bdecf86ba4e174f369fff Reviewed-on: https://gerrit.libreoffice.org/57899 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-07-23Fix a typo found by Andrea GelminiSophia Schröder
-reformatting part Change-Id: If12a0361a9b47878b7df0f562154931437e59fc6 Reviewed-on: https://gerrit.libreoffice.org/57827 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-07-11tdf#118314 Delete help content related to obsolete “Input Method Status” ↵Adolfo Jayme Barrientos
feature Change-Id: Ie80279915e3ee9a123204a729325ca9e119ab6bb Reviewed-on: https://gerrit.libreoffice.org/57224 Tested-by: Jenkins Reviewed-by: Tomaž Vajngerl <quikee@gmail.com>
2018-06-23Improve 'IFS documentationOlivier Hallot
COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS Improve collateral file Change-Id: I0573b4df1b7fdc5b656100756e98468bc2a0edf7 Reviewed-on: https://gerrit.libreoffice.org/56310 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-06-17tdf#118187 Text for INDIRECT() in wrong placeOlivier Hallot
Change-Id: Ia6b37858c79940ce95467345bd96d22c8fe4737c Reviewed-on: https://gerrit.libreoffice.org/55945 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-06-11tdf#116642 Fix COUNTIFS page + help makefilesOlivier Hallot
+ Add callateral file for COUNTIFS + Adjust makefiles + some tweaks in XSLT + adjust languages to gb_HELP_LANGS. Change-Id: I9d2684d20804b93fd0671621d28a8d786a101fdf Reviewed-on: https://gerrit.libreoffice.org/55493 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-06-06Cleanups and improvementsSophia Schröder
Help files in scalc/00/ Change-Id: I55ffb4961fb5614f75fbc3e71dd50b461dff17de Reviewed-on: https://gerrit.libreoffice.org/54603 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-06-04Better use of embed for similar contentsOlivier Hallot
Save translation work for 'IFS functions Change-Id: I7e9c9fa9d84419f4faf28622be818eb7f2fe6d2a Reviewed-on: https://gerrit.libreoffice.org/55211 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
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-20More punctuation fixesSophia Schröder
Change-Id: Ia38e862e5a1dc2f225f8c6f8928f35aeba440683 Reviewed-on: https://gerrit.libreoffice.org/54549 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-05-15Fix external reference to blog post on pivot chartsOlivier Hallot
Change-Id: Icabfdcce2ae18848793bd467fd606e20afa97f5f Reviewed-on: https://gerrit.libreoffice.org/54347 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-05-12Grammar: subject–verb agreementAdolfo Jayme Barrientos
We don’t suffix “-s/-es” to verbs that refer to a subject in the third-person plural. Change-Id: I6fd90814bd63d618c8af4e625d38c6ee9895f919
2018-05-08Refactor help files with sample files embeddedOlivier Hallot
Change-Id: I46d1147b2a6db931914d332ba6004d1b23b4ea65 Reviewed-on: https://gerrit.libreoffice.org/53954 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-05-06De-dup object IDOlivier Hallot
Just in case ... Change-Id: I3950fe9f75b26c9c2cd458048c1eafb326ed488e Reviewed-on: https://gerrit.libreoffice.org/53714 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-05-04Remove duplicate HIDs added by script - from scalcGabor Kelemen
To improve readability of xhps Also fix some ahelps with multiple bookmarks Change-Id: Ia3394344ac8b0bdca78ce4c1aebef8d827d8313c Reviewed-on: https://gerrit.libreoffice.org/53854 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>
2018-05-01Add more links between pivot tables and chartsOlivier Hallot
Fix id duplicity Change-Id: I72520764bcf68f25299a05be619b8624d5ca5d1c Reviewed-on: https://gerrit.libreoffice.org/53697 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-05-01Refactor inter-page linksOlivier Hallot
+ reduce translation work Change-Id: I9d6025186f2769981ccac9bd9ec8cfcd00c83f07 Reviewed-on: https://gerrit.libreoffice.org/53694 Tested-by: Jenkins <ci@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-29Fix ahelps on the Scenario pageGabor Kelemen
Two bookmarks => ahelp must be a dot Change-Id: Ieaf8b794faf4705f8c72a9c3faf9a431a75d4029 Reviewed-on: https://gerrit.libreoffice.org/53573 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-24Formatting in help text, further corrections.Sophia Schröder
Change-Id: I7950ef7267129d111bb5c63fc9b962fd80e13131 Reviewed-on: https://gerrit.libreoffice.org/53385 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-04-24paragraph IDs need to be unique...Christian Lohmaier
Change-Id: Id44418c90ee071cd98f20ecfa0296b06292d3343
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-04-24Add sample file for trigonometric functionsOlivier Hallot
Change-Id: I2645a468dfffdd53a1eaf1b96e18cee097f34c2a Reviewed-on: https://gerrit.libreoffice.org/53368 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-23Improve formatting in help text.Sophia Schröder
Change-Id: I873128ed6353caf37f063a87361bd0a6f7c79f96 Reviewed-on: https://gerrit.libreoffice.org/53321 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-23Fix bookmark weird placementOlivier Hallot
Change-Id: Ia7b087ddc78f84097310e5644b91385737e9e692 Reviewed-on: https://gerrit.libreoffice.org/53302 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-23Fix in conditional format help page external linkOlivier Hallot
Change-Id: Id70b5549c02abaa650c9d8ba8c9a23872b7f2f33 Reviewed-on: https://gerrit.libreoffice.org/53301 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-23Fix example for ROUNDSIGOlivier Hallot
Change-Id: I35699a995e8c6b751337d90e471f258f0c55bb16 Reviewed-on: https://gerrit.libreoffice.org/53300 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-23More punctuation fixesSophia Schröder
Change-Id: I02ffc730b03d696a70c192b5824534fde81f64a1 Reviewed-on: https://gerrit.libreoffice.org/53256 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-16replace http links with https equivalentsdennisroczek
* mainly http://wiki.documentfoundation.org * http://en.wikipedia.org * http://api.libreoffice.org Change-Id: I3587d8d5e6a6de4a7c7013920b9e135e4adc977c Reviewed-on: https://gerrit.libreoffice.org/52354 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-12tdf#94438 disambiguate bookmark branches (iii)Olivier Hallot
Change-Id: I4953a00750c9f7a5aa65aff01232a66e0ad360fc Reviewed-on: https://gerrit.libreoffice.org/52799 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-12tdf#94438 Fix dup bookmark branchesOlivier Hallot
Part 1, Calc files Change-Id: I9a3c1d8f6afac7e693590be9220e811b07d6fd28 Reviewed-on: https://gerrit.libreoffice.org/52793 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-10fix validation errorsChristian Lohmaier
Change-Id: I0288d52b4420b2be76a136cbd34b1fee87f1cf71 Reviewed-on: https://gerrit.libreoffice.org/52686 Tested-by: Jenkins <ci@libreoffice.org> Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
2018-04-10Fix path for a bookmark. Add hid/ where missing.Olivier Hallot
Change-Id: Ia0fdd57add10f5f934f1e34c67b49fb736733bd6 Reviewed-on: https://gerrit.libreoffice.org/52652 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-04-09Fix typos in helpSophia Schröder
Fix double spaces in text, change "it's" to "it is" like mentioned by Adolfo. Change-Id: Ie1008663a87680583ee58775f64260b5c3bbe8c4 Reviewed-on: https://gerrit.libreoffice.org/52558 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-04-09scalc: cleanup markup and whitespaceSophia Schröder
Change-Id: Id279950e7b50f46a55784153ce7faf1fddf6b6b1 Reviewed-on: https://gerrit.libreoffice.org/52531 Reviewed-by: Thorsten Behrens <Thorsten.Behrens@CIB.de> Tested-by: Thorsten Behrens <Thorsten.Behrens@CIB.de>
2018-04-09Fix typo in helpSophia Schröder
Double space in text. Change-Id: I981556d796ab7b0fcc249c7c2a58b38899ebf635 Reviewed-on: https://gerrit.libreoffice.org/52557 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-04-09scalc: cleanup markup and whitespaceSophia Schröder
Change-Id: I5de820f3ce4d12bf4e3aca7846c7edd33fe1616f Reviewed-on: https://gerrit.libreoffice.org/52538 Reviewed-by: Thorsten Behrens <Thorsten.Behrens@CIB.de> Tested-by: Thorsten Behrens <Thorsten.Behrens@CIB.de>
2018-04-03tdf#116241 Customizing value highlighting colors -- help textAndras Timar
Change-Id: I60ee785b814eb3bd12dff21e3bb46a32eb790eea Reviewed-on: https://gerrit.libreoffice.org/52291 Reviewed-by: Andras Timar <andras.timar@collabora.com> Tested-by: Andras Timar <andras.timar@collabora.com>
2018-04-02Removed commentsAndrea Gelmini
Change-Id: I5917f9c4b49a06937f5d7ab5ecf1551953dc7875 Reviewed-on: https://gerrit.libreoffice.org/52229 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-03-22tdf#105562 Correct page for AND/OR logic functionOlivier Hallot
Change-Id: I2dcc976e2ea090da68d4d8389c58847f6c6fb082 Reviewed-on: https://gerrit.libreoffice.org/51744 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-03-22Add vnd.oasis.opendocument.* objects in new helpOlivier Hallot
Add capability to link ODF files in help page as objects Files are stored in media/files/ folder Example in func_imsin.xhp Change-Id: I4704e3cc235fd31251f3a4dba403e62f2ef1de0e Reviewed-on: https://gerrit.libreoffice.org/51721 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-03-21Deploy videos in New Help (WIP)Olivier Hallot
Add YouTube videos in New help. add makefile NOTE: <object> is not rendered in old help. NOTE2: Removed online objects from offline help Change-Id: I829fe1858002a454417d36d0651fe49097e008d4 Reviewed-on: https://gerrit.libreoffice.org/51679 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2018-03-20tdf#80367 Help page for Calc XML SourceOlivier Hallot
With contribution of Kohei, from https://wiki.documentfoundation.org/Development/Calc/XMLSource Change-Id: I363f864069cf42c0893ceb1402f26c9c1dc186a5 Reviewed-on: https://gerrit.libreoffice.org/51645 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
generated by cgit (git 2.34.1) at 2025-03-11 19:14:44 +0000