[Lazarus] fpspreadsheet 1.4 released

Werner Pamler werner.pamler at freenet.de
Wed Dec 31 18:44:51 CET 2014

I am glad to announce that a new version of fpspreadsheet, version 1.4, 
has been uploaded to 
https://sourceforge.net/projects/lazarus-ccr/files/FPSpreadsheet/. Here 
is a list of the main additions of the new release:

  * Full support for *string formulas* (reading, writing, calculating).
    Registration mechanism which allows to extend the built-in formulas
    by user-defined ones. Calculation occurs when a workbook is saved
    (activate workbook option boCalcBeforeSaving) or when cell content
    changes (workbook option boAutoCalc).
  * *Shared formulas* (reading for sfExcel5, sfExcel8, sfOOXML; writing
    for sfExcel2, sfExcel5, sfExcel8).
  * Significant *speed-up* of writing of large spreadsheets for the
    xml-based formats (ods and xlsx), speed up for biff2; *speedtest
    demo* program
  * *VirtualMode* allowing to read and write very large spreadsheet
    files without having the entire document in memory. Formatting of
    cells in VirtualMode.
  * db export unit allowing programmatic exporting datasets using
    *TFPSExport*. Similar export units are e.g. fpdbfexport
    <http://wiki.lazarus.freepascal.org/fpdbfexport>, fpXMLXSDExport
  * Demo program for database export using virtual mode and TFPSExport.
  * Reader for *xlsx* files, now fully supporting the same features as
    the other readers.
  * Reader/writer for *CSV files* based on CsvDocument
  * *Wikitables writer* supports now most of the fpspreadsheet
    formatting options (background color, font style, font color, text
    alignment, cell borders/line styles/line colors, merged cells,
    column widths, row heights); new "wikitablemaker" demo
  * *Insertion and deletion of rows and columns* into a worksheet
    containing data.
  * Implementation of *sorting* of a worksheet.
  * Support of *diagonal "border" lines*
  * *Logging of non-fatal error messages* during reading/writing
  * *Merged* cells
  * *Registration* of currency strings for automatic conversion of
    strings to *currency values*
  * A set of *visual controls* (TsWorkbookSource, TsWorkbookTabControl,
    TsSpreadsheetInspector, TsCellEdit, TsCellIndicator, TsCellCombobox,
    in addition to the already-existing TsWorksheetGrid) and pre-defined
    standard actions to facilitate creation of GUI applications

  * *Overflow cells* in TsWorksheetGrid: label cells with text longer
    than the cell width extend into the neighboring cell(s).

See the wiki page <http://wiki.lazarus.freepascal.org/FPSpreadsheet> for 
documentation of the package, or the chm help file in the installation 
folder. If you need fpspreadsheet in gui applications you may also want 
to have a look at the tutorial 

This release is devoted to the late Reinier Olislagers ("bigchimp", 
http://forum.lazarus.freepascal.org/index.php/topic,26726), one of the 
former maintainers of the package.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20141231/d7ea22bd/attachment-0002.html>

More information about the Lazarus mailing list