summaryrefslogtreecommitdiffstats
path: root/test/xls-xml/borders
diff options
context:
space:
mode:
Diffstat (limited to 'test/xls-xml/borders')
-rw-r--r--test/xls-xml/borders/colors.xml109
-rw-r--r--test/xls-xml/borders/directions.xml121
-rw-r--r--test/xls-xml/borders/grid-box.xml237
-rw-r--r--test/xls-xml/borders/single-cells.xml202
4 files changed, 669 insertions, 0 deletions
diff --git a/test/xls-xml/borders/colors.xml b/test/xls-xml/borders/colors.xml
new file mode 100644
index 0000000..bab7dec
--- /dev/null
+++ b/test/xls-xml/borders/colors.xml
@@ -0,0 +1,109 @@
+<?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>2018-02-07T21:56:45Z</Created>
+ <LastSaved>2018-02-07T22:02: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>9105</WindowHeight>
+ <WindowWidth>13800</WindowWidth>
+ <WindowTopX>0</WindowTopX>
+ <WindowTopY>0</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="s62">
+ <Borders>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"
+ ss:Color="#FF0000"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s63">
+ <Borders>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"
+ ss:Color="#0070C0"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s64">
+ <Borders>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"
+ ss:Color="#00B050"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s65">
+ <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
+ <Borders>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"
+ ss:Color="#FFFF00"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"
+ ss:Color="#7030A0"/>
+ <Border ss:Position="DiagonalLeft" ss:LineStyle="Continuous" ss:Weight="3"
+ ss:Color="#00B0F0"/>
+ <Border ss:Position="DiagonalRight" ss:LineStyle="Continuous" ss:Weight="3"
+ ss:Color="#00B0F0"/>
+ </Borders>
+ </Style>
+ </Styles>
+ <Worksheet ss:Name="Sheet1">
+ <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="7" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="225.75"/>
+ <Row ss:AutoFitHeight="0"/>
+ <Row ss:Index="3" ss:AutoFitHeight="0">
+ <Cell ss:Index="2" ss:StyleID="s62"><Data ss:Type="String">Red -&gt;</Data></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell ss:Index="2" ss:StyleID="s63"><Data ss:Type="String">Blue -&gt;</Data></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell ss:Index="2" ss:StyleID="s64"><Data ss:Type="String">Green -&gt;</Data></Cell>
+ </Row>
+ <Row ss:Index="7" ss:AutoFitHeight="0" ss:Height="66.75">
+ <Cell ss:Index="2" ss:StyleID="s65"><Data ss:Type="String">&lt;- Yellow&#10;Purple -&gt;&#10;Light Blue \</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/>
+ <HorizontalResolution>600</HorizontalResolution>
+ <VerticalResolution>600</VerticalResolution>
+ </Print>
+ <Selected/>
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ <ActiveRow>8</ActiveRow>
+ <ActiveCol>1</ActiveCol>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+</Workbook>
diff --git a/test/xls-xml/borders/directions.xml b/test/xls-xml/borders/directions.xml
new file mode 100644
index 0000000..77be73b
--- /dev/null
+++ b/test/xls-xml/borders/directions.xml
@@ -0,0 +1,121 @@
+<?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>2018-01-14T17:03:52Z</Created>
+ <LastSaved>2018-01-25T01:00:20Z</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>7680</WindowHeight>
+ <WindowWidth>20490</WindowWidth>
+ <WindowTopX>0</WindowTopX>
+ <WindowTopY>0</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">
+ <Borders>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s17">
+ <Borders>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s18">
+ <Borders>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s19">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s20">
+ <Borders>
+ <Border ss:Position="DiagonalLeft" ss:LineStyle="Continuous" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s21">
+ <Borders>
+ <Border ss:Position="DiagonalRight" ss:LineStyle="Continuous" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s22">
+ <Borders>
+ <Border ss:Position="DiagonalLeft" ss:LineStyle="Continuous" ss:Weight="1"/>
+ <Border ss:Position="DiagonalRight" ss:LineStyle="Continuous" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ </Styles>
+ <Worksheet ss:Name="Directions">
+ <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="14" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="92.25"/>
+ <Row ss:Index="2">
+ <Cell ss:Index="2" ss:StyleID="s16"><Data ss:Type="String">top</Data></Cell>
+ </Row>
+ <Row ss:Index="4">
+ <Cell ss:Index="2" ss:StyleID="s17"><Data ss:Type="String">left</Data></Cell>
+ </Row>
+ <Row ss:Index="6">
+ <Cell ss:Index="2" ss:StyleID="s18"><Data ss:Type="String">right</Data></Cell>
+ </Row>
+ <Row ss:Index="8">
+ <Cell ss:Index="2" ss:StyleID="s19"><Data ss:Type="String">bottom</Data></Cell>
+ </Row>
+ <Row ss:Index="10">
+ <Cell ss:Index="2" ss:StyleID="s20"><Data ss:Type="String">tl to br</Data></Cell>
+ </Row>
+ <Row ss:Index="12">
+ <Cell ss:Index="2" ss:StyleID="s21"><Data ss:Type="String">tr to bl</Data></Cell>
+ </Row>
+ <Row ss:Index="14">
+ <Cell ss:Index="2" ss:StyleID="s22"><Data ss:Type="String">cross diagonal</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>13</ActiveRow>
+ <ActiveCol>1</ActiveCol>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+</Workbook>
diff --git a/test/xls-xml/borders/grid-box.xml b/test/xls-xml/borders/grid-box.xml
new file mode 100644
index 0000000..eca2d24
--- /dev/null
+++ b/test/xls-xml/borders/grid-box.xml
@@ -0,0 +1,237 @@
+<?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-07T23:59:12Z</Created>
+ <LastSaved>2013-10-08T00:01:57Z</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>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">
+ <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s17">
+ <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s18">
+ <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s19">
+ <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s20">
+ <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s21">
+ <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s22">
+ <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s23">
+ <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s24">
+ <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
+ ss:Color="#FF0000"/>
+ </Borders>
+ </Style>
+ </Styles>
+ <Worksheet ss:Name="Sheet1">
+ <Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="9" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Column ss:Index="3" ss:AutoFitWidth="0" ss:Width="69"/>
+ <Column ss:Index="6" ss:AutoFitWidth="0" ss:Width="73.5"/>
+ <Row ss:Index="2" ss:Height="15.75"/>
+ <Row ss:Height="15.75">
+ <Cell ss:Index="3" ss:StyleID="s16"><Data ss:Type="String">top left</Data></Cell>
+ <Cell ss:StyleID="s17"/>
+ <Cell ss:StyleID="s17"/>
+ <Cell ss:StyleID="s18"><Data ss:Type="String">top right</Data></Cell>
+ </Row>
+ <Row>
+ <Cell ss:Index="3" ss:StyleID="s19"/>
+ <Cell ss:StyleID="s20"/>
+ <Cell ss:StyleID="s20"/>
+ <Cell ss:StyleID="s21"/>
+ </Row>
+ <Row>
+ <Cell ss:Index="3" ss:StyleID="s19"/>
+ <Cell ss:StyleID="s20"/>
+ <Cell ss:StyleID="s20"/>
+ <Cell ss:StyleID="s21"/>
+ </Row>
+ <Row>
+ <Cell ss:Index="3" ss:StyleID="s19"/>
+ <Cell ss:StyleID="s20"/>
+ <Cell ss:StyleID="s20"/>
+ <Cell ss:StyleID="s21"/>
+ </Row>
+ <Row>
+ <Cell ss:Index="3" ss:StyleID="s19"/>
+ <Cell ss:StyleID="s20"/>
+ <Cell ss:StyleID="s20"/>
+ <Cell ss:StyleID="s21"/>
+ </Row>
+ <Row ss:Height="15.75">
+ <Cell ss:Index="3" ss:StyleID="s22"><Data ss:Type="String">bottom left</Data></Cell>
+ <Cell ss:StyleID="s23"/>
+ <Cell ss:StyleID="s23"/>
+ <Cell ss:StyleID="s24"><Data ss:Type="String">bottom right</Data></Cell>
+ </Row>
+ <Row ss:Height="15.75"/>
+ </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>
+ <Zoom>196</Zoom>
+ <Selected/>
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ <ActiveRow>3</ActiveRow>
+ <ActiveCol>3</ActiveCol>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+ <Worksheet ss:Name="Sheet2">
+ <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ </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="Sheet3">
+ <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ </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>
+</Workbook>
diff --git a/test/xls-xml/borders/single-cells.xml b/test/xls-xml/borders/single-cells.xml
new file mode 100644
index 0000000..49fc20e
--- /dev/null
+++ b/test/xls-xml/borders/single-cells.xml
@@ -0,0 +1,202 @@
+<?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-05T16:34:08Z</Created>
+ <LastSaved>2013-10-05T16:41:06Z</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>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">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s17">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Dot" ss:Weight="1"/>
+ <Border ss:Position="Left" ss:LineStyle="Dot" ss:Weight="1"/>
+ <Border ss:Position="Right" ss:LineStyle="Dot" ss:Weight="1"/>
+ <Border ss:Position="Top" ss:LineStyle="Dot" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s18">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="DashDotDot" ss:Weight="1"/>
+ <Border ss:Position="Left" ss:LineStyle="DashDotDot" ss:Weight="1"/>
+ <Border ss:Position="Right" ss:LineStyle="DashDotDot" ss:Weight="1"/>
+ <Border ss:Position="Top" ss:LineStyle="DashDotDot" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s19">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="DashDot" ss:Weight="1"/>
+ <Border ss:Position="Left" ss:LineStyle="DashDot" ss:Weight="1"/>
+ <Border ss:Position="Right" ss:LineStyle="DashDot" ss:Weight="1"/>
+ <Border ss:Position="Top" ss:LineStyle="DashDot" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s20">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Dash" ss:Weight="1"/>
+ <Border ss:Position="Left" ss:LineStyle="Dash" ss:Weight="1"/>
+ <Border ss:Position="Right" ss:LineStyle="Dash" ss:Weight="1"/>
+ <Border ss:Position="Top" ss:LineStyle="Dash" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s21">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s22">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="DashDotDot" ss:Weight="2"/>
+ <Border ss:Position="Left" ss:LineStyle="DashDotDot" ss:Weight="2"/>
+ <Border ss:Position="Right" ss:LineStyle="DashDotDot" ss:Weight="2"/>
+ <Border ss:Position="Top" ss:LineStyle="DashDotDot" ss:Weight="2"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s23">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="SlantDashDot" ss:Weight="2"/>
+ <Border ss:Position="Left" ss:LineStyle="SlantDashDot" ss:Weight="2"/>
+ <Border ss:Position="Right" ss:LineStyle="SlantDashDot" ss:Weight="2"/>
+ <Border ss:Position="Top" ss:LineStyle="SlantDashDot" ss:Weight="2"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s24">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="DashDot" ss:Weight="2"/>
+ <Border ss:Position="Left" ss:LineStyle="DashDot" ss:Weight="2"/>
+ <Border ss:Position="Right" ss:LineStyle="DashDot" ss:Weight="2"/>
+ <Border ss:Position="Top" ss:LineStyle="DashDot" ss:Weight="2"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s25">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Dash" ss:Weight="2"/>
+ <Border ss:Position="Left" ss:LineStyle="Dash" ss:Weight="2"/>
+ <Border ss:Position="Right" ss:LineStyle="Dash" ss:Weight="2"/>
+ <Border ss:Position="Top" ss:LineStyle="Dash" ss:Weight="2"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s26">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s27">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="3"/>
+ <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="3"/>
+ </Borders>
+ </Style>
+ <Style ss:ID="s28">
+ <Borders>
+ <Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"/>
+ <Border ss:Position="Left" ss:LineStyle="Double" ss:Weight="3"/>
+ <Border ss:Position="Right" ss:LineStyle="Double" ss:Weight="3"/>
+ <Border ss:Position="Top" ss:LineStyle="Double" ss:Weight="3"/>
+ </Borders>
+ </Style>
+ </Styles>
+ <Worksheet ss:Name="Borders">
+ <Table ss:ExpandedColumnCount="4" ss:ExpandedRowCount="15" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Row ss:Height="15.75"/>
+ <Row ss:Height="15.75">
+ <Cell ss:Index="4" ss:StyleID="s22"><Data ss:Type="Number">7</Data></Cell>
+ </Row>
+ <Row ss:Height="15.75"/>
+ <Row ss:Height="15.75">
+ <Cell ss:Index="2" ss:StyleID="s16"><Data ss:Type="Number">1</Data></Cell>
+ <Cell ss:Index="4" ss:StyleID="s23"><Data ss:Type="Number">8</Data></Cell>
+ </Row>
+ <Row ss:Height="15.75"/>
+ <Row ss:Height="15.75">
+ <Cell ss:Index="2" ss:StyleID="s17"><Data ss:Type="Number">2</Data></Cell>
+ <Cell ss:Index="4" ss:StyleID="s24"><Data ss:Type="Number">9</Data></Cell>
+ </Row>
+ <Row ss:Height="15.75"/>
+ <Row ss:Height="15.75">
+ <Cell ss:Index="2" ss:StyleID="s18"><Data ss:Type="Number">3</Data></Cell>
+ <Cell ss:Index="4" ss:StyleID="s25"><Data ss:Type="Number">10</Data></Cell>
+ </Row>
+ <Row ss:Height="15.75"/>
+ <Row ss:Height="15.75">
+ <Cell ss:Index="2" ss:StyleID="s19"><Data ss:Type="Number">4</Data></Cell>
+ <Cell ss:Index="4" ss:StyleID="s26"><Data ss:Type="Number">11</Data></Cell>
+ </Row>
+ <Row ss:Height="15.75"/>
+ <Row ss:Height="16.5">
+ <Cell ss:Index="2" ss:StyleID="s20"><Data ss:Type="Number">5</Data></Cell>
+ <Cell ss:Index="4" ss:StyleID="s27"><Data ss:Type="Number">12</Data></Cell>
+ </Row>
+ <Row ss:Height="16.5"/>
+ <Row ss:Height="16.5">
+ <Cell ss:Index="2" ss:StyleID="s21"><Data ss:Type="Number">6</Data></Cell>
+ <Cell ss:Index="4" ss:StyleID="s28"><Data ss:Type="Number">13</Data></Cell>
+ </Row>
+ <Row ss:Height="15.75"/>
+ </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>1</ActiveRow>
+ <ActiveCol>5</ActiveCol>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+</Workbook>
generated by cgit v1.2.3 (git 2.39.1) at 2024-10-17 20:17:54 +0000