summaryrefslogtreecommitdiffstats
path: root/source
Commit message (Collapse)AuthorAgeFilesLines
* tdf#131416 Syntax Diagrams omissions and cleanupLibreOfficiant2020-04-254-34/+35
| | | | | | | | | | | | - Missing '@' in list of type declaration characters - c(h)ar typo in fragments, refactoring in: - Type, Function, Property, Dim, ReDim statements - argument fragment Change-Id: I97caea851d6864e44d43550f6e71873e6f55eb91 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92769 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#129366 Basic Syntax DiagramsLibreOfficiant2020-04-2310-93/+521
| | | | | | | | | | | | | | - runtime/compiler Option statements - Sub, Function, Property Get/Let/Set - Dim, ReDim, DimArray - Dim and Redim help pages reviewed and amended accordingly - Sub, Function, Property pages updates in subsequent patches Change-Id: Iee857aa6e17533278bf16917c0b7d32af0e038ea Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92528 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#129366 Basic Byte datatype informationLibreOfficiant2020-04-232-13/+29
| | | | | | | | | | | - TypeName function - VarType function - syntax diagram fragment update Change-Id: I412e95c9eb8a3b84158b3888025081600030167e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92533 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#36737 Clarify routine arguments initialisationLibreOfficiant2020-04-232-12/+12
| | | | | | | | | | | | | | | in those contexts: - native LibreOffice Basic - w/ Option Compatible - w/ Option VBASupport 1/0 - Added missing Byte, Boolean datatypes - type declaration caracters fragment conciser layout Change-Id: I53387018223466ef7452d87fb166d5d9e6de0594 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92540 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Fix typoAndrea Gelmini2020-04-211-2/+2
| | | | | | | Change-Id: I09335c448cb058fec91cb6caf33c503c9a6e971d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92642 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* fragment heading insertionsLibreOfficiant2020-04-211-8/+8
| | | | | | | Change-Id: Id619066cf1d40ed760ff774003991d0f16343a99 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92441 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#132227 Add MySQL direct connection help pageOlivier Hallot2020-04-213-19/+48
| | | | | | | Change-Id: Icc0393d89799349701136d6b8e98519732ec0fa5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92601 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf129366 add Resume in 'Error handling' funcsLibreOfficiant2020-04-211-0/+1
| | | | | | | Change-Id: I48557474f6cedd357f03e767eabd09b6df8cd5b1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92440 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#131416 Type statement diagramLibreOfficiant2020-04-211-1/+5
| | | | | | | | | | - main diagram - subsequent fragments Change-Id: I5463aeac7257394cac826fbc36a819b4ddd8ced3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92435 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Update syntax section of Help for Calc's DCOUNT and DCOUNTA functions to ↵Steve Fanning2020-04-201-0/+2
| | | | | | | | | | indicate how to omit middle parameter (see bug 131362). Change-Id: Ib1fd850371c1876f16c10905994a92ac83a5a351 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92443 Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Fix typoAndrea Gelmini2020-04-181-4/+4
| | | | Change-Id: If99fba8853b2e378687727e00986c11b606d5661
* error handling w/ BasicLibreOfficiant2020-04-178-10/+27
| | | | | | | | | | - include err VBA object - relate pages together Change-Id: I94358470091cd6ce7d57a21b34325da7d88e42ad Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92427 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#131416 Basic syntax diagrams reusable fragmentsLibreOfficiant2020-04-176-0/+311
| | | | | | | | | | - a new help page to aggregate all fragments - reusable fragments as media/helpimg's Change-Id: If28747a75bbbd14ae8a0cc04bdedb8b7d81f173b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92009 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Basic Table of content alphebetical orderingLibreOfficiant2020-04-151-4/+4
| | | | | | | Change-Id: I5e0d46bbbf64fe1b9296fc912e2492a7acd73af7 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92180 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Typos and correction in pageOlivier Hallot2020-04-152-11/+12
| | | | | | | Change-Id: I1382ca7a49475d11c3cf424bea9c2146e0d4466e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92292 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#131960 Clarification of FLOOR/CEILING functionsSteve Fanning2020-04-132-27/+41
| | | | | | | Change-Id: Ifb90e95d632f0305d15562e9732dac7e3dc6d6ca Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92097 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* 3 Basic syntax diagramsLibreOfficiant2020-04-105-54/+216
| | | | | | | | | | - For statement variations - On Error Change-Id: Ic4b25b9d44adeb0c80fc2e24cc60301b9325c1a3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92010 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Fix typoAndrea Gelmini2020-04-101-1/+1
| | | | | | | Change-Id: I0219b40a90e82c5e4cd0d0bca4e3816eb837c6cf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92038 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Mute l10n in bascode sectionOlivier Hallot2020-04-101-13/+13
| | | | | | | Change-Id: Id510273714c15d3d5502be7550a569043a09cade Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92001 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#129366 Resume statement new help pageLibreOfficiant2020-04-092-0/+78
| | | | | | | | | | | | | | | | its 3 available options are: - 0 - label - Next + associated examples in combination with On Error statement To be rebased past #91709 Change-Id: I0986816580835bf9b2b2657ecdbdc06118b1ff9d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91712 Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf131416 Let/Set statements joint Syntax diagramLibreOfficiant2020-04-095-47/+672
| | | | | | | | | | - 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>
* Variable insertions for future page embedsLibreOfficiant2020-04-094-70/+67
| | | | | | | | | "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>
* tdf#131960 Clarification of FLOOR functionsSteve Fanning2020-04-092-50/+113
| | | | | | | | | + 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-092-99/+132
| | | | | | | | | + 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>
* Precise Call statement optionsLibreOfficiant2020-04-081-12/+12
| | | | | | | | | | | | - 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>
* tdf#131357 adjust Calc functions paramsSteve Fanning2020-04-062-2/+2
| | | | | | | | | 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>
* tdf#131362 Adjust number of function paramSteve Fanning2020-04-064-76/+76
| | | | | | | | | 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>
* Mute L10n on headingOlivier Hallot2020-04-031-1/+1
| | | | | | | Change-Id: Id5449b2dd49a32b5d76e4cac71768147f3a0e98f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91624 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* update variable name in Field help pageSeth Chaiklin2020-04-031-1/+1
| | | | | | | Change-Id: I0b383bc1c59f1627549844f998dfa0389053434a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91518 Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk> Tested-by: Jenkins
* VBA Err objectLibreOfficiant2020-04-024-3/+132
| | | | | | | | | | | | - 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>
* Call statement syntax diagramLibreOfficiant2020-04-012-5/+65
| | | | | | | Change-Id: Ia4cae7ee6078cf056b50009f73f8d545dc1b0384 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91506 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#131711 there are two help pages for the index dialog which has two modesCaolán McNamara2020-04-012-7/+7
| | | | | | | | | | 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>
* tdf#130360 Minor adjustments on complex numbers.Steve Fanning2020-04-012-3/+1
| | | | | | | Change-Id: I392d672e31940aa2bb1ca12c09e6496ee8c43700 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91485 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#131360 Adjust number of function param (2)Steve Fanning2020-04-012-88/+89
| | | | | | | | | 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>
* tdf#131360 Adjust number of function parametersSteve Fanning2020-03-307-39/+30
| | | | | | | | | | | 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>
* Remove empty heading.Olivier Hallot2020-03-301-1/+0
| | | | | | | Change-Id: Icca557cbe9ebcfe5004e1707835ecf4fdfbd5a05 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91365 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#131361 Adjust number of function parameters (3)Steve Fanning2020-03-264-63/+62
| | | | | | | | | | | 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>
* tdf#126923 Add guide for subtotals toolOlivier Hallot2020-03-265-57/+105
| | | | | | | Change-Id: I941214be272d6e959c1129b074891bb6f229ba26 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91079 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#131361 Adjust number of function parameters (2)Steve Fanning2020-03-263-23/+28
| | | | | | | | | | 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>
* Clarify TEXT spreadsheet function's first parameter (not only number)Mike Kaganski2020-03-261-3/+4
| | | | | | | Change-Id: Icf5c8a6ff2fe5f9238afdb9c35e22eb91937f778 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91106 Tested-by: Jenkins Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
* tdf#131361 Adjust number of function parametersSteve Fanning2020-03-257-141/+136
| | | | | | | | | | 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>
* Correct arguments for TEXTJOINOlivier Hallot2020-03-251-2/+2
| | | | | | | | | | 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>
* Fix to Property misleading snippetLibreOfficiant2020-03-241-2/+4
| | | | | | | Change-Id: Ie96f829d21384a9adab81e9b007d0773c035b97c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90948 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* tdf#91313 Update Paste Special new featuresOlivier Hallot2020-03-2111-107/+318
| | | | | | | | | | | - 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>
* tdf#131361 Correct param's GCD, LCM, PRODUCTSteve Fanning2020-03-205-29/+27
| | | | | | | | | - 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>
* Refactor Data analysis Calc help pageOlivier Hallot2020-03-2016-1719/+2009
| | | | | | | | | 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-2027-373/+370
| | | | | | | | | | | - 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#131361 Correct upper limit to 255Olivier Hallot2020-03-191-12/+12
| | | | | | | Change-Id: Ib174181e6e750a5a9a6721b0ea86d3ba2575cb0c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90748 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Apply correct style for table head in page (2)Olivier Hallot2020-03-191-4/+4
| | | | | | | Change-Id: I7af01680868e263579a681ff34f1bdd3ac07b8ad Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90727 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
* Apply correct style for table head in pageOlivier Hallot2020-03-191-46/+41
| | | | | | | Change-Id: I042e1ee043a9dc2034f9fa9c77100286cad02770 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/90726 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
generated by cgit (git 2.34.1) at 2024-07-04 18:37:34 +0000