To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101162 Issue #|101162 Summary|Resizing import range corrupts adjacent array formulas Component|Spreadsheet Version|OOo 3.0.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|villeroy
------- Additional comments from [email protected] Fri Apr 17 12:28:41 +0000 2009 ------- There is a handy option to expand adjacent formula ranges to imported database ranges. I encountered a strange issue when I tried this feature with a database range. I'll attach a spreadsheet where I could reproduce the issue with a db-range bound to the infamous Bibliography.biblio. It has no data stored but 2 versions of the same array formula with relative and absolute references. When you open the file you are prompted for update. After updating, the first calculated field looks right, but has many overlapping array formulas, the second field shows only the first result in all rows while showing the expected array formula. --------------------------------------------------------------------- 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]
