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/formula-cells-3 | |
| parent | Initial commit. (diff) | |
| download | liborcus-upstream.tar.xz liborcus-upstream.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/formula-cells-3')
| -rw-r--r-- | test/xls-xml/formula-cells-3/check.txt | 6 | ||||
| -rw-r--r-- | test/xls-xml/formula-cells-3/input.xml | 98 |
2 files changed, 104 insertions, 0 deletions
diff --git a/test/xls-xml/formula-cells-3/check.txt b/test/xls-xml/formula-cells-3/check.txt new file mode 100644 index 0000000..ad94e19 --- /dev/null +++ b/test/xls-xml/formula-cells-3/check.txt @@ -0,0 +1,6 @@ +Sheet1/0/0:formula:Sheet2!R[1]C[1]:Reference ME! +Sheet1/1/0:formula:SUM(Sheet2!R[3]C[2]:R[5]C[2]):6 +Sheet2/1/1:string:"Reference ME!" +Sheet2/4/2:numeric:1 +Sheet2/5/2:numeric:2 +Sheet2/6/2:numeric:3 diff --git a/test/xls-xml/formula-cells-3/input.xml b/test/xls-xml/formula-cells-3/input.xml new file mode 100644 index 0000000..4161e6d --- /dev/null +++ b/test/xls-xml/formula-cells-3/input.xml @@ -0,0 +1,98 @@ +<?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>2020-05-23T00:44:47Z</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>
+ </Styles>
+ <Worksheet ss:Name="Sheet1">
+ <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="2" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Row ss:AutoFitHeight="0">
+ <Cell ss:Formula="=Sheet2!R[1]C[1]"><Data ss:Type="String">Reference ME!</Data></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell ss:Formula="=SUM(Sheet2!R[3]C[2]:R[5]C[2])"><Data ss:Type="Number">6</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/>
+ <Selected/>
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ <ActiveRow>1</ActiveRow>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+ <Worksheet ss:Name="Sheet2">
+ <Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="7" x:FullColumns="1"
+ x:FullRows="1" ss:DefaultRowHeight="15">
+ <Row ss:AutoFitHeight="0"/>
+ <Row ss:AutoFitHeight="0">
+ <Cell ss:Index="2"><Data ss:Type="String">Reference ME!</Data></Cell>
+ </Row>
+ <Row ss:Index="5" ss:AutoFitHeight="0">
+ <Cell ss:Index="3"><Data ss:Type="Number">1</Data></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell ss:Index="3"><Data ss:Type="Number">2</Data></Cell>
+ </Row>
+ <Row ss:AutoFitHeight="0">
+ <Cell ss:Index="3"><Data ss:Type="Number">3</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/>
+ <Panes>
+ <Pane>
+ <Number>3</Number>
+ <ActiveRow>4</ActiveRow>
+ <ActiveCol>2</ActiveCol>
+ </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+ </WorksheetOptions>
+ </Worksheet>
+</Workbook>
|