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?