[Libreoffice-bugs] [Bug 125137] New: Language of Calc Spreadsheet

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125137

            Bug ID: 125137
           Summary: Language of Calc Spreadsheet
           Product: LibreOffice
           Version: 6.2.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: csongor at halmai.hu

There is an author who created a spreadsheet file for generating circles for an
SVG file. In column A there are the radii (radius values) of circles and in
column B there are string formulas that create the SVG content. Example: 

A1=1/2
B1="<circle cx='0' cy='0' r='"&A1&"'/>"

The author used English language settings so for him the result is displayed
with decimal points:
A1: 0.5
B1: <circle cx='0' cy='0' r='0.5'/>

This is a correct SVG node. 




But if I open the same file in my Hungarian LO then the fractional numbers are
displayed with a decimal comma, not a decimal point. That is, I can see the
following content:
A1: 0,5
B1: <circle cx='0' cy='0' r='0,5'/>

This is wrong for SVG because it would need 0.5 instead of 0,5. 


It would be nice to have a File -> Properties -> General -> Language setting.
By default, its value should be "Default", which means that the spreadsheet is
displayed in the language of the current user. However, the user could set this
value to any specific language so that this particular spreadsheet is displayed
with formatting of the given language. 

This setting should be saved into the ODS file too so that the file can be
shared with other users who use different language.



Currently, there are some semi-solutions with some glitches:
- the user can set their language of LO but it is not always obvious what
language should be selected. The author should be able to share this
information within the ODT file.
- the user could apply some formatting functions in each cell but it is
cumbersome, slow, and if the author did not do this then doing it by other
users is very hard. 




I originally supposed that the feature requested in bug #34142 could solve this
issue. It has already been implemented, the Format -> Cells -> Language setting
is what was asked there, I think. This is a change that is stored in the file
so I hoped it works. 

But it does not. If I format all the cells' language to English, then A1
becomes nice English ("0.5") but the string concatenation in B1 remains
Hungarian ("<... 0,5 ...>" instead of "<... 0.5 ...>"). 

I am not sure how it should work, is this feature buggy or not but a
document-wide setting for the language would be an elegant solution, I think.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190506/18677bf7/attachment.html>