What's New

New 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.

Bug fixes:
- 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.

Crash fixes:
- 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
Import/Export CSV
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
Formula Errors:
-#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.
Presentation Mode
Fast table panning/scrolling, proportional scrubbing/panning
Add Column (left/right) or Row (above/below)
Delete Column/Row

Planned, Upcoming Features:
==============================
Persistent script files
Graphs, Charts
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

Email Support:
support@getpermanent.com

App Changes