TABLE OF CONTENTS:


Q: Why another spreadsheet application?

Q: What improvements are planned for the future?

Q: Why should I upgrade to the 'Pro' version'?

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

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: 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
• scripted cell contents
• variable height rows and text spanning multiple cells
• OpenDocument spreadsheet import&export


Q: Why should I upgrade to the 'Pro' version'?

A:

Charts/Plots:
Without upgrading to ‘Pro’ you can only insert "bar charts".
If you upgrade to ‘Pro’ you can also use "pie charts", "line charts" and "scatter plots".
Functions/Formulae:
Without upgrading to ‘pro’ you can make arbitrarily complex formulae (in the standard Excel formula-language) but they can only contain the basic operators (*, /, +, -) and the basic functions SUM(), AVG(), MIN() and MAX().
If you upgrade to ‘Pro’ you can also use more than 100 other Excel compatible functions, see here ( https://www.corecode.io/tableedit/faq.html#FUNCTIONLIST ).

All other features in TableEdit are freely available without upgrading to ‘Pro’.


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: 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