TABLE OF CONTENTS:


Q: Why another spreadsheet application?

Q: Whats the difference between TableEdit and TableEdit-Lite?

Q: Why was TableEdit changed from free to commercial?

Q: What improvements are planned for the future?

Q: How can i 'script' a cell with Python or VBA?

Q: How can you make text in a cell wrapped?

Q: Can I export to PDF?

Q: How can I change the width of columns?

Q: How can I move rows or columns?

Q: I bought TableEdit via Paddle - how can i recover my lost license key?

Q: How can I change the column headers or row numbers?

Q: How can I sort the table by a column?

Q: Which excel compatible functions are supported?


________________________________________________________________


Q: Why another spreadsheet application?

A:

There are no good Mac-native spreadsheets. Existing spreadsheets for Mac OS X take ages to launch and are complex, complicated and bloated. Online spreadsheets have awful usability and are not Mac-like or integrated into the Mac Desktop. Open source spreadsheets work great under Linux and even Windows but on the Mac they are barely usable, sluggish and look disgusting. TableEdit is a simple spreadsheet for the Mac that launches quickly and lets you get started right away.


Q: Whats the difference between TableEdit and TableEdit-Lite?

A:

TableEdit-Lite is the free version of the spreadsheet TableEdit. In contrast to TableEdit it does not have:
• cell content styling including fonts, font styles and sizes, font colors and text alignment
• cell background styling including fill-colors and borders
• cell formatting as currencies, date and time formats and different numbers formats like scientific or percentages
• support for charts & graphs (bar chart, line chart, etc)
• support for a world-class Excel-compatible formula & function system to calculate SUMs and much more
• support for alternating row colors
• support for table scaling & magnification

What does TableEdit-Lite have in common with TableEdit:
• An easy fast, intuitive & Mac-like spreadsheet system
• Support for 16 million rows or columns
• Support for sorting: single columns, parts of columns or the whole table
• Easy column reordering via drag & drop, row-reordering via menu-item
• Easy adding of rows & columns with the draggable plus-buttons
• Excel (.xls, .xlsx) import & export
• Configurable CSV/TSV import & export
• PDF export
• Printing support
• Support for Undo and Redo
• Support for going back to any previous saved version of any spreadsheet
• Inserting of rows & columns at arbritrary positions
• Support for drag & drop and copy & paste even from other spreadsheets
• Support for "filling" cells from neighbouring cells
• Support for inserting dates and times into cells
• Support for inserting configurable numbers into cells (ascending, descending, etc)
• Support for autosizing of column widths
• A common file-format with TableEdit, so you can edit TableEdit spreadsheets in TableEdit-Lite and vice versa


Q: Why was TableEdit changed from free to commercial?

A:

We've worked on TableEdit for more than 4 years, but the total amount of upgrades to the 'Pro' version covered less than 0.2% of our accumulated development costs. Since TableEdit did not generate any income, it was impossible to sustain doing free support and development to add commonly-requested features. There were basically two options, either abandan the project completely, or change to a commercial model where TableEdit costs money instead of being available for free. We felt that our users are better served by a product that costs money but is actively developed than by an abandoned project. We understand that some users will be unable or unwilling to buy TableEdit and so we are doing the following to help those users:
• The last largely free version of TableEdit (1.3.0) will remain available for download and free (but unsupported) use on the TableEdit-Lite homepage
• We are creating a new product 'TableEdit-Lite' that is completely free. It contains less features than TableEdit did previously, but will be actively supported going forward
• We are open-sourcing 'TableEdit Lite' completely as a gift to the Mac community so that more features can be added independently of us


Q: What improvements are planned for the future?

A:

Please let us know which features or improvements you'd like to see so we can prioritize future development. We have currently planned these major features:
• chart improvents including proper label support
• more cell border editing options
• multiple 'sheets' per document
• ability to search in spreadsheets
• variable height rows and text spanning multiple cells
• OpenDocument spreadsheet import&export


Q: How can i 'script' a cell with Python or VBA?

A:

TableEdit does not include support for 'VBA' but it allows a flexible extension mechanism via the 'Python' programming language.
Specifically you can add scripts to the '~/Library/Containers/com.corecode.TableEdit/Data/Library/Application Support/TableEdit/PythonFunctions/' folder and then use them like you would use any other function like SIN or DAY (if you are using the version bought from the homepage, substitute TableEdit for TableEdit-HP). The scripts should be named like this: NAMEOFFUNCTION_NUMBEROFARGUMENTS.py
For example, you can put a text file named 'PI_0.py' into the 'PythonFunctions' folder with a script like this: 'print "3.14159"'. Since the script has a 0 at the end of the filename, it doesn't take any arguments. You can now use it like any other Function, however with the "PY_" prefix. So, you can now enter '=PY_PI()' into a cell, and the cell will contain the first few digits of PI, coming from the python script. You can use the result from the Python script like you would use the result of any other function, e.g. put this into a cell to get PI * 2: '=PY_PI()*2'.
As an example script that takes arguments, put a file named 'PI_1.py' into the 'PythonFunctions' folder with this script: 'import sys ; print "3.141592653589793238462643383279502884"[0:int(sys.argv[1])+1]'. You can now enter e.g. '=PY_PI(9)' into any cell in any TableEdit spreadsheet to get the first 9 digits of PI.
Your scripts can be arbritrarily complex and e.g. do things like fetch stock market information, call WebAPIs, do advanced calculations or anything else you want.
Note that the result of Python scripts will always be cached, for performance. If you need your scripts to be re-run (e.g. to fetch more recent stock market information), just press F9 to re-calculate your table.


