Issue 107417 - Calc is not processing the AutoFitWidth commands
Summary: Calc is not processing the AutoFitWidth commands
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.1.1
Hardware: PC Windows, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-12-03 16:07 UTC by brunoais
Modified: 2014-01-02 11:40 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
This is the file (28.28 KB, text/xml)
2009-12-03 16:09 UTC, brunoais 		no flags Details
Excel 2010 vs. Calc 4.1 (166.65 KB, image/jpeg)
2014-01-02 11:40 UTC, Edwin Sharp 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description brunoais 2009-12-03 16:07:28 UTC 
I've made a full xml file for microsoft excel where it works like a charm!
But... when I try to open it with Calc it opens well with only one problem.
It is not processing the

<Column ss:AutoFitWidth="1" ss:Width="17" />

tags correctly.
It is working as the option: "AutoFitWidth" was ="0".

Please show me (if it is not a bug) how to correct it.

This is the code I'm trying to test:
<?xml version="1.0"?>

<!--

Welcome to my excel xml test file! What I wanted with this is to have a base
xml file to make an export to excel that has a better text than the earlyer version

I hope this works...

there will be comments as the file continues. I do hope they are clear enugth
-->

<!--
From here:
it's not meant to be changed not even a bit!!!
-->


<?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">
 
 <!--
This is the styles tag
Everything inside it has information on all the cells styles.
(Needs some checkup to perfect it)
Do not change it if you don't have a backup!!!
	-->
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
  </Style>
  <Style ss:ID="m39074656">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
  </Style>
  <Style ss:ID="m39074676">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
  </Style>
  <Style ss:ID="m39074696">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
  </Style>
  <Style ss:ID="m39074208">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
  </Style>
  <Style ss:ID="m39074228">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
  </Style>
  <Style ss:ID="m39074248">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
  </Style>
  <Style ss:ID="m39074268">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
  </Style>
  <Style ss:ID="m39074288">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
  </Style>
  <Style ss:ID="m39074308">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
  </Style>
  <Style ss:ID="s62">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </Style>
  <Style ss:ID="s63">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
  </Style>
  <Style ss:ID="s75">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </Style>
  <Style ss:ID="s78">
   <Interior ss:Color="#F2F2F2" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s79">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Interior ss:Color="#F2F2F2" ss:Pattern="Solid"/>
  </Style>
  <Style ss:ID="s80">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Interior ss:Color="#F2F2F2" ss:Pattern="Solid"/>
   <NumberFormat ss:Format="Short Date"/>
  </Style>
  <Style ss:ID="s81">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Interior ss:Color="#F2F2F2" ss:Pattern="Solid"/>
   <NumberFormat ss:Format="General Date"/>
  </Style>
  <Style ss:ID="s82">
   <Interior/>
  </Style>
  <Style ss:ID="s83">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Interior/>
  </Style>
  <Style ss:ID="s84">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Interior/>
   <NumberFormat ss:Format="Short Date"/>
  </Style>
  <Style ss:ID="s85">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Interior/>
   <NumberFormat ss:Format="General Date"/>
  </Style>
  <Style ss:ID="s86">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>
   </Borders>
  </Style>
 </Styles>
	<!--
Dunno if this "admin_export" needs to be changed
	-->
	
 <Worksheet ss:Name="admin_export">
  <Table>
   
   <!--
here do not change the number of tags.
There must be the same amount of tags as there are of cols that have data
The width is the perfect size for the values it has now.
Maybe: It has to be optimized for other languages
	-->
   <Column ss:AutoFitWidth="1" ss:Width="70" />
   <Column ss:AutoFitWidth="1" ss:Width="30" />
   <Column ss:AutoFitWidth="1" ss:Width="25" />
   <Column ss:AutoFitWidth="1" ss:Width="28" />
   <Column ss:AutoFitWidth="1" ss:Width="12" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="17" />
   <Column ss:AutoFitWidth="1" ss:Width="23" />
   <Column ss:AutoFitWidth="1" ss:Width="50" />
   
    <!--
This is the 1st row.
I think it is self explanatory
	-->
   <Row ss:AutoFitHeight="0" ss:StyleID="s62">
    <Cell ss:MergeDown="1" ss:StyleID="m39074208"><Data
ss:Type="String">name</Data></Cell>
    <Cell ss:MergeDown="1" ss:StyleID="m39074228"><Data
ss:Type="String">this</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="m39074248"><Data
ss:Type="String">vs</Data></Cell>
    <Cell ss:MergeAcross="9" ss:StyleID="m39074268"><Data
ss:Type="String">that</Data></Cell>
    <Cell ss:MergeAcross="9" ss:StyleID="m39074288"><Data ss:Type="String">and
that</Data></Cell>
    <Cell ss:MergeAcross="9" ss:StyleID="m39074308"><Data
ss:Type="String">this</Data></Cell>
    <Cell ss:MergeDown="1" ss:StyleID="m39074656"><Data ss:Type="String">this
