To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67774 Issue #|67774 Summary|Odd handling of DataArray pseudoProprty Component|Spreadsheet Version|OOo 2.0.3 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|terrye
------- Additional comments from [EMAIL PROTECTED] Tue Jul 25 15:13:04 -0700 2006 ------- I wrote a macro which included the use of DataArray access to convert columns containing formulas to their literal equivalent (as in copy/paste value). I first tried oRange.DataArray = oRange.DataArray which is supposed to be semantically equivalent to oRange.setDataArray(oRange.GetDataArray() but it isn't -- the first leaves the formulas unchanged and the second doesn't. I simplified it down to the following code which repeatedly shows the issue: rB2 = ThisComponent.Sheets(0).getCellByPosition(1, 1) rB2a = rB2 rB2b = ThisComponent.Sheets(0).getCellByPosition(1, 1) rB2.Formula = "=Row()" : rB2.DataArray = rB2.DataArray : Print rB2.Formula rB2.Formula = "=Row()" : rB2a.DataArray = rB2.DataArray : Print rB2.Formula rB2.Formula = "=Row()" : rB2b.DataArray = rB2.DataArray : Print rB2.Formula rB2.Formula = "=Row()" : t=rB2.DataArray : rB2.DataArray=t : Print rB2.Formula rB2.Formula = "=Row()" : rB2.setDataArray(rB2.getDataArray): Print rB2.Formula 1 & 2 return the ROW() formula, 3-4 return the value. It's the fact that the second fails and the third works. Clearly it fails when the variants are pointing to the same object (e.g. rB2 and RB2A) as opposed to two separate but identical objects (R2 and R2B) --------------------------------------------------------------------- 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]