Version: 1.6 beta 1 (using KDE KDE 3.5.4) Installed from: Gentoo Packages Compiler: gcc 4.1.1 OS: Linux The chart in the attached file was created in OpenOffice.org Calc. It is not rendered correctly in KSpread.

Created an attachment (id=17803) [details] Spreadsheet with some data and a chart from OOo Calc

SVN commit 589745 by ingwa: ODF: Create support for data in rows or columns Yay! This is the first ODF commit for kchart in a loooong time. Viva aKademy for giving me time to actually do this. CCBUGS: 134195 Btw, Bug 134195 is a great testcase because it is simple and yet contains a number of things that don't work yet. M +5 -0 ChangeLog M +8 -2 kchart_params.cc --- branches/koffice/1.6/koffice/kchart/ChangeLog #589744:589745 @@ -1,3 +1,8 @@ +2006-09-28 Inge Wallin <inge@lysator.liu.se> + + * kchart_params.cc (loadOasisPlotarea): Add support for + chart:series-source (row or column): + 2006-08-11 Inge Wallin <inge@lysator.liu.se> Only show checkboxes in config dialog if applicable. --- branches/koffice/1.6/koffice/kchart/kchart_params.cc #589744:589745 @@ -572,7 +572,11 @@ // chart:stock-with-volume - boolean // chart:japanese-candle-sticks - boolean - // chart:series-source - "row" or "columns + // chart:series-source - "rows" or "columns" + // "columns" is the default + if ( styleStack.attributeNS( KoXmlNS::chart, "series-source" ) == "rows" ) { + setDataDirection( DataRows ); + } // chart:data-label-number - "value" / "percentage" / "none" (def: none) @@ -957,6 +961,9 @@ break; } + // chart:series-source + plotAreaStyle.addProperty( "chart:series-source", + ( dataDirection() == DataRows ) ? "rows" : "columns" ); // Register the style, and get back its auto-generated name const QString styleName = mainStyles.lookup( plotAreaStyle, "ch" ); @@ -965,7 +972,6 @@ saveOasisAxis( bodyWriter, mainStyles, KDChartAxisParams::AxisPosBottom, "x" ); saveOasisAxis( bodyWriter, mainStyles, KDChartAxisParams::AxisPosLeft, "y" ); - // TODO chart:series // TODO chart:wall // TODO chart:floor }

Just found out by looking inside the file that it actually is invalid. The cells without value are given as "1.#NAN", which should be "NAN". This does not mean that kchart doesn't load the file wrong in other ways, of course. I am on those, but you should also bug report the file to OpenOffice.org as invalid.