Version: 1.5.2 (using KDE Devel) Installed from: Compiled sources Compiler: gcc (GCC) 4.1.0 (SUSE Linux) OS: Linux I'm not aware of any steps to reproduce this behavior, but after having opened http://bugs.kde.org/attachment.cgi?id=17152&action=view, saved it and started a new map in the same KSpread process, I encountered, that some empty cells were filled with zero after saving and reopening the created map. Only the empty cells before a non-default cell in a row were affected. (First, I thought it was just related to copy & paste, but it was not.) If you find a way to reproduce this issue, post it here. [Even if this report is about a not reproducable issue, it should stay open!]

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. ***