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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from csongor at halmai.hu ---
I attached a sample ODS file which I created with locale like this:

`Tools` -> `Options` -> `Language Settings` -> `Languages` -> `Locale setting`
is `Hungarian` and the `Decimal separator key` checkbox below it, it is ticked
- `Same as local setting (,)`

#1
If I open the attached file then the initial parameters in the yellow area show
comma as decimal separator, because they are formatted as Hungrian (Format ->
Cells -> Numbers -> Language). This is good.

#2
The random fractional numbers in the amber area contain decimal points becuase
I formatted them as `English (USA)`. This is also good.

#3
The strings in the green cells, however, contain comma again, despite the fact
that I formatted them as `English (USA)`. At first glimpse, it seems to be a
bug. At second glimpse, I understand that these cells are not numbers any more
and `English (USA)` is meant to be applied only on numbers, not on texts. But
then, how could I display numbers other way than my local setting dictates? 

#4
The complete SVG is concatenated in the red G9 cell which also shows commas,
not numbers. This is also not what I wanted to have because in an SVG file,
decimal comma is not premitted, just decimal point.


In order to get decimal points in my green and red cells, I would need to apply
explicit formatting formulas which 
- is cumbersome to add them one by one
- would make the whole spreadsheet calculation slower
- does not work if the file is write protected

Due to bug #125484, changing the locale does not update the strings either.

Even if both #125483 and #125484 get fixed, my problem is still there. If I get
a file from someone who used English locale and I have Hungarian then I see the
pure number cells in Hungarian but the texts concatenating thise numbers are in
the author's English.

My proposal would save the locale setting right into the file. The author could
pick how to handle the locale, in the File -> Properties -> General dialog:
- "use user's default"
- "enforce English" (or whatever else) 
With this one, the author could determine how his file needs to be handled and
this information would travel as part of the file.

And even if the author adjusts something the receiver does not like, it is easy
to change this setting only for this particular file. (By contrast, if I change
the LO locale then it affects all opened file right once, which I normally
dont't want.)

-- 
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/20190525/6d6a7dec/attachment-0001.html>