Thanks for the replies. But the strict typing combined with lack of any way to denote empty or null values of a certain type makes it really, really unfriendly.
I was trying to total a range, or replicate a cascading running total down a column in sheet of content which was nicely formatted with white space between groups of entries. Therefore, if a formula derived from column data to the left is copied all the way down a column, there are going to end up being zero values. Shouldn't matter, and is easy to suppress zero display in er, uh, that other package claiming by its name to be excellent, but ...
So I'll omit the details of griping about number, time and date formatting, or the number of clicks and layers required, or the lack of tool bar buttons or a way to customize or add buttons and just say did they hire people from Microsoft to come over and do this product?
But eventually I just threw in the towel and let my column have lots of extraneous zero values, and spent an hour setting up a custom format that would suppress zeros, use parenthesized display for negatives, and keep two fixed decimal places. This is otherwise known as standard accounting format and has been around at least a couple centuries I know of, so I'm just a little bit surprised it's not a choice in Numbers.
Before everyone starts replying with all kinds of hints, yes I know all these things are there. But if you want them together you have to build your own, and it can take a long time so if your time is money (I'm a consultant who bills hourly and spends unbillable hours trading, so time is definitely money) then the cost of use is orders of magnitude more than any cost of software.
Maybe when I get it all set up and customized it will feel more effective. There's plenty to like and it's really been since Trapeze -- whoa, going on 15 years ago? -- since someone realized a spreadsheet is not equivalent to a page. But it's still rough around the edges and needs some serious tuning based on metering user actions. Also, clicks and display of resulting selections seem to deviate from Mac standards in frustrating ways. They're trying to give clicks in the same region different meanings depending on other context. I understand the desire, but it's a UI no-no.
Thanks again.
