Tables

Licence: Shareware (29 EUR)
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"
This version addresses the following issues:
  • 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
This version addresses the following issues:
  • 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
This version addresses the following issues:
  • 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
This version addresses the following issues:
  • 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)
This version addresses the following issues:
  • 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
This version addresses the following issues:
  • 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).
This version addresses the following issues:
  • 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.