To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100135 Issue #|100135 Summary|Moving formulas containing external references may res |ult in wrong references. Component|Spreadsheet Version|OOO310m4 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|er Reported by|er
------- Additional comments from e...@openoffice.org Wed Mar 11 18:47:23 +0000 2009 ------- Moving formulas containing external references may result in wrong references. Scenario: 1. Create and save a document external.ods with some data in cell Sheet1.A1. 2. Create a new document. 3. In cell A1 enter the formula ='external.ods'#Sheet1.A1 4. Copy cell A1 to clipboard. 5. Paste clipboard to cell A2. 6. The formula and result will be correctly adapted to point to external.ods Sheet1.A2 7. Move cell A2 to B3, either by Cut&Paste or dragging with the mouse. 8. Formula and result of B3 will point to external.ods Sheet1.A1 instead of external.ods Sheet1.A2 Note: you'll need a (not yet available) OOO310m5 (DEV300m43 does as well) to reproduce, earlier versions already crash after having entered the external reference.. In a non-product dbg-util build assertions pop up about a virtual dummy ScToken::CalcAbsIfRel() being called, which essentially is related to this. --------------------------------------------------------------------- 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...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
