Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index

Hi Tim!

Tim Herb wrote on 21/10/2022 19:47:

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.

That's really nice. Thanks!

 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.

Separator can be set in Options > LibreOffice Calc > Formula.

And the string indicator, must indeed be from the locale. See Options > Language Settings > Languages.

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.

In any case, checking the Calc options must be interesting, I think.
Maybe some relevant are hidden under Options > LibreOffice > Advanced > Expert Configuration?


Cor Nouws
GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28  A038 E49D 7365 B134 80A6
- vrijwilliger
- volunteer
- Member Board The Document Foundation
- marketing @CollaboraOffice
- ceo
- initiator

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.