Copy&Paste after using autofilter does not work as expected in gnumeric

[leonidas]

Binary package hint: gnumeric

Create a table with some different data. Then use Autofilter to create a "slice" of the data. Make it so that the resulting slice is non-contiguous, i.e. the rows 1, 4, 7 are displayed. Then select some elements of this table, e.g. rows with the number 1 and 4. Then use copy, and paste everything to some other area of the spreadsheet. Then the rows 1, 2, 3, 4 will be pasted.
I consider this a bug, because what is the use of the autofilter if i cannot access the filtered data easily? Of course only the contents of row 1 and 4 should be inserted. This is also the behaviour of Excel and OO Calc.

[Jérôme Guelfucci (jerome-guelfucci-deactivatedaccount)]

Thank you for your bug report. It looks like I can't reproduce this:

I create a column of data with random positive and negative numbers, select this column and go to Data -> Filter -> Add an advanced filter (translated from french) : the filter appears on the top of the column.
I click on it, and select "Custom" and select "bigger than 0". When some data is selected with this filter, even if it's row 1,3,7, I can copy paste them correctly.

Are we speaking about the same filter ?

[leonidas (l-wallner)]

I think we are using different commands. I'm using the english gui, and i am using the following command:
Data->Filter->Add Auto Filter
In the Filter Sub-Menu there is also the option "Advanced Filter", I am not talking about this command.

And when you do the paste, then paste it into some area which is not affected by the filter command, e.g. in a row under the whole data. Otherwise the pasted content will appear correct, but if you de-activate the filter you will realise that all the data was pasted, it was just that the additional data was hidden in the rows hidden by the filter.

[Jérôme Guelfucci (jerome-guelfucci-deactivatedaccount)]

Ok, I got it, but I can't reproduce this. It works fine for me.

[leonidas (l-wallner)]

I am using gnumeric 1.7.8 (installed through synaptic). With which version did you make the tests? Would it help if i made some screenshots?

[Jérôme Guelfucci (jerome-guelfucci-deactivatedaccount)]

Funny, I tested first with 1.7.8 and could not reproduce it, and now with 1.7.11 I could... I'll report this upstream. Sorry for the trouble.

[Jérôme Guelfucci (jerome-guelfucci-deactivatedaccount)]

This had already been reported upstream: http://bugzilla.gnome.org/show_bug.cgi?id=149824

In the comments someone speaks about auto filter copy/paste.

[Charlie Kravetz (cjkgeek)]

https://bugzilla.gnome.org/show_bug.cgi?id=149824 has been marked a duplicate of https://bugzilla.gnome.org/show_bug.cgi?id=143220

[a7782457 (a7782457)]

This bug again

[a7782457 (a7782457)]

OK, after reading this https://bugzilla.gnome.org/show_bug.cgi?id=143220
I understand this is not bug but feature.