TableEdit
v1.4.8
Description:
TableEdit is a simple, clean & elegant spreadsheet application designed specifically for the Mac. TableEdit features a minimalistic yet intuitive interface and has convenient features like formulae, charts and exhaustive cell styling options as well as comprehensive import & export options.
MAC-NATIVE UI: TableEdit has been designed from the ground up to be a simple, fast and convenient spreadsheet. Unlike cross-platform competitors we natively support Mac technologies like autosave, document versioning, iCloud and many more. Navigating and selecting works just as expected in any real Mac-app, with keyboard shortcuts and modifier keys having their usual effect. The defining element of the interface is the toolbar which gives access to the most commonly used options as well as the 'main cell editor'. The main cell editor always displays cell contents unmodified by formatting options or formulae results. The main cell editor also provides easy access for inserting common functions like SUM.
TABLE OPTIONS: Your configurable table options allow you to resize the table and enable a 'floating header row' so that you don't lose track of titles when scrolling down. Configurable row-heights allow multiple lines of text in a cell. Furthermore there is support for scaling the whole table or defining alternating row background colors on a global or per-spreadsheet basis.
CELL STYLING: You can easily select background colors for your cells and define cell border options with varying thickness, placement and color. There are also exhaustive text setting including color, font and alignment.
CELL FORMATTING: TableEdit has many options for controlling how cell content should be displayed in the table. You can opt for customizable date and time formats. Even more options are available for number display - you can control the number of digits, separator, choose scientific or currency display. Or you can go all the way and use the freeform "custom" representation for numbers.
FUNCTIONS / FORMULAE: Our world-class Excel-compatible formula implementation has been tested on over a million formulae and works with the most complex imaginable formulae. In the formula-system there is support for more than hundred of the most-used Excel functions. In many cases you can just import a Excel file and the formulae will carry over and work as expected. Also you can write Python scripts to define custom functions that can do anything you want.
CHARTS / GRAPHS: TableEdit supports different charts and graphs to visualize your data. You can currently select from pie-charts, bar-charts and line-graphs and define colors, styles and various options. You can move charts freely around your document and export them directly to PDF.
IMPORT & EXPORT: You can either import CSV and Excel files quickly via drag&drop or use the Import-panel to select more options like the separator or encoding. Exporting to Excel (classic or XML) is also just a mouse click away.
System Requirements:
• macOS 10.13 'High Sierra' or later
License & Cost:
TableEdit is completely free of charge & supported by showing info about our other apps.
Contact & Support:
The product website is located here: https://www.corecode.io/tableedit/
Technical support for TableEdit is no longer available.
Usage:
0.) Download TableEdit from the "Mac App Store" or from its homepage and once it has finished downloading start it from Launchpad or your Applications folder.
1.) A new spreadsheet will be opened where you can enter your data. Click on a cell to enter data directly into the cell. You can also edit cells from the big textfield in the middle of the toolbar. This "main editor" always shows the 'real' without any formatting or formulae applied. You can move between cells to edit with the mouse or the arrow-keys.
2.) You can increase the number of rows and columns in your spreadsheet by clicking on the 'Table' toolbar item to the upper left or by using the '+'-buttons embedded in the table.
3.) You can change the formatting, font or background of selected cells by selecting some cells and then clicking on the relevant toolbar buttons to the upper right.
FUNCTIONS / FORMULAE:
Inserting and editing of functions may work different in TableEdit than you are used to, so read along to avoid frustration:
IMPORTANT NOTE: TableEdit does not support selecting some cells while editing a formula to have the names of those cells inserted into the formula. You have to write the cell name(s) yourself or use the convenience methods for function-creation listed below.
Basic Functions: To insert a simple function (sum/min/max/avg) of some numbers, just select all the cells of which you want to calculate the sum/etc and then use drag&drop to drag the function from the "main editor" (center field in the toolbar) into the cell where you want the result to be.
Other Functions: To insert another formula which is not one of these 4 basic functions, also select the cells of which you want to calculate the function and then click on the 'Function' toolbar button. Find your function in the list and drag it into the cell where you want the result to be. Note that most functions require multiple arguments, so you may have to edit the inserted function to see the desired result.
Complex Formulae: To insert a complex formula, you are best off just writing it 'by hand' by starting a cell content with '=' to signify the formula and then entering a syntactically correct excel-formula. Note that you can select 'Functions Reference' from the 'Window'-menu to see a list of excel-functions and their arguments.
CHARTS / GRAPHS:
To insert a basic bar-chart, first select all the cells of which chart should be generated and then drag the 'chart' button from the "main editor" (center field in the toolbar) to the location where the chart should be placed. To generate a chart of a different type use the 'Chart' toolbar item or just change the chart type of the bar chart afterwards.
You can edit a chart by double clicking it or selecting 'Edit…' from its menu.
To bring up the menu of a chart, right-click it or click in its upper-left corner.
To delete a chart, just select 'Delete' from its menu or edit-window.
Note that any chart can be exported to an editable PDF with 'layers' by selecting 'Save as PDF…' from its menu
'HIDDEN' FUNCTIONALITY:
Some of the functionality of TableEdit may not be directly obvious:
The '+'-buttons embedded in the spreadsheet to add rows/columns can also be dragged to add many at once.
Importing CSV files by drag & drop guesses the 'separator' and 'encoding', while using the 'import' menu item offers control.
Importing files by drag & drop uses the 'padding' that has last been selected in the 'import' menu item window.
Pressing 'F4' will convert the formula cell-reference type of selected cells between absolute&relative, like Excel.
Pressing 'F9' will "re-calculate" the whole table and all formulae, like Excel.
Pressing 'Alt/Option' shows all cells that have formulae and all cells that are 'dependencies' to formulae-cells in special colors.
The Command-Arrow shortcuts jump the cell selection to the table edges.
Holding down 'Alt/Option' while adding adding formulae or charts, makes them use absolute cell references.
Holding down 'Alt/Option' during the import of excel documents makes TableEdit import the first 'sheet' instead of asking for the sheet to import.
Holding down 'Alt/Option' while adding a row/column via menu or '+'-button, removes one instead.
Holding down 'Shift' or 'command' has its usual meaning to extend the selection, e.g. when clicking cells or a column/row header, or when using the arrow keys.
Holding down 'Shift' while pressing enter moves the selection up instead of down.
TableEdit will not import CSV files that use single quotes (') for escaping as they don't confirm to the standard. If you have any of those files, replace these quotes with proper double quotes (").
Privacy Policy:
CoreCode believes strongly in privacy rights and therefore does not collect any data from its customers.
Please view our current privacy policy here: https://www.corecode.io/privacy_policy.html