Missing currency symbol: CHF

Hello

At this time, solving that suppose that we know where is stored the list of strings used to display the currencies.

I don't know where they are.

Yvan KOENIG (from FRANCE vendredi 9 novembre 2007 18:37:39)

Hello

I'm sure that in Switzerland you have a minister in charge of education.
Why not send him a letter explaining the problem and asking him to write to Mr Steve Jobs about that ?
It's what I make when I encounter this kind of thing about the french language.
It's perhaps what I will do if Apple continue to leave Pages, Numbers and Keynote without a GUI allowing us to select the french quotes as the replacement ones.

Yvan KOENIG (from FRANCE vendredi 9 novembre 2007 21:28:45)

Hello

The problem is not in Numbers but in Mac OS X. The strings used to describe the currencies are in the system files but they dont comply the ISO 4217.

I'm always asking if someone know which is the file in which they are.

Yvan KOENIG (from FRANCE lundi 21 janvier 2008 17:02:04)

Workaround to change the currency symbol in Leopard
Don't do this if you're not sure

Go to System Preferences/International/Formats
Set everything as you would like it
close System Preferences

Then open terminal (it's in Applications/Utilities)
type:'
defaults read "Apple Global Domain" AppleLocale

You will get an answer which looks like (if you chose US computer for the region)
en USPOSIX
or
en USPOSIX@currency=UZS
or for example, if you choose French-France for the region:
fr_FR
or for example, if you choose French-Switzerland for the region:
fr_CH

Assuming the result was "en USPOSIX". If you then type in Terminal:
defaults write "Apple Global Domain" AppleLocale 'en USPOSIX@currency=chf'

(and analogously for whatever the reseult of the read was)

and restart your application you will then get "chf" follwoed by a blank as the currency symbol.

Unfortunately CHF does not work since this gets converted automatically by Apple to SwF etc.,
but CHf, chf, Chf, chF, ChF should all work.

If there was a mistake in typing and SystemPreferences refuses to open the International Panel after this, type in the Terminal

defaults write "Apple Global Domain" AppleLocale 'en USPOSIX'
or
defaults write "Apple Global Domain" AppleLocale 'en USPOSIX@currency='

and then open the International panel again.

You can use the same trick to replace the $ or other currency symbol by something
that is not as visible, such as "_"
by typing in Terminal , e.g.
defaults write "Apple Global Domain" AppleLocale 'en US_POSIX@currency='

(Unfortunately nothing or a blank will not work).

Hopefully Apple will give back the Customize button so we don't need these workarounds.

Thanks.

I knew that.

The problem is not:
may I change the string used

but

where are stored the strings used by Apple to set the currency?

Their table is wrong .

I wish to be able to replace it by the ISO 4217 one.

Here is what I get when setting "franc suisse"



Yvan KOENIG (from FRANCE mardi 5 février 2008 18:57:20)

Basically, it's not a question of compliance with this or that - Apple simply does not use the official international nomenclature for currencies such as all the banks of the world use - none of them are correct, or anyway, none that I know. They've come up with totally unknown ones instead (just check out Europe). I guess, they just made them up themselves! The EUR currency has been around for quite some years now - nice to be nostalgic and offer Deutsche Mark, e.g., but that would be DEM, by the way.
Besides, even though lots of Swiss make the same mistake, it would actually be SFr for Swiss Francs and not sFr - an adjective ending in -er such as Schweizer - is used with an upper-case letter.

And how about listing the countries in alphabetic order??

They should check the www.oanda.com list the bank converter uses!

I would have liked to use Numbers but it's absolutely impossible to do so with this type of abbreviation. Nobody, but nobody in Europe will even consider using such templates for presentations. To us, it's "Chinese" ...

Can't understand it - I thought that efforts such as establishing Volapük or Esperanto were out and intrnational communications were in???

I love Mac and all things Mac - but this is really the bottoms ... I changed to iWorks 08 in particular because of Numbers and now cannot use it - wouldn't know what for ...

Hello

The problem was reported to Apple.

I gave them the reference to ISO 4217 which is THE rule.
I explained them that it was foolish to loose time inventing lists when there is AN OFFICIAL one.

But as usual, they don't comment what is not published.

If at last they decide to treat the problem correctly, they must edit at least:

the operating system
Keynote
Numbers
Pages

because the lists used by the system on one side and the iWork's components on the other side are not the same.

Knowing them for years I'm sure that, one day, we will discover that they made the asked changes and then we will be allowed to sing "Hallelujah here they come!"

About the alphabetical order, it seems that the English list is correct but, the localized ones where not reordered.

It's the same for the lists of functions available in the spreadsheet modulus of the iWork's components.
It appears as a side-effect of the process ruling the self-localisation installed in all the modern products.

If you put a list of words in column A of a spreadsheet and put its translation in languageX in the cell just on the right of every word, we can't guarantee that column B will be alphabetically ordered.

Yvan KOENIG (from FRANCE lundi 24 mars 2008 21:26:26)

I gave them the reference to ISO 4217 which is THE rule.
I explained them that it was foolish to loose time inventing lists when there is AN OFFICIAL one.

I think I may have found the source of these symbols, which may not be "invented" after all. It's the standard ICU locale libraries, which are probably used by OS X. In these the ISO 4217 codes are translated in something else, depending on the locale (OS system language). The US locale currency list is here:

http://demo.icu-project.org/icu-bin/locexp?=enUS&SHOWCurrencies=1#Currencies

In en_US, CHF becomes SwF (no period).

In the fr_CH locale, it becomes sFr. (with period). In the de_CH and it_CH locales, it becomes SFr. (with period).

This is also found in the CLDR charts, e.g.

http://www.unicode.org/cldr/data/charts/summary/en.html

Do you know where this (these) list(s) is (are) stored in the system?
I searched several times but didn't find them.

I don't think they exist in a format where you could do anything with them. I suspect that the way this works is that the ICU (or similar) source code is incorporated in the app and/or the OS, and the app/OS calls upon it as required. You would probably need to find the parts of the program where these calls are made and change what it generates from the currency symbol to the currency code.

http://www.icu-project.org/

on my french version, it uses sFr.

Interesting. In my machine, set to English, both Numbers and the OS (system prefs/international/formats) use SwF.

Franc Suisse -->sFr.

If I switch my OS (10.4.10) from English to French, it still uses SwF instead of sFr.

I think this is more an issue with the system and the way it handles the currency. With "Leopard" at the end of the month, maybe that will address the problem.

Hello Lukas,

Did you post your script?
The link you give is broken.

Could you post Terminal commands we need to change "sFr." by "CHF".

Thank you

it's not a question of compliance with this or that

Yes it is, it's compliance with ISO 4217, which is the official nomenclature for currencies.

http://en.wikipedia.org/wiki/ISO_4217