To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108539 Issue #|108539 Summary|Using names in Calc gives problems when inserting a co |lumn Component|Spreadsheet Version|DEV300m49 Platform|Other URL|https://bugs.launchpad.net/ubuntu/+source/openoffice.o |rg/+bug/379676 OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|brunogirin
------- Additional comments from brunogi...@openoffice.org Thu Jan 21 12:03:30 +0000 2010 ------- See the original Ubuntu Launchpad bug for more details: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/379676 Using names in Calc gives problems when inserting a column. See attached file. Steps to reproduce: 1. Open the attached cars.ods file 2. Click on column header for column E 3. Go to: Insert -> Columns 4. A new column is inserted before E; values in column labelled "col3" have changed: instead of being the sum of D + F, they now have the same values as D 5. Go to: Insert -> Names -> Define 6. Select any definition 7. Click "modify" without changing anything 8. Click OK 9. Values in column G are now the sum of D and F as expected Expected behaviour: In step 4 above, the values of the column labelled "col3" should not change Actual behaviour: In step 4, values in column labelled "col3" change and need to be reset manually by a fake modify of the name definition Reference: 1. Example file: http://launchpadlibrarian.net/27079532/cars.ods --------------------------------------------------------------------- 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
