summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2020-04-09tdf131416 Let/Set statements joint Syntax diagramLibreOfficiant
- Call diagram update to better reflect optional parms - Resume diagram added by anticipation, in order to prevent merge conflict with patch #91712 Change-Id: I82d3ea4ac5af581462e919696a53d91868b6fdd2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91709 Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-09Variable insertions for future page embedsLibreOfficiant
"Relatedtopics" with x-refs to come after Change-Id: Ic6d58f4e338ea2ddcbba7f063be9dafce34eb914 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91178 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-04-08Precise Call statement optionsLibreOfficiant
- Document keyword args as opposed to positional args - Explicit parentheses/brackets usage - Display DLLs stuff under Win context ..not so certain this is needed in light of Mono/Linux mixed env. Change-Id: Iee2f0088e3a560212bb6f2dd15e76b95ba652d48 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91706 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-06tdf#131357 adjust Calc functions paramsSteve Fanning
Fixes CHISQINV, GAMMA Change-Id: If7ac0c74b5301bf3e460aa8caef68b0df01f4747 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91735 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-06tdf#131362 Adjust number of function paramSteve Fanning
Fix DISC, DURATION, MMULT, RECEIVED, DAYS360 Change-Id: Ie2c226a24716e79806618af889ecc5b4c6c10c7f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91731 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-03Mute L10n on headingOlivier Hallot
Change-Id: Id5449b2dd49a32b5d76e4cac71768147f3a0e98f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91624 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-03update variable name in Field help pageSeth Chaiklin
Change-Id: I0b383bc1c59f1627549844f998dfa0389053434a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91518 Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk> Tested-by: Jenkins
2020-04-02VBA Err objectLibreOfficiant
- Handling exceptions or Throwing them w/ Basic A limited set of VBA ERR object properties & methods are exhibiting useful features. This page document that subset. Change-Id: I98726a6ffbce370b81f1a26daa35a8a1bf3dc57c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91177 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-01Call statement syntax diagramLibreOfficiant
Change-Id: Ia4cae7ee6078cf056b50009f73f8d545dc1b0384 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91506 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-01tdf#131711 there are two help pages for the index dialog which has two modesCaolán McNamara
so at runtime suffix the two different widget descriptions depending on their mode and suffix the separate help pages for the widgets Change-Id: I40903c30d69f79ef86c15e0c26f71d6cf8c9d836 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91497 Tested-by: Jenkins Reviewed-by: Caolán McNamara <caolanm@redhat.com>
2020-04-01tdf#130360 Minor adjustments on complex numbers.Steve Fanning
Change-Id: I392d672e31940aa2bb1ca12c09e6496ee8c43700 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91485 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-04-01tdf#131360 Adjust number of function param (2)Steve Fanning
Fix for GETPIVOTDATA, IMPRODUCT, IMSUM Change-Id: I4c8e7600d53a2010b85d1387f7f368a5b6cee79a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91456 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-30tdf#131360 Adjust number of function parametersSteve Fanning
fix for AGGREGATE, GCD_EXCEL2003, LCM_EXCEL2003 MULTINOMIAL, RAWSUBTRACT, SUMIFS, AVERAGEIFS, COUNTIFS, MAXIFS, MINIFS, IFS, SWITCH Change-Id: Id652cdf52a795cd675e7717f856a2745be7d9f52 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91373 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-30Remove empty heading.Olivier Hallot
Change-Id: Icca557cbe9ebcfe5004e1707835ecf4fdfbd5a05 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91365 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-26tdf#131361 Adjust number of function parameters (3)Steve Fanning
Fix for STDEV, STDEV.P, STDEV.S, STDEVA, STDEVP, STDEVPA, VAR, VAR.P, VAR.S, VARA, VARP, VARPA, AND, OR, XOR, SUMPRODUCT, CONCATENATE Change-Id: I869f6d7fc687e645b9ee8c0ca36ff690c4108db3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91103 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-26tdf#131361 Adjust number of function parameters (2)Steve Fanning
Fixes for MAX, MAXA, MEDIAN, MIN, MINA, MODE, MODE.MULT MODE.SNGL, SKEW, SKEWP Change-Id: I2a8727611cf0f9cfeed9f7dbcd88751c81090e46 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91077 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-26Clarify TEXT spreadsheet function's first parameter (not only number)Mike Kaganski
Change-Id: Icf5c8a6ff2fe5f9238afdb9c35e22eb91937f778 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91106 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
2020-03-25tdf#131361 Adjust number of function parametersSteve Fanning
Fixes for SUM, SUMSQ, NPV, AVEDEV, AVERAGE, AVERAGEA COUNT, COUNTA, DEVSQ, KURT Change-Id: I1227064ed343ccccd5a339cce7425b5143072537 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91013 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-25Correct arguments for TEXTJOINOlivier Hallot
Total number of arguments in CALC functions is 255, therefore if some params are specific, adjust the remaining to sum 255. Change-Id: I2ac5a46f225ef6727165b5799ae551f35eb5f4e9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91009 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-24README: Add Weblate badge for helpcontent2 l10nAdolfo Jayme Barrientos
Change-Id: Ieb89f42e51a04bfa73732a779a92b79a755bc644
2020-03-24Fix to Property misleading snippetLibreOfficiant
Change-Id: Ie96f829d21384a9adab81e9b007d0773c035b97c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90948 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-21tdf#91313 Update Paste Special new featuresOlivier Hallot
- add Paste Nested Table, Columns Before, Rows Above - add Paste Only Text, Number, Formula - Refactor Paste Special <switch> for Calc Change-Id: I56547db917863aca2402191bef934c2bba5ff619 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90864 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-20tdf#131361 Correct param's GCD, LCM, PRODUCTSteve Fanning
- Also re-label sections to a better mnemonic id's Change-Id: I7b54216891116e9e9bb515d20218955b3d92fff9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90848 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>
2020-03-19tdf#131361 Correct upper limit to 255Olivier Hallot
Change-Id: Ib174181e6e750a5a9a6721b0ea86d3ba2575cb0c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90748 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-19Apply correct style for table head in page (2)Olivier Hallot
Change-Id: I7af01680868e263579a681ff34f1bdd3ac07b8ad Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90727 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-19Apply correct style for table head in pageOlivier Hallot
Change-Id: I042e1ee043a9dc2034f9fa9c77100286cad02770 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90726 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-19tdf#131036 add note on "rename" and "delete" and update gradient helpSeth Chaiklin
-added <note> about "rename" and "delete" option on Gradient -move "Add" and "Modify" together with Gradient and <note> -change to <h1>, <h2>, <h3> -removed point about "loading gradient lists" -Add headings and explanations for "Gradient" and "Options" -update option names "To Color" and "From Color" -update "Preview" label -add "Apply" option (for Writer) Change-Id: Iec0f29f8278e3be9dea47c69e76db3580a83e4a5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90636 Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2020-03-18tdf#131360,tdf#131361 (part) 256 argumentsOlivier Hallot
- update argument limit from 30 to 256 - create embeddedable text reusable for many functions listed in tdf#131360 and tdf#131261 when arguments are strings, integes, numbers, logicals, complex and references - with reduced translation job - fixes CONCAT, TEXTJOIN and CONCATENATE with String arguments. Change-Id: I8a32914c5ef31d796a21cf2ee705b92de7b58f90 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90613 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-18tdf#131036 add note to Hatch help page about "rename" and "delete"Seth Chaiklin
There is no indication on the Hatch tab in the Area page that it is possible to name/rename and/or delete existing hatch patterns. Adding a <note> about this possibility. Also add "howtoget" access command for Page/Slide in Writer/Draw/ Impress. (Calc does not have Hatch for a Sheet). Add missing period in first line. Change-Id: I414c2c0527b916d24e8703915dc9ca1208342fc0 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90633 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
2020-03-18o Property statement added in Procedures & Functions helpLibreOfficiant
o Multiple layout changes Note: Optional keyword to be referenced later in above help o ByVal/ByRef added to Property help page Change-Id: I30e84c1e7464b4bc101727d2d088a35173f74b34 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/89282 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-17Update icon replacement table for HelpOlivier Hallot
Change-Id: I8295bda6fcb041811b73186a6a64346f4d374ea7 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90574 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-17remove an errant parenthesis in an <embedvar>Seth Chaiklin
Change-Id: I4fa4738cc5f034455a4c5346760f14a57ef0c6d9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90630 Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk> Tested-by: Jenkins
2020-03-15tdf#102517 Chemical formulas in MathOlivier Hallot
Added some examples of chemical formulas in Math Help Change-Id: I5a0400e521ef5bf2264e5ee99e8844c7bc440046 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90533 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-14more cleanup in help page for field variablesSeth Chaiklin
- move some <embedvar> into a <note> for "Numbering by Chapter" "Level" and "Separator" Change-Id: I2e72c4e711c1e7d1e85c78fd344f6b471ee5947f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90392 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk> Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-14Slide Design command and dialog was renamedIlmari Lauhakangas
Change-Id: Icc7379d1c1204f203f011bea512614d72836fe0a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90130 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-14Fix error reported by translators.Olivier Hallot
Change-Id: I475d2f5dea0cdbabbbac9cf31613c29f3c9f015a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90483 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-12Helponline: Make that image shadow look not tackyAdolfo Jayme Barrientos
Change-Id: I7e0b370ad883e787a8c7b7970d8d96653e577f8e
2020-03-12Remove line breaks from translatable string 🤦‍♂️Adolfo Jayme Barrientos
Problem reported by Steen Rønnow at Weblate. Change-Id: I7f0dd381e36d0349d83d2db3f774a8cc86487a2d
2020-03-12tdf#128494 Change Spellcheck to SpellingIlmari Lauhakangas
1098fba99acb8c8cc7e87c55ece12ef175593147 left Help in a broken state. Change-Id: Ie8d8f6506a6634fefce875590fe54fa2e477c82a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90060 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-12corrections and clarifications on help page for field VariablesSeth Chaiklin
- correction of "Chapter by Numbering" name - add indications of when certain options appear for different options. - add "DDE Statement" (and embed explanation from "Section") - move warning to more appropriate place - <h1>, <h2>, <h3>, <warning> - add <section> and <variable> in Cross-references help page so they can be embedded for Name"into Variables page. - add <section> in Section help page about DDE to embed in Variables. - remove unnecessary spaces Change-Id: Ibbaa2d2beb482ee95d10d5e632d41603a7e152ae Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90041 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
2020-03-12tdf#106668 clarify how to apply stylesSeth Chaiklin
- reorganize page to separate information about applying styles from information about the Styles deck - clarify how to apply Character and Paragraph Styles - move links about the updating, loading, new style commands from under the descriptions to the titles of the commands - remove heading and description "Applied Styles" (because not relevant to this page) - add information about predefined shortcuts for applying styles. - change information about Styles toolbar into a <tip> and update the toolbar name. - add link about docking/hiding windows to related topics Change-Id: I24aef3b7f632097f201545c54f7080645f767317 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90285 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk> Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2020-03-12Fixing an uppercase typoSophia Schröder
+ superfluous whitespace + small reformatting of the source file Change-Id: I1ceca55968f7e4918804c86c4c35a4407828331c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/88021 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2020-03-12Small whitespace issueSophia Schröder
Change-Id: Ifc63c363932cb3749d7f99754f94b252a495de62 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/88038 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2020-03-12Mainly whitespace fixesSophia Schröder
+ visibility improvements Change-Id: I82f31ebdbae945ab823154242480930958707fb9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/88095 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com> Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2020-03-11Addition to Basic reference TOCLibreOfficiant
Change-Id: Icaea025c635127f5503270e071fab83f2760c480 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90278 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>