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!
-
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.
-
Danie
commented
As per title, just needs support for ZAR as a formatting option in Proton Sheets > Format > Number > Currencies.
-
Felix
commented
Add support for Swedish Crowns (SEK) as currency formatting option.
-
Tringhamm
commented
I believe many of the feature requests relaated to Sheets would be solved with a 'set locale' configuration or something similar.
-
Tringhamm
commented
In Brazil, we also follow a different format: point (.) separate thousands, and comma (,) separate decimals.
A 'set locale' configuration would be great, as suggested in
https://protonmail.uservoice.com/forums/932839-proton-drive/suggestions/50795321-location-settings-for-sheets-date-numbers-curr -
Tringhamm
commented
Add support for Brazilian Real (BRL) as a formatting option in Proton Sheets, under the menu 'Format > Number > More Currency'. The name, following the pattern, would be 'R$ Brazilian Real'.
Related requests:
https://protonmail.uservoice.com/forums/932839-proton-drive/suggestions/50774645-proton-sheets-support-for-swiss-francs-in-curren
https://protonmail.uservoice.com/forums/932839-proton-drive/suggestions/50787686-proton-sheets-support-for-czech-currency-k%C4%8D-c -
Pavel
commented
In the Czech Republic, spaces are used to separate thousands and a comma is used as the decimal separator (instead of a dot). Would it be possible to add this number formatting behaviour to the document settings?
Eg: 1 000 001,12 (one million two point twelve)
There may also be other national formats out there.
-
Pavel
commented
Similar to the request for Swiss currencies, I would like to ask for the support of Czech Crowns (Kč).
Related request:
(https://protonmail.uservoice.com/forums/932839-proton-drive/suggestions/50774645-proton-sheets-support-for-swiss-francs-in-curren)