5 Commits

Author SHA1 Message Date
f3a16adcb0 tdf#141474 Incorrect parameter names for Basic functions in help
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-13 17:49:09 +00:00
7e42394ecb tdf#152323 drop name attribute from <link> elements
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-12-07 17:39:02 +00:00
32b4e8c993 localize proper strings and fix example result for StrConv function
Change-Id: I6bd2b9fda9217c589f6e53b0341d8028a6ca44c8
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/126348
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-12-04 23:29:56 +01:00
cae1ccb613 tdf#131563 VBA color constants
- VBA color constants addition
- Aggregation of spreaded constant definitions in this page

Change-Id: I5f4045256e5e03c6b11247c9bb0442e9e63d738d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124013
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-10-25 13:11:10 +02:00
68a8e252d2 tdf#124066 Help for VBA StrConv function
1) LCID codes linked to LibreOffice internal LCID file
2) Examples borrowed from QA tests

Change-Id: I1b00a1901f32de0243b518de39abd633ba08eadc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116684
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2021-06-07 19:36:15 +02:00