To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=21280
------- Additional comments from [email protected] Tue Dec 8 02:51:31 +0000 2009 ------- On a sheet where there are formulae, eg column A contains values and column B contains cumulative totals (ie B2=B1+A2, etc), moving a row further down the sheet is not simple. It is possible (in OpenOffice 3.1.1) to move a row by selecting it, dragging a selected cell down, and pressing ALT before releasing the mouse (which isn't intuitively obvious, but is very useful). However, the formulae are badly messed up as a result. Moving the current row 3 down one row (ie swapping rows 3 and 4) results in B2=B1+A2 (good), B3=B4+A3 (bad), B4=B2+A4 (bad), B5=B3+A5 (bad), B6=B5+A6 (good). So three formulae are wrong in this case. The user then has to fix the spreadsheet manually, although it is not likely to be obvious that the formulae are now out of step. For users who haven't discovered the little-known ALT key functionality they would have to use the following method. First the new row location must be created as a blank row, but the cumulative formula for the line below is distorted, eg if B5 contained =B4+A5 the cell that it moves to (B6) becomes =B4+A6 (wrong). Next, the row to be moved is copied and pasted over the newly inserted blank row (noticing that the total at the bottom doesn't change, which is sad). Finally the original row is deleted and the formulae below it all show "#REF!". The user is then left to repair the damage. The Excel feature "insert cut cells" is very useful and some equivalent in OpenOffice would make such work much more pleasant and less prone to error. Perhaps the version should be advanced to 3.1 since the problem still exists? Thanks for your great product! --------------------------------------------------------------------- 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]
