summaryrefslogtreecommitdiffstats
path: root/test/xls-xml/colored-text
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--test/xls-xml/colored-text/check.txt13
-rw-r--r--test/xls-xml/colored-text/input.xml136
2 files changed, 149 insertions, 0 deletions
diff --git a/test/xls-xml/colored-text/check.txt b/test/xls-xml/colored-text/check.txt
new file mode 100644
index 0000000..b06bc36
--- /dev/null
+++ b/test/xls-xml/colored-text/check.txt
@@ -0,0 +1,13 @@
+ColoredText/0/0:string:"Standard colors (all cells)"
+ColoredText/0/1:string:"Standard colors (mixed)"
+ColoredText/1/0:string:"Dark Red"
+ColoredText/1/1:string:"Red and Blue"
+ColoredText/2/0:string:"Red"
+ColoredText/3/0:string:"Orange"
+ColoredText/4/0:string:"Yellow"
+ColoredText/5/0:string:"Light Green"
+ColoredText/6/0:string:"Green"
+ColoredText/7/0:string:"Light Blue"
+ColoredText/8/0:string:"Blue"
+ColoredText/9/0:string:"Dark Blue"
+ColoredText/10/0:string:"Purple"
diff --git a/test/xls-xml/colored-text/input.xml b/test/xls-xml/colored-text/input.xml
new file mode 100644
index 0000000..bc28b2e
--- /dev/null
+++ b/test/xls-xml/colored-text/input.xml
@@ -0,0 +1,136 @@
+<?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>2013-10-13T20:22:59Z</Created>
+ <LastSaved>2013-10-13T20:37:20Z</LastSaved>
+ <Version>15.00</Version>
+ </DocumentProperties>
+ <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
+ <AllowPNG/>
+ </OfficeDocumentSettings>
+ <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
+ <WindowHeight>9270</WindowHeight>
+ <WindowWidth>24915</WindowWidth>
+ <WindowTopX>480</WindowTopX>
+ <WindowTopY>120</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">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FF0000"/>
+ </Style>
+ <Style ss:ID="s17">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#C00000"/>
+ </Style>
+ <Style ss:ID="s18">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#92D050"/>
+ </Style>
+ <Style ss:ID="s19">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"
+ ss:Bold="1"/>
+ </Style>
+ <Style ss:ID="s20">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FFC000"/>
+ </Style>
+ <Style ss:ID="s21">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FFFF00"/>
+ </Style>
+ <Style ss:ID="s22">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#00B050"/>
+ </Style>
+ <Style ss:ID="s23">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#00B0F0"/>
+ </Style>
+ <Style ss:ID="s24">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#0070C0"/>
+ </Style>
+ <Style ss:ID="s25">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#002060"/>
+ </Style>
+ <Style ss:ID="s26">
+ <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#7030A0"/>
+ </Style>
+ </Styles>
+ <Worksheet ss:Name="ColoredText">
+ <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="11" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Column ss:AutoFitWidth="0" ss:Width="141"/>
+ <Column ss:AutoFitWidth="0" ss:Width="123"/>
+ <Row>
+ <Cell ss:StyleID="s19"><Data ss:Type="String">Standard colors (all cells)</Data></Cell>
+ <Cell ss:StyleID="s19"><Data ss:Type="String">Standard colors (mixed)</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s17"><Data ss:Type="String">Dark Red</Data></Cell>
+ <Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><Font
+ html:Color="#FF0000">Red</Font><Font html:Color="#000000"> and </Font><Font
+ html:Color="#0070C0">Blue</Font></ss:Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s16"><Data ss:Type="String">Red</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s20"><Data ss:Type="String">Orange</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s21"><Data ss:Type="String">Yellow</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s18"><Data ss:Type="String">Light Green</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s22"><Data ss:Type="String">Green</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s23"><Data ss:Type="String">Light Blue</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s24"><Data ss:Type="String">Blue</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s25"><Data ss:Type="String">Dark Blue</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:StyleID="s26"><Data ss:Type="String">Purple</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/>
+ <HorizontalResolution>600</HorizontalResolution>
+ <VerticalResolution>600</VerticalResolution>
+ </Print>
+ <Selected/>
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ <ActiveRow>2</ActiveRow>
+ <ActiveCol>1</ActiveCol>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+</Workbook>