diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:48:59 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:48:59 +0000 |
commit | c484829272cd13a738e35412498e12f2c9a194ac (patch) | |
tree | a1f5ec09629ee895bd3963fa8820b45f2f4c574b /test/xls-xml/cell-properties | |
parent | Initial commit. (diff) | |
download | liborcus-c484829272cd13a738e35412498e12f2c9a194ac.tar.xz liborcus-c484829272cd13a738e35412498e12f2c9a194ac.zip |
Adding upstream version 0.19.2.upstream/0.19.2upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to '')
-rw-r--r-- | test/xls-xml/cell-properties/default-style.xml | 89 | ||||
-rw-r--r-- | test/xls-xml/cell-properties/locked-and-hidden.xml | 83 | ||||
-rw-r--r-- | test/xls-xml/cell-properties/wrap-and-shrink.xml | 82 |
3 files changed, 254 insertions, 0 deletions
diff --git a/test/xls-xml/cell-properties/default-style.xml b/test/xls-xml/cell-properties/default-style.xml new file mode 100644 index 0000000..f00b110 --- /dev/null +++ b/test/xls-xml/cell-properties/default-style.xml @@ -0,0 +1,89 @@ +<?xml version="1.0"?> +<?mso-application progid="Excel.Sheet"?> +<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" + xmlns:o="urn:schemas-microsoft-com:office:office" + xmlns:x="urn:schemas-microsoft-com:office:excel" + xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" + xmlns:html="http://www.w3.org/TR/REC-html40"> + <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> + <Author>Kohei Yoshida</Author> + <LastAuthor>Kohei Yoshida</LastAuthor> + <Created>2022-09-08T03:01:50Z</Created> + <Version>16.00</Version> + </DocumentProperties> + <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> + <AllowPNG/> + </OfficeDocumentSettings> + <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> + <WindowHeight>12315</WindowHeight> + <WindowWidth>28800</WindowWidth> + <WindowTopX>32767</WindowTopX> + <WindowTopY>32767</WindowTopY> + <ProtectStructure>False</ProtectStructure> + <ProtectWindows>False</ProtectWindows> + </ExcelWorkbook> + <Styles> + <Style ss:ID="Default" ss:Name="Normal"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Dot" ss:Weight="1"/> + </Borders> + <Font ss:FontName="DejaVu Sans" x:Family="Swiss" ss:Size="12" ss:Color="#000000"/> + <Interior ss:Color="#E2EFDA" ss:Pattern="Solid"/> + <NumberFormat ss:Format="0.0000"/> + <Protection x:HideFormula="1"/> + </Style> + </Styles> + <Worksheet ss:Name="Sheet1"> + <Table ss:ExpandedColumnCount="7" ss:ExpandedRowCount="6" x:FullColumns="1" + x:FullRows="1" ss:DefaultColumnWidth="68.25" ss:DefaultRowHeight="15.75"> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="String">A1</Data></Cell> + <Cell><Data ss:Type="String">B1</Data></Cell> + <Cell><Data ss:Type="String">C1</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="String">A2</Data></Cell> + <Cell><Data ss:Type="String">B2</Data></Cell> + <Cell><Data ss:Type="String">C2</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="String">A3</Data></Cell> + <Cell><Data ss:Type="String">B3</Data></Cell> + <Cell><Data ss:Type="String">C3</Data></Cell> + </Row> + <Row ss:Index="5" ss:AutoFitHeight="0"> + <Cell ss:Index="5"><Data ss:Type="String">E5</Data></Cell> + <Cell><Data ss:Type="String">F5</Data></Cell> + <Cell><Data ss:Type="String">G5</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell ss:Index="5"><Data ss:Type="String">E6</Data></Cell> + <Cell><Data ss:Type="String">F6</Data></Cell> + <Cell><Data ss:Type="String">G6</Data></Cell> + </Row> + </Table> + <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> + <PageSetup> + <Header x:Margin="0.3"/> + <Footer x:Margin="0.3"/> + <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/> + </PageSetup> + <Unsynced/> + <Print> + <ValidPrinterInfo/> + <VerticalResolution>0</VerticalResolution> + </Print> + <Selected/> + <Panes> + <Pane> + <Number>3</Number> + <ActiveRow>5</ActiveRow> + <ActiveCol>4</ActiveCol> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> +</Workbook> diff --git a/test/xls-xml/cell-properties/locked-and-hidden.xml b/test/xls-xml/cell-properties/locked-and-hidden.xml new file mode 100644 index 0000000..7b85e45 --- /dev/null +++ b/test/xls-xml/cell-properties/locked-and-hidden.xml @@ -0,0 +1,83 @@ +<?xml version="1.0"?> +<?mso-application progid="Excel.Sheet"?> +<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" + xmlns:o="urn:schemas-microsoft-com:office:office" + xmlns:x="urn:schemas-microsoft-com:office:excel" + xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" + xmlns:html="http://www.w3.org/TR/REC-html40"> + <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> + <Author>Kohei Yoshida</Author> + <LastAuthor>Kohei Yoshida</LastAuthor> + <Created>2022-09-13T23:36:16Z</Created> + <Version>16.00</Version> + </DocumentProperties> + <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> + <AllowPNG/> + </OfficeDocumentSettings> + <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> + <WindowHeight>12315</WindowHeight> + <WindowWidth>28800</WindowWidth> + <WindowTopX>32767</WindowTopX> + <WindowTopY>32767</WindowTopY> + <ProtectStructure>False</ProtectStructure> + <ProtectWindows>False</ProtectWindows> + </ExcelWorkbook> + <Styles> + <Style ss:ID="Default" ss:Name="Normal"> + <Alignment ss:Vertical="Bottom"/> + <Borders/> + <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/> + <Interior/> + <NumberFormat/> + <Protection/> + </Style> + <Style ss:ID="s63"> + <Alignment ss:Vertical="Bottom" ss:WrapText="1"/> + <Protection ss:Protected="0"/> + </Style> + <Style ss:ID="s64"> + <Alignment ss:Vertical="Bottom" ss:WrapText="1"/> + <Protection x:HideFormula="1"/> + </Style> + <Style ss:ID="s65"> + <Alignment ss:Vertical="Bottom" ss:WrapText="1"/> + <Protection x:HideFormula="1" ss:Protected="0"/> + </Style> + </Styles> + <Worksheet ss:Name="Sheet1"> + <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="2" x:FullColumns="1" + x:FullRows="1" ss:DefaultRowHeight="15"> + <Column ss:Width="205.5"/> + <Column ss:AutoFitWidth="0" ss:Width="132"/> + <Row ss:Height="30"> + <Cell><Data ss:Type="String">Default (Should be locked but not hidden)</Data></Cell> + <Cell ss:StyleID="s63"><Data ss:Type="String">Not Locked and not hidden</Data></Cell> + </Row> + <Row> + <Cell ss:StyleID="s64"><Data ss:Type="String">Locked and hidden</Data></Cell> + <Cell ss:StyleID="s65"><Data ss:Type="String">Not locked and hidden</Data></Cell> + </Row> + </Table> + <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> + <PageSetup> + <Header x:Margin="0.3"/> + <Footer x:Margin="0.3"/> + <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/> + </PageSetup> + <Print> + <ValidPrinterInfo/> + <VerticalResolution>0</VerticalResolution> + </Print> + <Selected/> + <Panes> + <Pane> + <Number>3</Number> + <ActiveRow>1</ActiveRow> + <ActiveCol>1</ActiveCol> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> +</Workbook> diff --git a/test/xls-xml/cell-properties/wrap-and-shrink.xml b/test/xls-xml/cell-properties/wrap-and-shrink.xml new file mode 100644 index 0000000..429110c --- /dev/null +++ b/test/xls-xml/cell-properties/wrap-and-shrink.xml @@ -0,0 +1,82 @@ +<?xml version="1.0"?> +<?mso-application progid="Excel.Sheet"?> +<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" + xmlns:o="urn:schemas-microsoft-com:office:office" + xmlns:x="urn:schemas-microsoft-com:office:excel" + xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" + xmlns:html="http://www.w3.org/TR/REC-html40"> + <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> + <Author>Kohei Yoshida</Author> + <LastAuthor>Kohei Yoshida</LastAuthor> + <Created>2022-05-18T00:46:32Z</Created> + <LastSaved>2022-05-18T01:44:54Z</LastSaved> + <Version>16.00</Version> + </DocumentProperties> + <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> + <AllowPNG/> + </OfficeDocumentSettings> + <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> + <WindowHeight>15990</WindowHeight> + <WindowWidth>29040</WindowWidth> + <WindowTopX>32767</WindowTopX> + <WindowTopY>32767</WindowTopY> + <ProtectStructure>False</ProtectStructure> + <ProtectWindows>False</ProtectWindows> + </ExcelWorkbook> + <Styles> + <Style ss:ID="Default" ss:Name="Normal"> + <Alignment ss:Vertical="Bottom"/> + <Borders/> + <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/> + <Interior/> + <NumberFormat/> + <Protection/> + </Style> + <Style ss:ID="s16"> + <Alignment ss:Vertical="Bottom" ss:WrapText="1"/> + </Style> + <Style ss:ID="s17"> + <Alignment ss:Vertical="Bottom" ss:ShrinkToFit="1"/> + </Style> + </Styles> + <Worksheet ss:Name="Sheet1"> + <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="3" x:FullColumns="1" + x:FullRows="1" ss:DefaultRowHeight="15"> + <Column ss:AutoFitWidth="0" ss:Width="85.5"/> + <Column ss:AutoFitWidth="0" ss:Width="88.5"/> + <Row> + <Cell><Data ss:Type="String">Default</Data></Cell> + <Cell><Data ss:Type="String">Text long enough to spill over</Data></Cell> + </Row> + <Row ss:Height="30"> + <Cell><Data ss:Type="String">Wrap text</Data></Cell> + <Cell ss:StyleID="s16"><Data ss:Type="String">Text long enough to spill over</Data></Cell> + </Row> + <Row> + <Cell><Data ss:Type="String">Shrink to fit</Data></Cell> + <Cell ss:StyleID="s17"><Data ss:Type="String">Text long enough to spill over</Data></Cell> + </Row> + </Table> + <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> + <PageSetup> + <Header x:Margin="0.3"/> + <Footer x:Margin="0.3"/> + <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/> + </PageSetup> + <Print> + <ValidPrinterInfo/> + <VerticalResolution>0</VerticalResolution> + </Print> + <Selected/> + <Panes> + <Pane> + <Number>3</Number> + <ActiveRow>9</ActiveRow> + <ActiveCol>14</ActiveCol> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> +</Workbook> |