Info: Numbers Sorting Bug Remains in Version 10.2

Question

Level 7

30,426 points

Info: Numbers Sorting Bug Remains in Version 10.2

Numbers 10.2 did not fix the problem with sorting of tables that have formulas such as =COUNTIF(A$2:A4,A4) in a column. We use that kind of formula a lot here and this bug makes those tables unsortable. Table 1 in the screenshot is the original table. The "x" in "Ax" in the headers refers to a row number, like in the formula above. When sorted by column A in Table 1-1, the A$2 part of the range reference gets mangled, same as before. The lower rows came out correct but rows 2 and 3 are wrong.

Posted on Sep 23, 2020 6:46 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,550 points

Sep 23, 2020 8:39 AM in response to Badunit

Can duplicate here. Even when anchor to A$1 (Header Row instead of body row).

Only sort-safe approach I could think of is something like this:

=SUM(OFFSET(A$1,1,0,ROW()−1,1))

=COUNTIF(OFFSET(A$1,1,0,ROW()−1,1),A2)

SG

Reply

Answer 2

J_Beal

Level 1

27 points

Sep 26, 2020 8:49 AM in response to Badunit

So, how does an average Joe go about reporting bugs to Apple? I'm assuming the forum is not an official channel. (I'm trying to report a filtering issue that still exists.)

As an aside, it's not only when explicitly sorting. The use of the anchored first cell is an issue when sorting happens due to categories.

Reply

Answer 3

Badunit Author

Level 7

30,426 points

Sep 26, 2020 9:14 AM in response to J_Beal

In the Numbers menu, click on Provide Numbers Feedback. One of the choices is report a bug.

What is your filtering issue? I like to keep a folder of Numbers documents that display bugs/issues so I can test them out when an update comes out.

Reply

Answer 4

Badunit Author

Level 7

30,426 points

Sep 26, 2020 1:16 PM in response to J_Beal

I'm not so sure that is a bug. It is just how they handled adding rows when a filter is on. I'm not sure how I'd handle it differently but if you have a suggestion, let them (and us) know.

I don't use Excel very often but, from what I see there for comparison, Excel handles it by not having dynamic filtering. If you drag down to create a new row in Excel in a filtered sheet, that new row will display even when it does not match the filter. (It starts out being an exact copy of the row you dragged but, after editing, it may no longer match.) You have to mess with the filter again to filter the newly added rows. It seems like you have to recreate the quick filter each time but maybe I'm doing it wrong. This, to me is more difficult than in Numbers where you click the filter off, create the new row, edit it, then turn the filter back on. Or in Numbers where a checkbox on the sheet can make the extra rows show so you can edit one.

Reply

Answer 5

J_Beal

Level 1

27 points

Sep 26, 2020 11:03 AM in response to Badunit

Thanks.

Just to be complete (but not hijack this thread):

https://discussions.apple.com/thread/251840772?answerId=253533143022#253533143022

Reply

Info: Numbers Sorting Bug Remains in Version 10.2

Similar questions