tests/data/multisheet.gnumeric

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <gnm:Workbook xmlns:gnm="http://www.gnumeric.org/v10.dtd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.gnumeric.org/v9.xsd">
   3   <gnm:Version Epoch="1" Major="12" Minor="44" Full="1.12.44"/>
   4   <gnm:Attributes>
   5     <gnm:Attribute>
   6       <gnm:name>WorkbookView::show_horizontal_scrollbar</gnm:name>
   7       <gnm:value>TRUE</gnm:value>
   8     </gnm:Attribute>
   9     <gnm:Attribute>
  10       <gnm:name>WorkbookView::show_vertical_scrollbar</gnm:name>
  11       <gnm:value>TRUE</gnm:value>
  12     </gnm:Attribute>
  13     <gnm:Attribute>
  14       <gnm:name>WorkbookView::show_notebook_tabs</gnm:name>
  15       <gnm:value>TRUE</gnm:value>
  16     </gnm:Attribute>
  17     <gnm:Attribute>
  18       <gnm:name>WorkbookView::do_auto_completion</gnm:name>
  19       <gnm:value>TRUE</gnm:value>
  20     </gnm:Attribute>
  21     <gnm:Attribute>
  22       <gnm:name>WorkbookView::is_protected</gnm:name>
  23       <gnm:value>FALSE</gnm:value>
  24     </gnm:Attribute>
  25   </gnm:Attributes>
  26   <office:document-meta xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:ooo="http://openoffice.org/2004/office" office:version="1.2">
  27     <office:meta>
  28       <dc:date>2020-07-29T16:17:03Z</dc:date>
  29       <meta:creation-date>2020-07-29T16:16:01Z</meta:creation-date>
  30     </office:meta>
  31   </office:document-meta>
  32   <gnm:Calculation ManualRecalc="0" EnableIteration="1" MaxIterations="100" IterationTolerance="0.001" FloatRadix="2" FloatDigits="53"/>
  33   <gnm:SheetNameIndex>
  34     <gnm:SheetName gnm:Cols="256" gnm:Rows="65536">Sheet1</gnm:SheetName>
  35     <gnm:SheetName gnm:Cols="256" gnm:Rows="65536">Sheet2</gnm:SheetName>
  36     <gnm:SheetName gnm:Cols="256" gnm:Rows="65536">Sheet3</gnm:SheetName>
  37   </gnm:SheetNameIndex>
  38   <gnm:Geometry Width="1438" Height="690"/>
  39   <gnm:Sheets>
  40     <gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0">
  41       <gnm:Name>Sheet1</gnm:Name>
  42       <gnm:MaxCol>0</gnm:MaxCol>
  43       <gnm:MaxRow>0</gnm:MaxRow>
  44       <gnm:Zoom>1</gnm:Zoom>
  45       <gnm:Names>
  46         <gnm:Name>
  47           <gnm:name>Print_Area</gnm:name>
  48           <gnm:value>#REF!</gnm:value>
  49           <gnm:position>A1</gnm:position>
  50         </gnm:Name>
  51         <gnm:Name>
  52           <gnm:name>Sheet_Title</gnm:name>
  53           <gnm:value>&quot;Sheet1&quot;</gnm:value>
  54           <gnm:position>A1</gnm:position>
  55         </gnm:Name>
  56       </gnm:Names>
  57       <gnm:PrintInformation>
  58         <gnm:Margins>
  59           <gnm:top Points="120" PrefUnit="mm"/>
  60           <gnm:bottom Points="120" PrefUnit="mm"/>
  61           <gnm:left Points="72" PrefUnit="mm"/>
  62           <gnm:right Points="72" PrefUnit="mm"/>
  63           <gnm:header Points="72" PrefUnit="mm"/>
  64           <gnm:footer Points="72" PrefUnit="mm"/>
  65         </gnm:Margins>
  66         <gnm:Scale type="percentage" percentage="100"/>
  67         <gnm:vcenter value="0"/>
  68         <gnm:hcenter value="0"/>
  69         <gnm:grid value="0"/>
  70         <gnm:even_if_only_styles value="0"/>
  71         <gnm:monochrome value="0"/>
  72         <gnm:draft value="0"/>
  73         <gnm:titles value="0"/>
  74         <gnm:do_not_print value="0"/>
  75         <gnm:print_range value="GNM_PRINT_ACTIVE_SHEET"/>
  76         <gnm:order>d_then_r</gnm:order>
  77         <gnm:orientation>portrait</gnm:orientation>
  78         <gnm:Header Left="" Middle="&amp;[TAB]" Right=""/>
  79         <gnm:Footer Left="" Middle="Page &amp;[PAGE]" Right=""/>
  80         <gnm:paper>iso_a4</gnm:paper>
  81         <gnm:comments placement="GNM_PRINT_COMMENTS_IN_PLACE"/>
  82         <gnm:errors PrintErrorsAs="GNM_PRINT_ERRORS_AS_DISPLAYED"/>
  83       </gnm:PrintInformation>
  84       <gnm:Styles>
  85         <gnm:StyleRegion startCol="0" startRow="0" endCol="255" endRow="65535">
  86           <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
  87             <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font>
  88           </gnm:Style>
  89         </gnm:StyleRegion>
  90       </gnm:Styles>
  91       <gnm:Cols DefaultSizePts="48"/>
  92       <gnm:Rows DefaultSizePts="12.75">
  93         <gnm:RowInfo No="0" Unit="13.5"/>
  94       </gnm:Rows>
  95       <gnm:Selections CursorCol="0" CursorRow="1">
  96         <gnm:Selection startCol="0" startRow="1" endCol="0" endRow="1"/>
  97       </gnm:Selections>
  98       <gnm:Cells>
  99         <gnm:Cell Row="0" Col="0" ValueType="60">Wrong sheet</gnm:Cell>
 100       </gnm:Cells>
 101       <gnm:SheetLayout TopLeft="A1"/>
 102       <gnm:Solver ModelType="0" ProblemType="0" MaxTime="60" MaxIter="1000" NonNeg="1" Discr="0" AutoScale="0" ProgramR="0" SensitivityR="0"/>
 103     </gnm:Sheet>
 104     <gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0">
 105       <gnm:Name>Sheet2</gnm:Name>
 106       <gnm:MaxCol>2</gnm:MaxCol>
 107       <gnm:MaxRow>3</gnm:MaxRow>
 108       <gnm:Zoom>1</gnm:Zoom>
 109       <gnm:Names>
 110         <gnm:Name>
 111           <gnm:name>Print_Area</gnm:name>
 112           <gnm:value>#REF!</gnm:value>
 113           <gnm:position>A1</gnm:position>
 114         </gnm:Name>
 115         <gnm:Name>
 116           <gnm:name>Sheet_Title</gnm:name>
 117           <gnm:value>&quot;Sheet2&quot;</gnm:value>
 118           <gnm:position>A1</gnm:position>
 119         </gnm:Name>
 120       </gnm:Names>
 121       <gnm:PrintInformation>
 122         <gnm:Margins>
 123           <gnm:top Points="120" PrefUnit="mm"/>
 124           <gnm:bottom Points="120" PrefUnit="mm"/>
 125           <gnm:left Points="72" PrefUnit="mm"/>
 126           <gnm:right Points="72" PrefUnit="mm"/>
 127           <gnm:header Points="72" PrefUnit="mm"/>
 128           <gnm:footer Points="72" PrefUnit="mm"/>
 129         </gnm:Margins>
 130         <gnm:Scale type="percentage" percentage="100"/>
 131         <gnm:vcenter value="0"/>
 132         <gnm:hcenter value="0"/>
 133         <gnm:grid value="0"/>
 134         <gnm:even_if_only_styles value="0"/>
 135         <gnm:monochrome value="0"/>
 136         <gnm:draft value="0"/>
 137         <gnm:titles value="0"/>
 138         <gnm:do_not_print value="0"/>
 139         <gnm:print_range value="GNM_PRINT_ACTIVE_SHEET"/>
 140         <gnm:order>d_then_r</gnm:order>
 141         <gnm:orientation>portrait</gnm:orientation>
 142         <gnm:Header Left="" Middle="&amp;[TAB]" Right=""/>
 143         <gnm:Footer Left="" Middle="Page &amp;[PAGE]" Right=""/>
 144         <gnm:paper>iso_a4</gnm:paper>
 145         <gnm:comments placement="GNM_PRINT_COMMENTS_IN_PLACE"/>
 146         <gnm:errors PrintErrorsAs="GNM_PRINT_ERRORS_AS_DISPLAYED"/>
 147       </gnm:PrintInformation>
 148       <gnm:Styles>
 149         <gnm:StyleRegion startCol="0" startRow="0" endCol="255" endRow="65535">
 150           <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
 151             <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font>
 152           </gnm:Style>
 153         </gnm:StyleRegion>
 154       </gnm:Styles>
 155       <gnm:Cols DefaultSizePts="48"/>
 156       <gnm:Rows DefaultSizePts="12.75">
 157         <gnm:RowInfo No="0" Unit="13.5" Count="4"/>
 158       </gnm:Rows>
 159       <gnm:Selections CursorCol="0" CursorRow="0">
 160         <gnm:Selection startCol="0" startRow="0" endCol="2" endRow="3"/>
 161       </gnm:Selections>
 162       <gnm:Cells>
 163         <gnm:Cell Row="0" Col="0" ValueType="60">hi</gnm:Cell>
 164         <gnm:Cell Row="0" Col="1" ValueType="60">tweedle</gnm:Cell>
 165         <gnm:Cell Row="0" Col="2" ValueType="40">1</gnm:Cell>
 166         <gnm:Cell Row="1" Col="0" ValueType="60">ho</gnm:Cell>
 167         <gnm:Cell Row="1" Col="1" ValueType="60">dee</gnm:Cell>
 168         <gnm:Cell Row="1" Col="2" ValueType="40">2</gnm:Cell>
 169         <gnm:Cell Row="2" Col="0" ValueType="60">hum</gnm:Cell>
 170         <gnm:Cell Row="2" Col="1" ValueType="60">dum</gnm:Cell>
 171         <gnm:Cell Row="2" Col="2" ValueType="40">3</gnm:Cell>
 172         <gnm:Cell Row="3" Col="0" ValueType="40">6</gnm:Cell>
 173         <gnm:Cell Row="3" Col="1" ValueType="40">5</gnm:Cell>
 174         <gnm:Cell Row="3" Col="2" ValueType="40">4</gnm:Cell>
 175       </gnm:Cells>
 176       <gnm:SheetLayout TopLeft="A1"/>
 177       <gnm:Solver ModelType="0" ProblemType="0" MaxTime="60" MaxIter="1000" NonNeg="1" Discr="0" AutoScale="0" ProgramR="0" SensitivityR="0"/>
 178     </gnm:Sheet>
 179     <gnm:Sheet DisplayFormulas="0" HideZero="0" HideGrid="0" HideColHeader="0" HideRowHeader="0" DisplayOutlines="1" OutlineSymbolsBelow="1" OutlineSymbolsRight="1" Visibility="GNM_SHEET_VISIBILITY_VISIBLE" GridColor="0:0:0">
 180       <gnm:Name>Sheet3</gnm:Name>
 181       <gnm:MaxCol>0</gnm:MaxCol>
 182       <gnm:MaxRow>0</gnm:MaxRow>
 183       <gnm:Zoom>1</gnm:Zoom>
 184       <gnm:Names>
 185         <gnm:Name>
 186           <gnm:name>Print_Area</gnm:name>
 187           <gnm:value>#REF!</gnm:value>
 188           <gnm:position>A1</gnm:position>
 189         </gnm:Name>
 190         <gnm:Name>
 191           <gnm:name>Sheet_Title</gnm:name>
 192           <gnm:value>&quot;Sheet3&quot;</gnm:value>
 193           <gnm:position>A1</gnm:position>
 194         </gnm:Name>
 195       </gnm:Names>
 196       <gnm:PrintInformation>
 197         <gnm:Margins>
 198           <gnm:top Points="120" PrefUnit="mm"/>
 199           <gnm:bottom Points="120" PrefUnit="mm"/>
 200           <gnm:left Points="72" PrefUnit="mm"/>
 201           <gnm:right Points="72" PrefUnit="mm"/>
 202           <gnm:header Points="72" PrefUnit="mm"/>
 203           <gnm:footer Points="72" PrefUnit="mm"/>
 204         </gnm:Margins>
 205         <gnm:Scale type="percentage" percentage="100"/>
 206         <gnm:vcenter value="0"/>
 207         <gnm:hcenter value="0"/>
 208         <gnm:grid value="0"/>
 209         <gnm:even_if_only_styles value="0"/>
 210         <gnm:monochrome value="0"/>
 211         <gnm:draft value="0"/>
 212         <gnm:titles value="0"/>
 213         <gnm:do_not_print value="0"/>
 214         <gnm:print_range value="GNM_PRINT_ACTIVE_SHEET"/>
 215         <gnm:order>d_then_r</gnm:order>
 216         <gnm:orientation>portrait</gnm:orientation>
 217         <gnm:Header Left="" Middle="&amp;[TAB]" Right=""/>
 218         <gnm:Footer Left="" Middle="Page &amp;[PAGE]" Right=""/>
 219         <gnm:paper>iso_a4</gnm:paper>
 220         <gnm:comments placement="GNM_PRINT_COMMENTS_IN_PLACE"/>
 221         <gnm:errors PrintErrorsAs="GNM_PRINT_ERRORS_AS_DISPLAYED"/>
 222       </gnm:PrintInformation>
 223       <gnm:Styles>
 224         <gnm:StyleRegion startCol="0" startRow="0" endCol="255" endRow="65535">
 225           <gnm:Style HAlign="GNM_HALIGN_GENERAL" VAlign="GNM_VALIGN_BOTTOM" WrapText="0" ShrinkToFit="0" Rotation="0" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
 226             <gnm:Font Unit="10" Bold="0" Italic="0" Underline="0" StrikeThrough="0" Script="0">Sans</gnm:Font>
 227           </gnm:Style>
 228         </gnm:StyleRegion>
 229       </gnm:Styles>
 230       <gnm:Cols DefaultSizePts="48"/>
 231       <gnm:Rows DefaultSizePts="12.75">
 232         <gnm:RowInfo No="0" Unit="13.5"/>
 233       </gnm:Rows>
 234       <gnm:Selections CursorCol="0" CursorRow="1">
 235         <gnm:Selection startCol="0" startRow="1" endCol="0" endRow="1"/>
 236       </gnm:Selections>
 237       <gnm:Cells>
 238         <gnm:Cell Row="0" Col="0" ValueType="60">Not this sheet!</gnm:Cell>
 239       </gnm:Cells>
 240       <gnm:SheetLayout TopLeft="A1"/>
 241       <gnm:Solver ModelType="0" ProblemType="0" MaxTime="60" MaxIter="1000" NonNeg="1" Discr="0" AutoScale="0" ProgramR="0" SensitivityR="0"/>
 242     </gnm:Sheet>
 243   </gnm:Sheets>
 244   <gnm:UIData SelectedTab="1"/>
 245 </gnm:Workbook>