Ubuntu
gnumeric package

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

Bug #160966 reported by leonidas
2
Affects Status Importance Assigned to Milestone
Gnumeric
Expired
Wishlist
gnumeric (Ubuntu)
Triaged
Low
Unassigned

Bug Description

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.

Revision history for this message
Jérôme Guelfucci (jerome-guelfucci-deactivatedaccount) wrote :

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 ?

Changed in gnumeric:
importance: Undecided → Low
status: New → Incomplete
Revision history for this message
leonidas (l-wallner) wrote :

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.

Revision history for this message
Jérôme Guelfucci (jerome-guelfucci-deactivatedaccount) wrote :

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

Revision history for this message
leonidas (l-wallner) wrote :

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?

Revision history for this message
Jérôme Guelfucci (jerome-guelfucci-deactivatedaccount) wrote :

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.

Changed in gnumeric:
status: Incomplete → Triaged
Revision history for this message
Jérôme Guelfucci (jerome-guelfucci-deactivatedaccount) wrote :

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.

Bug Watch Updater (bug-watch-updater)
Changed in gnumeric:
status: Unknown → Confirmed
Bug Watch Updater (bug-watch-updater)
Changed in gnumeric:
status: Confirmed → Invalid
Revision history for this message
Charlie Kravetz (charlie-tca) wrote :

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

Changed in gnumeric:
status: Invalid → Unknown
Bug Watch Updater (bug-watch-updater)
Changed in gnumeric:
status: Unknown → Confirmed
Bug Watch Updater (bug-watch-updater)
Changed in gnumeric:
importance: Unknown → Wishlist
Revision history for this message
a7782457 (a7782457) wrote :

This bug again

Revision history for this message
a7782457 (a7782457) wrote :

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

Bug Watch Updater (bug-watch-updater)
Changed in gnumeric:
status: Confirmed → Expired
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.