Version: 1.4.2 (using KDE 3.5.0, Gentoo) Compiler: gcc version 3.3.6 (Gentoo 3.3.6, ssp-3.3.6-1.0, pie-8.7.8) OS: Linux (i686) release 2.6.11-gentoo-r11 Hello, When you create a table, set there some whole number, like 6 and set the cell the data format to number with precision of 1 (so it shows '6.0'), it shows it OK. If I save it as KSpreadSheet, it is kept like it should. However, if I save it to OpenDocument, the data format get's lost. Next time, I see only '6', where there was '6.0'. Experimenting with OpenOffice a bit, I found out that the data format is ignored by KSpread both when loading and when saving. OpenOffice stores it in some way, saving and opening in OOo does remember it. Is there any more I info I can provide? If so, tell me.

SVN commit 531980 by nikolaus: "three in a row" OpenDocument Fix loading/saving of number formattings. Fix loading/saving of number precisions. Fix saving of large numbers. Parts of this patch (precision, BC preserving, hint for the large number issue) come from Ariya. Thanks. BUGS: 118331,125520,125632 M +19 -11 branches/koffice/1.5/koffice/kspread/kspread_cell.cc M +6 -0 branches/koffice/1.5/koffice/kspread/kspread_doc.cc M +10 -1 branches/koffice/1.5/koffice/kspread/kspread_format.cc M +2 -2 branches/koffice/1.5/koffice/kspread/kspread_format.h M +109 -23 branches/koffice/1.5/koffice/kspread/kspread_style.cc M +1 -1 branches/koffice/1.5/koffice/kspread/kspread_style.h M +1 -1 branches/koffice/1.5/koffice/lib/kofficecore/KoGenStyles.h M +123 -12 branches/koffice/1.5/koffice/lib/kofficecore/KoOasisStyles.cpp M +16 -0 branches/koffice/1.5/koffice/lib/kofficecore/KoOasisStyles.h M +29 -21 trunk/koffice/kspread/kspread_cell.cc M +6 -0 trunk/koffice/kspread/kspread_doc.cc M +9 -0 trunk/koffice/kspread/kspread_format.cc M +2 -2 trunk/koffice/kspread/kspread_format.h M +108 -23 trunk/koffice/kspread/kspread_style.cc M +1 -1 trunk/koffice/kspread/kspread_style.h M +1 -1 trunk/koffice/libs/kofficecore/KoGenStyle.h M +116 -17 trunk/koffice/libs/kofficecore/KoOasisStyles.cpp M +6 -1 trunk/koffice/libs/kofficecore/KoOasisStyles.h

System dates are still a problem. :(

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

SVN commit 569308 by nikolaus: OpenDocument Fix loading of system date formatting. Fix saving of prefix/suffix (not for dates, times and strings). BUGS: 118331 CCBUGS: 131052 M +1 -1 branches/koffice/1.6/koffice/kspread/kspread_cell.cc M +4 -0 branches/koffice/1.6/koffice/kspread/kspread_format.cc M +128 -70 branches/koffice/1.6/koffice/kspread/kspread_style.cc M +28 -15 branches/koffice/1.6/koffice/kspread/kspread_style.h M +28 -36 branches/koffice/1.6/koffice/lib/kofficecore/KoOasisStyles.cpp M +20 -23 branches/koffice/1.6/koffice/lib/kofficecore/KoOasisStyles.h M +1 -1 trunk/koffice/kspread/Cell.cpp M +4 -0 trunk/koffice/kspread/Format.cpp M +112 -53 trunk/koffice/kspread/Style.cpp M +24 -11 trunk/koffice/kspread/Style.h M +16 -8 trunk/koffice/libs/kofficecore/KoOasisStyles.cpp M +16 -8 trunk/koffice/libs/kofficecore/KoOasisStyles.h