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

[kyoshida svn gnome org]

Author: kyoshida
Date: Sat Nov  8 05:53:43 2008
New Revision: 14467
URL: http://svn.gnome.org/viewvc/ooo-build?rev=14467&view=rev

Log:
2008-11-08  Kohei Yoshida  <kyoshida novell com>

	* scratch/sc-xlsutil/src/record.py:
	* scratch/sc-xlsutil/src/stream.py: added handler for SXVIEW
	(PivotTable view record).


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	Sat Nov  8 05:53:43 2008
@@ -760,6 +760,66 @@
         self.strmData.appendPivotCacheId(strmId)
         self.appendLine("pivot cache stream ID in SX DB storage: %d"%strmId)
 
+
+class SXView(BaseRecordHandler):
+
+    def parseBytes (self):
+        rowFirst = self.readUnsignedInt(2)
+        rowLast  = self.readUnsignedInt(2)
+        self.appendLine("row range: %d - %d"%(rowFirst, rowLast))
+
+        colFirst = self.readUnsignedInt(2)
+        colLast  = self.readUnsignedInt(2)
+        self.appendLine("col range: %d - %d"%(colFirst,colLast))
+
+        rowHeadFirst = self.readUnsignedInt(2)
+        rowDataFirst = self.readUnsignedInt(2)
+        colDataFirst = self.readUnsignedInt(2)
+        self.appendLine("heading row: %d"%rowHeadFirst)
+        self.appendLine("data row: %d"%rowDataFirst)
+        self.appendLine("data col: %d"%colDataFirst)
+
+        cacheIndex = self.readUnsignedInt(2)
+        self.appendLine("cache index: %d"%cacheIndex)
+
+        self.readBytes(2)
+
+        dataFieldAxis = self.readUnsignedInt(2)
+        self.appendLine("default data field axis: %d"%dataFieldAxis)
+
+        dataFieldPos = self.readUnsignedInt(2)
+        self.appendLine("default data field pos: %d"%dataFieldPos)
+
+        numFields = self.readUnsignedInt(2)
+        numRowFields = self.readUnsignedInt(2)
+        numColFields = self.readUnsignedInt(2)
+        numPageFields = self.readUnsignedInt(2)
+        numDataFields = self.readUnsignedInt(2)
+        numDataRows = self.readUnsignedInt(2)
+        numDataCols = self.readUnsignedInt(2)
+        self.appendLine("field count: %d"%numFields)
+        self.appendLine("row field count: %d"%numRowFields)
+        self.appendLine("col field count: %d"%numColFields)
+        self.appendLine("page field count: %d"%numPageFields)
+        self.appendLine("data field count: %d"%numDataFields)
+        self.appendLine("data row count: %d"%numDataRows)
+        self.appendLine("data col count: %d"%numDataCols)
+
+        # option flags (TODO: display these later.)
+        flags = self.readUnsignedInt(2)
+
+        # autoformat index
+        autoFmtIndex = self.readUnsignedInt(2)
+        self.appendLine("autoformat index: %d"%autoFmtIndex)
+
+        nameLenTable = self.readUnsignedInt(2)
+        nameLenDataField = self.readUnsignedInt(2)
+        text, nameLenTable = globals.getRichText(self.readBytes(nameLenTable+1), nameLenTable)
+        self.appendLine("PivotTable name: %s"%text)
+        text, nameLenDataField = globals.getRichText(self.readBytes(nameLenDataField+1), nameLenDataField)
+        self.appendLine("data field name: %s"%text)
+
+
 class SXViewSource(BaseRecordHandler):
 
     def parseBytes (self):
@@ -779,6 +839,7 @@
 
         self.appendLine("data source type: %s"%srcType)
 
+
 class SXViewFields(BaseRecordHandler):
 
     def parseBytes (self):

Modified: trunk/scratch/sc-xlsutil/src/stream.py
==============================================================================
--- trunk/scratch/sc-xlsutil/src/stream.py	(original)
+++ trunk/scratch/sc-xlsutil/src/stream.py	Sat Nov  8 05:53:43 2008
@@ -90,7 +90,7 @@
     0x00AB: ["GCW", "Global Column-Width Flags"],
     0x00AE: ["SCENMAN", "Scenario Output Data"],
     0x00AF: ["SCENARIO", "Scenario Data"],
-    0x00B0: ["SXVIEW", "View Definition"],
+    0x00B0: ["SXVIEW", "View Definition", record.SXView],
     0x00B1: ["SXVD", "View Fields", record.SXViewFields],
     0x00B2: ["SXVI", "View Item", record.SXViewItem],
     0x00B4: ["SXIVD", "Row/Column Field IDs"],