(Cross-posted to FPC & Lazarus lists)
We're pleased to announce that fpspreadsheet 1.2 has been released.
Changes since previous 1.1:
laz_fpspreadsheet package
laz_fpspreadsheet.lpk will not be installed into the IDE (as a design time package) as was done in previous versions. Just compiling it will be enough - you can then use it in your projects.
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 (e.g. .xls file size writing limitation of about 7MB)
Link to download and more information via
http://wiki.lazarus.freepascal.org/FPSpreadsheet
Recent
