Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

share|improve this question
    
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 Tuinstra Dec 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 Frank Dec 2 '12 at 13:32
    
Frank, it's yours !! –  Jacob Jan Tuinstra Dec 2 '12 at 13:37
    
Did you find the problem, causing the mayhem? –  Jacob Jan Tuinstra Dec 2 '12 at 17:39
    
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 Frank Dec 3 '12 at 4:13
show 2 more comments

1 Answer 1

up vote 1 down vote accepted

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.

share|improve this answer
    
Your answer will be moderated.....Let us know if we can help once more. –  Jacob Jan Tuinstra Dec 3 '12 at 6:48
    
Hi Frank, Was it a glitch in the matrix, or have you seen this problem again? –  Jacob Jan Tuinstra Jan 22 '13 at 19:42
    
I haven't seen it again, but I haven't really been using comments, because I don't want to lose my work again. –  Joshua Frank Jan 23 '13 at 1:19
    
Just happened / happens to me still. Ridiculous. How can I notify Google of this bug? –  grunwald2.0 Mar 28 '13 at 23:31
add comment

protected by Community Jan 24 '13 at 17:19

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.