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 <http://wiki.lazarus.freepascal.org/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 <http://wiki.lazarus.freepascal.org/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 (TsWorksheet.ErrorMsg)
* *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 <http://wiki.lazarus.freepascal.org/FPSpreadsheet_tutorial:_Writing_a_mini_spreadsheet_application>.
* *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
<http://wiki.lazarus.freepascal.org/FPSpreadsheet_tutorial:_Writing_a_mini_spreadsheet_application>.
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.freepascal.org/pipermail/lazarus/attachments/20141231/d7ea22bd/attachment.html>