ooo-build r14204 - in trunk: . scratch/sc-xlsutil/src

[kyoshida svn gnome org]

Author: kyoshida
Date: Fri Oct  3 16:12:12 2008
New Revision: 14204
URL: http://svn.gnome.org/viewvc/ooo-build?rev=14204&view=rev

Log:
2008-10-03  Kohei Yoshida  <kyoshida novell com>

	* scratch/sc-xlsutil/src/record.py:
	* scratch/sc-xlsutil/src/stream.py: added handler for the chart 
	properties record, which contains Excel's chart specific options.  In
	Excel, each embedded chart can have its own set of option values.


Modified:
   trunk/ChangeLog
   trunk/scratch/sc-xlsutil/src/record.py
   trunk/scratch/sc-xlsutil/src/stream.py

Modified: trunk/scratch/sc-xlsutil/src/record.py
==============================================================================
--- trunk/scratch/sc-xlsutil/src/record.py	(original)
+++ trunk/scratch/sc-xlsutil/src/record.py	Fri Oct  3 16:12:12 2008
@@ -574,3 +574,36 @@
         self.appendLine("position: (x, y) = (%d, %d)"%(x, y))
         self.appendLine("size: (width, height) = (%d, %d)"%(w, h))
         
+
+class CHProperties(BaseRecordHandler):
+
+    def parseBytes (self):
+        flags = globals.getSignedInt(self.bytes[0:2])
+        emptyFlags = globals.getSignedInt(self.bytes[2:4])
+
+        manualSeries   = "false"
+        showVisCells   = "false"
+        noResize       = "false"
+        manualPlotArea = "false"
+
+        if (flags & 0x0001):
+            manualSeries = "true"
+        if (flags & 0x0002):
+            showVisCells = "true"
+        if (flags & 0x0004):
+            noResize = "true"
+        if (flags & 0x0008):
+            manualPlotArea = "true"
+
+        self.appendLine("manual series: %s"%manualSeries)
+        self.appendLine("show only visible cells: %s"%showVisCells)
+        self.appendLine("no resize: %s"%noResize)
+        self.appendLine("manual plot area: %s"%manualPlotArea)
+
+        emptyValues = "skip"
+        if emptyFlags == 1:
+            emptyValues = "plot as zero"
+        elif emptyFlags == 2:
+            emptyValues = "interpolate empty values"
+
+        self.appendLine("empty value treatment: %s"%emptyValues)

Modified: trunk/scratch/sc-xlsutil/src/stream.py
==============================================================================
--- trunk/scratch/sc-xlsutil/src/stream.py	(original)
+++ trunk/scratch/sc-xlsutil/src/stream.py	Fri Oct  3 16:12:12 2008
@@ -230,7 +230,7 @@
     0x103F: ["CHSURFACE", "?"],
     0x1040: ["CHRADARAREA", "?"],
     0x1041: ["CHAXESSET", "?"],
-    0x1044: ["CHPROPERTIES", "?"],
+    0x1044: ["CHPROPERTIES", "?", record.CHProperties],
     0x1045: ["CHSERGROUP", "?"],
     0x1048: ["CHPIVOTREF", "?"],
     0x104A: ["CHSERPARENT", "?"],