What's new in TableEdit 1.4.7
Feb 25, 2021
- TableEdit is now free and supported by showing our other apps
- Improved import of Dates from Excel .xslx files
- Improvements for CSV import
New in TableEdit 1.4.6 (Feb 28, 2020)
- Fixed problem with Excel import and export
- Added 'notarization' for improved security and easier launching on macOS 10.15
New in TableEdit 1.4.5 (Dec 5, 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
New in TableEdit 1.4.3 (Oct 30, 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
New in TableEdit 1.4.2 (Oct 31, 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
New in TableEdit 1.4.1 Build 9507 (Jul 12, 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
New in TableEdit 1.4.0 Build 9469 (Apr 25, 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
New in TableEdit 1.3.5 Build 9180 (Apr 6, 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
New in TableEdit 1.3.0 Build 9100 (Feb 2, 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
New in TableEdit 1.2.9 Build 9000 (Jul 25, 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
New in TableEdit 1.2.8 Build 8900 (Jun 5, 2017)
- Fix for expired excel import/export support
New in TableEdit 1.2.7 Build 8896 (May 27, 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
New in TableEdit 1.2.6 Build 8862 (May 12, 2017)
- Fix crashes when disabling or modifying toolbar
- Improved stability on macOS versions 10.9 & 10.10
- Improved implementations of the DAYS, LEFT & RIGHT functions
- Improved compatibility with Excel XLS files
New in TableEdit 1.2.5 Build 8813 (Feb 22, 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
New in TableEdit 1.2.3 Build 8744 (Dec 24, 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
New in TableEdit 1.2.2 Build 8690 (Dec 6, 2016)
- Fixed inability to purchase upgrade to 'Pro' in the Mac App Store 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
New in TableEdit 1.2.1 Build 8678 (Nov 29, 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
New in TableEdit 1.2.0 Build 8510 (Nov 22, 2016)
- IMPORTANT: Advanced charts & formulae are now an in-app purchase to fund development
- 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
- 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
New in TableEdit 1.0.5 Build 6937 (Jun 7, 2016)
- Fix crash when opening the function-popup.
New in TableEdit 1.0.4 Build 6923 (Jun 5, 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)
New in TableEdit 1.0.3 Build 6686 (May 7, 2016)
- Fix alternate function-spellings (AVG / AVERAGE) stopping to work
- Enable moving cursor inside a cell with arrow-keys
New in TableEdit 1.0.2 Build 6673 (May 5, 2016)
- IMPORTANT: fixed import & export options not appearing
- Implemented references to empty cells in formulae
New in TableEdit 1.0.1 Build 6655 (May 3, 2016)
- Improved stability, performance and memory-usage
- Improved excel-import and formula support
- Implemented NORMSDIST, NA, ISNUMBER, ISTEXT, ISNA, ISERR & ISERROR functions
- Fixed memory leaks on documents with formulae
New in TableEdit 1.0 Beta 35 (Apr 18, 2016)
- Removed 'beta' warnings in preparation of 1.0 release
- Extended ReadMe and documented non-obvious features
- Implemented DOLLAR function
- GRAPHS & CHARTS:
- line charts
- added different coloring options to charts
- fixed charts positioning and scrolling with table
- saved charts should now appear after opening a document
- fixed crash related to 'reverting' and charts
New in TableEdit 1.0 Beta 32 (Mar 26, 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
New in TableEdit 1.0 Beta 31 (Jan 31, 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 cekk 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
New in TableEdit 1.0 Beta 30 (Dec 4, 2015)
- 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
- 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
New in TableEdit 1.0 Beta 20 (Oct 21, 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
New in TableEdit 1.0 Beta 13 (Oct 21, 2015)
- Prevent importing white font color which would not be seen
New in TableEdit 1.0 Beta 12 (Jun 17, 2015)
- Improved application icon and toolbar icons
New in TableEdit 1.0 Beta 11 (Apr 14, 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
New in TableEdit 1.0 Beta 10 (Feb 12, 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
New in TableEdit 1.0 Beta 9 (Jan 29, 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
New in TableEdit 1.0 Beta 8 (Jan 26, 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
New in TableEdit 1.0 Beta 7 (Jan 26, 2015)
- Fixed various problems and crashes related to functions
New in TableEdit 1.0 Beta 6 (Oct 16, 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
New in TableEdit 1.0 Beta 5 (Aug 16, 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.
New in TableEdit 1.0 Beta 4 (Jul 29, 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
New in TableEdit 1.0 Beta 3 (Jun 26, 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'
- Improved stability
New in TableEdit 1.0 Beta 2 (Jun 24, 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"