Version: 1.5rc1 (using KDE KDE 3.5.1) Installed from: Gentoo Packages Compiler: gcc 4.1.0 OS: Linux Use default template create a spread file, fill some data in column A, such as 32345, don't change its format, then fill some date value in column B, such as 2006-02-03, change the whole column format to Date (system date), then save the spread as OASIS format, open it in OpenOffice Calc, the number cell also changed to date, with above sample, the date is 1988/7/21.
Results in: <table:table table:name="Sheet1" table:style-name="ta1"> <table:table-column table:style-name="co1"/> <table:table-column table:style-name="co1" table:default-cell-style-name="ce1"/> <table:table-column table:style-name="co1"/> <table:table-row table:style-name="ro1"> <table:table-cell office:value-type="float" office:value="32345"> <text:p>32345</text:p> </table:table-cell> <table:table-cell office:value-type="date" office:date-value="2006-02-03"> <text:p>03.02.2006</text:p> </table:table-cell> </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> </table:table> Seems like OO.o Calc is confused by the the repeated empty cell and the "default-cell-style-name" of the second column. Related to http://bugs.kde.org/show_bug.cgi?id=107956 Leave it open until the "default-cell-style-name" issue is clarified.
SVN commit 566941 by nikolaus: OpenDocument Default cell style name. Unless there's a clarification from the OpenDocument committee, we stay with the old (in my opinion the correct one) behaviour. At least it is better than losing styles assigned to cols/rows! CCBUGS: 107956, 124566, 130923 M +62 -45 branches/koffice/1.6/koffice/kspread/kspread_sheet.cc M +57 -45 trunk/koffice/kspread/Sheet.cpp
This is a bug in OpenOffice. Please refer to http://qa.openoffice.org/issues/show_bug.cgi?id=68116