Issue 65095 - date format change not saved
Summary: date format change not saved
Status: CLOSED DUPLICATE of issue 31933
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needmoreinfo, oooqa
: 65096 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-05-04 19:24 UTC by pippilotta
Modified: 2006-07-03 10:40 UTC (History)
2 users (show)

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

Attachments
expample for date format (6.16 KB, application/vnd.sun.xml.calc)
2006-05-05 23:59 UTC, pippilotta 		no flags Details
expample for date format Excel (6.50 KB, application/vnd.ms-excel)
2006-05-06 00:00 UTC, pippilotta 		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 pippilotta 2006-05-04 19:25:00 UTC 
I changed the date format from Standard to English (USA) and it works. But after
saving the file and closing Calc and reopen the same file, the format is again
Standard instead of English (USA)
Comment 1 frank 2006-05-04 22:25:25 UTC 
*** Issue 65096 has been marked as a duplicate of this issue. ***
Comment 2 Rainer Bielefeld 2006-05-05 06:14:26 UTC 
Seems I found a more clever way to do that change, 
WFM with "2.0.2  German version WIN XP: [680m5(Build9011)]"

If it does not cause too cause too much inconvenience, may be you can tell us
some more details how to reproduce that problem (best would be a step by step
instruction containing every mouse click and every key press you did) and attach
a sample file ;-) ?

Did you really test for all Platforms and OS?
Comment 3 pippilotta 2006-05-05 23:59:35 UTC 
Created attachment 36290 [details]
expample for date format
Comment 4 pippilotta 2006-05-06 00:00:00 UTC 
Created attachment 36291 [details]
expample for date format Excel
Comment 5 pippilotta 2006-05-06 00:06:04 UTC 
Hi,

I think after doing these two files I know a little bit more about, it always
happens, if I save the file as excel file.
Here is what I've done:
I write the date in the cell: 05/04/06, 
after using the tab button and jumping to the next cell,
the date changed to 05.04.06
I marked the cell and clicked on Format cell
I changed the language from standard to English (U.S.)
I clicked the OK button
the date in the cell changed to 05/04/06
I saved the file as Excel file
I closed the file
After reopen, it shows me the date as 05.04.06
BUT if I save it as OpenOffice file, the format change keeps save

I am sorry for any inconvenience, but I really would like to help to improve
OpenOffice, because I think this is a wonderful project!
Comment 6 frank 2006-07-03 10:39:29 UTC 
Hi,

double to Issue 46334 and therefore double to Issue 31933 .

Frank

*** This issue has been marked as a duplicate of 31933 ***
Comment 7 frank 2006-07-03 10:40:11 UTC 
closed double