To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=59745





------- Additional comments from [EMAIL PROTECTED] Wed Dec 19 09:47:22 +0000 
2007 -------
A Real Workaround!
(& excellent repair!)

Copy / pasting the affected cells, even in situ repairs the position of the 
notes. 
(Moving the cells does the same).

Method 1 - Fine
So after inserting/deleting the new rows/columns, the notes are all in the wrong
place.  Select the cells affected by the insertion (eg all cells below the new
lines inserted) do a control-C followed by a control-V, which copies and pastes
the cells in situ (in their places).  The notes are now where they should be.  

Method 2 - Gross
For large sheets, you can just select the whole sheet (click on the top left
corner of the sheet) and do the same control-C followed by a control-V, which
copies and pastes the whole sheet in situ.

Analysis
copy/paste and move handle note positions correctly,
insert/delete rows/columns, sorting etc do not. 
I have only verified this in 2.3.1. 

Effect
If I had found this repair years ago my children would not know so many curse
words. 

Hope this is helpful to some other irritated souls!

---------------------------------------------------------------------
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]

Reply via email to