GNOME Bugzilla – Bug 347536
Merged cells and comments
Last modified: 2006-07-17 21:44:35 UTC
Comments work on normal cells. Once you merge one or more cells, comments seem to vanish into thin air and new comments once added immediately disappear.
move your cursor on the little red triangle and you can still read the comment. Yu just can't edit it! There is really nothing critical about this bug.
Ok, my fault - I wasn't clear. For example; 1. Take 1 very complex spreadsheet with lots of merged cells and comments on those merged cells (in xls format) 2. Move the user to GNumeric, load the sheet, view the comments - all looks well. 3. Make some changes and re-save the sheet. 4. Quit 5. Open GNumeric the next day and find that all your comments have walked - completely. No more red corners on boxes ... a. I do accept that it's the "edit" facility that's broken b. My issue is that users who've tried to move have lost work with no warning If a bug means that a user cannot migrate from Excel to GNumeric (this is a bug, not a missing feature) , surely this is 'critical' ? That aside, given data is lost in the process described above (I've duplicated this behaviour with one merged cell, created in OO, saved as .xls, loaded in GNumeric, immediately saved and reloaded - comments gone) surely that classifies it as critical ?
Sorry I didn't understand the whole problem. As far as I understand now there are several issues: 1) Comments attached to merged cells cannot be edited and are not even visible in the comment-dialog. (I am pretty sure I found the cause for that and will be able to fix it as soon as the GNOME cvs->svn migration is finished.) 2) When merging cells, and undoing the merge, comments on the original cell appear to have migrated and are un-editable. 3) When unmerging cells the comment marker remains stationary (although the comment ought to stick with the top left cell.) 4) XL export does not save comments. This is indeed bug 53113 and should (?) have nothing to do with merged cells, but should happen for any cells. (Saving of cell comments to gnumeric and opendocument works.) You may want to go to that bug report and add your own comments. I note that that bug is currently indeed marked as an "enhancement" request and I agree with you that since gnumeric claims to support the xl file format that is an incorrect classification, even i fwe might disagree on the severity of that bug. I have nothing to do with XL files (and their import or export) so unfortuntely I can't help you with this aspect.
(1) is fixed in cvs head
(2) and (3) is fixed in cvs HEAD As mentioned above the remainder is a duplicate of 53113 *** This bug has been marked as a duplicate of 53113 ***