To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80252 Issue #|80252 Summary|Formula in a cell corrupted by copy/paste on another c |ell Component|Spreadsheet Version|OOo 2.2.1 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|ccasteyde
------- Additional comments from [EMAIL PROTECTED] Wed Aug 1 09:56:49 +0000 2007 ------- When I copy a cell from one row to another one, the formula placed in the adjacent cell is corrupted. For instance, with the given sample file, there are two columns of numbers (A and B), and the sum by row in the third column (A+B). So the cells in the column C contains the following formulas: "=A2+B2", "=A3+B3", etc. When i select a cell in the B column (for instance the cell B3), cut it and paste it in another B cell (for instance B5), the formula adjacent to the cut cell (so C3, "=A3+B3") is modified and becomes "=A3+B5". This is wrong, I didn't modified the cell, and even if it was the case, it should still sum numbers in the same row! This is a big problem because when the user copy/paste a cell, she is looking at the destination, and doesn't think to check the formula of the source row. So the sum are wrong, and if there is a total at the bottom of the C column, the result is wrong (by the amount of "-B3 + B5"). Once you got the problem, you can check all formulas after copy/paste operation, but this is tiring and the software is simply not reliable. Btw, I think that protecting the cell would be inefficient, since the modification is totally unexpected and may even bypass access control check. I didn't try this test, but I also reported a bug with cell protection bypassed with cut/past on multi cell, so I'm quite sure this part of code is a mess. Thanks a lot, CC --------------------------------------------------------------------- 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]
