1.3 Summary of Changes from SpreadScript 1.1 to 1.2

The following is a summary of the changes and bug fixes in SpreadScript 1.2.

• Excel spreadsheets created with SpreadScript now use less space to store certain types of numbers.
• Fixed exception handling problem where exceptions were not getting cleared once set.
• Added support for European-style dates where the day precedes the month (SS_FMT_DATE_ALT - dd/mm/yy); importTSV() and importCSV() each now have an optional argument to choose between mm/dd/yy and dd/mm/yy.
• Various improvements in reading Excel files.
• Fixed bug in LARGE() and SMALL() that occurred when finding the Nth largest/smallest value when N exceeded the number of non-empty cells in the specified range.
• PERCENTRANK() and MODE() now work with ranges of empty cells.
• Fixed problem with reading Excel 95 files produced by Gnumeric.

1.3.1 Summary of Changes from SpreadScript 1.0 to 1.1

• Added Excel compatibility mode that now allows the use of Excel syntax, such as ``:'' for ranges (e.g., A1:B3); this mode may be turned on globally for all newly created Workbook objects with setDefaultExcelMode() or turned on for a particular Workbook using Workbook::setExcelMode().
• SpreadScript is now capable of properly reading and writing Excel files that are larger than 7 MB.
• The IF() function is now properly supported in Excel files.
• The string concatenation operator ``&'' (single ampersand) is now properly supported in Excel files.
• Range::setFormula() now works correctly when the formula is a number, such as Range::setFormula(``1'').
• Worksheet::getFormula() works correctly when the cell is empty.
• Worksheet::setFormula() now properly throws an exception when the formula specified contains a syntax error.
• The Perl binding no longer produces the ``Not a HASH'' and ``Use of uninitialized value during global destruction'' warnings; the first warning caused problems when using SpreadScript with the Apache module mod_perl.