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! :)
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
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).
Please fix this issue.
Adding needsUXeval to discuss how this could be implemented. With a Default cell style like in Writer?
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.
Talked about the topic in the design meeting and we agreed on WFM.