Deleting rows in a filtered table -- Is this a Bug or a Feature

I've noticed Numbers behaves differently if you delete rows in a filtered table by


a) selecting multiple rows one-at-a-time (i.e., click on one row, then on another row, then another, and so forth, all while holding down the <<command>> key).


VERSUS


b) doing a multi-row selection operation (i.e., by clicking on one row, holding the <<shift>> key and clicking on another that is many rows away).


The differences in behavior are apparent when you turn off the filter. In case (a), only the individually selected rows will have been deleted. In case (b), rows not visible in the filtered table will be deleted along with those selected by the multi-row selection operation. The latter seems like a bug to me. Both (a) and (b) should have the same effect.


What am I missing here?


Dave


MacBook Pro 15″, macOS 10.15

Posted on May 20, 2023 01:59 PM

Reply
Question marked as Top-ranking reply

Posted on May 20, 2023 05:47 PM

Hi David,


You wrote: "The notion of being able to delete rows one can't see seems ... well ... wrong."


Perhaps, but it can also be seen as a consistent result for each of two features:

  1. the selection behaviour of including the command key when clicking to select and
  2. the selection behaviour of including the shift key when clicking to select


Examples:


With all rows of a table visible, here is the result of clicking the row reference tab for row 2, then pressing command and clicking the tabs for rows 4, 6, 8 and 10:


Each click adds the clicked row to the selection.


Using the same table (after deselecting all rows)…


With all rows of the table visible, here is the result of clicking the row reference tab for row 2, then pressing shift and clicking the tab for row 10:



shift tells Numbers to expand the selection to include all rows from the one originally selected to (and including) the one clicked with shift.


The behaviour is consistent whether or not some rows of the table are hidden.


Regards,

Barry

Similar questions

5 replies
Question marked as Top-ranking reply

May 20, 2023 05:47 PM in response to David Powsner

Hi David,


You wrote: "The notion of being able to delete rows one can't see seems ... well ... wrong."


Perhaps, but it can also be seen as a consistent result for each of two features:

  1. the selection behaviour of including the command key when clicking to select and
  2. the selection behaviour of including the shift key when clicking to select


Examples:


With all rows of a table visible, here is the result of clicking the row reference tab for row 2, then pressing command and clicking the tabs for rows 4, 6, 8 and 10:


Each click adds the clicked row to the selection.


Using the same table (after deselecting all rows)…


With all rows of the table visible, here is the result of clicking the row reference tab for row 2, then pressing shift and clicking the tab for row 10:



shift tells Numbers to expand the selection to include all rows from the one originally selected to (and including) the one clicked with shift.


The behaviour is consistent whether or not some rows of the table are hidden.


Regards,

Barry

May 20, 2023 02:25 PM in response to David Powsner

Not a bug, just how it works. If you look at the selection boxes when you command click you will see they are not connected if they span a hidden row. With shift click it makes one selection box that includes all the rows in the middle.


I would rather it worked like you want it to or, better yet, if there was a third method (Command Shift Click?) to select a range of rows while excluding the hidden ones. You can use Numbers->Provide Numbers Feedback to make this suggestion to the iWork team.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Deleting rows in a filtered table -- Is this a Bug or a Feature

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.