From 7e42394ecbf921ee53160b495aa12c1cba158604 Mon Sep 17 00:00:00 2001 From: Ilmari Lauhakangas Date: Tue, 6 Dec 2022 14:05:20 +0200 Subject: tdf#152323 drop name attribute from elements Replacement done with find . -name \*.xhp -print0 |xargs -0 -P 0 perl -CS -pi -e \ 's#(]*?) +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#(]*?) +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 gets turned into 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 --- source/text/sbasic/shared/calc_functions.xhp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'source/text/sbasic/shared/calc_functions.xhp') diff --git a/source/text/sbasic/shared/calc_functions.xhp b/source/text/sbasic/shared/calc_functions.xhp index fa495681fa..11ed299864 100644 --- a/source/text/sbasic/shared/calc_functions.xhp +++ b/source/text/sbasic/shared/calc_functions.xhp @@ -25,7 +25,7 @@ API;sheet.addin.Analysis API;sheet.FunctionAccess -

Using Calc Functions in Macros

+

Using Calc Functions in Macros

In addition to the native BASIC functions, you can call Calc functions in your macros and scripts and set Calc functions in cell formulas.

Calling Internal Calc functions in Basic

Use the CreateUNOService function to access the com.sun.star.sheet.FunctionAccess service. @@ -70,7 +70,7 @@

Calling Add-In Calc Functions in BASIC

- The Calc Add-In functions are in the UNO services com.sun.star.sheet.addin.Analysis, com.sun.star.sheet.addin.DateFunctions and com.sun.star.sheet.addin.PricingFunctions. + The Calc Add-In functions are in the UNO services com.sun.star.sheet.addin.Analysis, com.sun.star.sheet.addin.DateFunctions and com.sun.star.sheet.addin.PricingFunctions. REM Example calling Add-in function SQRTPI -- cgit