TableEdit History:
1.4.8 (Sep 2022):
• Resolved compatibility problem with macOS 13 'Ventura'
• Fixed problem related to formulae where TableEdit could freeze
1.4.7 (25 Feb 2021):
• TableEdit is now free and supported by showing our other apps
• Improved import of Dates from Excel .xslx files
• Improvements for CSV import
1.4.6 (25 Jan 2020):
• Fixed problem with Excel import and export
• Added 'notarization' for improved security and easier launching on macOS 10.15
1.4.5 (04 Dec 2019):
• Fix issue with TableEdit randomly freezing on macOS 10.14 and macOS 10.15
• Fix issue with updating of formulae when sorting the table
• Improved import of Excel .XLS and XLSX files
• Improved parsing of Excel functions / formulae
• Implemented DATEVALUE function
• Fixed problem where dates without slashes could still be interpreted as American format
1.4.3 (22 Oct 2019):
• IMPORTANT: The minimum system requirements have been raised to macOS 10.13
• Add support for 'Dark Mode' on macOS 10.14 'Mojave'
• Add new keyboard shortcuts Command-Arrow to jump the selection to the edges
• Fixed problems with importing CSV some files that contain single quotes
• Fixed problems where sorting descending or single columns would not work correctly
• Fixed problems where sorting would not properly update formulae cell references
• Fixed problems where sorting would not sort according to formula results
1.4.2 (17 Oct 2018):
• Fix issue with 'floating header row' being transparent on macOS 'Mojave' 10.14
• Fix problems with entering text in multi-byte languages like Arabic, Chinese and many more
1.4.1 (09 Jul 2018):
• Redesigned preferences window with more explanations
• Allow configurability of wrapping mode for multi-line cell text
• Added default row-color settings to preferences window
• Dramatically increased performance when opening spreadsheets with many rows
• Dramatically increased performance when importing large CSV files
• Increased compatibility and standard compliance of CSV-export
1.4.0 (23 Apr 2018):
• Add option to make first row a 'floating header row' that stays visible when scrolling
• Add option to change row height including support for multi-line cell contents
• Function keys like 'Page Up/Down', 'Home' and 'End' now work correctly
• Fix re-ordering columns with multi-character column names via drag&drop
• Fixed chart positioning on macOS 10.13 and 10.12 which was broken since version 1.3.0
• Fixed automatic update check
1.3.5 (03 Apr 2018):
• IMPORTANT: TableEdit now costs 9.99$ so that we can continue developing it
• IMPORTANT: 'TableEdit-Lite' continues to be free and is available here
• Added option to use 'Python' scripts to calculate cell contents, see FAQ
• Pressing 'F9' now "re-calculates" the whole table and all formulae, just like Excel
• Add option to export the whole spreadsheet to a PDF
• Add FAQ entries on how to export to PDF, on how to change column widths and on moving rows up or down
• Fixed parenthesis getting dropped from forumlae when pasting them to other cells
• Fixed parenthesis getting dropped from forumlae when adding, removing or moving rows or columns
1.3.0 (01 Feb 2018):
• IMPORTANT: The minimum system requirements have been raised to macOS 10.10
• Fixed possible crashes on macOS 10.10
• Added 'Formatted Copy' option to copy formatted values with calculated formula results
• Exported documents now default to the document name instead of 'Untitled'
• The 'fill-down' feature can now be used to get column names into the first row
• The 'fill-right' feature can now be used to get row numbers into the first column
• Fixed plus row/colmns button not adding rows when clicked
• Fixed problems related to the 'Crash Reporter'
• Fixed problems related to the 'Functions Reference'
• Fixed problems where cell-borders could be mistakenly added
• Fixed main cell editor to show both rows for longer text
• Fixed selection-knobs being incorrectly postitioned after column resize
• Disallow removing all rows within a document as this can cause problems
• Clarified naming of cell-border options to match what they are doing
1.2.9 (24 Jul 2017):
• Fixed crash when setting backgroundcolor after closing documents
• Fixed problems when restoring the upgrade to 'Pro' in the MacAppStore version
• Fixed update-check interval selection in the Homepage version
1.2.8 (4 Jun 2017):
• Fix for expired excel import/export support
1.2.7 (21 May 2017):
• Increased stability when typing formulae with multi-argument functions
• Implement option to sort a column without affecting other columns
• Improved implementation of VLOOKUP and HLOOKUP functions
• Fixed possible problem with in-app purchases
1.2.6 (11 May 2017):
• Fix crashes when disabling or modifying toolbar
• Improved stability on Mac OS X versions 10.9 & 10.10
• Improved implementations of the DAYS, LEFT & RIGHT functions
• Improved compatibility with Excel XLS files
1.2.5 (20 Feb 2017):
• 'Merge cells' feature now allows for text to spawn multiple columns
• Enable sorting of columns by right-clicking on their headers
• Sorting by a column now always places empty rows at the bottom
• Fix possible crashes with the COLUMN and ROW functions
• Improve the ISNUMBER function
• Fix display problem after resizing in fullscreen-mode
• Improved debug information in case of problems
1.2.3 (21 Dec 2016):
• Print settings like margins and pagination are saved now
• Added option to fill the selected cells with incrementing numbers
• Fixed problem where applying styles to a cell could also alter other cells
1.2.2 (5 Dec 2016):
• Fixed inability to purchase upgrade to 'Pro' in the MacAppStore version
• Fixed problem where the toolbar settings would not be saved
• Disabled removing the last row or column which can lead to problems
• Improved debug information in case of problems
1.2.1 (25 Nov 2016):
• Implemented excel-compatible 'Fill Down/Right/etc' functions
• Fixed crashes when removing rows/columns containing formulae
• Fixed crash related to deselecting a cell with cmd-click
• Fixed crash on setting font color to grayscale color
• Fixed problems adding or moving rows/columns while editing a cell
• Make sure exceptions cause an alert and won't freeze the app
• Improved debug information in case of problems
1.2.0 (17 Nov 2016):
• IMPORTANT: Advanced charts&formulae are now an in-app purchase to fund development
• IMPORTANT: rewritten support for charts with many bug-fixes & improvements including:
– Support for 'scatter plots'
– Charts can have configurable titles now
– Charts can now be printed
– Implemented many more configuration options
– Fixed X-axis labelling of line-charts to be visible
– Fixed stability and visual problems related to charts
• Added options to insert current date/time into the current cell
• Improved printing support by adding user-definable margins and positioning
• Improved launch performance
• Fixed problem using undo while still editing a cell
• Fixed calculation of formulae containing references to empty cells
• Fixed tab-separated value file import that was broken since version 1.1
• Fixed possible data-loss when quitting while editing a cell
• Fixed paste going to top-left cell when nothing is selected
1.1.0 (14 Sep 2016):
• IMPORTANT: Properly offset all formulas when moving/inserting/deleting columns/rows
• Add option to display a number (representing e.g. seconds) as a formatted time
• Automatically support both ';' and ',' separators in formulae
• 'F4' will convert the formula cell-reference type of selected cells between absolute&relative.
• Add 'Tutorial Videos' showing e.g. how to insert formulae in TableEdit
• Add 'Padding cells' import setting from Import-panel also to the preferences
• Improve display of path of files in recent document list
• Two double quotes in formulae behave like in Excel now
• Show '-' instead of '+' buttons when holding 'alt' to indicate functionality
• Allow direct import of tab-separated value files TXT extension for Excel-compatibility
• Allow exporting tab-separated value files with TSV, TAB and TXT extensions
• Allow exporting XLSX-files with .XLSM extension
• Fix bugs preventing offsetting of formulae when copy & pasting them
• Fix crash related to the 'Revert' feature
• Fix crash with some invalid formulae
• Fix mislabeling of columns after deleting column(s)
• Fix cut/copy/paste menu-items not looking enabled
• Fix possible problem when entering incorrect cell ranges
• Fix menu-button on graphs being broken since v1.0.4
• Fix problem with plus row/column buttons under macOS 10.12 'Sierra'
• Fix problem with charts under macOS 10.12 'Sierra'
• Fix problem selecting delimiter for CSV-export
• Fix problem when importing tab-separated value files with empty cells
• Fix plus-column button overlapping with last column resize area
1.0.5 (7 Jun 2016):
• Fix crash when opening the function-popup
1.0.4 (3 Jun 2016):
• Implemented Cut (Command-X) for cells
• Implemented DIVIDE, ROUND, ROUNDUP, ROUNDDOWN & TRUNC functions
• Improved performance
• Fixed possible crashes with functions dividing by zero
• Fixed dragging of selection knobs not working since beta35
• Fixed COUNT function
• Fixed problem with Dates (also related to functions)
1.0.3 (6 May 2016):
• Fix alternate function-spellings (AVG / AVERAGE) stopping to work
• Enable moving cursor inside a cell with arrow-keys
1.0.2 (5 May 2016):
• IMPORTANT: fixed import &t; export options not appearing
• Implemented references to empty cells in formulae
1.0.1 (1 May 2016):
• Improved stability, performance and memory-usage
• Improved excel-import and formula support
• Implemented NORMSDIST, NA, ISNUMBER, ISTEXT, ISNA & ISERR(OR) functions
• Fixed memory leaks on documents with formulae
1.0 (19 Apr 2016):
• First stable release
• Implemented SUMPRODUCT function
• Improved formula support (array arguments, reliability)
• Improved excel-import
• Fixed problem with functions-reference opening browser windows
• Fixed possible misplacement of welcome-window
• Fixed option to choose update interval not showing
1.0 beta 35 (15 Apr 2016):
• LAST BETA VERSION: please test thoroughly and send feedback
• GRAPHS & CHARTS:
– Line charts!
– Added different coloring options to charts
– Fixed charts positioning and scrolling with table
– Fixed crash related to 'reverting' and charts
– Saved charts should now appear after opening a document
• Removed 'beta' warnigns in preparation of 1.0 release
• Extended ReadMe and documented non-obvious features
• Implemented DOLLAR function
1.0 beta 32 (25 Mar 2016):
• Many fixes for functions and formulae
• Implemented 'union ranges' in formulae
• Various fixes for excel import
• Fixed issues related to copy and paste
• Fixed CSV export not to add empty rows/cols
1.0 beta 31 (29 Jan 2016):
• Added automatic delimiter option to CSV import dialogue
• Added keyboard shortcuts for most options
• Added options to define decimal mark recognizing numbers
• Text too long to fit a cell is truncated with ellipsis again
• Auto-updates should work again
• Improved performance when auto-sizing many columns at once
• Fixed memory leak
• Fixed problem where imported files would not be saved
• Fixed menu item for text alignment
• Implemented 'percent' formatting for numbers
• Implemented 'custom' formatting for numbers
• Automatically auto-size all columns after XLS/CVS-import
• Allow import of multiple cells via drag&drop
1.0 beta 30 (2 Dec 2015):
• FUNCTIONS & FORMULAE:
– formula support has been completely re-implemented
– more than 100 excel compatible functions implemented
– operators like '=A1+B1' work now in addition to functions
– a new 'functions' popup for inserting functions
– a new 'functions reference' window with function documentation
– excel files are now imported with formulae instead of results
• Cell contents no longer disappear when formatting fails
• Increase table size on demand when pasting data
• Make 'tab' go to next row when at end of row
• Always scroll to selected tabs
• Allow changing scale for printing with 'page setup'
• Fixed crash when 'reverting changes'
• Fixed issue with numbers with 'thousands sepator'
• Fixed issue with numbers being rounded to integer
• Fixed issue importing some excel files
• Keep main editor in sync when editing cells
1.0 beta 20 (19 Oct 2015):
• Added support for 'Undo' and 'Redo'
• Fixed most known bugs that are not related to 'Graphs' or 'Functions'
• Enabled better error reporting while the app is in beta
• Added preliminary support for 'merging cells'
• Temporarily removed too-slow support for truncating long cells
1.0 beta 13 (19 Aug 2015):
• Prevent importing white font color which would not be seen
1.0 beta 12 (15 Jun 2015):
• Improved application icon and toolbar icons
1.0 beta 11 (13 Apr 2015):
• Added proper import of dates, fonts & colors from excel .xls files
• Fixed problem with crash on launch when restoring document with invalid function
• Fixed problem with function results not being updated
• Fixed problem with bar chart options not showing up
• Fixed problem with autosizing of columns
• Fixed row sorting now to sort all uppercase cells first
• Import 'tsv' and 'tab' files with tab-separator by default
• Added smart guess whether to import 'csv' files with ',' or ';' separator
1.0 beta 10 (12 Feb 2015):
• Cell selection can now be adjusted with the mouse by dragging the corner-knobs
• Display truncated long text in cells with '…' to avoid confusion
• Display tooltips for cells with truncated long text
• Fixed crash related to editing graphs or having multiple documents open
• Prevented possibility to create crashing recursive functions with drag&drop
• Made welcome window not show an 'recent documents' list if its empty
• Relocate beta badge to avoid artifacts
• Fixed possible hang on restoring documents introduced in b9
• Fixed problem when entering invalid data in table resize field
• Fixed issue with column labels being cropped
• Fixed issue with welcome window only being shown once
• Fixed option to create cell borders when setting border color/width
1.0 beta 9 (28 Jan 2015):
• Added option to export charts to PDF
• Added explanation when trying to click function buttons instead of dragging
• Added menu button to charts as a more obvious way to edit/delete them
• Added option to select 'sheet' to import when importing XLS files
• Added option to scale/magnify the display whole table
• Added option to sort only some rows of the table
• Added option to automatically close the color panel with the popovers
• Added option to create cell borders when setting border color/width
• Added option to 'pad' imported CSV/XLS files with empty columns/rows
• Added option to drag&drop a chart of selected cells onto the table
• Fixed problem related to entering functions
• Fixed behavior of 'enter/return' to match 'Numbers': go to cell below
• Fixed problem related to popup placement
• Fixed problem adding multiple rows with dragging the plus-row button
• Fixed charts not appearing after loading a saved document with standard size
• Fixed problem with the 'move row' command
• Fixed for holding 'shift' while pressing arrow keys to extend selection
• Fixed import options to be persistently saved
• Fixed welcome-window to be movable
1.0 beta 8 (24 Jan 2015):
• Added smart popup window placement to avoid obscuring current cell
• Added 'close all popups' menu item
• Added contextual menu t to allow sorting a column to the column headers
• Added menu items to allow sorting a column
• Added close buttons to all popup windows
• Added preference option to always close popup-windows
• Properly add intermediate rows/columns to selection when holding down 'shift'
• Fixed issue when resizing the table with the sliders was limited in max values
• Fixed issue with column labels with more than 99999 rows
• Fixed performance problems in large tables introduced in beta 3
• Fixed artifact after dragging a function to the table but canceling
• Fixed drawing artifacts of cell borders at the top of the table
• Fixed problem where clicking outside the table would not cause deselection
1.0 beta 7 (16 Oct 2014):
• Fixed various problems and crashes related to functions
1.0 beta 6 (15 Oct 2014):
• Implemented alternating row colors on a per-table and global-default basis
• Implemented proper behavior when pressing "tab"
• Fixed problem where graph positions would not be properly restored
• Fixed problem where cell editing would not start for uppercase characters
• Fixed problem with horizontal and vertical border commands being mixed-up
• Clicking the table symbol at the upper left corner now now selects the whole table
1.0 beta 5 (15 Aug 2014):
• Added rudimentary charts & graphs
• Added ability for functions to take output of other functions as input
• Fixed problem with visual distortion after drag&drop
1.0 beta 4 (23 Jul 2014):
• Added recent documents to welcome screen
• Added menu items to control cell background/border and data format
• Added visual annotation to the drag&drop insertion point
• Added option to resize the table by dragging the "plus" buttons
• Fixed problem with column widths changed by adding/removing columns
• Fixed problem where numbers used in functions would be rounded
• Fixed problem where cells with functions could not be formatted
• Fixed 'select all' option to select the whole table
• Fixed crashes related to drag&drop
1.0 beta 3 (25 Jun 2014):
• Added option to set cell border styles
• Added keyboard shortcuts to set font styles
• Added optional welcome screen
• Fixed problems with copy & paste
• Show dependencies of cells with functions on selection
• Show function cells and dependent cells when pressing 'option'
• Enabled automatic updates to future versions
• Fixed problem where app would not run due to 'GateKeeper'
• Fixed problems with Excel import
• Improved stability
1.0 beta 2 (19 Jun 2014):
• Added simple Excel import and export
• Fixed various problems with editing cells
• Keep main editor and cell contents in sync
• Allow moving around the table with the arrow keys even when editing
• Added menu item and shortcut for editing the current cell in the main editor
• Implemented support for nested functions e.g. '=SUM(PROD(A1:A10),B2)'
• Performance improvements for functions
• Implemented the following functions: "SUM" / "ADD", "AVERAGE" / "AVG", "MEDIAN", "MIN", "MAX", "PROD" / "MULTIPLY", "ABS", "ACOS", "ACOSH", "ASIN", "ASINH", "ATAN", "ATANH", "COS", "COSH", "COSH", "DEGREES", "RADIANS", "ERFC", "RAND", "RANDBETWEEN", "EXP", "GAMMALN", "LN", "LOG", "MOD", "POWER" / "POW", "QUOTIENT" / "DIVIDE", "SIN", "SINH", "SQRT", "TAN", "TANH", "OR", "AND", "SIGN", "TRUE", "FALSE", "PI", "EQ", "GT", "GTE", "LT", "LTE", "MINUS", "NEQ", "UMINUS", "UPLUS", "COUNT", "CONCATENATE", "EXACT", "LEN", "LOWER", "PROPER", "UPPER"
1.0 beta 1 (14 Jun 2014):
• Initial public beta release