2 Replies Latest reply: Oct 23, 2013 8:38 AM by Malcolm McIvor
Malcolm McIvor Level 1 Level 1 (0 points)

I have a spreadsheet for simple accounting where the entries are sorted by date, with the new numbers you can now sort by date and the formulas are all moved around correctly. However a 2nd table on the same sheet which references those cells in table 1 gets totally messed up and the formula cells on table 2 are no longer looking at the correct cells on table 1. Has anyone else come across this yet

OS X Mountain Lion (10.8.3)
  • Jerrold Green1 Level 7 Level 7 (29,955 points)



    You have surfaced the first substantive operational change - that is change in the mechanics behind the curtain - that I have heard about.


    This would probably be to address the numerous complaints that Numbers used to sort differently than Excel. Numbers now continues to point at the same cell location, not the same data, after a sort as it did before the sort, in cross table references.


    Lots of folks will be happy that their Excel imports will work better.


    I've said this all without seeing your particular problem. If you post a screen shot and a description of what is happening and what you would rather see happen, I'll help you to straighten it out.



  • Malcolm McIvor Level 1 Level 1 (0 points)

    Thanks for your reply Jerrold.  As you said previous version of numbers never did sort what I would call proplerly. When you sorted by date you then had to grab the formula at the top of the spreadsheet and drag it down so that it filled in the cells correctly and the calculations were correct after the sort.


    That said other tables on the same sheet would keep to the correct cells on table 1 after it was sorted.


    Following the new update I sorted on date and hey, the calculations were all good without any further work, however the calcuations on the other tables on the same sheet were all over the place.


    It seems as though the sorting problem has been moved from one table to the other !


    Even if table 1 is sorted table 2 should still reference the cells before the sort and not emtpy cells or cells with the wrong data,


    I have put together a simplified version of my spreadsheet


    Cell reference problem.jpg

    My last entry in table 1 is for Oct 3rd, when I sort the table the balance is correct now without further work, but the total in table 2 changes to reflect the new sorted numbers on table 1. Before the upgrade Table 2 would still give £ 45 by sticking with the cells regardless of there new position, but now it will give whatever is in the first 3 cells rather than what it was referencing before the change.


    I hope I have explained my problem ok


    Thank you