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.