148Apps Review SummaryOur Rating: :: SPREADSHEET HEAVEN :: Read Our Full Review >>
Permanent sets out to change how spreadsheets are created on the iPad thanks to its intuitive interface and powerful features.
What's NewNew features:
- The most requested feature has arrived: Import/Export support for CSV and Excel XLSX files.
- Added "Target Mode". When enabled, tapping on a cell while editing will allow you to insert a cell reference instead of switching to editing a different cell.
- People didn't like the dots on the right side of the table. So the dots are now invisible by default, but you can still scrub a table by placing your finger on the right side where it was before.
- Scripting got a nice special keys bar (static for now) on top of the keyboard, for easier insertions of keys like ()+-= etc.
- Scripting View no longer has autocorrect enabled.
- Fix weird problems on the table after scrubbing
- No more directional lock on tables
- Editing a project actually changes the "Last edited ... ago" label and sorts the projects properly.
- All the keys on the custom numpad keyboard make the default iOS keyboard *tap* sound now, not just the numbers.
- Fixed the crashes from 1.0.1.
App Description**We are discounted to $9.99, a 50% reduction from our regular price of $19.99**
"Permanent makes spreadsheets glamorous to look at and pleasurable to use." -VentureBeat
As Seen On: 148Apps, AppStorm, BeautifulPixels, iPadFirst, ifun.de, MacTalk, TechWave.jp, VentureBeat, & HackerNews
Permanent is the best spreadsheet application for iPad. Create and edit spreadsheets. Write formulas. Run scripts. All on your iPad.
Permanent is fast. Permanent brings the power of columnar databases to the spreadsheet world. You don't have to change anything about how you use spreadsheets. Enter the data any way you want, as much of it as you want, and then ask questions you would've never been able to ask your old spreadsheet. The technology behind Permanent has been proven at the companies with the largest datasets and the toughest and most exacting latency requirements. Now you can use that same technology to run calculations on your spreadsheet.
Permanent is well-designed. The toolbar clearly indicates where you are in the app. The toolbar animations are easy to follow, and let you know what's going on. We have touch tooltips that explain what each button does. We try to design the buttons so that they are self-explanatory. File selection is familiar to those who use iOS. We've put a lot of care into the design.
Permament supports a wide range of spreadsheet formulas. Common spreadsheet operations and spreadsheet functions are supported. You can use math and string operations (+ - % * / ^ and &), formula comparison operations, and area operations (union, range, and intersect). 30 formula functions are supported (view list below or on our website), The function list will grow as the app is updated, soon to include all 300+ spreadsheet functions in common use.
Permanent includes a complete implementation of the Lua scripting language. To support editing Lua, Permanent includes a Lua IDE. Use Lua scripts to interact with your spreadsheet tables. Lua interacts seamlessly with Permanent's column-oriented format. You can update your spreadsheet tables as if they were Lua variables. Lua is the fastest and easiest scripting language available for spreadsheet applications.
The "Undo" feature in Permanent remembers what you did between sessions. Make a mistake the last time you were working, and you can still correct it the next time you open the app. Permanent has both a traditional "Undo" and "Redo" feature than you can use by tapping the left or right curved arrows. Also tap and hold on these (or swipe two fingers) to access your whole undo/redo timeline.
Current Feature List:
Import/Export Excel XLSX Files
Scripting using the full Lua language with Table interaction (via P[column#][row#])
Formulas: Use = in front of your formula
Formula Math & String Operations: + - % * / ^ &
Formula Comparison Operations
Formula Area Operations: union (,), range (:), intersect (␣)
Current Formula Functions (30, more coming):
-SUM COUNT MIN MAX AVERAGE NOT FALSE TRUE AND OR
-IF ABS SIGN SQRT LN LOG10 LOG EXP POWER PRODUCT
-PI RAND MOD EVEN ODD
-STDEV, STDEVP, CORREL, SLOPE, INTERCEPT
-#NULL! #DIV/0 #VALUE! #REF! etc.
Persistent Undo/Redo + Timeline with 2-finger swipes.
Create/Delete Project, Edit Project Details
Project Preview, Thumbnails of last active sheet
Filter by Favorites
Manage Sheets: Add, Delete, Switch.
Fast table panning/scrolling, proportional scrubbing/panning
Add Column (left/right) or Row (above/below)
Planned, Upcoming Features:
Persistent script files
Import/Export Permanent Files and ODF Files
Keyboard key bindings
Cell styling: background colors, widths, heights, etc.
Row/Column styling: width/height
Special column types: dates, etc.
Over 200 new Formula Functions
iCloud, Dropbox, G Drive, & SkyDrive Support
May 08, 2013 New version 1.2
March 30, 2013 Price Decrease: $9.99 -> $4.99
March 28, 2013 Price Decrease: $9.99 -> $4.99
March 27, 2013 New version 1.1
February 27, 2013 Initial Release