Related bug:
bug 126050

I encountered this bug several times lately, but like stefan, i'm not sure
about the way to reproduce it. 

Here what I did : open an ods file with OOo calc and do some stuff and save,
open the same file with kspread and do some stuff, then i save and reopen it,
and there were a lots of cells filled with zeros... I delete them but they
reappear the next time i open the file, and there are more columns "infected"
with zeros cells. 

At this address i talk about this bug :
http://bugs.kde.org/show_bug.cgi?id=131501

Created an attachment (id=17159) [details]
file with a lot of cells filled with zeros

Every time i erase the zeros, save the file and reopen it, there are more zeros
than the previous time.

Created an attachment (id=17172) [details]
Minimal triggering doc

I've broken it down to these lines in contents.xml. Relevant is the repetition,
without it there are no zeros.

<office:spreadsheet>
 <table:table table:name="Sheet1">
  <table:table-row table:style-name="ro1">
   <table:table-cell office:value-type="float" office:value="0"
table:number-columns-repeated="2"/>
   <table:table-cell office:value-type="float" office:value="1"/>
  </table:table-row>
 </table:table>
</office:spreadsheet>

SVN commit 568152 by nikolaus:

OpenDocument	Fix "Zeros all over after opening an OpenDocument file"
BUGS: 131508
CCMAIL: mecirt@gmail.com


 M  +1 -0      branches/koffice/1.6/koffice/kspread/kspread_value.cc  
 M  +1 -0      trunk/koffice/kspread/Value.cpp  


--- branches/koffice/1.6/koffice/kspread/kspread_value.cc #568151:568152
@@ -623,6 +623,7 @@
 
 void Value::setFormat (Value::Format fmt)
 {
+  detach();
   d->format = fmt;
 }
 
--- trunk/koffice/kspread/Value.cpp #568151:568152
@@ -625,6 +625,7 @@
 
 void Value::setFormat (Value::Format fmt)
 {
+  detach();
   d->format = fmt;
 }
 

*** Bug 134056 has been marked as a duplicate of this bug. ***