"Spreadsheet View Data" for OASIS OpenDocument

Introduction

Spreadsheet document may contain view settings that are not necessarily a part of the document but are still useful for advanced usage. They are stored in the settings.xml file fragment.

Changes to the specification

Since view settings are stored under the office:settings element using the config:config-item-set and its child elements as described in Section 2.5, it should warrant adding another top-level Section (Section 9: View Settings) to describe the application view settings that can be stored with the document.

9 View Settings

View settings are those settings that influence the state of what gets displayed on screen. They are not necessarily a part of the document but are useful for smooth recovery of the application view state, which is a necessity by today's sophisticated graphical user interface (GUI) applications.

9.1 Word Processing Application

reserved for word processing application.

9.2 Spreadsheet Application

View settings for a spreadsheet application uses the following hierarchy:

Sample

Note: this sample XML output still has the ooo: prefix in the 'ooo:view-settings' name of the topmost element.

        <config:config-item-set config:name="ooo:view-settings">
            <config:config-item config:name="VisibleAreaTop" config:type="int">899</config:config-item>
            <config:config-item config:name="VisibleAreaLeft" config:type="int">4516</config:config-item>
            <config:config-item config:name="VisibleAreaWidth" config:type="int">2258</config:config-item>
            <config:config-item config:name="VisibleAreaHeight" config:type="int">450</config:config-item>
            <config:config-item-map-indexed config:name="Views">
                <config:config-item-map-entry>
                    <config:config-item config:name="ViewId" config:type="string">View1</config:config-item>
                    <config:config-item-map-named config:name="Tables">
                        <config:config-item-map-entry config:name="Sheet1">
                            <config:config-item config:name="CursorPositionX" config:type="int">2</config:config-item>
                            <config:config-item config:name="CursorPositionY" config:type="int">2</config:config-item>
                            <config:config-item config:name="HorizontalSplitMode" config:type="short">0</config:config-item>
                            <config:config-item config:name="VerticalSplitMode" config:type="short">0</config:config-item>
                            <config:config-item config:name="HorizontalSplitPosition" config:type="int">0</config:config-item>
                            <config:config-item config:name="VerticalSplitPosition" config:type="int">0</config:config-item>
                            <config:config-item config:name="ActiveSplitRange" config:type="short">2</config:config-item>
                            <config:config-item config:name="PositionLeft" config:type="int">0</config:config-item>
                            <config:config-item config:name="PositionRight" config:type="int">0</config:config-item>
                            <config:config-item config:name="PositionTop" config:type="int">0</config:config-item>
                            <config:config-item config:name="PositionBottom" config:type="int">0</config:config-item>
                            <config:config-item config:name="ZoomType" config:type="short">0</config:config-item>
                            <config:config-item config:name="ZoomValue" config:type="int">100</config:config-item>
                            <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item>
                            <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item>
                        </config:config-item-map-entry>
                    </config:config-item-map-named>
                    <config:config-item config:name="ActiveTable" config:type="string">Sheet1</config:config-item>
                    <config:config-item config:name="HorizontalScrollbarWidth" config:type="int">270</config:config-item>
                    <config:config-item config:name="ZoomType" config:type="short">0</config:config-item>
                    <config:config-item config:name="ZoomValue" config:type="int">100</config:config-item>
                    <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item>
                    <config:config-item config:name="ShowPageBreakPreview" config:type="boolean"> 
                    false</config:config-item>
                    <config:config-item config:name="ShowZeroValues" config:type="boolean">true</config:config-item>
                    <config:config-item config:name="ShowNotes" config:type="boolean">true</config:config-item>
                    <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item>
                    <config:config-item config:name="GridColor" config:type="long">12632256</config:config-item>
                    <config:config-item config:name="ShowPageBreaks" config:type="boolean">true</config:config-item>
                    <config:config-item config:name="HasColumnRowHeaders" config:type="boolean">true</config:config-item>
                    <config:config-item config:name="HasSheetTabs" config:type="boolean">true</config:config-item>
                    <config:config-item config:name="IsOutlineSymbolsSet" config:type="boolean">true</config:config-item>
                    <config:config-item config:name="IsSnapToRaster" config:type="boolean">false</config:config-item>
                    <config:config-item config:name="RasterIsVisible" config:type="boolean">false</config:config-item>
                    <config:config-item config:name="RasterResolutionX" config:type="int">1270</config:config-item>
                    <config:config-item config:name="RasterResolutionY" config:type="int">1270</config:config-item>
                    <config:config-item config:name="RasterSubdivisionX" config:type="int">1</config:config-item>
                    <config:config-item config:name="RasterSubdivisionY" config:type="int">1</config:config-item>
                    <config:config-item config:name="IsRasterAxisSynchronized" config:type="boolean"> 
                    true</config:config-item>
                </config:config-item-map-entry>
            </config:config-item-map-indexed>
        </config:config-item-set>

Spreadsheet_View_Data (last edited 2009-08-12 18:04:26 by localhost)