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.
--
_______________________________________________
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
