To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107417 Issue #|107417 Summary|Calc is not processing the AutoFitWidth commands Component|xml Version|OOo 3.1.1 Platform|PC URL| OS/Version|Windows, all Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|www Assigned to|mib Reported by|brunoais
------- Additional comments from bruno...@openoffice.org Thu Dec 3 16:07:28 +0000 2009 ------- 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> --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@xml.openoffice.org For additional commands, e-mail: issues-h...@xml.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
