Location settings for Sheets (date, numbers, currency...)
It would be great to be able to define the location settings in each Proton Sheet file with a list of countries so that the date, number, currency, etc. formats correspond to the selected country.
the feature is out on the beta channel and rolling out soon to everyone!
-
Andrei Popescu
commented
Please re-open, this feature was about locale settings, which includes dates, number formats and currencies.
So far Sheets only supports 6 currencies, with US-style format (currency symbol in front), there are no settings for date formats, numbers (decimal / thousands separator).
-
J
commented
Does the declined status means that the feature is not coming to the tool?
-
Hans Inge
commented
I don't see how this is completed. I am finding no option to set locale for my Proton Sheet, and there is still only 6 currencies to select from.
-
Felipe
commented
How is this idea tagged as "Completed" if we still have just 6 currencies?
-
Robbin
commented
I've just started to use Sheets and mostly love it - formulas were imported, unlike so many other excel-ish apps - but the date formatting is driving me bonkers! Would love a locale option for formatting data. And an "account wide" preference in Proton settings would be most amazing! Thank you <3
-
MyName
commented
Proton Sheets - Support for Norwegian kroner (NOK) currency
-
MyName
commented
Proton Sheets - Support for Norwegian Kroner (NOK) in currencies
-
Jay
commented
Regional settings are critical to usability, esp for existing workflows/materials.
Cannot / will not migrate until this becomes available. -
Christian Sprenger
commented
Wir nutzen in Deutschland kein Format wir folgt:
1.22 $
sondern das folgende Format:
1,22 €
Bitte dringend anpassen, so kann man keine Finanzen verwalten. Danke.
-
Ju
commented
It seems hardcoded to English US which is very ironic (my OS is in English UK). It formats dates with the month before the day
-
luke
commented
Honestly, saying I'm surprised this wasn't a basic MVP feature for Proton Sheets is putting it mildly... It makes it borderline unusable for anyone not living in the US.
-
Anthony
commented
Hello, I'm joining the request for the separators, thank you in advance!
-
Aleksandra
commented
Same for Poland. The space is just something added automatically in programs. But it's absolutely unacceptable for me to not allow using comma as a decimal separator – I'm definitely not switching if this is the case.
-
Hanna commented
I use Iso standard with space as thousand divider, and comma as decimal divider, I was going to do a search and replace, but since it does not exist, I really can't use sheets yet sadly
-
Ben
commented
This idea is the same as: https://protonmail.uservoice.com/forums/945460-general-ideas/suggestions/50852306-decimal-markers
And these 2 should be combined -
Ben
commented
I totally agree with this option. I have copied/pasted some data from Microsoft Excel to Proton Sheets and it would copy the values wrong because if the difference in usage of decimal separators and thousands separator.
My (language) preference is also that it should be comma for decimal and dot for thousands. -
Kavinda Navaratne commented
Could you let us know when you plan to enable, in Proton Sheets, the use of the comma as a decimal separator (e.g. 10,50) and the dot as a thousands separator (e.g. 1.000), as an alternative to the English number formatting currently in use?
-
Vicente
commented
Additionally, BRL and other Latin-American currencies use commas (`,`) as decimal separators. E.g.:
* BRL (Reais) → R$ 3.144,10
* UYU (Uruguayan Pesos) → $U 3.144,10
* ARS (Argentinan Peso) → $ 3.144,10
As a fellow Brazilian, the lack of support for our currency is the only thing impeding me from using Proton Sheets. :(
-
Bobby
commented
Yes, please! Or a custom currency formatting option
-
Blaise
commented
Problem:
Currently, user can ony easily set cell to "currency" by clicking on the dollar sign. Which sets currency = $.
If user is european, he can't easily set currency = €
Instead, user needs to click on Format>Number>More Currencies>€ ; which is cumbersome.Request :
As a user, I want to be able to easily set the format of cells to currency = $ OR € without having to click several times in the toolbars menu, in order for my customer experience to be more fluid and efficient