11 Replies Latest reply: Jun 10, 2011 12:36 AM by KOENIG Yvan
Luiz Siqueira Neto Level 1 Level 1 (0 points)

I have a finance spreadsheet with a no so large number of calculated cells and unfortunately iWork Numbers becomes very slow when editing. I would like to know if is possible use a work around for this issue, is it possible disable auto calculation or maybe exist a technique for this kind of problem?

 

Thanks.


New iMac 20, Mac OS X (10.5.6)
  • 1. Re: Performance issue
    Level 8 Level 8 (41,760 points)

    Question asked and answered several times.

     

    There is no way to disable auto calculation.

     

    Numbers is a snail.

     

    The designers built it so that it recalculate the entire active sheet for every change.

    The AppleWorks designers, facing not so powerful processors and short RAM available were able to restrict the recalculation to the displayed area. Seems to be too complicated for youngsters.

     

    There is an efficient tip, at least when we use AppleScript to drive the app. I never made serious tests when editing by hand.

    Put the tables in which we insert datas in a sheet different than the one displaying the results.

     

    Other useful tip :

    Don't use header columns. They are highly efficient slowdowners.

     

    Yvan KOENIG (VALLAURIS, France) 12 mai 2011 14:50:47

  • 2. Re: Performance issue
    Luiz Siqueira Neto Level 1 Level 1 (0 points)

    I agree with you, I don't understand why today applications are so slow, it don't make sense, maybe the idea is sell new computers, who knows?

    This is a shame, for me iWork Numbers is really more easy to use than Excel, works fine with Magic Mouse and is revolutionary in spreadsheet world, for the first time tables are free to be placed in any place and used directly.

    I hope Apple solve this problem soon as possible because this problem can kill the application.

  • 3. Re: Performance issue
    Level 8 Level 8 (41,760 points)

    _Go to "Provide Numbers Feedback" in the "Numbers" menu_, describe what you wish.

    Then, cross your fingers, and wait _at least_ for iWork'11 ;-)

     

    Here we are just end users so we can't change the app's behavior.

     

    It's really boring to see that today's programmers rely upon the power of the modern microprocessor and fail to make basic optimization.

     

    When I run Numbers, I take care to never press cmd + F because I became fool when I see the way it behave.

    I click the Find/Replace button so, I may enter the string to search in good conditions.

     

    To store my bank transactions, I continue to use my old AppleWorks spreadsheet even if the Numbers version is ready. I hope that we will have a more efficient app when 10.7 will be delivered.

     

    Yvan KOENIG (VALLAURIS, France) 12 mai 2011 18:40:20

  • 4. Re: Performance issue
    Luiz Siqueira Neto Level 1 Level 1 (0 points)

    How you use AppleWorks today, do you have a old Mac or use some emulator?

     

    Thanks again.

  • 5. Re: Performance issue
    Level 8 Level 8 (41,760 points)

    AppleWorks behave flawlessly on modern machines.

     

    AppleWorks 6.2.9,

    mac OS X 10.6.7

    Rosetta installed.

     

    Yvan KOENIG (VALLAURIS, France) 12 mai 2011 18:54:24

  • 6. Re: Performance issue
    Luiz Siqueira Neto Level 1 Level 1 (0 points)

    Thanks again and I made my homework sending feedback to Apple about this issue like you suggested.

  • 7. Re: Performance issue
    Luiz Siqueira Neto Level 1 Level 1 (0 points)

    I forgot that I have AppleWorks, I will try it again.

  • 8. Re: Performance issue
    Luiz Siqueira Neto Level 1 Level 1 (0 points)

    Now I remember why I stopped to use AppleWorks 6, in my Mac it becomes very instable I don't know why.

    Back in the days of Mac OS Classic I used it a lot, love it.

    If you know some source or solution for the AppleWorks 6 instability I will love hear.

     

    Thanks.

  • 9. Re: Performance issue
    Level 8 Level 8 (41,760 points)

    I have no idea about that. Here it never surfaced.

     

    Yvan KOENIG (VALLAURIS, France) 13 mai 2011 09:52:36

  • 10. Re: Performance issue
    pbekkerus Level 1 Level 1 (55 points)

    Thanks, Yvan, for this great tip about putting the entry tables on a different sheet than the results of the calculation!  I was looking at some older, archived posts and then discovered this by switching around some tables.  I wasn't sure if that was the variable until I found this post.  It definitely helps a lot with my speed!

     

    You've helped me so many times (all the way back to AW days), I thank you!

  • 11. Re: Performance issue
    Level 8 Level 8 (41,760 points)

    Thanks for the feedback.

     

    As you perhaps saw, I (quite) no longer respond in AppleWorks forum.

    I don't understand that users start using such a product in year 2011.

    They are playing with matches.

    Of course, continuing to use it when we are working with it for many years is an other thing.

    But I guess that old users know the way to use the beast.

     

    Yvan KOENIG (VALLAURIS, France) vendredi 10 juin 2011 09:36:24

    iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.7


    Please : Search for questions similar to your own before submitting them to the community

     

    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !