diff options
Diffstat (limited to 'test/xls-xml/formula-cells-2')
| -rw-r--r-- | test/xls-xml/formula-cells-2/check.txt | 41 | ||||
| -rw-r--r-- | test/xls-xml/formula-cells-2/config.yaml | 3 | ||||
| -rw-r--r-- | test/xls-xml/formula-cells-2/input.xml | 198 |
3 files changed, 242 insertions, 0 deletions
diff --git a/test/xls-xml/formula-cells-2/check.txt b/test/xls-xml/formula-cells-2/check.txt new file mode 100644 index 0000000..888c318 --- /dev/null +++ b/test/xls-xml/formula-cells-2/check.txt @@ -0,0 +1,41 @@ +Лист1/0/1:string:"14.06.2013" +Лист1/0/5:string:"Надпись справа" +Лист1/2/1:string:"Заголовок 1 (центр)" +Лист1/4/1:string:"Назва" +Лист1/4/2:string:"Кількість" +Лист1/4/3:string:"Ціна" +Лист1/4/4:string:"Сума" +Лист1/5/1:string:"Український текст1 " +Лист1/5/2:numeric:32.97 +Лист1/5/3:numeric:10.03 +Лист1/5/4:formula:RC[-2]*RC[-1]:330.69 +Лист1/6/1:string:"Український текст2 " +Лист1/6/2:numeric:32.93 +Лист1/6/3:numeric:10.06 +Лист1/6/4:formula:RC[-2]*RC[-1]:331.28 +Лист1/7/1:string:"Український текст3 " +Лист1/7/2:numeric:32.9 +Лист1/7/3:numeric:10.09 +Лист1/7/4:formula:RC[-2]*RC[-1]:331.96 +Лист1/8/1:string:"Український текст4 " +Лист1/8/2:numeric:32.87 +Лист1/8/3:numeric:10.12 +Лист1/8/4:formula:RC[-2]*RC[-1]:332.64 +Лист1/9/1:string:"Український текст5 " +Лист1/9/2:numeric:32.84 +Лист1/9/3:numeric:10.15 +Лист1/9/4:formula:RC[-2]*RC[-1]:333.33 +Лист1/10/0:string:"[ITOG]" +Лист1/10/1:string:"Всього" +Лист1/10/4:formula:SUM(R[-1]C:R[-1]C):333.33 +Лист1/14/2:string:"Підпис" +Лист1/0/1:merge-width:4 +Лист1/0/1:merge-height:1 +Лист1/0/5:merge-width:3 +Лист1/0/5:merge-height:1 +Лист1/2/1:merge-width:10 +Лист1/2/1:merge-height:1 +Лист1/10/1:merge-width:3 +Лист1/10/1:merge-height:1 +Лист1/14/2:merge-width:4 +Лист1/14/2:merge-height:1 diff --git a/test/xls-xml/formula-cells-2/config.yaml b/test/xls-xml/formula-cells-2/config.yaml new file mode 100644 index 0000000..f3a335c --- /dev/null +++ b/test/xls-xml/formula-cells-2/config.yaml @@ -0,0 +1,3 @@ +--- +output-precision: 2 + diff --git a/test/xls-xml/formula-cells-2/input.xml b/test/xls-xml/formula-cells-2/input.xml new file mode 100644 index 0000000..0d8315c --- /dev/null +++ b/test/xls-xml/formula-cells-2/input.xml @@ -0,0 +1,198 @@ +<?xml version="1.0" encoding="UTF-8"?> +<?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>HOME</Author> +<LastAuthor>HOME</LastAuthor> +<LastPrinted>2012-11-18T17:17:34Z</LastPrinted> +<Created>2012-10-20T06:27:34Z</Created> +<LastSaved>2012-11-07T05:31:00Z</LastSaved> +<Company>Home, sweet home !!!</Company> +<Version>11.5606</Version> +</DocumentProperties> +<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> +<WindowHeight>10545</WindowHeight> +<WindowWidth>20940</WindowWidth> +<WindowTopX>0</WindowTopX> +<WindowTopY>1590</WindowTopY> +<ProtectStructure>False</ProtectStructure> +<ProtectWindows>False</ProtectWindows> +</ExcelWorkbook> +<Styles> +<Style ss:ID="Default" ss:Name="Normal"> +<Alignment ss:Vertical="Bottom"/> +<Borders/> +<Font ss:FontName="Arial Cyr" x:CharSet="204"/> +<Interior/> +<NumberFormat/> +<Protection/> +</Style> +<Style ss:ID="m24199894"> +<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> +<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> +<Font ss:FontName="Arial Cyr" x:CharSet="204" ss:Bold="1"/> +</Style> +<Style ss:ID="s22"> +<Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/> +<NumberFormat ss:Format="Fixed"/> +</Style> +<Style ss:ID="s24"> +<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/> +</Style> +<Style ss:ID="s26"> +<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> +</Style> +<Style ss:ID="s27"> +<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/> +<Font ss:FontName="Arial Cyr" x:CharSet="204"/> +</Style> +<Style ss:ID="s29"> +<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> +<Font ss:FontName="Arial Cyr" x:CharSet="204"/> +</Style> +<Style ss:ID="s30"> +<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/> +<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> +<NumberFormat ss:Format="Fixed"/> +</Style> +<Style ss:ID="s31"> +<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> +<NumberFormat ss:Format="Fixed"/> +</Style> +<Style ss:ID="s32"> +<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/> +<Borders> +<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> +</Borders> +<Font ss:FontName="Arial Cyr" x:CharSet="204"/> +</Style> +<Style ss:ID="s41"> +<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> +<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="s43"> +<Alignment ss:Vertical="Bottom"/> +</Style> +<Style ss:ID="s44"> +<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> +<Font ss:FontName="Arial Cyr" x:CharSet="204" ss:Bold="1"/> +<NumberFormat ss:Format="Fixed"/> +</Style> +</Styles> +<Worksheet ss:Name="Лист1"> +<Table ss:ExpandedColumnCount="11" ss:ExpandedRowCount="15" x:FullColumns="1" x:FullRows="1"> +<Column ss:AutoFitWidth="0" ss:Width="36"/> +<Column ss:AutoFitWidth="0" ss:Width="182.25"/> +<Column ss:Index="11" ss:AutoFitWidth="0" ss:Width="41.25"/> +<Row> +<Cell ss:Index="2" ss:MergeAcross="3" ss:StyleID="s22"><Data ss:Type="String">14.06.2013</Data></Cell> +<Cell ss:MergeAcross="2" ss:StyleID="s24"><Data ss:Type="String">Надпись справа</Data></Cell> +<Cell ss:StyleID="s43"/> <Cell ss:StyleID="s43"/> <Cell ss:StyleID="s43"/> </Row> <Row ss:Index="3"> <Cell ss:Index="2" ss:MergeAcross="9" ss:StyleID="s26"><Data ss:Type="String">Заголовок 1 (центр)</Data></Cell> +</Row> +<Row ss:Index="5"> +<Cell ss:StyleID="s27"><Data ss:Type="String"/></Cell> +<Cell ss:StyleID="s41"><Data ss:Type="String">Назва</Data></Cell> +<Cell ss:StyleID="s41"><Data ss:Type="String">Кількість</Data></Cell> +<Cell ss:StyleID="s41"><Data ss:Type="String">Ціна</Data></Cell> +<Cell ss:StyleID="s41"><Data ss:Type="String">Сума</Data></Cell> +</Row> +<Row> +<Cell ss:StyleID="s27"><Data ss:Type="String"/></Cell> +<Cell ss:StyleID="s29"><Data ss:Type="String">Український текст1 </Data></Cell> +<Cell ss:StyleID="s30"><Data ss:Type="Number">32.97</Data></Cell> +<Cell ss:StyleID="s30"><Data ss:Type="Number">10.03</Data></Cell> +<Cell ss:StyleID="s31" ss:Formula="=RC[-2]*RC[-1]"/> +</Row> +<Row> +<Cell ss:StyleID="s27"><Data ss:Type="String"/></Cell> +<Cell ss:StyleID="s29"><Data ss:Type="String">Український текст2 </Data></Cell> +<Cell ss:StyleID="s30"><Data ss:Type="Number">32.93</Data></Cell> +<Cell ss:StyleID="s30"><Data ss:Type="Number">10.06</Data></Cell> +<Cell ss:StyleID="s31" ss:Formula="=RC[-2]*RC[-1]"/> +</Row> +<Row> +<Cell ss:StyleID="s27"><Data ss:Type="String"/></Cell> +<Cell ss:StyleID="s29"><Data ss:Type="String">Український текст3 </Data></Cell> +<Cell ss:StyleID="s30"><Data ss:Type="Number">32.90</Data></Cell> +<Cell ss:StyleID="s30"><Data ss:Type="Number">10.09</Data></Cell> +<Cell ss:StyleID="s31" ss:Formula="=RC[-2]*RC[-1]"/> +</Row> +<Row> +<Cell ss:StyleID="s27"><Data ss:Type="String"/></Cell> +<Cell ss:StyleID="s29"><Data ss:Type="String">Український текст4 </Data></Cell> +<Cell ss:StyleID="s30"><Data ss:Type="Number">32.87</Data></Cell> +<Cell ss:StyleID="s30"><Data ss:Type="Number">10.12</Data></Cell> +<Cell ss:StyleID="s31" ss:Formula="=RC[-2]*RC[-1]"/> +</Row> +<Row> +<Cell ss:StyleID="s27"><Data ss:Type="String"/></Cell> +<Cell ss:StyleID="s29"><Data ss:Type="String">Український текст5 </Data></Cell> +<Cell ss:StyleID="s30"><Data ss:Type="Number">32.84</Data></Cell> +<Cell ss:StyleID="s30"><Data ss:Type="Number">10.15</Data></Cell> +<Cell ss:StyleID="s31" ss:Formula="=RC[-2]*RC[-1]"/> +</Row> +<Row> +<Cell ss:StyleID="s32"><Data ss:Type="String">[ITOG]</Data></Cell> +<Cell ss:MergeAcross="2" ss:StyleID="m24199894"><Data ss:Type="String">Всього</Data></Cell> +<Cell ss:StyleID="s44" ss:Formula="=SUM(R[-1]C:R[-1]C)"/> +<Cell><Data ss:Type="String"/></Cell> +</Row> +<Row ss:Index="15"> +<Cell ss:Index="3" ss:MergeAcross="3" ss:StyleID="s26"><Data ss:Type="String">Підпис</Data></Cell> +</Row> +</Table> +<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> +<PageSetup> +<Header x:Margin="0.26"/> +<PageMargins x:Bottom="0.984251969" x:Left="0.45" x:Right="0.36" x:Top="0.44"/> +</PageSetup> +<Print> +<ValidPrinterInfo/> +<PaperSizeIndex>9</PaperSizeIndex> +<HorizontalResolution>300</HorizontalResolution> +<VerticalResolution>300</VerticalResolution> +</Print> +<PageBreakZoom>60</PageBreakZoom> +<Selected/> +<Panes> +<Pane> +<Number>3</Number> +<ActiveRow>14</ActiveRow> +<ActiveCol>8</ActiveCol> +</Pane> +</Panes> +<ProtectObjects>False</ProtectObjects> +<ProtectScenarios>False</ProtectScenarios> +</WorksheetOptions> +</Worksheet> +</Workbook>
\ No newline at end of file |