Issue 46334 - Language not saved in XLS
Summary: Language not saved in XLS
Status: CLOSED DUPLICATE of issue 31933
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-03-30 23:29 UTC by david
Modified: 2005-06-25 13:33 UTC (History)
2 users (show)

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

Attachments
Export as XLS and watch as 1,000 becomes 1.000 (w/Danish format) (8.05 KB, application/vnd.sun.xml.calc)
2005-04-04 18:46 UTC, david 		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 david 2005-03-30 23:29:17 UTC 
When you save an .XLS file with currency or date set to e.g. English, then quit 
and load the XLS-file to check it, the currency is reset back to Danish and the 
dato is shown in Danish standard format too. That is of course if your default 
language is Danish so I guess the langue and localization format os not saved in 
XLS files. Please fix (especially it's a problem when your invoice of 1,000 
dollars suddenly turns out to be 1.0 dollar when you save it - and the date is 
no longer January 10th but October 1st).

-- David
Comment 1 daniel.rentz 2005-04-04 18:08:30 UTC 
Excel does not store the language of a date format at a cell. It does some
auto-magic after loading the document, according to the date format. For
instance it detects the format DD-MM-YY to be Danish and shows this in the
number format dialog. Nevertheless, the export of number formats to Excel is
somewhat limited in Calc, see issue 31933. But -- the filter should never change
a number itself, e.g. never 1000 dollars become 1 dollar, and never the 10th of
Jan becomes 1st of Oct. If this happens, please reopen this issue and attach an
excel document to reproduce.

*** This issue has been marked as a duplicate of 31933 ***
Comment 2 daniel.rentz 2005-04-04 18:08:47 UTC 
double -> closed
Comment 3 david 2005-04-04 18:45:38 UTC 
Problem is that 1,000 becomes 1.000 if you're not using American default 
regional settings. This way if you print it out and send it to an American 
customer he'll be pretty happy (which is alright but not really the point :)

I hope you can find a way to avoid this. Perhaps instead of using "Default" 
regional format you could encode that into the cell content somehow.

Load the following attachment and export is as XLS and load it.
Comment 4 david 2005-04-04 18:46:47 UTC 
Created attachment 24638 [details]
Export as XLS and watch as 1,000 becomes 1.000 (w/Danish format)
Comment 5 stp 2005-06-25 13:33:05 UTC 
Regarding 1.000 turning into 1 please see issue 39898, issue 50670 and issue 38494.