Re: [libreoffice-l10n] Wiki module created to save time for Calc function article translators

On 21.10.2022 20.47, Tim Herb wrote:
> Hello,
>
> it is great that there is now a solution to invoke Calc-Function names
> at Wikipages. I have written after I asked in August about the place
> where I can find the files where the calc functions are translated a
> program that extracts out of the files the strings. It creates one
> CSV-File per language where a file with strings for Calc-Functions
> exists. You can find the CSV-Files and the program at this page.
>
> https://public.paws.wmcloud.org/User:Hog%C3%BC-456/Spreadsheet%20To%20Code%20Converter/Spreadsheetfunctions%20by%20Language/
>
>  From my point of view it is great if it is possible to copy a function
> example from a Wikipage or a documentation page into calc. In Germany
> usually the semicolon is the separator and in other countries it is the
> comma in functions. For strings there are also different characters
> used. It is the " and the '. Does the separator depend on the language
> version or on the settings of a user. Im working since more than two
> years at program that converts Spreadsheetfunctions into source code.
> With this program if only parts of it are used it is also possible to
> transfer a function from one language into another one and changing
> through that the separator of function arguments and for strings and
> also the notation for a cell from the A1-Format where a cell address
> consists out of letters and number into a R1C1-Format where the column
> and the row are numbers. Replacing is propably for the examples accurate
> enough but it is theoretically possible that a string contains a name
> that is also a function name. What will you do with the mentioned cases
> where separators are different depending on a criteria I dont know yet.
> Will this be a local translation work or is there a possibility to find
> it out depending on the language and create a automatically solution to
> use the most common one.

That's a good point about the language-specific parameter separators and 
such in the Calc function call examples. I have to keep such examples 
fully translatable.

I guess a separate module could be created to replace the separators 
etc. based on language, but it might be tricky (what are the edge cases, 
what kind of stuff can appear in a formula). I will not attempt it, but 
others are free to take a shot at creating a reliable solution.

Ilmari

--
To unsubscribe e-mail to: l10n+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/l10n/
Privacy Policy: https://www.documentfoundation.org/privacy