data</Data></Cell>
    <Cell ss:MergeDown="1" ss:StyleID="m39074676"><Data ss:Type="String">last
log.</Data></Cell>
    <Cell ss:MergeDown="1" ss:StyleID="m39074696"><Data
ss:Type="String">id</Data></Cell>
    <Cell ss:StyleID="s75"/>
   </Row>
    <!--
This is the 2nd row.
I think it is self explanatory
	-->
   <Row ss:AutoFitHeight="0" ss:Height="15.75" ss:StyleID="s62">
    <Cell ss:Index="3" ss:StyleID="s63"><Data ss:Type="String">man</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">horse</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t1</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t2</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t3</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t4</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t5</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t6</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t7</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t8</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t9</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t10</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t1</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t2</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t3</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t4</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t5</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t6</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t7</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t8</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t9</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t10</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t1</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t2</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t3</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t4</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t5</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t6</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t7</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t8</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t9</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">t10</Data></Cell>
    <Cell ss:Index="38" ss:StyleID="s75"/>
   </Row>
   <!--
This is the 3rd row.
I think it is self explanatory
	-->
   <!--
Please watch carefully the
ss:StyleID
tag.
it repeats each 2 rows.
It's only meant to make the 2 colours in order to be more easy not to jump lines
while analysing the data
	-->
   <Row ss:AutoFitHeight="0" ss:StyleID="s78">
    <Cell ss:StyleID="s79"><Data ss:Type="String">brunoais</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s80"><Data
ss:Type="DateTime">2009-11-20T00:00:00.000</Data></Cell>
    <Cell ss:StyleID="s81"><Data
ss:Type="DateTime">2009-11-20T23:35:25.000</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:StyleID="s82">
    <Cell ss:StyleID="s83"><Data ss:Type="String">brunoais</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">63456345</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s84"><Data
ss:Type="DateTime">2009-11-20T00:00:00.000</Data></Cell>
    <Cell ss:StyleID="s85"><Data
ss:Type="DateTime">2009-11-20T23:35:25.000</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:StyleID="s78">
    <Cell ss:StyleID="s79"><Data ss:Type="String">brunoais</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s80"><Data
ss:Type="DateTime">2009-11-20T00:00:00.000</Data></Cell>
    <Cell ss:StyleID="s81"><Data
ss:Type="DateTime">2009-11-20T23:35:25.000</Data></Cell>
    <Cell ss:StyleID="s79"><Data ss:Type="Number">0</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:StyleID="s82">
    <Cell ss:StyleID="s83"><Data ss:Type="String">brunoais</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">1</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s84"><Data
ss:Type="DateTime">2009-11-20T00:00:00.000</Data></Cell>
    <Cell ss:StyleID="s85"><Data
ss:Type="DateTime">2009-11-20T23:35:25.000</Data></Cell>
    <Cell ss:StyleID="s83"><Data ss:Type="Number">0</Data></Cell>
   </Row>
   
   <!--
Say good bye to database calculating the sum.
let's let the excel do this for us
	-->
   
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s86"><Data ss:Type="String">Sum</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C:R[-1]C)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C:R[-1]C)"><Data
ss:Type="Number">2</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C4:R[-1]C4)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C5:R[-1]C5)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C6:R[-1]C6)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C7:R[-1]C7)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C8:R[-1]C8)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C9:R[-1]C9)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C10:R[-1]C10)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C11:R[-1]C11)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C12:R[-1]C12)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C13:R[-1]C13)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C14:R[-1]C14)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C15:R[-1]C15)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C16:R[-1]C16)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C17:R[-1]C17)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C18:R[-1]C18)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C19:R[-1]C19)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C20:R[-1]C20)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C21:R[-1]C21)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C22:R[-1]C22)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C23:R[-1]C23)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C24:R[-1]C24)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C25:R[-1]C25)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C26:R[-1]C26)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C27:R[-1]C27)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C28:R[-1]C28)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C29:R[-1]C29)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C30:R[-1]C30)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C31:R[-1]C31)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C32:R[-1]C32)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C33:R[-1]C33)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C34:R[-1]C34)"><Data
ss:Type="Number">0</Data></Cell>
    <Cell ss:StyleID="s86"/>
    <Cell ss:StyleID="s86"/>
    <Cell ss:StyleID="s86" ss:Formula="=SUM(R3C37:R[-1]C37)"><Data
ss:Type="Number">0</Data></Cell>
   </Row>
  </Table>
 </Worksheet>
</Workbook>
Comment 1 brunoais 2009-12-03 16:09:10 UTC 
Created attachment 66476 [details]
This is the file
Comment 2 michael.brauer 2009-12-04 15:31:39 UTC 
Adapted component.
Comment 3 michael.brauer 2009-12-04 15:32:52 UTC 
adapted sub component
Comment 4 Edwin Sharp 2014-01-02 11:40:07 UTC 
Created attachment 82199 [details]
Excel 2010 vs. Calc 4.1
Comment 5 Edwin Sharp 2014-01-02 11:40:49 UTC 
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1552994
Rev.1552994
Win 7