Bug 124566

Summary: Incorrect data format when save to OASIS format.
Product: [Applications] calligrasheets Reporter: younker <younker_dl>
Component: opendocumentAssignee: Raphael Langerhorst <raphael.langerhorst>
Status: RESOLVED NOT A BUG    
Severity: normal    
Priority: NOR    
Version: unspecified   
Target Milestone: ---   
Platform: Gentoo Packages   
OS: Linux   
Latest Commit: Version Fixed In:

Description younker 2006-03-30 15:29:04 UTC 
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.
Comment 1 Stefan Nikolaus 2006-04-19 19:01:01 UTC 
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.
Comment 2 Stefan Nikolaus 2006-07-27 18:14:10 UTC 
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
Comment 3 Stefan Nikolaus 2006-08-03 15:44:44 UTC 
This is a bug in OpenOffice. Please refer to http://qa.openoffice.org/issues/show_bug.cgi?id=68116