To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84806 Issue #|84806 Summary|Array formula results incorrect Component|Spreadsheet Version|OOo 2.3.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|edeveridge
------- Additional comments from [EMAIL PROTECTED] Thu Dec 20 19:48:12 +0000 2007 ------- The following array formula does not calculate correctly: {=SUM(IF(MOD(COLUMN(B1:J1);3)<>MOD(COLUMN();3);0;B1:J1))} when it occurs in location A1 in a single row of data 0 1 1 1 1 1 1 1 1 1 MS Excel correctly calculates this as 3 3 1 1 1 1 1 1 1 1 1 related to but not the same as problems 19765, 63166, 46681 xml for the sheet is <?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:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> <Version>11.9999</Version> </DocumentProperties> <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> <Colors> <Color> <Index>3</Index> <RGB>#C0C0C0</RGB> </Color> <Color> <Index>4</Index> <RGB>#FF0000</RGB> </Color> </Colors> </OfficeDocumentSettings> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> <WindowHeight>9000</WindowHeight> <WindowWidth>13860</WindowWidth> <WindowTopX>165</WindowTopX> <WindowTopY>-15</WindowTopY> <ProtectStructure>False</ProtectStructure> <ProtectWindows>False</ProtectWindows> </ExcelWorkbook> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font/> <Interior/> <NumberFormat/> <Protection/> </Style> <Style ss:ID="s21" ss:Name="Default"> </Style> <Style ss:ID="s27" ss:Name="Normal_"> <Alignment ss:Vertical="Bottom"/> <Font ss:FontName="Helv"/> </Style> </Styles> <Worksheet ss:Name="Sheet1"> <Table ss:ExpandedColumnCount="86" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1" ss:StyleID="s21"> <Column ss:StyleID="s21" ss:Width="64.5"/> <Column ss:StyleID="s21" ss:Width="29.25"/> <Column ss:StyleID="s21" ss:Width="17.25" ss:Span="68"/> <Column ss:Index="72" ss:StyleID="s21" ss:Width="66" ss:Span="14"/> <Row ss:AutoFitHeight="0" ss:Height="15.1875"> <Cell ss:StyleID="s27" ss:ArrayRange="RC" ss:Formula="=SUM(IF(MOD(COLUMN(RC[1]:RC[9]),3)<>MOD(COLUMN(),3),0,RC [1]:RC[9]))"><Data ss:Type="Number">3</Data></Cell> <Cell><Data ss:Type="Number">1</Data></Cell> <Cell><Data ss:Type="Number">1</Data></Cell> <Cell><Data ss:Type="Number">1</Data></Cell> <Cell><Data ss:Type="Number">1</Data></Cell> <Cell><Data ss:Type="Number">1</Data></Cell> <Cell><Data ss:Type="Number">1</Data></Cell> <Cell><Data ss:Type="Number">1</Data></Cell> <Cell><Data ss:Type="Number">1</Data></Cell> <Cell><Data ss:Type="Number">1</Data></Cell> </Row> </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <Selected/> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> <x:WorksheetOptions/> </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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]