[Lazarus] fpspreadsheet 1.2 has been released

[Reinier Olislagers]

(Cross-posted to FPC & Lazarus lists)
We're pleased to announce that fpspreadsheet 1.2 has been released.

Changes since previous 1.1:
fpSpreadsheetGrid:
fpSpreadsheetGrid has been extended to display formatting of the cells
and to evolve towards a spreadsheet viewer. The demo is modified to show
how cell formatting can be interactively changed and how the modified
spreadsheet can be saved to file. In addition to cell values, it can
display the text representation of RPN formulas.

biff support
All biff file formats have been brought to the same level of support.
Many limitations of number formats have been relaxed. Now any format can
be written. Reading works for not too complex format constructions.

Enhanced color and font support
Color (including background color) and font support has been extended
for the BIFF (Excel) file formats. The color type TsColor is no longer
an enumeration now.
Full font support, not just "bold".

Enhanced formatting support

Cell border styles: different line styles and colors for cell borders
Text alignment: left/center/right alignment, top/center/bottom alignment
of text within cell boundaries

Wiki table output format
Support for wiki table format output

Support for Date/Time cells

Read/write support for date/time/datetime cells in BIFF8 .xls,
OpenDocument .ods.
Write as text cell support for date/time/datetime cells in other formats

Number/text/date/time format support in BIFF .xls and OpenDocument ods
Number format parser to give access to most features of the number
formats for reading and writing

Formula support
Support for ABS, DATE and TIME and 75 more RPN formulas added to biff
format.
Reading of RPN formulas from biff files.
Conversion of RPN formulas to Excel-like strings
Reading of string formulas from ods files

Cardinal cell addressing
For formats that support it, reading/writing to cells > 65536
rows/columns is now supported.

Text cell size limit enforced
Text cell size limits enforced for BIFF2..8 xls, xlsx and ooxml so it is
no longer possible for excessively long cells to corrupt a file.
Overflowing bytes are currently silently truncated.

Zip64 support on FPC 2.7.1
On FPC 2.7.1, fpspreadsheet uses the FPC-supplied zip units, which
provides support for large files/large number of files inside an
ooxml/xlsx file.

Unit tests for fpspreadsheet
fpcunit unit tests have been added to fpspreadsheet that help ensure that
- functionality is not changed inadvertently (regression tests)
- interoperability with Excel/OpenOffice/LibreOffice files works (or
does not get worse)
Please add unit test cases whenever adding new functionality to
fpspreadsheet (e.g. patches)

Bug fixes
... and bug fixes.

Link to download and more information via
http://wiki.lazarus.freepascal.org/FPSpreadsheet