Apache OpenOffice (AOO) Bugzilla – Issue 109372
Calc loses comments after inserting rows
Last modified: 2013-08-07 15:15:29 UTC
winxp.pro.ru.sp3 or linux fedora 12 OOo.3.2 OOO320m12 OOo-dev.3.3 DEV300m71 Preparation: 1) start Calc 2) menu Insert - Comment - type something 3) click on A1 cell - Ctrl+C (copy) 4) select A2:A20 - Ctrl+V (paste) 5) Ctrl+S (save) Experiment 1, after preparation: 6) select A1 7) menu Insert - Rows 8) Ctrl+S (save) 9) menu File - Reload Result: some comments was lost (A2, A4, A6, ... after insert). Experiment 2, after preparation: 6) select A1:A3 7) menu Insert - Rows 8) Ctrl+S (save) 9) menu File - Reload Result: some comments was lost (A4:A6, A10:A12, A16:18 after insert).
yes, I noticed this one too.
Created attachment 67880 [details] proposed patch that seems to fix this problem
That patch appears to fix this. My own testing also indicates that it does not cause any other issues, but of course my testing is not as comprehensive as full QA testing.
Confirm problem ALTLinux + OOo 3.1.1 OOO310m19, build 9420
Adjusted target
This patch would break updating the note position when changing wow heights / column widths.
changing back issue type to defect
owner...
fixed in CWS OOO320/calc321stopper1 http://hg.services.openoffice.org/cws/calc321stopper1/changeset/885a4db773c3 The committed fix adds a new boolean parameter to various document, table, and drawing layer functions that specifies whether to update the cell position in note caption objects.
back to QA
Seen ok in cws, all comment are correct after reload.
ok in DEV300_m15, issue closing