summaryrefslogtreecommitdiffstats
path: root/test/xls-xml/formatted-text
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-15 05:48:59 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-15 05:48:59 +0000
commitc484829272cd13a738e35412498e12f2c9a194ac (patch)
treea1f5ec09629ee895bd3963fa8820b45f2f4c574b /test/xls-xml/formatted-text
parentInitial commit. (diff)
downloadliborcus-upstream/0.19.2.tar.xz
liborcus-upstream/0.19.2.zip
Adding upstream version 0.19.2.upstream/0.19.2upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'test/xls-xml/formatted-text')
-rw-r--r--test/xls-xml/formatted-text/basic.xml241
1 files changed, 241 insertions, 0 deletions
diff --git a/test/xls-xml/formatted-text/basic.xml b/test/xls-xml/formatted-text/basic.xml
new file mode 100644
index 0000000..afdd730
--- /dev/null
+++ b/test/xls-xml/formatted-text/basic.xml
@@ -0,0 +1,241 @@
+<?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>2023-09-03T16:52:11Z</Created>
+ <LastSaved>2023-09-04T00:51:59Z</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>
+ <ActiveSheet>2</ActiveSheet>
+ <Iteration/>
+ <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">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"
+ ss:Bold="1"/>
+ </Style>
+ <Style ss:ID="s17">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"
+ ss:Italic="1"/>
+ </Style>
+ <Style ss:ID="s18">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"
+ ss:Bold="1" ss:Italic="1"/>
+ </Style>
+ <Style ss:ID="s19">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"
+ ss:Underline="Single"/>
+ </Style>
+ <Style ss:ID="s20">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"
+ ss:Bold="1" ss:Underline="Single"/>
+ </Style>
+ <Style ss:ID="s21">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"
+ ss:StrikeThrough="1"/>
+ </Style>
+ <Style ss:ID="s22">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"
+ ss:VerticalAlign="Superscript"/>
+ </Style>
+ <Style ss:ID="s23">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"
+ ss:VerticalAlign="Subscript"/>
+ </Style>
+ <Style ss:ID="s24">
+ <Font ss:FontName="Calibri Light" x:Family="Swiss" ss:Size="12"
+ ss:Color="#000000"/>
+ </Style>
+ <Style ss:ID="s25">
+ <Font ss:FontName="Arial" x:Family="Swiss" ss:Size="18" ss:Color="#000000"/>
+ </Style>
+ <Style ss:ID="s26">
+ <Font ss:FontName="Times New Roman" x:Family="Roman" ss:Size="14"
+ ss:Color="#000000"/>
+ </Style>
+ <Style ss:ID="s27">
+ <Font ss:FontName="Consolas" x:Family="Modern" ss:Size="9" ss:Color="#000000"/>
+ </Style>
+ <Style ss:ID="s28">
+ <Font ss:FontName="Bookman Old Style" x:Family="Roman" ss:Size="20"
+ ss:Color="#000000"/>
+ </Style>
+ </Styles>
+ <Worksheet ss:Name="Text Properties">
+ <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="15" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Column ss:Width="142.5"/>
+ <Row>
+ <Cell><Data ss:Type="String">Normal Text</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s16"><Data ss:Type="String">Bold Text</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s17"><Data ss:Type="String">Italic Text</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s18"><Data ss:Type="String">Bold and Italic Text</Data></Cell>
+ </Row>
+ <Row>
+ <Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><B><Font
+ html:Color="#000000">Bold</Font></B><Font html:Color="#000000"> and </Font><I><Font
+ html:Color="#000000">Italic</Font></I><Font html:Color="#000000"> mixed</Font></ss:Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s16"><ss:Data ss:Type="String"
+ xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Color="#000000">Bold base with </Font></B><Font
+ html:Color="#000000">non-bold</Font><B><Font html:Color="#000000"> part</Font></B></ss:Data></Cell>
+ </Row>
+ <Row>
+ <Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><Font
+ html:Color="#000000">Only partially </Font><U><Font html:Color="#000000">underlined</Font></U></ss:Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s19"><Data ss:Type="String">All Underlined</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s20"><Data ss:Type="String">Bold and underlined</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s21"><Data ss:Type="String">All Strikethrough</Data></Cell>
+ </Row>
+ <Row>
+ <Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><Font
+ html:Color="#000000">Partial </Font><S><Font html:Color="#000000">strikethrough</Font></S></ss:Data></Cell>
+ </Row>
+ <Row ss:Height="17.25">
+ <Cell ss:StyleID="s22"><Data ss:Type="String">Superscript</Data></Cell>
+ </Row>
+ <Row ss:Height="18">
+ <Cell ss:StyleID="s23"><Data ss:Type="String">Subscript</Data></Cell>
+ </Row>
+ <Row ss:Height="17.25">
+ <Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><Font
+ html:Color="#000000">x</Font><Sup><Font html:Color="#000000">2</Font></Sup><Font
+ html:Color="#000000"> + y</Font><Sup><Font html:Color="#000000">2</Font></Sup><Font
+ html:Color="#000000"> = 10</Font><Sup><Font html:Color="#000000">2</Font></Sup></ss:Data></Cell>
+ </Row>
+ <Row ss:Height="18">
+ <Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><Font
+ html:Color="#000000">x</Font><Sub><Font html:Color="#000000">i</Font></Sub><Font
+ html:Color="#000000"> = y</Font><Sub><Font html:Color="#000000">i</Font></Sub><Font
+ html:Color="#000000"> + z</Font><Sub><Font html:Color="#000000">i</Font></Sub></ss: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>
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ <ActiveRow>10</ActiveRow>
+ <ActiveCol>14</ActiveCol>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+ <Worksheet ss:Name="Fonts">
+ <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="5" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Column ss:Width="240"/>
+ <Column ss:Width="117.75"/>
+ <Row ss:Height="15.75">
+ <Cell ss:StyleID="s24"><Data ss:Type="String">Calibri Light 12</Data></Cell>
+ <Cell ss:StyleID="s24"><Data ss:Type="String">Monterotondo</Data></Cell>
+ </Row>
+ <Row ss:Height="23.25">
+ <Cell ss:StyleID="s25"><Data ss:Type="String">Arial 18</Data></Cell>
+ <Cell ss:StyleID="s25"><Data ss:Type="String">Ciayunan</Data></Cell>
+ </Row>
+ <Row ss:Height="18.75">
+ <Cell ss:StyleID="s26"><Data ss:Type="String">Times New Roman 14</Data></Cell>
+ <Cell ss:StyleID="s26"><Data ss:Type="String">Gaoguan</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s27"><Data ss:Type="String">Consolas 9</Data></Cell>
+ <Cell ss:StyleID="s27"><Data ss:Type="String">Gumdag</Data></Cell>
+ </Row>
+ <Row ss:Height="25.5">
+ <Cell ss:StyleID="s28"><Data ss:Type="String">Bookman Old Style 20</Data></Cell>
+ <Cell ss:StyleID="s28"><Data ss:Type="String">Tornabous</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>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+ <Worksheet ss:Name="Mixed Fonts">
+ <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="2" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Column ss:Width="467.25"/>
+ <Row ss:Height="15.75">
+ <Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><Font
+ html:Color="#000000">C++ has </Font><Font html:Face="Liberation Mono"
+ x:Family="Modern" html:Color="#000000">class</Font><Font html:Color="#000000"> and </Font><Font
+ html:Face="Liberation Mono" x:Family="Modern" html:Color="#000000">struct</Font><Font
+ html:Color="#000000"> as keywords.</Font></ss:Data></Cell>
+ </Row>
+ <Row ss:Height="46.5">
+ <Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><Font
+ html:Color="#000000">Text with </Font><Font html:Size="12"
+ html:Color="#FF0000">12</Font><Font html:Size="12" html:Color="#000000">-point</Font><Font
+ html:Color="#000000"> font, </Font><Font html:Size="24" html:Color="#FF0000">24</Font><Font
+ html:Size="24" html:Color="#000000">-point</Font><Font html:Color="#000000"> font, and </Font><Font
+ html:Size="36" html:Color="#FF0000">36</Font><Font html:Size="36"
+ html:Color="#000000">-point</Font><Font html:Color="#000000"> font mixed.</Font></ss: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>
+ <Selected/>
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ <ActiveRow>1</ActiveRow>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+</Workbook>