https://issues.apache.org/ooo/show_bug.cgi?id=110031
--- Comment #2 from [email protected] --- I have the same (or related/similar?) problem in my English version OOO320m12 Build 9483. Account numbers of the format "n-mmmm" (e.g. 1-1110 for Cheque Account) are changed to dates. I attach two files as a test rig: Bug110031.ods Sheet 1 "Entered Data": The original spread sheet created with account numbers in a column, with cell format of "text". The remainder are account name (number), credits and debits and balance columns (all currency). Bug110031.csv This is a csv export of sheet1 of the above ods, with text delimiter set to nothing, i.e. no quotes. Done so, since this is the format, in which my accounting s/w spits out the data. Back to Bug110031.ods Sheet 2 ("ExternalDataReferenced") is full of cells, referencing the data in the csv. This is the problematic sheet. There are several scenarios having this sheet behaving in different ways: 1. If I open Bug110031.csv with oooCalc and leave all settings at default => account numbers are changed to dates 2. If I open Bug110031.csv with oooCalc and change the first column's format to "text" in the csv import dialog => account numbers remain as per original data input 3. If I first open Bug110031.csv as per point 1. and then open Bug110031.ods => *.ods changes my account numbers to dates. 4. If I first open Bug110031.csv as per point 2. and then open Bug110031.ods => *.ods shows account numbers as account numbers. 5. If I open Bug110031.ods before or without Bug110031.csv being open => *.ods behaves as per 3., i.e. changes my account numbers into dates. -- You are receiving this mail because: You are on the CC list for the bug.
