summaryrefslogtreecommitdiff
path: root/source/text/scalc/01
AgeCommit message (Collapse)Author
2018-01-03Fix typosAndrea Gelmini
Change-Id: I7ef82f8d2896f3687be1aacfd08b8cf0d0d6e105 Reviewed-on: https://gerrit.libreoffice.org/47273 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2018-01-03Fix typoAndrea Gelmini
Change-Id: I180510136adc14ff60f1474fbcf2365af7d5821e Reviewed-on: https://gerrit.libreoffice.org/47274 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2017-12-29Correction to the QUOTIENT spreadsheet function documentationMike Kaganski
If arguments have different signs, it isn't equivalent to INT(numerator/denominator). E.g., QUOTIENT(-3,14;1) gives -3, while INT(-3,14/1) gives -4. Change-Id: I1abe0a6bd77ba5f451844cf3e5c2ab2e021d7c96 Reviewed-on: https://gerrit.libreoffice.org/47171 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2017-12-25Fix <filename> root pathOlivier Hallot
The missing slash corrects the caculation of the <base> tag. Change-Id: I1d1affcaef8b69049452f67d5ec122f6722874c6 Reviewed-on: https://gerrit.libreoffice.org/47061 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-12-17tdf#40460 Improve help for Calc IRR functionOlivier Hallot
Change-Id: Ie61635f75ec8d208656623c61b31d1bc82c75663 Reviewed-on: https://gerrit.libreoffice.org/46625 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-12-13Fix even more typos in help pagesOlivier Hallot
Change-Id: Idbcae07c0807df54db3ba93ed66a9f881c5fa2e4 Reviewed-on: https://gerrit.libreoffice.org/46406 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-12-12Fix more typos in help pagesOlivier Hallot
Change-Id: Ie6af0ec57f921df31bcb096d12b9e8dd938c40ba Reviewed-on: https://gerrit.libreoffice.org/46337 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-12-12Fix Help pages typos.Olivier Hallot
Change-Id: I425e6ddc86c997b6e00b8e80c193ee6a7b6df4d3 Reviewed-on: https://gerrit.libreoffice.org/46335 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-12-11tdf#107601 rename t-test to Paired t-test in HelpOlivier Hallot
Note: The change in the interface is related to Data - Statistics - t-Test. Reference to Calc function =TTEST() are left unchanged. Change-Id: Ic83d177cbea14aa2fe49534cdf6bd363b0701d63 Reviewed-on: https://gerrit.libreoffice.org/46185 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-12-06tdf#83269 Help page for Calc Data->Form...Olivier Hallot
Change-Id: If182e61aec29a912faa7af8e3d0791d03fcf1aca Reviewed-on: https://gerrit.libreoffice.org/45937 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-12-05Display the same extended help for more widgetsGabor Kelemen
Change-Id: I76fe74a736ad01366ec8ffa05b49f0c4005e0c71 Reviewed-on: https://gerrit.libreoffice.org/45830 Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>
2017-11-14Related: tdf#113768 VDB change Type parameter opposite to NoSwitchEike Rathke
Change-Id: I9a603cb70f5922c83482da55fa797441bffab93c
2017-11-06Update references to 'Edit - Track Changes' submenu commandsGabor Kelemen
Since commit 37ad8daa these submenu commands have shorter names Remaining instances of the command names refer to window names and functions, this is why not all of them are changed. Change-Id: Ieff7776ad7975c1cfd389d58e6b95f344bc1a25d Reviewed-on: https://gerrit.libreoffice.org/44340 Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>
2017-11-03Correct the explanation for STYLE spreadsheet functionMike Kaganski
Change-Id: Ia0fedd0bc673f3090cf065ac578ef193d1d3b6b7 Reviewed-on: https://gerrit.libreoffice.org/44196 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2017-10-31Fix bookmarks in Fill Random Number pageGabor Kelemen
- Add missing ahelps and bookmarks - Fix menu path Change-Id: Ibf8b8775aa90922645fbc445ff5c987e5110c692 Reviewed-on: https://gerrit.libreoffice.org/44090 Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>
2017-10-31tdf#113249 Update Fill Sheets pageGabor Kelemen
- Fix page title and command location with plurals in menu command name - Extend description with information about pasted content location as requested in the bug report - Highlight the information that this works only with two or more selected sheets - Fix text pointing to the page Paste Special - Remove redundant bookmark Change-Id: Iaf700d1ed096ffff6a829e7bb32abd29a75365b7 Reviewed-on: https://gerrit.libreoffice.org/44088 Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>
2017-10-27Related: tdf#113455 update help to 'disable' the spinbuttons for special caseCaolán McNamara
now that there's a checkbox for the special 'clear' state rather than special empty spin button hackery to store this state Change-Id: I72756336a6c7fe68aec7efcf53e7b8dfb4c3d8d1
2017-10-24Better example of TRIM()Olivier Hallot
After translator suggestion (mbalabanov) Change-Id: I7d39b3ec1826c199e56cf31352782ab9295b31e8 Reviewed-on: https://gerrit.libreoffice.org/43762 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-10-11BESSELJ: if you state result is the same as above, it should be the sameChristian Lohmaier
4.33 is treated as 4 since the decimals are ignored, but for some reason help referenced a different value... Change-Id: I9c0a97516ff7b9eb713fcb6eea994a737687945b
2017-10-06remove empty strings (helpex warned)Andras Timar
Change-Id: I96a78fe8bf7f98b9728ddeeb4fa8b2ec622ab276
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-09-21tdf#108090 Clarify array separators in help pagesOlivier Hallot
Change-Id: I60ddea24020d5775a373b1a06b1bdfa8f33d3c5d Reviewed-on: https://gerrit.libreoffice.org/42571 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2017-09-01Rename Help CONVERT to CONVERT_OOO, CONVERT_ADD to CONVERT, tdf#69539Eike Rathke
UI function name wise this was already done for 5.3, see https://bugs.documentfoundation.org/show_bug.cgi?id=69539 So CONVERT actually matches the ODF definition and Excel and what the user expects. Change-Id: Ifdcbedc324dc5b4c8e43f2428a5c02dbe97d48c0
2017-08-21tdf#107040 Calc: help for SUBTOTAL indexes 101-111Olivier Hallot
Change-Id: I90ad83a574748597553bb58c5436343b84947395 Reviewed-on: https://gerrit.libreoffice.org/41359 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2017-08-15tdf#111651 'Styles and Formatting' -> 'Styles'Olivier Hallot
Change-Id: Ic4db58aa04d21c514987cdbeaed5d11292d79b85 Reviewed-on: https://gerrit.libreoffice.org/41103 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2017-07-20Mute some l10n stringsOlivier Hallot
Change-Id: I3e263434d9881d3a7a6a20bbe0a5a85878fd1081 Reviewed-on: https://gerrit.libreoffice.org/40103 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2017-07-16fix command in Detective for automatical refreshing of tracesStanislav Horacek
Change-Id: I17d733ee55e0908d27c3d4ecc58237b8858dcd73 Reviewed-on: https://gerrit.libreoffice.org/40006 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2017-07-03tdf#108871 Fix embed of RAWSUBTRACT in HelpOlivier Hallot
Fix also COLOR. Change-Id: I159b20f36e1452864fa466584ff2de283251f11c Reviewed-on: https://gerrit.libreoffice.org/39458 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2017-06-26Expand some useless “MS” abbreviations to “Microsoft”Adolfo Jayme Barrientos
Abbreviations should be used only when we lack space (e.g., in UI), but there’s plenty of it here Change-Id: Ib0ac97b2003ca96e4bc286a1a1436bda0f81bd8a
2017-05-30Mass remove excess spaces from inside tagsGabor Kelemen
This is fallout from the l10n and oldref attribute removal. Some tags were broken into two rows and the second was indented with spaces. The line break was removed along the tags, but those spaces were not. Command I used to catch these: find source/text/ -name "*xhp" | xargs sed -i -e 's#\" *>#\">#g' Change-Id: I6f9bad46cbfb7416950bee8230e358a3dd851def Reviewed-on: https://gerrit.libreoffice.org/37791 Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> Tested-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
2017-05-18Fix several mistakes flagged by translatorsOlivier Hallot
Change-Id: If2e081fa32ec82250514c59d820adb5fa071669b Reviewed-on: https://gerrit.libreoffice.org/37743 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2017-05-17switchinline still is no valid child of "item" or "emph"Christian Lohmaier
Change-Id: I175560732e50bbf96f652a77a7674e7283b3583c
2017-05-17readd woraround for nested lists to be valid against DTDChristian Lohmaier
thus partial revert of 2e141341684eb610834db92693d715f3fd01d0dd Change-Id: I9909c267286e22623283f343f26e1ac36473c602
2017-05-12adjust image paths after moving helpimg into more appropriate folderKatarina Behrens
Change-Id: Idcfa3700bfd53d38ddeda484828f00bf36cf3b57 Reviewed-on: https://gerrit.libreoffice.org/32104 Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> Tested-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
2017-05-09remove obsolete oldref attribute (removes one context line in pot)Christian Lohmaier
also remove obsolete l10n attribute (doesn't affect translations/pot) Change-Id: I809866ea7b16cb1cacad9efacb6fdeebae38ea9f
2017-05-08Make wording clearerIlmari Lauhakangas
Change-Id: I5423b72f9f612749ca4dc92c4740915c4c6d0597 Reviewed-on: https://gerrit.libreoffice.org/37299 Reviewed-by: Katarina Behrens <Katarina.Behrens@cib.de> Tested-by: Katarina Behrens <Katarina.Behrens@cib.de>
2017-05-03tdf#103431 HELP Bessel functions need examplesOlivier Hallot
Change-Id: Id564a07c9f5db0e3203d6ebfe5c9f3c2ea425fb4 Reviewed-on: https://gerrit.libreoffice.org/37182 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2017-05-03tdf#103457 link UNICODE() to UNICHAR() in HelpOlivier Hallot
Change-Id: I80f7bdf22dc302b8bb8cab1cd278b06989a14f6b Reviewed-on: https://gerrit.libreoffice.org/37181 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2017-05-03tdf#100410 Update help page for WEEKDAY()Olivier Hallot
Change-Id: I115a5a7543c44bccc22f77065725c5d708fe24dd Reviewed-on: https://gerrit.libreoffice.org/37177 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
2017-04-25Fix reference to UI layoutGabor Kelemen
Change-Id: I11a79ea1c3598ac7b4b75769331f113358b73324 Reviewed-on: https://gerrit.libreoffice.org/36925 Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>
2017-04-25This doesn't need to be hidden.Gabor Kelemen
Currently a heading without description is shown. Let's show the description too. Change-Id: I34ee6ee98cddfd25f9cce01a63756ef7bac83e68 Reviewed-on: https://gerrit.libreoffice.org/36924 Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>
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-04-10update help ids for .ui conversionCaolán McNamara
Change-Id: I2dc481b16b2af15682bbd5e504892eff679f8699
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>
2017-03-02tdf#60874 (partial) Show correct page from "Protect Document" windowGabor Kelemen
The bookmark for the Password entry was used on the wrong page. This needed to be moved over and the entry description set up as extended help. A new help ID was needed to be added to the Confirm entry with an accompanying extended help. Hidden, as this page is rather a howto and not a window description (thankfully). Change-Id: I6583f8708cd4c0b0891ead7067ce486153dd2be1 Reviewed-on: https://gerrit.libreoffice.org/34502 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Eike Rathke <erack@redhat.com>
2017-01-23Fix ahelp of 'Sheet from file' menu commandGabor Kelemen
Remove a duplicate bookmark too Change-Id: Icfb63d1edc750759fa0f0805f8e83bee8dc29a95 Reviewed-on: https://gerrit.libreoffice.org/33405 Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>
2017-01-20Fix Calc Group pageGabor Kelemen
Fix bookmarks, ahelps and the menu path for the Ungroup action Change-Id: Ia8e66fb00f580e562f7abd2546666f8d74a06ab4 Reviewed-on: https://gerrit.libreoffice.org/33331 Reviewed-by: Gabor Kelemen <kelemeng@ubuntu.com> Tested-by: Gabor Kelemen <kelemeng@ubuntu.com>