[bastion]

Working on a 2x1.8GHz G5, one of my files that was working quite well in AppleWorks consists of about 6000 rows and 8 columns. The last two columns are formulas that aren't especially tricky but do contain a couple of nested IF()s. It takes many seconds to complete a paste into one of the cells in this file. Even after I dropped the more complex of the two calculation columns...I just tested and it took more than 15 seconds for a simple text paste. I've got other tables (each in their ow file) with the same structure but smaller numbers of rows, and there's a definite correlation between the responsiveness and the total number of rows. Even tabbing through cells without editing has a lag.
Just for fun, I've deleted the second calculation... Now I've got 6049 rows by six columns, with nothing but data. No formulas or conditional formatting. And spell checking is disabled. ... and it took less than 1.5 seconds for a paste to complete.
I think I would gladly give Numbers more RAM for them to cache a set of reference information so they can look up what cells are impacted when a given cell changes. I suspect the source of the lag is that they're visiting every formula in the sheet whenever any cell changes.

[Charles_Martel]

I can live without macro or scripting support, but lack of pivot tables is a show stopper for me. /forums/ubbthreads/images/graemlins/frown.gif

[KeithSWilson]

Quote:

---

BUT I think ten pages should have been written on the lack of AppleScript support.

---

Why only 10 pages - as a Cocoa developer I would like to throw the whole damn book at them for the lack of AppleScript support in Numbers.
I develop database applications using Core Data. There are some functions and reports that are best done in a spreadsheet. Sure, I can write code within my own Cocoa application but for certain functions it is far better to simply export the required data to a spreadsheet and let the user do his/her own thing with it - I have no intention of allowing the user to reimport the changed data - it is a one way export.
I was really hoping to be able to use Applescript to set up the Numbers spreadsheet the way I want it so that I know that the user is starting with something that is properly defined. I only really need to be able to define and select the default template that my data is being exported to. Until Numbers can provide me with AppleScriptabily for these simple setup functions then .... I may have to consider the alternative application that other crowd from Seattle.
My apps already interface with iPhoto and iCal - why not iNumbers as well?
Keith

[chrisl]

I disagree with your column. Until this last school year, I had never used a spreadsheet. My co-workers use only Excel. One of our jobs is data analysis and visualization. They took hours to create graphs, often imploring my help. In helping them I found Excel unwieldy and overly complex. Once I started using spreadsheets, I initially started with Excel, moved to OpenOffice and now use Numbers. While numbers has the mark of a version 1.0 software, it is much easier to use than Excel. Your review is from the perspective of a long-time Excel user. Saying Numbers is not as efficient because it is not what you are used to does not make sense. Especially since I consider some of the "missing features" you talk about as a positive.
Chris--