fpspreadsheet 1.4 released

[wp]

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, 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 (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.
• Overflow cells in TsWorksheetGrid: label cells with text longer than the cell width extend into the neighboring cell(s).

See the wiki page 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.

[exdatis]

Wow, thank you very much! Happy new year!

[Hansvb]

Great, i will download it.
happy new year

[MSC]

Thanks,
will try it soon!
Happy new year.
MSC

[JZS]

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/.

Many thanks wp.
Am no longer able to download from that link.

SF says:
"Download Forbidden!!!
We cannot send this file to your location."

Happy New Year

[marcov]

from http://sourceforge.net/blog/clarifying-sourceforgenets-denial-of-site-access-for-certain-persons-in-accordance-with-us-law/

"This means users residing in countries on the United States Office of Foreign Assets Control (OFAC) sanction list, including Cuba, Iran, North Korea, Sudan, and Syria, may not post content to, or access content available through, SourceForge.net"

[JZS]

Thanks Marcov.

Shall I call Mr. P, or alternative can be found?

[wp]

@JZS: Send me a PM with your private e-mail address and I'll send you the file as an attachment.

[JanRoza]

I love this package and it fills a great need I had, but I have a problem with the latest version.
Trying to compile the fpspreadsheet_visual package I get this serie of errors:

Code: [Select]

Compiling package laz_fpspreadsheet_visual 1.4: Exit code 1, Errors:8, Hints:1
fpspreadsheetgrid.pas(694,3) Error: Identifier not found "RangeSelectMode"
fpspreadsheetgrid.pas(694,22) Error: Identifier not found "rsmMulti"
fpspreadsheetgrid.pas(3049,24) Hint: Conversion between ordinals and pointers is not portable
fpspreadsheetgrid.pas(3113,8) Error: Identifier not found "HasMultiSelection"
fpspreadsheetgrid.pas(3115,22) Error: Identifier not found "SelectedRangeCount"
fpspreadsheetgrid.pas(3117,14) Error: Identifier not found "SelectedRange"
fpspreadsheetgrid.pas(3117,31) Error: Expression type must be class or record type
fpspreadsheetgrid.pas(3121,42) Error: Identifier not found "Bottom"
fpspreadsheetgrid.pas(3122,42) Error: Identifier not found "Right"

I tried this using Lazarus 1.3 (45478) and fpc 2.6.4.
Am I missing something?

Using Lazarus 1.2.6 and FPC 2.6.4 compiling does work.
 

[wp]

Your svn revision is too old, please use a more recent one. This is because about two months ago a "RangeSelectMode" property was added to TCustomGrid and its descendents which is useful for TsWorksheetGrid to get better compatibility with Excel etc when selecting multiple cell ranges (http://bugs.freepascal.org/view.php?id=27000"). The fpspreadsheet code checks only the lazarus version, therefore the missing new property is no problem with version 1.2.6, but it is in trunk if the revision used is too old.

[JanRoza]

I suspected as much.
I'll get the latest svn and retry.
Thanks!