To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103329 Issue #|103329 Summary|Formulas not relcalculating on paste or drag-copy on l |arge spreadsheets Component|Spreadsheet Version|1.0.3 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|hontzd
------- Additional comments from hon...@openoffice.org Sat Jul 4 20:53:33 +0000 2009 ------- I cannot replicate this in a small example, however, it occurs on a larger spreadsheet (100+ rows by 23 columns) I work with. When pasting cells with formulas to a new position, the formula in the new cell is updated to the correct relative references, but the value on that cell is not updated (it retains the value of the copied cell). Similarly, using drag-copy to extend a column of formulas down updates the formula references, but the values displayed are just copies of the value in the first cell. The formula I'm using that surfaces this bug simply adds the value of a cell in a different column of the current row to the value of the cell immediately above in the current column, for example in cell T117, i have the formula =T116+I117 Additionally, I experienced numerous crashes while copying and pasting these sorts of cells, but it appear that bug is already be tracked. Also see forum thread: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=19697 --------------------------------------------------------------------- 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