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!
-
Daniel Eckstein commented
I am having issues with currency calculations in Beta and in Beta only. In the currently released version, euro calculations are working as expected.
The values are not rounded correctly and cannot be used for follow up calculations correctly, as they are sometimes taken into account for the follow up calculation and sometimes ignored.
This bug can be reproduced by adding =0.99+0.92 to a Proton Sheet Cell and formatting the cell as Euro.
Expected Output: 1,91€
Actual Output: 1.9100000000000001In addition to this problem I am facing issues with calculations concerning percentages of currency values.
This can be reproduced by adding =3*1.9% to a Proton Sheet Cell and formatting the cell as Euro.
Expected Output: 0,05€ or 0,06€
Actual Output: 0.056999999999999995 -
M V
commented
When moving my google sheets to proton, it converted my € currency format data to $ and now uses . as decimals instead of , The format to Currency button also converts to dollar without an easy to set euro as default. My system and browser are not set to en-US, so this should not happen.
-
Klára Schenková
commented
Missing variant where number and currency is delimited by space character.
Wrong: 1 000 000Kč
Correct: 1 000 000 Kč
-
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?