Tables
- Version 1.4.5 | Release Date: 2008-07-10 | Download
This version addresses the following issues:
- Small changes on the Excel Importer and Exporter
- Find (Previous) doesn't scroll to the position found
- Graphics could be misaligned in printout
- Tables could freeze when closing a document with a split view
- Version 1.4.4 | Release Date: 2008-05-27 | Download
This version addresses the following issues:
- Function PPMT: Miscalculation with the arguments per = 1 and ptype = 1
- Function ATAN2: The arguments x and y were swapped during calculation
- Incorrect handling for the keyboard shortcuts option-up arrow and option-down arrow
- Partially missing columns and rows in printout when a print scale is used
- Version 1.4.3 | Release Date: 2008-03-14 | Download
This version addresses the following issues:
- A few changes on the AppleWorks Importer
- Some fixes regarding merged cells
- Fixed some code that could lead to a crash when closing a document
- Improved Import for documents in OpenDocument format
- Further small fixes to improve the compatibility of Tables with Mac OS X 10.5 "Leopard"
- Function TRUNC(): The 2nd argument (decimals) is now optional
- Version 1.4.2 | Release Date: 2008-02-06 | Download
This version addresses the following issues:
- Changed the Spotlight Importer
- Workaround for a Cocoa-Bug
- Regard merged cell when creating LaTeX Code
- Further small changes to improve the compatibility of Tables with Mac OS X 10.5 "Leopard"
- Detect CR+LF, CR and LF on input and automatically enable the option "Automatic line break"
- Version 1.4.2 | Release Date: 2008-02-05 | Download
This version addresses the following issues:
- Changed the Spotlight Importer
- Workaround for a Cocoa-Bug
- Regard merged cell when creating LaTeX Code
- Further small changes to improve the compatibility of Tables with Mac OS X 10.5 "Leopard"
- Detect CR+LF, CR and LF on input and automatically enable the option "Automatic line break"
- Version 1.4.1 | Release Date: 2008-01-02 | Download
This version addresses the following issues:
- Some fixes regarding merged cells
- Excel-Importer: Improved import of cell format strings
- The current zoom factor got lost when the sheet was changed
- The functions from the category Information doesn't return localized values for TRUE/FALSE
- Save empty non locked cells to prevent a change to locked cells when reloading the document
- Search merged cells only once during search to prevent multiple entries in the search result
- Premature calculations during load could lead to wrong results in cells with formulas
- Disable the new button in the color panel when the color panel is opened from the Graphic Inspector
- Version 1.4 | Release Date: 2007-11-30 | Download
This version offers the following new features:
- Multiple cells can be merged and merged cells can be splitted again
- Improved Universal Access support for example for VoiceOver
- The window can be splitted so that different sheets/areas of the document can be displayed
- References in formulas are marked with different colors after input
- Cells and sheets can be protected against changes
- Optimization on detection of dependencies in formulas with references
- Improved Import for documents in OpenDocument format
- Sheets with dynamic size, viz. inserting and removing columns/rows will automatically resize the sheet
- A document can be printed with all sheets and exported as PDF in complete form or with a specified range of sheets
- The input of a number value in a cell with the format type percentage is directly transformed into a percentage quotation
- The scale of a page for printing can directly be changed in the Sheets Inspector
- New financial functions IPMT and PPMT
- New statistical function MODE
- New AppleWorks Importer using the AppleScript interface in AppleWorks
- The type of a chart can be specified directly when inserting a new chart
- Automatic and manual recalculation of the functions NOW(), TODAY() and RAND() when opening a document or with the menu item "Recalculate"
- The data range from a selected chart is marked with color
- The search field in the toolbar is now able to search cell comments
- A new inspector window can be opened with an Option click on the icon in the inspector window
- Setup for continuous pagination or specification of a start value for pagination in the sheet inspector
- The Inspector window can now be resized for some inspectors
- The color panel has a new button to change the text or background color of a cell
- Warnings during import can be displayed for further processing
- Version 1.3.10 | Release Date: 2007-10-25 | Download
This version addresses the following issues:
- Stop the current input before opening the autofilter popup menu
- A cell formatted as Percent is displayed with factor 100 on Mac OS X 10.5 "Leopard"
- Further small changes to improve the compatibility of Tables with Mac OS X 10.5 "Leopard"
- Calculate the automatic print range including cells that either contain text or have a cell border
- By scrolling with the mouse wheel it was possible to scroll beyond the last column or row
- A different drawing method for cell borders is used for print and PDF export to reduce the size of the output
- Version 1.3.9 | Release Date: 2007-09-19 | Download
This version addresses the following issues:
- "Replace All" only acts on the current sheet even when "Entire Document" is selected
- A sheet with a print range can not be printed or exported as PDF with Tables 1.3.8!
- Version 1.3.8 | Release Date: 2007-09-14 | Download
This version offers the following new features:
- Improved performance on opening a Tables document
- Activate the text field "Find" on opening the window "Find & Replace"
- Possible error calculating the print range including text that protrude to neighbor cells
- The focus of the input field got lost when the sheet changed on finding the next or previous occurrence of a text
- Version 1.3.7 | Release Date: 2007-08-21 | Download
This version addresses the following issues:
- The shortcut for Copy was missing in the French version
- Corrupted Tables documents could lead to a crash during load
- Function CHOOSE(): Error evaluating the maximum index
- Charts were partly updated before all dependent cells were updated
- New charts of type stacked areas were only displayed correctly after a save and reload
- Version 1.3.6 | Release Date: 2007-08-05 | Download
This version addresses the following issues:
- Fixed the workaround for the Cocoa bug when scrolling with the mouse wheel, because it caused some problems in the Layout view
- Version 1.3.5 | Release Date: 2007-08-03 | Download
This version addresses the following issues:
- A problem when sorting time values
- Excel-Importer: Fix for CSV files with XLS extension
- Calculate the print range including text that protrude to neighbor cells
- Workaround for a Cocoa bug when scrolling with the mouse wheel
- Menu item in the French Version to send a bug report by mail
- The title in the preferences window isn't localized after switching the group
- Version 1.3.4 | Release Date: 2007-07-20 | Download
This version offers the following new features:
- Added a new toolbar item to insert a chart
- Performance of XML handling for loading and saving of Tables and ODF documents improved
- Added an alert when inserting new columns/rows and this will result in losing of content in the last column/row
- A problem with the Spotlight importer
- Calculation of function RATE() improved
- Corrupted Find & Replace panel in the English Tables version
- Error code of the functions HLOOKUP() and VLOOKUP() changed
- File type not switched to Tables on Save As... on Mac OS X 10.3.9
- Detect TRUE and FALSE in strings and use case-insensitive handling
- The parser couldn't handle brackets in string arguments within functions
- The toolbar symbol function was enabled even when disabled
- Handling of quotes in a strings within a formula improved
- Advanced Find & Replace in Current Selection leaves the current selection
- The PopUp-Button for Zoom wasn't usable in the English Tables version
- A problem with the error handling of the functions ADDRESS(), CODE() and SUMPRODUCT()
- A Tables documents couldn't be reopened when the data range for a chart contains a cell with an error code
- Version 1.3.3 | Release Date: 2007-07-04 | Download
This version offers the following new features:
- Dutch localization by Alexander Henket - Nederlands
- French localization by Ronald Leroux - Canada
- You can enter a month in a date as the 3 letter shortcut of the name for the month like 1.Jun.07
- Some small fixes in Tables Help
- Insertion of a chart on another than the first page
- Percentages in formulas aren't displayed as percentages after input
- Charts aren't correct with a positive minimum value for the Y-Axis
- Input of hundredth of a second for time values isn't possible
- The page count doesn't work when columns/rows are defined as header for continuation pages
- Version 1.3.1 | Release Date: 2007-06-07 | Download
This version addresses the following issues:
- Some small fixes in Tables Help
- The shortcut for Copy was missing in the English version
- The text color was ignored when the selection was copied as HTML
- The entered text in a cell formatted as Text was not handled as text
- The marking of misspelled words from spell checking was present in print-out
- Version 1.3 | Release Date: 2007-06-01 | Download
This version offers the following new features:
- Charts of types: pie, line, (stacked) areas as well as (stacked) columns
- You can choose a different language for spell checking for any cell
- Add an autofilter to easily sort and filter lists
- Copy the current selection as a simple LaTeX table, HTML (text), PDF, PostScript or TIFF image to the clipboard
- Set a spacing for the text to each border of a cell
- More text encoding options for CSV files
- CSV settings can be changed during export and when opening a CSV file including a preview
- New statistical functions STDEV() and STDEVP()
- Advanced cell editor for cells with automatic line break and format type Text
- Version 1.2.6 | Release Date: 2007-05-07 | Download
This version addresses the following issues:
- The toolbar item Function wasn't enabled and disabled correctly
- A sheet without content for example only with graphics and PDFs could not be printed
- A crash when closing a document that contains the same graphic multiple times
- Tables Preferences: The resizing of the sheet to add functions to the toolbar item Function doesn't work
- Function SUMPRODUCT: Empty cells in the matrix lead to a wrong result of the function
- Function INDIRECT: Update problem in conjunction with the functions ADDRESS, COLUMN and ROW
- Paste a graphic from the clipboard at the current cell or the current visible area of the sheet
- Problems with "Insert Cells" when the sheet was completely selected
- Version 1.2.5 | Release Date: 2007-04-23 | Download
This version offers the following new features:
- New statistic functions LARGE and SMALL
- Scroll the cell editor into the visible range when moving the cursor
- CSV-Import: Format time values without a date part as time only
- CSV-Import: Set all columns to optimal width after import
This version addresses the following issues:
- A timing problem with the search field in the toolbar
- Take accuracy problems of floating point into account when comparing two values
- Take the default settings for rows, columns and cells into account when opening a document with a print range
- Find & Replace: Added a check for circular references on "Replace All"
- Function MEDIAN: An error occurred when the arguments doesn't contain any valid data
- Function INDIRECT: A problem with incomplete references when opening a document
- Version 1.2.4 | Release Date: 2007-04-07 | Download
This version addresses the following issues:
- Fixes a problem with whitespaces when opening Tables documents
- Fixes a problem with Entity-References when opening Tables documents
- Insert the content of copied cells as plain text in the header and footer
- Excel-Import: Fixed incorrect import of column width and default column width
- Version 1.2.2 | Release Date: 2007-03-30 | Download
This version offers the following new features:
- Jump to the same column of the first tab key in the next row when the user hit enter
- Show a hint in form of a red triangle in the upper right corner of a cell when the cell contains a comment
This version addresses the following issues:
- Scrolling with the scroll-wheel improved
- Deleting a styles sometimes failed
- The pop-up menu in the styles list caused trouble
- Sometimes the automatic row height wasn't adjusted when sorting and pasting
- Opening a document with a not installed font led to an error
- Recognition of sheet names like 2007 or J2007 in references within formulas improved
- The selection jumps to the last edited cell of a previous sheet after paste
- Disable all inspectors when the last document is minimised to the dock
- Excel-Importer: Use the Arial or System font when the used font in the document is not installed
- Version 1.2.1 | Release Date: 2007-03-09 | Download
This version offers the following new features:
- Clicking the arrow in the Toolbar item function now opens the popup menu directly
This version addresses the following issues:
- Improved recognition of circle references when shifting cells
- Error when filling a series when the cells within the range already had a content
- A print range not beginning in column A or line 1 could cause a problem when printing
- Vertical alignment of text with 2-byte-codes e.g. with Japanese, Chinese and other characters changed
- Absolute references and references from/to sheets were not correctly converted when shifting cells
- Use quoted sheet names for sheets with special characters (- + */^ &) on references in formulas
- Cut off an additional line end when pasting text from the clipboard to avoid an additional empty cell
- Version 1.2 | Release Date: 2007-02-22 | Download
This version offers the following new features:
- A cell editor for direct input in the sheet
- The selection in inactive windows is drawn in grey
- Values keep their scientific notification after input
- Rename a sheet directly in the document inspector
- German function names are available in the German version
- The function window offers a function description in German
- A grid can be setup for cells without borders on print
- Enter the name for the new sheet when you add it
- PopUp menu for the toolbar object function incl. preferences
- Columns and rows can be defined as header for continuation pages
- Spotlight can now search documents incl. various settings
- The text color can be changed directly in the Colors windows by holding down the control key while the background color can be changed by holding down the option key
- Delete cells and shift adjacent cells left or up
- Insert cells and shift adjacent cells right or down
- A column reference becomes absolute by holding down the option key when inserting a reference by mouse
- A row reference becomes absolute by holding down the command key when inserting a reference by mouse
- Changed the calculation of the RATE() function
- Fixed an error on undoing changes that lead to a circular reference
- The current display position for the active sheet wasn't updated in the document on save
- Excel-Import: Improved identification of Excel document before Excel 8.0
- Excel-Import: Improved import for documents created with third party applications
- Version 1.1.5 | Release Date: 2007-01-16 | Download
This version offers the following new features:
- Improved keyboard handling in function window
- With terminating the input with Enter the selection remains in the current cell
- The functions SUM(), SUMIF(), COUNT(), COUNTBLANK(), COUNTIF(), AVERAGE(), MEDIAN(), MIN() and MAX() use the additional area of the current selection as a range reference for the first argument
- Support for Excel .xls documents created with Mesa
- Save the default column width and default row height of sheets
- Improved selection of multiple columns and rows by mouse
- Improved resizing of columns and rows by mouse
- You can resize multiple columns and rows by mouse
- The Function CONCATENATE() accepts numbers like =CONCATENATE(1;2;3)
- Error on populating a series when the start cell is empty
- The resolution of graphics is partly not determined correctly on open
- TRUE/FALSE as direct values in cells are not recognized on open
- Functions are not used when they are inserted as optional arguments in other functions
- Partial problems with the formats when user-defined formats are used in system preferences
- Excel-Importer: Problems with .xls files > 7 MB
- The "Paste Special..." window wasn't up-to-date in the English version
- Problems with the context menu for columns and rows
- The delete key doesn't directly clear the cell content
- Problems setting column width/row height for all columns/rows
- Format changes for complete columns/rows sometimes doesn't effect current settings
- Duplicate empty columns and row as well when duplicating a sheet
- Function INDIRECT(): Error on resolving incomplete references
- Excel Importer: Import of format types Currency and Accounting improved
- Excel Importer: Validate the Excel .xls document format on open
- Excel Exporter: Export prefix and suffix of format type Number
- Function RANK() returned a wrong ranking on duplicate values in descendant order
- Functions SUM(), SUMIF() and SUMPRODUCT() don't processed date/time values
- The parser rejected the formula ="123"-"23" because text values weren't allowed in this case
- On opening of a document unused graphics are released now
- Excel Import/Export: The time formats for duration's > 24 hours weren't converted
- The Tab- and Enterkey aren't working in text fields in the Inspector
- Version 1.1 | Release Date: 2006-12-15 | Download
This version offers the following new features:
- Export documents as Excel xls documents
- Move columns and rows around with their content
- TRUE and FALSE can be used
- Enter comments for cells
- Format a cell as 'text only' with the new format type 'Text'
- Access functions quickly through context menus for cells, column header, row header and graphics
- Select the Zero Value format for the format types 'Number', 'Percent' and 'Scientific'
- New text function T()
- New finance function RATE()
- The function TEXT() has an additional argument to use Excel formatting codes for date & time formatting
- The functions TODAY(), NOW() and RAND() are transient now and therefore calculated on open
- The active sheet is memorised on save and activated on open.
- New Text function VALUE()
- New Date & Time functions DATEVALUE(), TIMEVALUE()
- New Financial functions DB(), DDB(), FV(), IRR(), LEGALFEES(), NPER(), NPV(), PMT(), PV(), SLN(), SYD()
- New Information functions ISERR(), ISLOGICAL(), ISNA(), ISNONTEXT(), ISNUMBER(), ISREF(), ISTEXT()
- A sheet can be flipped horizontally for print and export to PDF
- Duplication of complete columns and rows
- A time can be used without a date
- A new format under date & time for duration's > 24 hours
- & Operator to concatenate strings like ="ABC"&"DEF" for ABCDEF
- All values for the format type 'Number' with the negative format (100) are now aligned
- Menuitems 'Tables Website...' and 'Send Bug Report...' are not available when no document is open
- Referencen to cells are now readjusted on move and copy & paste respectively
- Direct references got lost on 'Delete > All'
- Error saving the current display position of sheets
- Display refresh when the tab in the inspector is changed
- Opening the pop-up menu for styles with clicking the triangle symbol could lead to a crash
- When pasting area references with a fixed from area the whole area reference becomes fixed
- Compatibility of the functions CHOOSE(), HLOOKUP(), INDEX(), MATCH() and VLOOKUP() improved
- References to sheets with quoted names are not handled correctly
- Error on open of documents in conjunction with cell formatting
- Function COUNTIF(): Sometimes the criteria is not correctly parsed
- Function INDIRECT(): Update the reference on changes of the argument not until the argument is updated
- Excel-Importer: Error on formulas with a missing reference as an argument
- Excel-Importer: Better handling of cell formatting in documents created with third party applications
- Excel-Importer: Narrow area references to the maximum sheet size
- Error on removing the print range on a sheet
- Encode special characters in sheet names on save
- Prefix ' for text only got lost on copy and paste
- Pasting stopped when the data was wider than the current sheet
- Function INDIRECT(): Update the reference when the argument value change
- Display the cell border and background from the default style for all cells
- When inserting cell range with mouse in a formula no semicolon was added
- Excel-Importer: the sheet got lost for references to cell ranges in other sheets
- Copy the header and footer of a sheet on duplicate
- End editing of header and footer when the active sheet is switched
- Error in calculating and checking of trial period even when Tables is registered
- Sometimes the inspector displays wrong values when multiple empty cells are selected
- Excel-Importer: Error on detection of text color
- Excel-Importer: Error message when opening documents before version 8.0 (Excel 97)
- Refresh mouse rectangles in column and row header on insert/delete of columns/rows
- Abort cell editing when the affected sheet should be deleted
- End editing when the document should be saved
- Function DATE(): Wrong results when month > 12 and/or day > 30/31
- Function INDIRECT(): Internal error that sometimes leads to a crash
- Workaround for a bug in conjunction with print settings when duplicating sheets
- Adopt all settings when duplicating a sheet
- Display negative numbers in the input field as expected
- Workaround for 10.3.9 for undefined symbols in the format string for Custom Date & Time
- Excel-Importer: Take the date system of the file into account when importing time values
- Excel-Importer: Improved the import of documents generated with AppleWorks
- The reference to the sheet gets lost on range references to other sheets
- Finalise input on close of resize sheet window
- Fixed sheet margins on print and export to PDF
- Fixed duplication of a row after undo/redo a duplication
- The Cancel button in the English window for resizing sheets
- An undo of a paste can freeze Tables in some circumstances
- Assigning a style to complete columns/rows/sheets doesn't change the style of used cells
- Check for circular references when moving and pasting cells/content
- Workaround for a bug in conjunction with print settings
- Display negative numbers and percentages in parentheses only when value is negative
- German tool-tips for changing column width/row height with mouse
- Don't display content of hidden column
- Use of references to cells in other sheet with different size (columns/rows)
- Restrict calculated printout scale from 25% till 400%
- Shortened the latency for drag and drop of cells
- Excel-Importer: take broken references into account
- Excel-Importer: calculate dependent cells on import
- Excel-Importer: formatting of percentages and negative values in red
- Excel-Importer: use the printout scale only when set
- Recalculate dependent cell on paste
- Crash under 10.3.9 on export
- Save the default style of a sheet
- Version 1.0 | Release Date: 2006-09-15 | Download
This version offers the following new features:
- Double clicking a cell and F2 switch into editing mode
- Further display options for negative numbers and percentages
- Drag and Drop to copy and move cells
- New functions CHOOSE(), HLOOKUP(), VLOOKUP() and SUMIF()
- Criteria in function can now be an expression like ">3"
- You can preset the end of line character for CSV export
- You can preset the text encoding for CSV import/export
- The size of a sheet (columns/rows) can be changed
- Shortcut/Menu for search field in toolbar
- The printout scale can be calculated
- Rearranging of sheets within a document
- Insert of several columns/rows matchig marked columns/rows.
- The index parameter for the functions FIND() and SEARCH() is now optional.
- New functions AVERAGE(), COUNT(), COUNTBLANK(), MAX(), MEDIAN() and MIN().
- The Prefix ' in the input field produces always a text, e.g. '0815 will lead to the text 0815 and not the number 815.
- Crashreporter to send Crash Logs at startup.
- You can preset the separator for CSV import/export.
- Implemented search & replace menu and panel.
- You can preset the size for new sheets (columns/rows).
- Display of column and row titles in layout view
- Behaviour of header and footer when changing document margins
- Use of default tab stops for header and footer
- Disabled automatic scrolling while dragging tab stops
- Detection of first keystroke on 2 character code input method
- Further text after a date is not longer cut off after input
- No actions for buttons in German Find and Replace Window under Simple
- No drag and drop of sheets in English Document Inspector
- Finalise input on close of Preference window
- Reseted the 30-day Trial
- Layout of centered text
- Selection with Mouse improved
- Performance of Excel-Importer improved
- Error while changing decimal places in Percent format
- Error in functions with a calculated attribute of type date
- The CSV-Importer ignored the last character
- Error pasting values with Paste Special...
- Performance of Paste improved
- Display of page breaks in normal view
- Use selected Measurement Units for ruler
- Round maximum values for column width and row height
- Optimum column with for cells with automatic line break
- Recognition of numbers and date for Switzerland imporoved.
- Errors when sorting completely marked lines or columns repaired.
- No message at startup, when version is up-to-date.
- Paste of several rows with different number of columns fixed.
- Paste text without attribute into the input field.
- Revised help and further parts of English help translated.
- Version 0.16 beta | Release Date: 2006-08-01 | Download
First public beta release.



