iPad App for spreadsheets

August 7, 2011 1:16 PM

I need an iPad2 spreadsheet app with some specific requirements concerning conditional formatting:

• can open spreadsheets that I created on my MacBook (MacOS 10.6.8 at the moment), let me change some values of cells and save the changes so I can open the files on my MacBook again with formatting intact
• can do formulas with +, -, *, / and combinations thereof, maybe do a sum or similar simple things, but nothing fancy like sin, cos, log, ...
• allows for several tables in one document and references between them
• can do or at least keep intact conditional formatting, namely change the background color of a cell according to a rule or two, preferably even allowing these rules to include things like "If the value of this cell is equal to (or greater than) the value of this other cell, change the background color to green".

It seems like Numbers would do most of these things, but the iPad version strips a document of all conditional formatting, and Numbers can only handle simple conditional rules like "if the value of this cell is equal to 6", but not compare the value of a cell to that of another cell.

Currently I have the following programs available on my MacBook: an old version of Excel for Mac (am willing to upgrade), Numbers '08 (willing to upgrade), OpenOffice and LibreOffice (current versions). I need an app that can handle documents created by any of these and do the things mentioned above or a program that runs on my MacBook plus a compatible app for the iPad2. GoogleDocs is not an option because of data privacy protection.

Thanks for your help!

posted by amf to Computers & Internet (3 answers total)

Neither DocsToGo nor Quickoffice support conditional formatting, either.

Filemaker Go might? it's more of a database than a spreadsheet, but it works with excel files.
posted by empath at 1:44 PM on August 7, 2011

Response by poster: Thanks, empath, at least now I know what won't work... and I'll look into Filemaker Go, it hadn't even occured to me that a database would also be an option.
posted by amf at 1:41 PM on August 9, 2011

Response by poster: Has anyone tried Office² HD and knows if it works with Excel documents without deleting formulas or the like?
posted by amf at 1:22 PM on August 14, 2011