Hello,

 I found a annoying bug. When i add or remove row from table (in excel 2007 SP3) and after use filter A/Z , Z/A few time for columns "ID", "Folder" with combination of collapse / expand rows , collapsed data become messed.
Note: Same problem in excel 2010.

Here i tried add rows line1, line2, line3 under last row (start at 21 row)

more details in video:

http://youtu.be/JdKM1n9jbfU

Mirror (without comments): 

dropbox.com/s/s9heit2sz3kzibt/Excel2007-2010_filter_collapse_BUG.avi

My excel bug test file:
(for some reason i cant post images ... :/ )
 www.dropbox.com/s/zercbgagxzktkiv/Excel-collapse-filter-BUG.xlsx

 www.dropbox.com/s/c3rnbo4gr81b2gt/Before.jpg 

 www.dropbox.com/s/gwx00ku76z07z8s/After.jpg

Hi,

I have watched the video, and reproduced what you do.

But I cant get your result.

As far as I know, sort policy

Column name

First key word

Second key word

Third key word

So I suppose that the file may have some compound sort policies.

I recommend that you can check the sort  (Date>sort)

Then you may try to create a new worksheet, and check the issue.

I hope its helps.

Hello,

I created also new worksheet, but same problem. This bug also happens if you use filter in skydrive excel preview.

Hi,

I watched your video again.

But I can't follow your steps.

And I have no earlier Office version to check the issue.

Regards,

Qian.