Office 2007 SP1 goes automatic for the people

@ No Thanks

Actually, the enhancement to allow >65536 rows is useful for business processes.

We use spreadsheets to migrate customer data from their old finance system when they purchase the software we write - if you saw the accounts of most mid to large companies, the number of transactions is not an insignificant amount - being able to migrate the data in one go, rather than having to subset the information into lots of smaller imports will be a time saver for us and will remove the risk of accidentally migrating the same transaction twice.

In fact we have also recently had a modification enhancement request from one of our customers to develop our application to use the new xlsx format as the amount of data they wish to export from their software is now exceeding the row limit of the xls format. This information is not physically read/processed by the user, but is often used to integrate data between multiple software packages by extracting from one package and importing into the other.

Don't insinuate all "punters" are idiots because we need or want the scope of our software increased - there are people out there doing much more complex tasks with spreadsheets than just compiling their ratings of their favourite pr0n sites.

@ 65536 rows

Migrating databases isn't the only reason for wanting more than 65536 rows.

I once spent a summer investigating the use of compressed air at a big industrial plant. As part of that, I used huge amounts of data from a datalogging system to determine the overall use of the air and monitor it over time.

65536 rows is only 45 days of data at 1-minute intervals.

I ended up having to do a lot of number-crunching across multiple sheets and workbooks to condense the data down to amounts that Excel could handle.

(And yes - Round-Robin tool would have been better. But I didn't have access to that then)

No Office

People aren't avoiding Office 2007 because it's buggy -- I hadn't even heard about that. People are avoiding it because:

a) Office <something older> is good enough.

b) Already have OpenOffice. Why spend $$$ for something else?

c) Ideologically opposed to OOXML and/or Microsoft.

d) That crap non-menu bar. Microsoft and fans' response is generally along the lines of "Oh you're stupid", "You have to learn how to use it", "It's the wave of the future get used to it". Well, having little nearly-identical-looking blobs (a.k.a. icons) instead of text doesn't do it for me, and I know many like me. If Microsoft's Office team doesn't wish to accomodate people like me, then fine, I won't use Office.

e) No Linux version. I wonder how many people Microsoft *assumes* are running Windows (due to sales figures from all those preloaded PCs) really aren't. They're NEVER going to get Office 2007 since it's not available for them.

For me, it's mostly b, d, and e. But c applies too -- I don't like Microsoft's behavior and avoid sending them money when possible.