View previous topic :: View next topic |
Author |
Message |
LJ-Bettona Keymaker
Joined: Jan 23, 2008 Posts: 98 Location: United States
|
Posted: Wed May 14, 2008 7:55 am Post subject: Euro currency not displaying correctly |
|
I've just created my first spreadsheet in euro. In Italy, a number is written:
1.234,00. I can't speak for the rest of the continent.
Note the difference in use of . and ,
When I tried to change it so the Italians who will be reading it would understand the sums involved, the numbers displayed as 1,234.00 Oops!
Also, the euro options are miles down the list. I nearly gave up hope of ever finding them. Even if entered alphabetically they should come before the Thai whatever. As so many countries now use the euro, could they be put near the top - dollars, pounds sterling, euro - something like that?
Thanks |
|
Back to top |
|
|
pluby The Architect
Joined: Jun 16, 2003 Posts: 11949
|
Posted: Wed May 14, 2008 9:35 am Post subject: Re: Euro currency not displaying correctly |
|
LJ-Bettona wrote: | Also, the euro options are miles down the list. I nearly gave up hope of ever finding them. Even if entered alphabetically they should come before the Thai whatever. As so many countries now use the euro, could they be put near the top - dollars, pounds sterling, euro - something like that? |
I don't see that. When I have Italian date and number formats set in the System Preferences application, when I launch NeoOffice Calc, select the Format :: Cells menu, click on the Numbers tab, and select Currency, the currency is set to Euros.
This is how NeoOffice's underlying OpenOffice.org code works: it tries to match the currency to your system's locale so that you do not have to look through the massive list of currencies. So if you use Italian formatting frequently, can you verify that you have Italian date and number formats set in the System Preference application?
To do this, open the System Preferences application, click on the International icon, and click on the Formats tab. Check the Show All Regions checkbox and select Italy :: Italian for the Region. After doing this, relaunch NeoOffice.
Patrick |
|
Back to top |
|
|
LJ-Bettona Keymaker
Joined: Jan 23, 2008 Posts: 98 Location: United States
|
Posted: Wed May 14, 2008 2:18 pm Post subject: |
|
OK - I can do that. But what a bind. I work in English most of the time and only flip to the Italian Pro keyboard and Italian spellcheck when I am using Italian. This means resetting everything every time I need to use Italian. And, more importantly, remembering to set it back. But, if that's how it works, I'll just have to discipline myself.
Thanks |
|
Back to top |
|
|
LJ-Bettona Keymaker
Joined: Jan 23, 2008 Posts: 98 Location: United States
|
Posted: Wed May 14, 2008 2:36 pm Post subject: |
|
I found another way, and I think I may be happier with it set this way.
System prefs are set to:
Region UK (that gets my dates the way I want)
Currency Sterling
Office language prefs are:
Interface English (So I can understand all the instructions)
Locale Italian (gets my decimal separator as a , and my currency as Euro)
Default language English (my docs should start out in English and so should the spell check)
Of course, I have to change the spellcheck language when I start a doc or sheet in Italian, but that's easy to do when I change the keyboard. And I still have to remember to change the locale back to USA or UK if I'm using numbers where it matters what the decimal separator is. But at least it's just Neo that's affected, not the whole system.
At least I'l try it this way for a while and see how it works.
Thanks |
|
Back to top |
|
|
sardisson Town Crier
Joined: Feb 01, 2004 Posts: 4588
|
Posted: Wed May 14, 2008 4:04 pm Post subject: |
|
I *think* that you can set up templates with the various defaults, so you could set up a template for Italian documents and another for English ones, and open one or the other depending on the document you want to create.
Smokey _________________ "[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki |
|
Back to top |
|
|
LJ-Bettona Keymaker
Joined: Jan 23, 2008 Posts: 98 Location: United States
|
Posted: Thu May 15, 2008 1:40 am Post subject: |
|
Sardisson,
You are a genius!!! 10 out of 10!!
That's the answer.
I have created 4 templates :
2 in Writer - English and Italian
2 in Calc - English and Italian
One of the main tricks is to watch the 'This document only' check box. That seems to guarantee that the change in country doesn't spill over onto another template.
So far, they have all tested OK. At least the spell checkers are correct for the language I want in each and the numbers are in the expected format. And new docs do not use the other spell checker. I'm happy with that.
Maybe we should rename this post 'Templates and how to use them' or 'Neo Office in more than one language' ?
Thanks so much. |
|
Back to top |
|
|
sardisson Town Crier
Joined: Feb 01, 2004 Posts: 4588
|
Posted: Thu May 15, 2008 8:21 am Post subject: |
|
We should get this in the wiki as one of the examples on the Editing the Default Styles and Using Templates page....
Smokey _________________ "[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki |
|
Back to top |
|
|
LJ-Bettona Keymaker
Joined: Jan 23, 2008 Posts: 98 Location: United States
|
Posted: Fri May 16, 2008 12:59 am Post subject: |
|
Do you want me to create a full description of the steps to follow? I have editing privileges as I help Lorinda by proof reading her tutorial.
Just don't ask for it tomorrow, please. |
|
Back to top |
|
|
sardisson Town Crier
Joined: Feb 01, 2004 Posts: 4588
|
Posted: Fri May 16, 2008 4:13 am Post subject: |
|
LJ-Bettona wrote: | Do you want me to create a full description of the steps to follow? I have editing privileges as I help Lorinda by proof reading her tutorial. |
I added this to the "New Pages Needed" so that it would be picked up in time, but if you want to work on it, be my guest
LJ-Bettona wrote: | Just don't ask for it tomorrow, please. |
Of course not Whenever you have a chance.
Smokey _________________ "[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki |
|
Back to top |
|
|
|