To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74434 Issue #|74434 Summary|Formulas that calculate across sheets are flakey Component|Spreadsheet Version|OOo 2.0.4 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|dalo
------- Additional comments from [EMAIL PROTECTED] Sun Feb 11 21:30:47 +0000 2007 ------- This happened during an OOo course of Calc (OOo 2.04 NL) We where doing an exercise on 3D formula's - sum function through several sheets, e.g. calculating a sum on cell B2 During the exercise I explained that dragging the sheets and inserting new sheets and deleting sheets between the two outer sheets influenced the sums immediately. Simply do not touch the two outer sheets but drag in what you like to have an instant total sheet. After the exercise one of my students happened to see that his sums where faulty. He did insert and delete copies of sheets, even redid the calculation afterwards but the result remained wrong. I cannot reproduce what he did (on OOo2.1 EN), and I myself am unable to get in this situation. --------------------------------------------------------------------- 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]