Looking for history on a specific currency format availavle

English
#1

cell currency selection
cell currency selection1195×1069 238 KB

I was editing a spreadsheet and had to change the currency format of a cell. The computer has Swedish and English set for default languages with Swedish being the prominent one. Default currency in the cells is “-0.00 kr” as expected. I wanted to change a cell to the Canadian dollar and as expected, you see the “CAD $ English (Canada)” and “CAD $ French (Canada)”.

I have never seen “CAD $ Shuswap” before. Shuswap is a region in British Columbia, Canada, so I am curious about the history of the selection.

Not an important question, but curious minds want to know 8^)

#10

Yust a sincere suggestion:
Omit all the “traditional” currency formatting and the related special symbols. That’s only good for creating misunderstandings. Where you need numbers to be interpreted the “money-way” always provide a complete column for the purpose, and put the respective ISO code into the header. The rest is “simply numbers”.

#2

Just guessing aloud: since there is no reason currency symbol CAD varies with language (because it is based on an ISO standard as ISO 3166-1 alpha 2 + one letter), isn’t this merely a language tag to silence spell checking?

Therefore we could have CAD tagged as en_CA, fr_CA and shs (defined in ISO 639-3).

Personally, I consider currency symbols as “registered” abbreviations and would rather tag them with language [None] which would reduce the list to one occurrence per currency where the languages are merged.

The existence of CAD Shuswap may result from a localisation/translation of LO in Shuswap despite the low number of speakers.

1 Like
#3

Related release notes: OpenOffice.org 3.1 New Features

It is already present in OOo 3.2.0.

#4

Yes, I see it there. It is more of a why it is there question. I think Ajlittoz may have the right idea.

#5

Sure. The “why” is what @erAck can only answer :wink:

#6

so, possibly one of the indigenous peoples may have had something registered for their native language. Interesting thought and quite probably correct. With the number of different indigenous people groups in Canada, it wouldn’t surprise me if more started to pop up.

Something I have never seen in Microsoft products but it could be that when working in Canada I never needed to change the currency language setting as the default was cdn english.

Thank you for your thoughts.

#7

maybe he will see this and give his thoughts. :slight_smile:

#8

For “why” Shuswap exists: it was requested and added already for OOo 86084 – add support for a new locale shs_CA (Shuswap) .

The “why” there are different entries for each locale is because the formats may differ for locales, plus the Excel format codes include the numeric LCID as designator with the currency symbol, i.e. selecting CAD $ French (Canada) results in a format

#,##0.00 [$$-C0C];[RED]-#,##0.00 [$$-C0C]

whereas selecting CAD $ Shuswap results in

[$$-648]#,##0.00;[RED]-[$$-648]#,##0.00

(separators are adapted to the current locale).

#9

Thank you erAck. It is interesting to see things like this and how they evolved. I doubt MS would take something like this on.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.