diff options
Diffstat (limited to 'sc/qa/unit/data/xml')
| -rw-r--r-- | sc/qa/unit/data/xml/background-color-standard.xml | 150 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/border-colors.xml | 109 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/border-directions.xml | 121 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/character-set.xml | 1840 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/column-width-row-height.xml | 100 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/empty-rows.xml | 79 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/hidden-rows-columns.xml | 115 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/merged-cells.xml | 101 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/named-exp-global.xml | 92 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/named-exp-local.xml | 131 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/rhbz1390776.xml | 73 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/styles.xml | 34 | ||||
| -rw-r--r-- | sc/qa/unit/data/xml/universal-content.xml | 119 |
13 files changed, 3064 insertions, 0 deletions
diff --git a/sc/qa/unit/data/xml/background-color-standard.xml b/sc/qa/unit/data/xml/background-color-standard.xml new file mode 100644 index 000000000..7ccfef8a2 --- /dev/null +++ b/sc/qa/unit/data/xml/background-color-standard.xml @@ -0,0 +1,150 @@ +<?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-21T23:43:59Z</Created> + <LastSaved>2013-10-21T23:51:49Z</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"> + <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="#FFFFFF" + ss:Bold="1"/> + <Interior ss:Color="#C00000" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s18"> + <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" + ss:Bold="1"/> + <Interior ss:Color="#FF0000" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s19"> + <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" + ss:Bold="1"/> + <Interior ss:Color="#FFC000" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s20"> + <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" + ss:Bold="1"/> + <Interior ss:Color="#FFFF00" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s21"> + <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" + ss:Bold="1"/> + <Interior ss:Color="#92D050" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s22"> + <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" + ss:Bold="1"/> + <Interior ss:Color="#00B050" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s23"> + <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" + ss:Bold="1"/> + <Interior ss:Color="#00B0F0" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s24"> + <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" + ss:Bold="1"/> + <Interior ss:Color="#0070C0" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s25"> + <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" + ss:Bold="1"/> + <Interior ss:Color="#002060" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s26"> + <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" + ss:Bold="1"/> + <Interior ss:Color="#7030A0" ss:Pattern="Solid"/> + </Style> + </Styles> + <Worksheet ss:Name="BackgroundColor"> + <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="11" x:FullColumns="1" + x:FullRows="1" ss:DefaultRowHeight="15"> + <Column ss:AutoFitWidth="0" ss:Width="222.75"/> + <Row> + <Cell ss:StyleID="s16"><Data ss:Type="String">Background Color</Data></Cell> + </Row> + <Row> + <Cell ss:StyleID="s17"><Data ss:Type="String">Dark Red</Data></Cell> + </Row> + <Row> + <Cell ss:StyleID="s18"><Data ss:Type="String">Red</Data></Cell> + </Row> + <Row> + <Cell ss:StyleID="s19"><Data ss:Type="String">Orange</Data></Cell> + </Row> + <Row> + <Cell ss:StyleID="s20"><Data ss:Type="String">Yellow</Data></Cell> + </Row> + <Row> + <Cell ss:StyleID="s21"><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>12</ActiveRow> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> +</Workbook> diff --git a/sc/qa/unit/data/xml/border-colors.xml b/sc/qa/unit/data/xml/border-colors.xml new file mode 100644 index 000000000..bab7dec8b --- /dev/null +++ b/sc/qa/unit/data/xml/border-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 -></Data></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell ss:Index="2" ss:StyleID="s63"><Data ss:Type="String">Blue -></Data></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell ss:Index="2" ss:StyleID="s64"><Data ss:Type="String">Green -></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"><- Yellow Purple -> 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/sc/qa/unit/data/xml/border-directions.xml b/sc/qa/unit/data/xml/border-directions.xml new file mode 100644 index 000000000..77be73b91 --- /dev/null +++ b/sc/qa/unit/data/xml/border-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/sc/qa/unit/data/xml/character-set.xml b/sc/qa/unit/data/xml/character-set.xml new file mode 100644 index 000000000..036b20c55 --- /dev/null +++ b/sc/qa/unit/data/xml/character-set.xml @@ -0,0 +1,1840 @@ +<?xml version="1.0" encoding="windows-1251"?> +<?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>Горленко Галина</Author> + <LastAuthor>BORLAS_T</LastAuthor> + <Revision>1</Revision> + <TotalTime>0</TotalTime> + <LastPrinted>2014-02-05T05:01:01Z</LastPrinted> + <Created>2014-01-16T09:15:45Z</Created> + <LastSaved>2014-02-05T05:02:30Z</LastSaved> + <Version>12.00</Version> + </DocumentProperties> + <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> + <AllowPNG/> + <DoNotRelyOnCSS/> + </OfficeDocumentSettings> + <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> + <WindowHeight>7860</WindowHeight> + <WindowWidth>18885</WindowWidth> + <WindowTopX>180</WindowTopX> + <WindowTopY>465</WindowTopY> + <Iteration/> + <ProtectStructure>False</ProtectStructure> + <ProtectWindows>False</ProtectWindows> + </ExcelWorkbook> + <Styles> + <Style ss:ID="Default" ss:Name="Normal"> + <Alignment ss:Vertical="Bottom"/> + <Borders/> + <Font ss:FontName="Times New Roman1" ss:Color="#000000"/> + <Interior/> + <NumberFormat/> + <Protection/> + </Style> + <Style ss:ID="m61638848"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior ss:Color="#FFCC00" ss:Pattern="Solid"/> + <NumberFormat/> + </Style> + <Style ss:ID="m61638868"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/> + <NumberFormat/> + </Style> + <Style ss:ID="m43941496"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="m43941516"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s62"> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000"/> + </Style> + <Style ss:ID="s63"> + <Alignment ss:Vertical="Bottom"/> + <Borders/> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s64"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Borders/> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s65"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/> + <Borders/> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s68"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Size="11" ss:Color="#000000"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s70"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/> + <Borders> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s77"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1"/> + <Borders> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s81"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s90"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s91"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom" ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s99"> + <Alignment ss:Vertical="Bottom" ss:ShrinkToFit="1" ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s100"> + <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1" ss:Italic="1"/> + <Interior ss:Color="#66FFFF" ss:Pattern="Solid"/> + <NumberFormat ss:Format="@"/> + </Style> + <Style ss:ID="s101"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1" ss:Italic="1"/> + <Interior ss:Color="#66FFFF" ss:Pattern="Solid"/> + <NumberFormat ss:Format="@"/> + </Style> + <Style ss:ID="s102"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1" ss:Italic="1"/> + <Interior ss:Color="#66FFFF" ss:Pattern="Solid"/> + <NumberFormat ss:Format="0.0000"/> + </Style> + <Style ss:ID="s103"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Italic="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s104"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Italic="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s105"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Italic="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s106"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Italic="1"/> + <Interior/> + <NumberFormat ss:Format="dd"."mm"."yyyy"/> + </Style> + <Style ss:ID="s107"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Italic="1"/> + <Interior/> + <NumberFormat ss:Format="@"/> + </Style> + <Style ss:ID="s109"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Italic="1"/> + <Interior/> + <NumberFormat ss:Format="0.0000"/> + </Style> + <Style ss:ID="s110"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Italic="1"/> + <Interior/> + <NumberFormat ss:Format="0.000"/> + </Style> + <Style ss:ID="s113"> + <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1" ss:Italic="1"/> + <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/> + <NumberFormat/> + </Style> + <Style ss:ID="s114"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:ShrinkToFit="1" + ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1" ss:Italic="1"/> + <Interior/> + <NumberFormat ss:Format="0.000"/> + </Style> + <Style ss:ID="s115"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1" ss:Italic="1"/> + <Interior/> + <NumberFormat ss:Format="0.0000"/> + </Style> + <Style ss:ID="s123"> + <Alignment ss:Vertical="Bottom"/> + <Borders/> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Size="11" ss:Color="#000000"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s124"> + <Alignment ss:Vertical="Bottom"/> + <Borders/> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1" ss:Italic="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s125"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Borders/> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s127"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom" ss:WrapText="1"/> + <Borders/> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1" ss:Italic="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s129"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Borders/> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Bold="1" ss:Italic="1"/> + <Interior/> + <NumberFormat/> + </Style> + <Style ss:ID="s132"> + <Alignment ss:Horizontal="Center" ss:Vertical="Center"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Italic="1"/> + <Interior/> + <NumberFormat ss:Format="0.000"/> + </Style> + <Style ss:ID="s133"> + <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/> + <Borders> + <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" + ss:Color="#000000"/> + </Borders> + <Font ss:FontName="Times New Roman" x:CharSet="204" x:Family="Roman" + ss:Color="#000000" ss:Italic="1"/> + <Interior/> + <NumberFormat ss:Format="@"/> + </Style> + </Styles> + <Worksheet ss:Name="Лист1"> + <Names> + <NamedRange ss:Name="Sheet_Title" ss:RefersTo="="Лист1""/> + <NamedRange ss:Name="Print_Area" ss:RefersTo="=Лист1!#REF!"/> + </Names> + <Table ss:ExpandedColumnCount="10" ss:ExpandedRowCount="65000" x:FullColumns="1" + x:FullRows="1" ss:StyleID="s62" ss:DefaultColumnWidth="42"> + <Column ss:StyleID="s63" ss:AutoFitWidth="0" ss:Width="55.5"/> + <Column ss:StyleID="s64" ss:Width="67.5"/> + <Column ss:StyleID="s63" ss:AutoFitWidth="0" ss:Width="118.5"/> + <Column ss:StyleID="s63" ss:AutoFitWidth="0" ss:Width="46.5"/> + <Column ss:StyleID="s64" ss:AutoFitWidth="0" ss:Width="82.5"/> + <Column ss:StyleID="s64" ss:AutoFitWidth="0" ss:Width="43.5" ss:Span="1"/> + <Column ss:Index="8" ss:StyleID="s64" ss:AutoFitWidth="0" ss:Width="46.5"/> + <Column ss:StyleID="s64" ss:AutoFitWidth="0" ss:Width="43.5"/> + <Column ss:StyleID="s64" ss:AutoFitWidth="0" ss:Width="78.75"/> + <Row ss:AutoFitHeight="0" ss:Height="13.3125"> + <Cell ss:Index="2" ss:StyleID="s65"><Data ss:Type="String">ГСМ </Data></Cell> + <Cell ss:MergeAcross="7" ss:StyleID="s65"><Data ss:Type="String">Акмолинские МЭС за июль 2013 г. по 01.Ералина, Кенжегуль Хибратовна</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.3125"> + <Cell ss:MergeAcross="9" ss:StyleID="s68"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="21"> + <Cell ss:MergeDown="1" ss:StyleID="s70"><Data ss:Type="String">Дата записи</Data></Cell> + <Cell ss:MergeDown="1" ss:StyleID="s70"><Data ss:Type="String">№ документа</Data></Cell> + <Cell ss:MergeDown="1" ss:StyleID="s70"><Data ss:Type="String">От кого получено или кому выдано</Data></Cell> + <Cell ss:MergeDown="1" ss:StyleID="s77"><Data ss:Type="String">Т.Е</Data></Cell> + <Cell ss:StyleID="s81"><Data ss:Type="String">Остаток</Data></Cell> + <Cell ss:MergeAcross="1" ss:StyleID="m43941496"><Data ss:Type="String">Приход</Data></Cell> + <Cell ss:MergeAcross="1" ss:StyleID="m43941516"><Data ss:Type="String">Расход</Data></Cell> + <Cell ss:StyleID="s70"><Data ss:Type="String">Остаток</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="25.5"> + <Cell ss:Index="5" ss:StyleID="s81"><Data ss:Type="String">на начало месяца</Data></Cell> + <Cell ss:StyleID="s81"><Data ss:Type="String">Кол-во</Data></Cell> + <Cell ss:StyleID="s81"><Data ss:Type="String">Цена</Data></Cell> + <Cell ss:StyleID="s81"><Data ss:Type="String">Кол-во</Data></Cell> + <Cell ss:StyleID="s81"><Data ss:Type="String">Сумма</Data></Cell> + <Cell ss:StyleID="s90"><Data ss:Type="String">на конец месяца</Data></Cell> + </Row> + <Row> + <Cell ss:StyleID="s91"><Data ss:Type="Number">1</Data></Cell> + <Cell ss:StyleID="s91"><Data ss:Type="Number">2</Data></Cell> + <Cell ss:StyleID="s91"><Data ss:Type="Number">3</Data></Cell> + <Cell ss:StyleID="s91"><Data ss:Type="Number">4</Data></Cell> + <Cell ss:StyleID="s91"><Data ss:Type="Number">5</Data></Cell> + <Cell ss:StyleID="s91"><Data ss:Type="Number">6</Data></Cell> + <Cell ss:StyleID="s91"><Data ss:Type="Number">7</Data></Cell> + <Cell ss:StyleID="s91"><Data ss:Type="Number">8</Data></Cell> + <Cell ss:StyleID="s91"><Data ss:Type="Number">9</Data></Cell> + <Cell ss:StyleID="s91"><Data ss:Type="Number">10</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное М8В</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0000179</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Литол 24</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0000186</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Жидкость тормозная</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0000191</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло М8Г2К</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0001530</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Талоны на бензин АИ-92</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0002060</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">20.3928</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String">31.07.2013</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">9842392</Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Зак. на перемещ.1064770</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0002060</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">371.0922</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String">31.07.2013</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">9842393</Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Зак. на перемещ.1064770</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0002060</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">1010.3928</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Перенос в 03.004.17</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0002060</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">1410</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">1410</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">1381.485</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">48.9078</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Талоны на бензин АИ-80</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0002061</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">401.2055</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String">31.07.2013</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">9842394</Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Зак. на перемещ.1064770</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0002061</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">5233.9721</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String">31.07.2013</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">9842395</Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Зак. на перемещ.1064770</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0002061</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">2511.2055</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String">31.07.2013</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">9842396</Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Зак. на перемещ.1064770</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0002061</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">600</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Перенос в 03.004.17</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0002061</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">8420</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">8420</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">8345.1776</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">476.0279</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное М8Г2</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0002327</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное М10-Г2К</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0002328</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Талоны на бензин АИ-93</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0002999</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Тосол А-40</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0003048</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Жидкость тормозная ДОТ-4</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0003431</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Талоны дизтопливо летнее</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0003561</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Талоны дизтопливо зимнее</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0003562</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное М10В</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0003763</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Дизельное топливо летнее (талоны)</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0003784</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">740.4011</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String">31.07.2013</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">9842397</Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Зак. на перемещ.1064770</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0003784</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">540</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String">31.07.2013</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">9842398</Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Зак. на перемещ.1064770</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0003784</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">561.4532</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String">31.07.2013</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">9842399</Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Зак. на перемещ.1064770</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0003784</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">16190.4011</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Перенос в 03.004.17</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0003784</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">17260</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">17260</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">17291.8543</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">708.5468</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Дизельное топливо зимнее (талоны)</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0003785</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Охлаждающая жидкость Тосол А-40</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0004225</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное Лукойл-Стандарт</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0009423</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное ESSO 10W40 полусинтетик турбо</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0016962</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное Лукойл Стандарт</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0016971</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло гидравлическое ВМГЗ</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0023122</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло дизельное М8ДМ</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0027124</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло трансмиссионное CASTROL GH 75W90</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0028139</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Охлаждающая жидкость MOBIL Antifreez Advanced красный G12</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0028143</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное CASTROL diesel SAE 5W40</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0028154</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное, SAE 20 API SD/CB</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0028448</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Охлаждающая жидкость, антифриз</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0028451</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное, SAE 5W-40 API SJ/CF</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0028455</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное, SAE 30 API СС</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0028457</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло трансмиссионное, SAE 80W-90 API GL-5</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0028459</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Тормозная жидкость, Роса ДОТ-4</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0028461</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Пластичные смазки, литол-24</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0028462</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло гидравлическое, ВМГЗ</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0028464</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String">31.07.2013</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">9842400</Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Зак. на перемещ.1064770</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0028464</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">140</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Перенос в 03.004.17</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0028464</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">140</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">140</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">140</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное, SAE 10W40 АРI CF</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0030826</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло трансмиссионное, SAE 75W-90 API GL-5</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0030830</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638848"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s100"><Data ss:Type="String">Масло моторное, SAE 5W-40 API SJ/CF</Data></Cell> + <Cell ss:StyleID="s101"><Data ss:Type="String">0032519</Data></Cell> + <Cell ss:StyleID="s102"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String">31.07.2013</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">9842401</Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Зак. на перемещ.1064770</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0032519</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">100</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row> + <Cell ss:StyleID="s106"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s133"><Data ss:Type="String">Перенос в 03.004.17</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String">0032519</Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s110"><Data ss:Type="Number">100</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s132"><Data ss:Type="Number">0</Data></Cell> + <Cell ss:StyleID="s109"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s105"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s99"/> + <Cell ss:StyleID="s81"/> + <Cell ss:StyleID="s113"><Data ss:Type="String">Итого:</Data></Cell> + <Cell ss:StyleID="s107"><Data ss:Type="String"></Data></Cell> + <Cell ss:StyleID="s109"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">100</Data></Cell> + <Cell ss:StyleID="s103"/> + <Cell ss:StyleID="s114"><Data ss:Type="Number">100</Data></Cell> + <Cell ss:StyleID="s104"/> + <Cell ss:StyleID="s115"><Data ss:Type="Number">0</Data></Cell> + </Row> + <Row> + <Cell ss:MergeAcross="9" ss:StyleID="m61638868"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="15"> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:Index="5" ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s124"><Data ss:Type="String">Начальник _________________</Data></Cell> + <Cell ss:StyleID="s125"/> + <Cell ss:Index="5" ss:MergeAcross="5" ss:StyleID="s127"><Data ss:Type="String">Начальник СМиТ __________________</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="15"> + <Cell ss:StyleID="s123"/> + <Cell ss:Index="5" ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="15"> + <Cell ss:StyleID="s123"/> + <Cell ss:Index="5" ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="15"> + <Cell ss:StyleID="s123"/> + <Cell ss:Index="5" ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + <Cell ss:StyleID="s123"/> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="13.5"> + <Cell ss:StyleID="s124"><Data ss:Type="String">Механик ___________________</Data></Cell> + <Cell ss:Index="5" ss:MergeAcross="5" ss:StyleID="s129"><Data ss:Type="String">Диспетчер СМиТ __________________</Data></Cell> + </Row> + </Table> + <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> + <PageSetup> + <Layout x:Orientation="Landscape"/> + <Header x:Margin="0.28739999999999999"/> + <Footer x:Margin="0.28739999999999999"/> + <PageMargins x:Bottom="0.28739999999999999" x:Left="0.28739999999999999" + x:Right="0.28739999999999999" x:Top="0.28739999999999999"/> + </PageSetup> + <Print> + <ValidPrinterInfo/> + <PaperSizeIndex>9</PaperSizeIndex> + <HorizontalResolution>600</HorizontalResolution> + <VerticalResolution>600</VerticalResolution> + </Print> + <Selected/> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + <EnableSelection>NoSelection</EnableSelection> + <AllowFormatCells/> + <AllowSizeCols/> + <AllowSizeRows/> + <AllowInsertCols/> + <AllowInsertRows/> + <AllowInsertHyperlinks/> + <AllowDeleteCols/> + <AllowDeleteRows/> + <AllowSort/> + <AllowFilter/> + <AllowUsePivotTables/> + </WorksheetOptions> + </Worksheet> +</Workbook> diff --git a/sc/qa/unit/data/xml/column-width-row-height.xml b/sc/qa/unit/data/xml/column-width-row-height.xml new file mode 100644 index 000000000..170cd28cd --- /dev/null +++ b/sc/qa/unit/data/xml/column-width-row-height.xml @@ -0,0 +1,100 @@ +<?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-04-16T23:00:57Z</Created> + <LastSaved>2013-04-16T23:09:17Z</LastSaved> + <Company>Novell, Inc.</Company> + <Version>16.00</Version> + </DocumentProperties> + <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> + <AllowPNG/> + </OfficeDocumentSettings> + <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> + <WindowHeight>12210</WindowHeight> + <WindowWidth>28800</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> + </Styles> + <Worksheet ss:Name="Sheet1"> + <Table ss:ExpandedColumnCount="12" ss:ExpandedRowCount="14" x:FullColumns="1" + x:FullRows="1" ss:DefaultRowHeight="15"> + <Column ss:AutoFitWidth="0" ss:Width="93"/> + <Column ss:AutoFitWidth="0" ss:Width="56"/> + <Column ss:AutoFitWidth="0" ss:Width="83"/> + <Column ss:AutoFitWidth="0" ss:Width="109"/> + <Column ss:Index="6" ss:AutoFitWidth="0" ss:Width="67" ss:Span="2"/> + <Column ss:Index="11" ss:AutoFitWidth="0" ss:Width="119" ss:Span="1"/> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="String">Column Width</Data></Cell> + <Cell><Data ss:Type="Number">10</Data></Cell> + <Cell><Data ss:Type="Number">15</Data></Cell> + <Cell><Data ss:Type="Number">20</Data></Cell> + <Cell ss:Index="6"><Data ss:Type="Number">12</Data></Cell> + <Cell><Data ss:Type="Number">12</Data></Cell> + <Cell><Data ss:Type="Number">12</Data></Cell> + <Cell ss:Index="11"><Data ss:Type="Number">22</Data></Cell> + <Cell><Data ss:Type="Number">22</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="String">Row Height</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="20"> + <Cell><Data ss:Type="Number">20</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="30"> + <Cell><Data ss:Type="Number">30</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="40"> + <Cell><Data ss:Type="Number">40</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="50"> + <Cell><Data ss:Type="Number">50</Data></Cell> + </Row> + <Row ss:Index="8" ss:AutoFitHeight="0" ss:Height="25"> + <Cell><Data ss:Type="Number">25</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="25"> + <Cell><Data ss:Type="Number">25</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="25"> + <Cell><Data ss:Type="Number">25</Data></Cell> + </Row> + <Row ss:Index="13" ss:AutoFitHeight="0" ss:Height="35"> + <Cell><Data ss:Type="Number">35</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0" ss:Height="35"> + <Cell><Data ss:Type="Number">35</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/> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> +</Workbook> diff --git a/sc/qa/unit/data/xml/empty-rows.xml b/sc/qa/unit/data/xml/empty-rows.xml new file mode 100644 index 000000000..624e94bb4 --- /dev/null +++ b/sc/qa/unit/data/xml/empty-rows.xml @@ -0,0 +1,79 @@ +<?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>2016-12-14T01:54:30Z</Created> + <LastSaved>2016-12-14T01:58:30Z</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>14385</WindowHeight> + <WindowWidth>24000</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> + </Styles> + <Worksheet ss:Name="Sheet1"> + <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="9" x:FullColumns="1" + x:FullRows="1" ss:DefaultRowHeight="15"> + <Row> + <Cell><Data ss:Type="String">Top row, followed by 2 empty rows.</Data></Cell> + </Row> + <Row ss:Index="4"> + <Cell ss:Index="2"><Data ss:Type="Number">1</Data></Cell> + </Row> + <Row> + <Cell ss:Index="2"><Data ss:Type="Number">2</Data></Cell> + </Row> + <Row> + <Cell ss:Index="2"><Data ss:Type="Number">3</Data></Cell> + </Row> + <Row> + <Cell ss:Index="2"><Data ss:Type="Number">4</Data></Cell> + </Row> + <Row> + <Cell ss:Index="2"><Data ss:Type="Number">5</Data></Cell> + </Row> + <Row> + <Cell ss:Index="2" ss:Formula="=SUM(R[-5]C:R[-1]C)"><Data ss:Type="Number">15</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>9</ActiveRow> + <ActiveCol>1</ActiveCol> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> +</Workbook> diff --git a/sc/qa/unit/data/xml/hidden-rows-columns.xml b/sc/qa/unit/data/xml/hidden-rows-columns.xml new file mode 100644 index 000000000..6b4b597bf --- /dev/null +++ b/sc/qa/unit/data/xml/hidden-rows-columns.xml @@ -0,0 +1,115 @@ +<?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-14T01:31:11Z</Created> + <LastSaved>2018-02-14T01:35:31Z</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> + <ActiveSheet>1</ActiveSheet> + <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="Hidden Rows"> + <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="9" x:FullColumns="1" + x:FullRows="1" ss:DefaultRowHeight="15"> + <Row> + <Cell><Data ss:Type="String">visible</Data></Cell> + </Row> + <Row ss:Hidden="1"> + <Cell><Data ss:Type="String">hidden</Data></Cell> + </Row> + <Row ss:Hidden="1"> + <Cell><Data ss:Type="String">hidden</Data></Cell> + </Row> + <Row> + <Cell><Data ss:Type="String">visible</Data></Cell> + </Row> + <Row ss:Hidden="1"> + <Cell><Data ss:Type="String">hidden</Data></Cell> + </Row> + <Row> + <Cell><Data ss:Type="String">visible</Data></Cell> + </Row> + <Row> + <Cell><Data ss:Type="String">visible</Data></Cell> + </Row> + <Row> + <Cell><Data ss:Type="String">visible</Data></Cell> + </Row> + <Row ss:Hidden="1"> + <Cell><Data ss:Type="String">hidden</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>14</ActiveRow> + <ActiveCol>3</ActiveCol> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> + <Worksheet ss:Name="Hidden Columns"> + <Table ss:ExpandedColumnCount="12" ss:ExpandedRowCount="1" x:FullColumns="1" + x:FullRows="1" ss:DefaultRowHeight="15"> + <Column ss:Index="3" ss:Hidden="1" ss:AutoFitWidth="0" ss:Span="3"/> + <Column ss:Index="11" ss:Hidden="1" ss:AutoFitWidth="0"/> + <Row> + <Cell ss:Index="2"><Data ss:Type="String">hidden -></Data></Cell> + <Cell ss:Index="7"><Data ss:Type="String"><- hidden</Data></Cell> + <Cell ss:Index="10"><Data ss:Type="String">hidden -></Data></Cell> + <Cell ss:Index="12"><Data ss:Type="String"><- hidden</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>10</ActiveRow> + <ActiveCol>1</ActiveCol> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> +</Workbook> diff --git a/sc/qa/unit/data/xml/merged-cells.xml b/sc/qa/unit/data/xml/merged-cells.xml new file mode 100644 index 000000000..6bc69d55b --- /dev/null +++ b/sc/qa/unit/data/xml/merged-cells.xml @@ -0,0 +1,101 @@ +<?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>2016-12-15T03:48:24Z</Created> + <LastSaved>2016-12-15T03:54:21Z</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>14385</WindowHeight> + <WindowWidth>24000</WindowWidth> + <WindowTopX>0</WindowTopX> + <WindowTopY>0</WindowTopY> + <RefModeR1C1/> + <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="s17"> + <Interior ss:Color="#FCE4D6" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s22"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Interior ss:Color="#EDEDED" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s23"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Interior ss:Color="#FFF2CC" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s24"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Interior ss:Color="#F8CBAD" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s25"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Interior ss:Color="#F4B084" ss:Pattern="Solid"/> + </Style> + <Style ss:ID="s26"> + <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> + <Interior ss:Color="#FFFF00" ss:Pattern="Solid"/> + </Style> + </Styles> + <Worksheet ss:Name="Sheet1"> + <Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="6" x:FullColumns="1" + x:FullRows="1" ss:DefaultRowHeight="15"> + <Row> + <Cell ss:StyleID="s17"><Data ss:Type="Number">1</Data></Cell> + <Cell ss:MergeAcross="1" ss:StyleID="s22"><Data ss:Type="Number">2</Data></Cell> + <Cell ss:MergeAcross="2" ss:StyleID="s23"><Data ss:Type="Number">3</Data></Cell> + </Row> + <Row> + <Cell ss:MergeDown="1" ss:StyleID="s24"><Data ss:Type="Number">2</Data></Cell> + </Row> + <Row> + <Cell ss:Index="3" ss:MergeAcross="3" ss:MergeDown="3" ss:StyleID="s26"><Data + ss:Type="String">merged cell</Data></Cell> + </Row> + <Row> + <Cell ss:MergeDown="2" ss:StyleID="s25"><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> + <Print> + <ValidPrinterInfo/> + <VerticalResolution>0</VerticalResolution> + </Print> + <Selected/> + <Panes> + <Pane> + <Number>3</Number> + <ActiveRow>8</ActiveRow> + <ActiveCol>5</ActiveCol> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> +</Workbook> diff --git a/sc/qa/unit/data/xml/named-exp-global.xml b/sc/qa/unit/data/xml/named-exp-global.xml new file mode 100644 index 000000000..151ed7037 --- /dev/null +++ b/sc/qa/unit/data/xml/named-exp-global.xml @@ -0,0 +1,92 @@ +<?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>2016-12-17T20:46:03Z</Created> + <LastSaved>2016-12-17T20:49:13Z</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>14385</WindowHeight> + <WindowWidth>24000</WindowWidth> + <WindowTopX>0</WindowTopX> + <WindowTopY>0</WindowTopY> + <RefModeR1C1/> + <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> + <Names> + <NamedRange ss:Name="MyRange" ss:RefersTo="=Sheet1!R1C1:R5C1"/> + <NamedRange ss:Name="MyRange2" ss:RefersTo="=Sheet1!R1C1:R5C2"/> + </Names> + <Worksheet ss:Name="Sheet1"> + <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="7" x:FullColumns="1" + x:FullRows="1" ss:DefaultRowHeight="15"> + <Row> + <Cell><Data ss:Type="Number">1</Data><NamedCell ss:Name="MyRange"/><NamedCell + ss:Name="MyRange2"/></Cell> + <Cell><Data ss:Type="Number">6</Data><NamedCell ss:Name="MyRange2"/></Cell> + </Row> + <Row> + <Cell><Data ss:Type="Number">2</Data><NamedCell ss:Name="MyRange"/><NamedCell + ss:Name="MyRange2"/></Cell> + <Cell><Data ss:Type="Number">7</Data><NamedCell ss:Name="MyRange2"/></Cell> + </Row> + <Row> + <Cell><Data ss:Type="Number">3</Data><NamedCell ss:Name="MyRange"/><NamedCell + ss:Name="MyRange2"/></Cell> + <Cell><Data ss:Type="Number">8</Data><NamedCell ss:Name="MyRange2"/></Cell> + </Row> + <Row> + <Cell><Data ss:Type="Number">4</Data><NamedCell ss:Name="MyRange"/><NamedCell + ss:Name="MyRange2"/></Cell> + <Cell><Data ss:Type="Number">9</Data><NamedCell ss:Name="MyRange2"/></Cell> + </Row> + <Row> + <Cell><Data ss:Type="Number">5</Data><NamedCell ss:Name="MyRange"/><NamedCell + ss:Name="MyRange2"/></Cell> + <Cell><Data ss:Type="Number">10</Data><NamedCell ss:Name="MyRange2"/></Cell> + </Row> + <Row ss:Index="7"> + <Cell ss:Formula="=SUM(MyRange)"><Data ss:Type="Number">15</Data></Cell> + <Cell ss:Formula="=SUM(MyRange2)"><Data ss:Type="Number">55</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>6</ActiveRow> + <ActiveCol>1</ActiveCol> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> +</Workbook> diff --git a/sc/qa/unit/data/xml/named-exp-local.xml b/sc/qa/unit/data/xml/named-exp-local.xml new file mode 100644 index 000000000..46f110bf3 --- /dev/null +++ b/sc/qa/unit/data/xml/named-exp-local.xml @@ -0,0 +1,131 @@ +<?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>2017-02-08T02:38:34Z</Created> + <LastSaved>2017-02-08T02:41:56Z</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>14385</WindowHeight> + <WindowWidth>24000</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> + </Styles> + <Worksheet ss:Name="Sheet1"> + <Names> + <NamedRange ss:Name="MyRange" ss:RefersTo="=Sheet1!R1C1:R3C2"/> + </Names> + <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="7" x:FullColumns="1" + x:FullRows="1" ss:DefaultRowHeight="15"> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="Number">1</Data><NamedCell ss:Name="MyRange"/></Cell> + <Cell><Data ss:Type="Number">6</Data><NamedCell ss:Name="MyRange"/></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="Number">2</Data><NamedCell ss:Name="MyRange"/></Cell> + <Cell><Data ss:Type="Number">7</Data><NamedCell ss:Name="MyRange"/></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="Number">3</Data><NamedCell ss:Name="MyRange"/></Cell> + <Cell><Data ss:Type="Number">8</Data><NamedCell ss:Name="MyRange"/></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="Number">4</Data></Cell> + <Cell><Data ss:Type="Number">9</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="Number">5</Data></Cell> + <Cell><Data ss:Type="Number">10</Data></Cell> + </Row> + <Row ss:Index="7" ss:AutoFitHeight="0"> + <Cell ss:Formula="=SUM(MyRange)"><Data ss:Type="Number">27</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>6</ActiveRow> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> + <Worksheet ss:Name="Sheet2"> + <Names> + <NamedRange ss:Name="MyRange" ss:RefersTo="=Sheet2!R4C1:R5C2"/> + </Names> + <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="7" x:FullColumns="1" + x:FullRows="1" ss:DefaultRowHeight="15"> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="Number">10</Data></Cell> + <Cell><Data ss:Type="Number">20</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="Number">11</Data></Cell> + <Cell><Data ss:Type="Number">21</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="Number">12</Data></Cell> + <Cell><Data ss:Type="Number">22</Data></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="Number">13</Data><NamedCell ss:Name="MyRange"/></Cell> + <Cell><Data ss:Type="Number">23</Data><NamedCell ss:Name="MyRange"/></Cell> + </Row> + <Row ss:AutoFitHeight="0"> + <Cell><Data ss:Type="Number">14</Data><NamedCell ss:Name="MyRange"/></Cell> + <Cell><Data ss:Type="Number">24</Data><NamedCell ss:Name="MyRange"/></Cell> + </Row> + <Row ss:Index="7" ss:AutoFitHeight="0"> + <Cell ss:Formula="=SUM(MyRange)"><Data ss:Type="Number">74</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>6</ActiveRow> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + </WorksheetOptions> + </Worksheet> +</Workbook> diff --git a/sc/qa/unit/data/xml/rhbz1390776.xml b/sc/qa/unit/data/xml/rhbz1390776.xml new file mode 100644 index 000000000..141805644 --- /dev/null +++ b/sc/qa/unit/data/xml/rhbz1390776.xml @@ -0,0 +1,73 @@ +<?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"> + <Styles> + <Style ss:ID="Default" ss:Name="Normal"> + <Alignment ss:Vertical="Bottom"/> + </Style> + <Style ss:ID="black"> + <Font ss:Color="#000000" /> + </Style> + <Style ss:ID="red"> + <Font ss:Color="#FF0000" ss:Bold="1"/> + </Style> + <Style ss:ID="blue"> + <Font ss:Color="#0000FF" ss:Bold="1"/> + </Style> + </Styles> + <Worksheet ss:Name="Sheet1"> + <Table ss:ExpandedColumnCount="18" x:FullColumns="1" x:FullRows="1"> + <Column ss:Index="1" ss:AutoFitWidth="0" ss:Width="150"/> + <Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="3" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="4" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="5" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="6" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="7" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="8" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="9" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="10" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="11" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="12" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="13" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="14" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="15" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="16" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="17" ss:AutoFitWidth="0" ss:Width="50"/> + <Column ss:Index="18" ss:AutoFitWidth="0" ss:Width="50"/> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + <Row><Cell><Data ss:Type="Number">1</Data></Cell></Row> + + <Row><Cell ss:Formula="=sum(R[-10]C:R[-5]C"><Data ss:Type="Number">10</Data></Cell></Row> + </Table> + </Worksheet> +</Workbook> diff --git a/sc/qa/unit/data/xml/styles.xml b/sc/qa/unit/data/xml/styles.xml new file mode 100644 index 000000000..fa5cd2759 --- /dev/null +++ b/sc/qa/unit/data/xml/styles.xml @@ -0,0 +1,34 @@ +<?xml version="1.0"?> +<office:styles xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0"> + <style:style style:name="Name1" style:family="table-cell" style:parent-style-name="Text"> + <style:table-cell-properties fo:background-color="#feffcc" fo:border="0.06pt dotted #ffcc12"/> + </style:style> + <style:style style:name="Name2" style:family="table-cell" style:parent-style-name="Text"> + <style:table-cell-properties fo:diagonal-bl-tr="1.74pt dashed #ffccee" fo:diagonal-tl-br="0.74pt dash-dot #120000" fo:border-left="none" fo:border-right="0.74pt dotted #ff0000"/> + </style:style> + <style:style style:name="Name3" style:family="table-cell" style:parent-style-name="Text"> + <style:table-cell-properties style:cell-protect="hidden-and-protected" style:print-content="true"/> + </style:style> + <style:style style:name="Name4" style:family="table-cell" style:parent-style-name="Text"> + <style:table-cell-properties style:cell-protect="protected formula-hidden" style:print-content="false"/> + </style:style> + <style:style style:name="Name5" style:family="table-cell" style:parent-style-name="Text"> + <style:table-cell-properties style:cell-protect="none" style:print-content="true"/> + </style:style> + <style:style style:name="Name6" style:family="table-cell" style:parent-style-name="Text"> + <style:text-properties style:font-name="Liberation Sans" style:text-underline-style="solid" fo:font-size="24pt" fo:color="#808080" fo:font-style="italic" style:text-underline-color="font-color" fo:font-weight="bold"/> + </style:style> + <style:style style:name="Name7" style:family="table-cell" style:parent-style-name="Default"> + <style:text-properties style:text-line-through-style="solid" style:text-line-through-type="single"/> + </style:style> + <style:style style:name="Name8" style:family="table-cell" style:parent-style-name="Default"> + <style:text-properties style:text-line-through-style="solid" style:text-line-through-type="single" style:text-line-through-width="bold"/> + </style:style> + <style:style style:name="Name9" style:family="table-cell" style:parent-style-name="Default"> + <style:text-properties style:text-line-through-style="solid" style:text-line-through-type="single" style:text-line-through-text="/"/> + </style:style> + <style:style style:name="Name10" style:family="table-cell" style:parent-style-name="Text"> + <style:table-cell-properties style:vertical-align="middle"/> + <style:paragraph-properties fo:text-align="end"/> + </style:style> +</office:styles> diff --git a/sc/qa/unit/data/xml/universal-content.xml b/sc/qa/unit/data/xml/universal-content.xml new file mode 100644 index 000000000..828af6039 --- /dev/null +++ b/sc/qa/unit/data/xml/universal-content.xml @@ -0,0 +1,119 @@ +<?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>moggi</Author> + <LastAuthor>moggi</LastAuthor> + <Created>2013-09-05T11:50:47Z</Created> + <Version>14.00</Version> + </DocumentProperties> + <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> + <AllowPNG/> + </OfficeDocumentSettings> + <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> + <WindowHeight>8190</WindowHeight> + <WindowWidth>16380</WindowWidth> + <WindowTopX>0</WindowTopX> + <WindowTopY>0</WindowTopY> + <TabRatio>141</TabRatio> + <ProtectStructure>False</ProtectStructure> + <ProtectWindows>False</ProtectWindows> + </ExcelWorkbook> + <Styles> + <Style ss:ID="Default" ss:Name="Normal"> + <Alignment ss:Vertical="Bottom"/> + <Borders/> + <Font ss:FontName="Arial" x:Family="Swiss"/> + <Interior/> + <NumberFormat/> + <Protection/> + </Style> + </Styles> + <Worksheet ss:Name="Sheet1"> + <Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="4" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="60.75"> + <Row> + <Cell> + <Data ss:Type="Number">1</Data> + </Cell> + <Cell> + <Data ss:Type="String">String1</Data> + </Cell> + <Cell ss:Formula="=2*3"> + <Data ss:Type="Number">6</Data> + </Cell> + </Row> + <Row> + <Cell> + <Data ss:Type="Number">2</Data> + </Cell> + <Cell> + <Data ss:Type="String">String2</Data> + </Cell> + <Cell ss:Formula="=2+3"> + <Data ss:Type="Number">5</Data> + </Cell> + <Cell ss:Index="5" ss:MergeAcross="1" ss:MergeDown="1"/> + </Row> + <Row> + <Cell ss:Index="3" ss:Formula="=2-3"> + <Data ss:Type="Number">-1</Data> + </Cell> + <Cell ss:Index="8"> + <Comment ss:Author=""> + <ss:Data xmlns="http://www.w3.org/TR/REC-html40"> + <Font html:Face="Tahoma" x:CharSet="1" html:Size="9" html:Color="#000000">Test</Font> + </ss:Data> + </Comment> + </Cell> + </Row> + <Row> + <Cell ss:Index="3" ss:Formula="=R[-3]C+R[-2]C"> + <Data ss:Type="Number">11</Data> + </Cell> + </Row> + </Table> + <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> + <PageSetup> + <Layout x:StartPageNumber="1"/> + <Header x:Margin="0.78749999999999998" x:Data="&C&A"/> + <Footer x:Margin="0.78749999999999998" x:Data="&CPage &P"/> + <PageMargins x:Bottom="1.0249999999999999" x:Left="0.78749999999999998" x:Right="0.78749999999999998" x:Top="1.0249999999999999"/> + </PageSetup> + <Print> + <ValidPrinterInfo/> + <HorizontalResolution>300</HorizontalResolution> + <VerticalResolution>300</VerticalResolution> + </Print> + <Selected/> + <Panes> + <Pane> + <Number>3</Number> + <ActiveRow>6</ActiveRow> + <ActiveCol>3</ActiveCol> + </Pane> + </Panes> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + <EnableSelection>NoSelection</EnableSelection> + </WorksheetOptions> + </Worksheet> + <Worksheet ss:Name="Sheet2"> + <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="60.75"> + </Table> + <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> + <PageSetup> + <Header x:Margin="0.78749999999999998" x:Data="&C&A"/> + <Footer x:Margin="0.78749999999999998" x:Data="&CPage &P"/> + <PageMargins x:Bottom="1.0249999999999999" x:Left="0.78749999999999998" x:Right="0.78749999999999998" x:Top="1.0249999999999999"/> + </PageSetup> + <Print> + <ValidPrinterInfo/> + <HorizontalResolution>300</HorizontalResolution> + <VerticalResolution>300</VerticalResolution> + </Print> + <ProtectObjects>False</ProtectObjects> + <ProtectScenarios>False</ProtectScenarios> + <EnableSelection>NoSelection</EnableSelection> + </WorksheetOptions> + </Worksheet> +</Workbook> |