I'm running into this weird problem with Google spreadsheets: if the cells have comments on them and I sort the spreadsheet, the rows sort but the comments stay in the same position, and don't move with the cells they're attached to. In other words, the cells look like this:

A
C <-- comment on this cell
B

and then I sort by this column:

A
B <-- comment remains on this cell (stays in position)
C <-- comment should have remained attached to this cell

This means that sorting is completely broken and I can't use it at all, because I clearly need the cell comments to stay with the cell they're attached to. Is this a bad bug in Google Spreadsheets, or am I missing something here?

I can't reproduce the phenomenon you're describing. See file I've added and see for yourself. I've tried column sorting as well as the menu option: goo.gl/NWEJ1.
–
Jacob Jan TuinstraDec 2 '12 at 13:09

I have view access only, so I can't test it out. Can you share with Everyone. I should be more specific and add that I'm selecting a range of cells and choosing "Sort Range", not trying to sort by the whole column (because of the way the data are structured).
–
Joshua FrankDec 2 '12 at 13:32

Thanks for following up, but not really. I tried copying the data to a new sheet, but the comments didn't copy. And then, somewhere in the process, it deleted all the comments entirely. So I'm not too happy with Google Spreadsheets right now. The data in those comments wasn't mission critical, but it's still pretty annoying.
–
Joshua FrankDec 3 '12 at 4:13

1 Answer
1

This isn't really an answer, but, just to close the loop, during my various attempts to troubleshoot this problem, the spreadsheet just deleted all the comments, so that fixed my problem in one sense, I guess. I don't really have any idea what was causing the initial problem, or the data deletion. It's a fairly big spreadsheet, with multiple collaborators, so maybe it got corrupted. Boo, Google.