Q: How can you make text in a cell wrapped?

A:

To allow text to wrap we would first need a way to make some rows high enough to accomodate multiple lines of text. While columns can be changed in width arbritarily, changing the height of rows is not currently supported. This feature is scheduled (along with text wrapping) for version 2.0.
The only things currently helping with long texts could be this one or more of these:
0.) You can merge a cell with the horizontally adjacent cells to have the long text span multiple cells
1.) Just make the column wide enough for the long text
2.) Decrease font size to make the long text fit
3.) Cut up the long text and distribute it to the neighbouring cells by hand
4.) Select the cell with cut-off long text, the big 'main cell editor' in the toolbar should show more of the text
5.) Hoover the mouse over a cell with long text and a tooltip with the complete cell contents will appear


Q: Can I export to PDF?

A:

Of course: 1.) You can export to PDF from any app that supports printing by going to the print-panel and then select "Save as PDF" from the "PDF" drop-down button in the lower left corner. 2.) You can export to PDF by selecting "Export…" from the "File" menu and then selecting PDF instead of CSV or Excel. 3.) You can export individual 'Charts' by right clicking them and selecting "Save as PDF…"


Q: How can I change the width of columns?

A:

Like in any other Mac app that contains columns - just put your mouse on the vertical line in the header between the columns and once the mouse cursor changes to an double-arrow <-|-> just drag to the left or right to resize. You can also 'autosize' a column (so it fits the widest row entry) by double clicking on this vertical line. To 'autosize' multiple columns at once, use the 'Autosize column(s)' menu item from the 'Column' menu.


Q: How can I move rows or columns?

A:

You can move or re-order your columns like in any other Mac app by just using drag&drop on the column header.
You can move or re-order your rows by selecting the (consequitive) rows you want to move and then use the 'Move row…' menu item from the 'Row' menu.


Q: I bought TableEdit via Paddle - how can i recover my lost license key?

A:

There are two versions of TableEdit, the 'Mac App Store' version and the 'Paddle' version directly downloadable on our homepage. If you bought the 'Paddle' version you should have received an e-mail by 'Paddle' with your license key after purchase. If you did not get this e-mail or lost your license just send an e-mail to <help@paddle.com>. Paddle handle everything related to the purchase and activation of directly downloadable version of TableEdit.


Q: How can I change the column headers or row numbers?

A:

Just as in Excel or Numbers, columns are always titled A,B,C… and rows are always numbered orderly starting from 1,2,3….
If you want named column headers, just use any row below to insert your column titles and style them according to your wishes, see illustrating screenshot here.
Similarly, if you need specialized row numbers, just do then yourself e.g. in the first column.
You can use the insert numbers feature (Cell=>Insert=>Numbers) to quickly insert numbers into a column, see illustrating screenshot here.
One thing too keep in mind when using custom header rows is sorting. When you sort your table according to a column, the header row will also be sorted together with the data rows. So its best to select the rows that should be sorted (i.e. excluding the header row) and then use the 'Sort selected rows of column' feature to restrict sorting to the chosen rows.


Q: How can I sort the table by a column?

A:

You can sort columns as is usual just by double clicking on the column header.
Alternatively you can sort by using the ’sort' menu items from the 'column' menu or by right-clicking on the column-header.

In case you are using the first row(s) as a header you may not want these row(s) to be included in the sort process - in this case we recommend selecting only the rows to be sorted and then use the "sort selected rows" menu item (see previous question).

One other thing to consider is that sorting by one column, will also change all the data in the other columns, so that things that were in the same row previously will still be in the same row after sorting (as is usual in spreadsheets).
In case you want to sort just a single column without affecting the order in other columns you can use the "sort column without affecting others" menu item or just hold down shift while double clicking the column header.

Note that you can also right click on a clumn header to access a context menu containing options for sorting by this column.


Q: Which excel-compatible functions are supported?

A:

Currently these functions are implemented - if you need any else let us know so we can prioritize: AND AVERAGE CONCATENATE COUNT MAX MAXA MEDIAN MIN MINA OR PRODUCT SUM SUMPRODUCT XOR ABS ACOS ACOSH ACOT ACOTH ADDRESS ASIN ASINH ATAN ATAN2 ATANH BASE BITAND BITLSHIFT BITOR BITRSHIFT BITXOR CHAR CHOOSE CLEAN CODE COLUMN COS COSH COT COTH CSC CSCH DATE DAY DAYS DEGREES DIVIDE DOLLAR ERFC EXACT EXP FACT FACTDOUBLE FALSE FIND GAMMALN HLOOKUP HOUR IF ISBLANK ISEVEN ISFORMULA ISLOGICAL ISODD ISNUMBER ISTEXT ISNA ISERR ISERROR LEFT LEN LN LOG LOG10 LOOKUP LOWER MATCH MINUTE MOD MONTH NA NORMSDIST NOT NOW PI POWER PROPER QUOTIENT RADIANS RAND RANDBETWEEN RIGHT ROUND ROUNDUP ROUNDDOWN ROW SEC SECOND SECH SIGN SIN SINH SUMIF SQRT SQRTPI TAN TANH TIME TODAY TRIM TRUE TRUNC UNICHAR UNICODE UPPER VLOOKUP YEAR