To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112938 Issue #|112938 Summary|copying a sheet with references to another, in the sam |e document, makes formulas point to the wrong sheet Component|Spreadsheet Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|Mac OS X, 10.6 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|pldg
------- Additional comments from p...@openoffice.org Mon Jul 5 16:17:50 +0000 2010 ------- I've been using copying and modifying of sheets for several years, but was away on a sabbatical and didn't have to use the feature since 2008. Now that I do, I spotted the problem on 3.2.0, upgraded to 3.2.1 and also tested on OOo-dev 3.3.0 (DEV300m84 build 9512). In the attached sample, "lista" contains basic data about my students which I reference from the other sheets, like "prova1". For the second exam in the class I used to copy the sheet "prova1", renamed as "prova2" and then would fill in the marking data for that exam appropriately. For this to work, all formating and formulas that reference "lista" must remain the same. However, on 3.2.0, 3.2.1 and DEV300m84 the formulas on the copied sheet all reference "notas" instead of "lista". --------------------------------------------------------------------- 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