Bug Hunting Session
Bug 44750 - Allow changing the document's locale directly, not globally
Summary: Allow changing the document's locale directly, not globally
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Master old -3.6
Hardware: All All
: lowest enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
 
Reported: 2012-01-13 02:43 UTC by Xavier Poirot
Modified: 2018-11-22 14:15 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Example on implementation of the enhancement (287.60 KB, image/png)
2012-01-13 02:43 UTC, Xavier Poirot
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Xavier Poirot 2012-01-13 02:43:58 UTC
Created attachment 55534 [details]
Example on implementation of the enhancement

In Tools > Options > Language Options > Language

We can change the spelling correction to a chosen language, and then check the box "Only for the current document".
This is great if I want to create an English document, since my computer is in Danish.

Though, if I want to use English currency ($, €, £, ...) other than the Danish krone (kr.), I've got two possibilities :

Select in the current Page all the boxes, and change in Format the number formatting to the currency I want, then select English - Country on the right (to have the correct thousand separator etc...). Very annoying step!

Or then change in Options > Languages Options > Language : change Locale Options to English, and all my number formatting is going to be by default correct, just by clicking on the button "Number format: Currency" which is a lot more convenient to use than the first solution.

The enhancement I'm requesting is : Could you add the spread action of the box "Only for the current document" as quoted in the start, so it affects also, if checked, the "Change Locale Options".

If the enhancement is implemented, then I check the box, and my whole document has changed its Locale Options with "English", WITHOUT setting by default all my new documents to English. Only this document. :)

If you need any further information, let me know, I feel it's hard to explain!
I attached a picture showing what should affect the box "Only for the current document".

Or then it can be implemented in a "Document settings" window, a lot easier to find! :)

Xavier Poirot
Comment 1 sasha.libreoffice 2012-05-08 02:49:55 UTC
Thanks for bugreport
> Select in the current Page all the boxes, and change in Format the number
> formatting to the currency I want, then select English - Country on the right
> (to have the correct thousand separator etc...). Very annoying step!
Please, attach small example document that demonstrates this problem
Comment 2 Murz 2014-02-25 12:05:29 UTC
Confirm this problem. At now LibrOffice have only global Locale setting, this is give many problems with formulas, how to reproduce:

Float numbers in English locale saved with dot: 1.33
Float numbers in Russian, Spanish locale saved with comma: 1,33

I work in Libreoffice with documents that need different locales, one must use dot in float numbers, other - comma.

So when I paste number in wrong locale, formulas shows #VALUE! error instead of counting.

Example: In cell A2 I write "1.33" and in B2 - formula "=A2*2", and this give me the error "#VALUE!" if global LibreOffice locale is not English (Russian).
And conversely.

Please fix this issue.
Comment 3 Thomas Lendo 2018-09-16 20:19:48 UTC
Adding needsUXeval to discuss how this could be implemented. With a Default cell style like in Writer?
Comment 4 Heiko Tietze 2018-11-20 10:19:54 UTC
Drawing the "document only" frame around all options makes not much sense. At least the UI is likely irrelevant. Whether the other can be stored with the format is more a technical question.

In the end I think the situation has improved significantly with the new currency dropdown. The user can switch from $ to €, for example, and this setting is kept for the next input.

So my take: WFM.
Comment 5 Heiko Tietze 2018-11-22 14:15:02 UTC
Talked about the topic in the design meeting and we agreed on WFM.