Posted: Thu Apr 16, 2009 2:06 am Post subject: Calc ignores international settings
Using Mac OSX 10.5.6, NeoOffice 3.0-patch 1.
I use a Macbook2,1 with an external Mac USB keyboard with a numeric keypad. International Settings says that numbers are "1.234,56", i.e. that the decimal sign is a comma, and dates are "05/01/2009".. On the external keyboard, the corresponding key is labelled as a point. The region is "Custom"
In the Calculator app, when I press the above-mentioned key, a comma is displayed. NeoOffice also displays numbers in the correct format by default.
1) However, when entering numbers via the external keyboard, Calc will insert a point.
2) This is interpreted by Calc as a date, and Calc will display dates as "05.01.2009".
Is there any way to make NeoOffice honor the International Settings?
Posted: Thu Apr 16, 2009 7:31 am Post subject: Re: Calc ignores international settings
uselpa wrote:
In the Calculator app, when I press the above-mentioned key, a comma is displayed. NeoOffice also displays numbers in the correct format by default.
1) However, when entering numbers via the external keyboard, Calc will insert a point.
2) This is interpreted by Calc as a date, and Calc will display dates as "05.01.2009".
Is there any way to make NeoOffice honor the International Settings?
It sounds to me like the problem is that when you are pressing the "." key on external numeric keyboard, the keyboard is sending a "." character to NeoOffice. While "." key on your internal keyboard is configured to send a "," character to NeoOffice, your external keyboard is configured to send a "." for its "." key.
Can you test my theory by launching the /Applications/TextEdit and type the "." key on your external keyboard? Does a "." or a "," appear?
Posted: Thu Apr 16, 2009 12:02 pm Post subject: Re: Calc ignores international settings
pluby wrote:
Can you test my theory by launching the /Applications/TextEdit and type the "." key on your external keyboard? Does a "." or a "," appear?
Patrick
On the laptop's internal keyboard, the "." key sends a "." and the "," key sends a ",". The external keyboard works exactly in the same way, so in Textedit characters appear exactly as labeled on both keyboards.
What I think is happening is that some applications, such as OSX's Calculator, treat the "." key of the numeric keypad in a special way, substituting the received character (or sense code) with the decimal separator as set in the International settings.
Posted: Thu Apr 16, 2009 12:56 pm Post subject: Re: Calc ignores international settings
uselpa wrote:
What I think is happening is that some applications, such as OSX's Calculator, treat the "." key of the numeric keypad in a special way, substituting the received character (or sense code) with the decimal separator as set in the International settings.
You are correct: Calculator does replace "." characters with "," for certain locales. Unfortunately, NeoOffice Calc does not do any replacement.
One workaround is to change your keyboard language to match the locale of your numbers. For example, if I set my keyboard to Mac OS X's French keyboard, pressing the "." on my numeric keyboard enters a "," in any application including NeoOffice.
Can you tell us which language your keyboard is set to? If you are not sure which keyboard language you are using, can you launch the System Preferences application, click on the International icon, click on the Input Menu tab, and tell us which languages are checked?
Posted: Thu Apr 16, 2009 1:20 pm Post subject: Re: Calc ignores international settings
pluby wrote:
Can you tell us which language your keyboard is set to? If you are not sure which keyboard language you are using, can you launch the System Preferences application, click on the International icon, click on the Input Menu tab, and tell us which languages are checked?
Patrick
The Keyboard is Swiss-French.
In the Format tab, I did the following:
1) Set to UK, since OS X is in English and I want the interface to be in English
2) changed the currency to EURO
3) since at this stage the number format is 1,234.56, swapped . and , by issuing "defaults write -g AppleICUNumberSymbols -dict 0 ',' 1 '.' 10 ',' 17 '.' " (ugly, I know, but you can't change that via System Preferences) - at this point the region changed to "Custom"
Posted: Thu Apr 16, 2009 1:33 pm Post subject: Re: Calc ignores international settings
uselpa wrote:
The Keyboard is Swiss-French.
That is the problem. Mac OS X's Swiss-French keyboard maps the numeric keypads "." character to "." just like the U.S. English keyboard. The other settings that you have made won't hurt NeoOffice and they only affect how your data is displayed after you have input the data.
Since the Swiss-French keyboard is always going to enter a "." for that key, you might want to try switching to Mac OS X's French keyboard when you input lots of numbers. The French keyboard maps the "." to "," so you will be able to enter a "," by pressing the numeric keypad's "." key.
To switch to the French keyboard while in NeoOffice (or any other application), launch the System Preferences application, click on the International icon, click on the Input Menu tab, and check the French checkbox.
After doing the above steps, a flag will then appear in the right end of the Mac OS X menubar. Select a NeoOffice Calc window and then click on the flag and you will see the French keyboard. Click on the French keyboard.
Does using the French keyboard input "," when you press the "." in the external keyboard?
Installing DoubleCommand and activating "swap numpad-. with numpad-shift-. did the trick (well, half of the trick, because I now get "," regardless of whether I use shift or not, but that's a subject for DoubleCommand's forum).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum