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.
Proton Sheets will now default to your account or browser locale, and also supports manually setting a locale for a spreadsheet through File > Settings
-
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
-
Michał B.
commented
Yeah, the lack of Polish currency, or generally the support for a custom currency is annoying.
-
Michał Bachowski
commented
Add support for Polish Złoty (PLN / zł) as currency formatting option.
-
Lucas Tolchinsky
commented
Currently the localization settings to format numbers or dates seems to be locked into the OS locale or hardcoded to English.
This setting should be customizable per Sheet to allow for different formatting of data.
-
Proton user 234556
commented
It would be helpful to set € as standard and use European numerical system as a standard.
-
Sam
commented
Requested feature:
Add a locale or regional setting that allows users to choose their preferred number format. This could be implemented as:A spreadsheet-level setting (similar to Google Sheets' locale option)
An account-wide preference in Proton settings
Automatic detection based on browser/system locale -
Essie
commented
Would be nice if you could add the ability changing regional format, mainly for using a comma instead of a dot as decimal seperator ('8.000,00' instead of '8,000.00')
-
craze
commented
Currently the only option available seems to be the US month/day/year format.
Funnily, enough, pasting a day/month/year date from a google sheet seems to fix this, but I don't wanna live like this!
-
CheeseFactory
commented
In Germany, we also use the comma as a decimal separator and the period to separate thousands. Therefore, a “Set Locale” function, as already suggested, would be very useful.
-
Andreas
commented
There are already a bunch of requests for "add currency for <country>", so it's clear there is demand for this. It was certainly the first thing I noticed trying to set up a budget spreadsheet.
-
Adrian
commented
Sorry, "Locale setting" the correct term.