summaryrefslogtreecommitdiff
path: root/source/text/sbasic
AgeCommit message (Collapse)Author
2023-06-24tdf#156015 Mark unimplemented args of BASIC ShellOlivier Hallot
+ refactor Change-Id: Ide7bc5a4abd4685b2bbe2727740358ac4c811030 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/153455 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 0d3f7932c7af9b6b682668b96a36f2acc3910e2e) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/153427
2023-04-17Fix typoOlivier Hallot
Change-Id: Ib52c112685d97f8cd684e42ba3b238ce39af81b9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/150509 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2023-04-10SF_Calc DAvg, DCount, DMax, DMin and DSum are the status bar functionsEike Rathke
Change-Id: I7f905111e58f0997c6a249a38313853d6c26f725 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/150178 Reviewed-by: Eike Rathke <erack@redhat.com> Tested-by: Jenkins
2023-03-16convert paragraphs with role="heading" & childelements to → h<level>Christian Lohmaier
and also drop the language that was changed to implied previously/defaults to en-US unless specified. This change doesn't affect translations, only the content of the paragraph/headings is extracted. done with: perl -CSD -pi -e 'BEGIN {$base = qr/role="heading"|level="(?<level>\d+)"|(?<id>id="[^"]+")/;} s#<paragraph(((\s+($base)){3})|(\s+($base|xml-lang="en-US")){4})>(?<body>.*?)</paragraph>#<h$+{level} $+{id}>$+{body}</h$+{level}>#g' and manually undoing the one that uses <sup>in body that's not valid according to the dtd in the h tags. Change-Id: Ibd4aed3157ed168cd5005161575672a392e59202 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148797 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-16convert plain paragraphs with role="heading" → h<level>Christian Lohmaier
i.e. without child elements and also drop the language that was changed to implied in the dtd previously/defaults to en-US unless specified. This change doesn't affect translations, only the content of the paragraph/headings is extracted. done with: perl -CSD -pi -e 'BEGIN {$base = qr/role="heading"|level="(?<level>\d+)"|(?<id>id="[^"]+")/;} s#<paragraph(((\s+($base)){3})|(\s+($base|xml-lang="en-US")){4})>(?<body>[^<]+)</paragraph>#<h$+{level} $+{id}>$+{body}</h$+{level}>#g' (all permutations re order of attributes, and xml-lang="en-US" being optional / implied) Change-Id: I365a2bb983a3969af9390753fce7b7f3597c7b8b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148795 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-13tdf#141474 Incorrect parameter names for Basic functions in helpAlain Romedenne
Skipped items: Mid, MIRR, NPV, Shell: - MID statement is bugged, TDF#154166 refers, no need to change it yet. MID function operates fine - MIRR and NPV do not support named arguments in VBA despite MS documentation. No need to update those pages - Shell keyword arguments are correct Change-Id: I09dcc280edeec158eafaf87286966c36447ff71b Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148316 Tested-by: Jenkins Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2023-03-06tdf#141474 Incorrect parameter names for Basic functions in helpAlain Romedenne
Remaining pages up to included Join function Change-Id: Id6aad2fbdf3ace72fdaa33136fc71a6107abeadd Reviewed-on: https://gerrit.libreoffice.org/c/help/+/147986 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-05line break is actually CR+LF, not LF+CRStanislav Horacek
Change-Id: I22aa8c3f50b4ea35c6f48d8e1baed1df73c46d69 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148212 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2023-02-28Fix broken links in helpRafael Lima
Change-Id: I77413b0a66d7851d7c79e5f83ed72dd5f42f1c00 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/147975 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-02-20remove unnecessary sentenceSeth Chaiklin
Change-Id: I5168f58bfb24832a74e347a996bfa3f6d375a318 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/147282 Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk> Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-02-17typoAlain Romedenne
Change-Id: I67540e5f1feec3baa6d585a508fc5b270c0981ae Reviewed-on: https://gerrit.libreoffice.org/c/help/+/147241 Tested-by: Jenkins Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2023-02-13FormatPercent New Basic function / VBAAlain Romedenne
Change-Id: I0ad4022394632f0d49417bb56ecda641af3b0b42 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/146519 Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Jenkins
2023-01-25Fix typosAndrea Gelmini
Change-Id: I63a7a69b053b3ddca65a0bd41ac903ce425815a8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/146128 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2023-01-24Document new RemoveDuplicates method in SF Calc serviceRafael Lima
This patch also updates the method SortRange to remove the original limit of 3 row/column as keys (see commit 40bc1b275324f9a730960fe5d4d8982cdfbc7b03) Change-Id: If2f3e6cc97f3effdde34ee44330335ae85fef226 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/146028 Tested-by: Jenkins Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-01-24Improve ScriptForge TOC help pageRafael Lima
This patch also fixes the Basic service help page by classifying ThisComponent and ThisDatabaseDocument as properties instead of methods. Change-Id: Ia3937b0ea3fb057dacfc31ead1db512ddd951d64 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/146023 Tested-by: Jenkins Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-01-09Typo grab bagAdolfo Jayme Barrientos
Change-Id: I705b56ac8fd84227aaa6a81e57d182dfd797bd62 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/145183 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2023-01-08remove redundant tagStanislav Horacek
Change-Id: I9f0838ad3b230d454abc2810ce83033945339805 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/145174 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-01-08do not localize source codeStanislav Horacek
Change-Id: I00c8b6014be077f78485e43cbe0f86f2c2f29c6c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/145173 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2023-01-03mark Basic code as not localizableStanislav Horacek
Change-Id: Ic9ddc042c33c98fc5e73c2beb7ad65801adf9d38 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144966 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-12-20fix links to Put command pageStanislav Horacek
reported by Kamil Landa Change-Id: I415526d6bfcd6aec300fcacfd74ff101ac610969 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144577 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-12-19Fix duplicate IDs in non-localized contentIlmari Lauhakangas
Change-Id: I759b05a2ba10671700c9222f54e61edf39f5baff Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144538 Tested-by: Jenkins Tested-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2022-12-19Remove name attribute from linksIlmari Lauhakangas
Change-Id: I999712c68026ddd40578c1f5e92a994c24a11eae Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144460 Tested-by: Jenkins Tested-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org> Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
2022-12-18Minor fixes in the SF_Datasheet documentationRafael Lima
In commit bd899b607eed60487a75905a398b751cf5332352 I accidedntally ended up reverting a few fixes that had already been done to sf_datasheet.xhp. This patch reapplies these fixes. Change-Id: Ie2c7f65f4363aa788afa2315514ce8a348dc68c8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144364 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-12-17Fix typoAndrea Gelmini
Change-Id: I48aff9f91ddf1870efe97adc2629f6ef872437e5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144382 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2022-12-17Fix typoAndrea Gelmini
Change-Id: I3fd93d0db40bc0159853a5c40b5027545533d4ba Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144383 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2022-12-17Fix typoAndrea Gelmini
Change-Id: I22ef89aba9bf496d12911caabe79eff4a1340fe9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144384 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2022-12-17Fix typoAndrea Gelmini
Change-Id: I5e525f8125d5383d1bb4cf49ce3233d49eeec3c9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144381 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
2022-12-17Create TOC with all ScriptForge methods and propertiesRafael Lima
Change-Id: I32be401689efce0cba70216458bc7c8ba4a405c5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144309 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-12-16Document the new SF_Datasheet serviceRafael Lima
This patch creates the help page for the new ScriptForge service named Datasheet. It also updates associated methods that were added to the Base and Database services. Change-Id: I6611653b77e1ee41f6afacccb2094f19d7178434 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144183 Tested-by: Jenkins Tested-by: Jean-Pierre Ledure <jp@ledure.be> Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
2022-12-15Mute L10n in BASIC codeOlivier Hallot
Change-Id: I0e6a85285548385935eadd00e69bf2671af3d4c6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144178 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-12-15Update documentation of SF_Basic serviceRafael Lima
This patch adds the new CreateUnoStruct method and fixes a few minor issues in the file. Change-Id: I1369e801d4e86f3413ccd7e13dcae8255e4ff5b8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144122 Tested-by: Jenkins Tested-by: Jean-Pierre Ledure <jp@ledure.be> Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
2022-12-14Document new FilterFormula and FilterScope arguments in SF_Calc serviceRafael Lima
This patch updates the ScriptForge's Calc service to document the FilterFormula and FilterScope arguments that were added to the following methods: - ClearAll - ClearFormats - ClearValues - SetCellStyle Change-Id: Ice17a37ca49576f07be7f57800b11050054d90b3 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144057 Tested-by: Jenkins Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
2022-12-13Update documentation of SF_Dialog and SF_Dialog control servicesRafael Lima
This patch does the following changes: 1) Explain how to handle exceptions in dialog and control event handlers (both in Python and Basic) 2) Document the new SetPageManager method 3) Plus a few minor fixes in the text Change-Id: I4f7b3bfae025b45214b90dd036ecdbf4977d47e9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/144018 Tested-by: Jenkins Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
2022-12-10Mute L10n in code instructionsOlivier Hallot
Change-Id: I92f719fbd4b646809fb385360541b285a41fd3d9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143919 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-12-09Fix typoAndrea Gelmini
Change-Id: I859153f912a952e105e6d124fa85e7f81a702d83 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143891 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-12-08Fix to python script sampleAlain Romedenne
Change-Id: I9e79c85aecde08225212fd7985d32bd55a5f7bf1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143724 Tested-by: Jenkins Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2022-12-07tdf#152323 drop name attribute from <link> elementsIlmari Lauhakangas
Replacement done with find . -name \*.xhp -print0 |xargs -0 -P 0 perl -CS -pi -e \ 's#(<link[^>]*?) +name *="[^"]*" *( [^>]+|) *>#$1$2>#g' (note some inconsistencies with space between name and = and also having empty value, and some more complicated expression to also clear up double space before/after the attribute) translation files will be prepped with: find */helpcontent2 -name \*.po -print0 |xargs -0 -P 0 perl -CS -pi -e \ $'s#(<link[^>]*?) +name=(?:\\\\"[^"]*\\\\"|\'[^\']*\') *( [^>]+|) *(/?>)#$1$2$3#g unless /^#/' (note that not all languages use the " as quote character for the attributes, but that also single quotes appera in the po file. Hence the use of the shell $'string' syntax to be able to quote ' as \' It also requires to quote the backslash, so that it needs to be escaped once for the shell, then another time for perl. Also don't work on obsolete strings (those are prefixed with #~ in the po files) Also note that <link..></link> gets turned into <link ../> during translation extraction (along with removal of the space between the attribute name and the value), so the pattern needs to be slightly different here) Change-Id: I95e53a08e6b0095cd894109ea0de154cc4859d8f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143713 Tested-by: Jenkins Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
2022-11-15silence make translations warning (emtpy string flagged for translation)Christian Lohmaier
Change-Id: Ie8d188eca6b04a1e264ebe4f1abfeaa79bcba37d
2022-11-14DoEvents extra indicationsAlain Romedenne
Change-Id: I04da53ff9a7426a1698c880e26b4cdf01b7daf90 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142677 Tested-by: Jenkins Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2022-11-14CreateUnoServiceWithArguments supplemental method identification patternAlain Romedenne
Change-Id: I38e3938e9392558951c1cd64b2a669bd5e5c9093 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142676 Tested-by: Jenkins Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2022-11-11Basic typoAlain Romedenne
Change-Id: I6890eea2de0b2e6e7d95c0289ef8810434a89df6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142517 Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-11-09Basic typoAlain Romedenne
Change-Id: I8fb221c1af3a3be26cb30f85fcb9732b2e03bcd8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142446 Tested-by: Jenkins Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2022-11-09tdf114263 DoEvents new help pageAlain Romedenne
Change-Id: I4a031759aa48df9230e4019740a94ca167519792 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/141920 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-11-07tdf#150369 IsMissing Function explanationBogdan B
Change-Id: I10a25151109d4048fdbf8eca596f0f1e334092a2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142300 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-11-07tdf141474 Typename, Vartype functions accept keyword argumentsAlain Romedenne
- argument names updated to comply with VBA conventions Change-Id: I2166e62d6df4e0f72aaa494e96f9a515b03e3ac7 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/141919 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-11-03Corrections to UNO objects, function & services help pageAlain Romedenne
Change-Id: Ia72f062c5d0ec07e61aa6b45caea31139acf561e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/142199 Tested-by: Jenkins Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2022-10-30tdf141474 CreateUnoService accepts keyword argumentsAlain Romedenne
tdf114263 CreateUnoServiceWithArguments new help page Change-Id: I217746d0817cefcaab7ecb07d30b2c3f2ad8bfff Reviewed-on: https://gerrit.libreoffice.org/c/help/+/141916 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2022-10-26index correctionAlain Romedenne
Change-Id: I9580f8bef5138364667df66eb950f1d205b5e9a2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/141837 Tested-by: Jenkins Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
2022-10-25Fix typoAndrea Gelmini
Change-Id: I3b533183d82a707ee837cd584d3e9ed3862c2ed5 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/141827 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
2022-10-25tdf141474 CreateUnoListener function accepts keyword argumentsAlain Romedenne
- literals and links added to improve page legibility - 'related to' items added - Multiple text clarifications and additionss Change-Id: I0d7515783cb53f382ff2246a4a377ffb871a8284 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/141578 Tested-by: Jenkins Reviewed-by: Alain Romedenne <alain.romedenne@libreoffice.org>
generated by cgit (git 2.34.1) at 2025-02-10 11:38:07 +0000