(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 _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal