Why calc assumes a person will only ever use one currency on their entire life?!
I use danish locale (to work around the bug where one cannot set date format to iso8601!) and all my currency fields are kr.. How to have the currency format only format numbers and not try to read my mind on which currency i have on that particular cell?
Because currency formatting without currency symbol is just a bare number format. Use it.
On the other hand, you may explicitly define which locale’s currency to use, by formatting the cells with that locale, instead of “automatic” default (that “automatic” default, of course, is silly in case if currency).
not exactly, theres different color and decimal formating choices for currency type…
changing the locale per column is a good solution. don’t know why i assumed it only changed the language for spell check. thanks
Spell check’s language is on a different tab, with font.
But you can do all this (including colors, and much more) with any number format - the number format codes are universal.
See also tdf#167062.
Unsolicited:
Don’t use currency formats at all. A (frozen) heading like Amount/USD and “general” (or 0.00) numbers below is much better.
With currency formatting you can easily “prove” that 1.00USD = 1.00JPY .
You can