Issue 95969 - International settings not correctly used for decimal separator
Summary: International settings not correctly used for decimal separator
Status: CLOSED DUPLICATE of issue 51662
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.0
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-07 16:29 UTC by teoman_it
Modified: 2009-07-22 23:16 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
OO Calc and Excel conparison (311.70 KB, image/jpeg)
2008-11-07 16:30 UTC, teoman_it 		no flags Details
An ods file about "Thousand separator" (7.68 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-11-21 07:52 UTC, chl207 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description teoman_it 2008-11-07 16:29:18 UTC 
Don't know if it was present in the previous versions.

I'm Italian and I have Windows XP SP3 configured in International Settings as 
Italian(Italy)
I also prefere writing numbers as 1'234.56 instead of the default proposed by 
Windows 1.234,56 so I changed the default behaviour in International Settings.
Excel works fine, but OO Calc writes numbers using the default setting for 
Italian(Italy) instead of my customized ones.
In OO Calc Tools->Options->Language Settings->Languages I did't touch settings 
and left Standard in all Boxes.

I don't think it's a configuration issue, because if I leave Standard, I think 
settings should be taken from the current settings in windows.
Comment 1 teoman_it 2008-11-07 16:30:47 UTC 
Created attachment 57769 [details]
OO Calc and Excel conparison
Comment 2 chl207 2008-11-21 07:10:16 UTC 
In OOo3.0RC4 On WinXP，the issue exists. But maybe you can solve it (in Chinese 
and English version can) by changing the cell's "Format code": from #,###.00 
to #'###.00 in Format Cells dialogue_box. Please have a try!
Comment 3 chl207 2008-11-21 07:50:10 UTC 
Sorry, the above solution has a defect: when a number's integral part over six 
bits, it still shows only one '.
Comment 4 chl207 2008-11-21 07:52:10 UTC 
Created attachment 58181 [details]
An ods file about "Thousand separator"
Comment 5 teoman_it 2008-11-21 12:56:26 UTC 
Thank you for the hint, but this is only a workaround.
It is not easy to set EVERY cell of the sheet for EVERY sheet opened or created.
Comment 6 aoo-bugger 2009-06-13 01:10:51 UTC 
Hi, the feature to take the settings from your OS (Windows, Linux, etc.) is
currently not available in OOo 3.1, see post from er Wed Jan 10 15:24:59 2007 in
Issue 51662.

This issue is a duplicate of Issue 51662
Comment 7 gibi 2009-07-22 23:03:21 UTC 
So closing it as a duplicate of issue 51662.

*** This issue has been marked as a duplicate of 51662 ***
Comment 8 gibi 2009-07-22 23:16:26 UTC 
I can't leave it as "resolved" so changing to only "closed"