Issue 90412 - Calc loses cell-specific language setting when exporting to xls
Summary: Calc loses cell-specific language setting when exporting to xls
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.4.0
Hardware: PC Windows 2000
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-05 18:24 UTC by grillon
Modified: 2013-01-29 21:49 UTC (History)
4 users (show)

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

Attachments
Number below "English" should use a dot as decimal separator, while the one under "Portuguese" should have a comma instead (62.50 KB, application/vnd.ms-excel)
2008-06-05 18:27 UTC, grillon 		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 grillon 2008-06-05 18:24:26 UTC 
Hi all,
I have some spreadsheet documents which must be saved in Excel .xls format and
have numbers saved in en-US format. Here is Brasil, so the default language
setting for OOo is pt-BR. So I opened the xls files and changed the numeric
cells language to English (USA) and saved them as xls again. When I opened the
same files again, the cells were all back to pt-BR. The OS regional settings are
en-US (again, working requirements).

Step-by-step procedure:
1.Set default language for OOo documents to pt-BR
2.Open spreadsheet
3.Format some cells to en-US number
4.Save as .xls (M$ Office 97)
5.Reopen file

Results: all cells are pt-BR again

Note: this is quite similar to Issue 68605, in respect to the plausible problem
cause (exact M$O format unknown). However, it refers to portions of the document
(cells), as opposed to that issue, that cites whole presentation files.

Best regards
Comment 1 grillon 2008-06-05 18:27:00 UTC 
Created attachment 54273 [details]
Number below "English" should use a dot as decimal separator, while the one under "Portuguese" should have a comma instead
Comment 2 amy2008 2008-07-04 07:50:12 UTC 
I can reproduce it in DEV300_m21_en WinXP.
Comment 3 clytie 2008-07-09 10:16:49 UTC 
I think this issue is also related to issue 90191: there appears to be an impersistence in the language 
settings. You change them, but they don't persist. I'm confirming this issue, since it can be reproduced 
in DEV300_m21 on WinXP.
Comment 4 grillon 2010-08-20 18:52:53 UTC 
JFI: I'm changing my username to "emersonprado". So, if someone notices
"grillon" is gone, that doesn't mean the bug reporter is gone.
Also: the bug still happens. :B
Comment 5 Francesca 2012-01-13 11:37:18 UTC 
I'm having the same issue with text cells: changed the language settings with the 'only for this file' flag and on reopening the language is my default Italian again...
F