We are pleased to announce the release of FlexCel Studio DLL 7.17.
To be notified of new releases open Topics tagged flexcel-dll-release and watch the tag.
This release updates the dll to use FlexCel 7.17. Below you can find what is new in FlexCel Studio for VCL & FMX 7.17.
New in v 7.17 - June 2023
-
Improved API for defining columns in tables. Now you can define a totals formula or a column formula for the columns in the table, if needed. As usual, APIMate will show you how to do it.
-
Now FlexCel preserves digital signatures in macros. When you have digitally signed macros in a file, now FlexCel will preserve them when opening and saving that file
-
New property DeleteEmptyBandsFixed in FlexCelReport controls what to do with empty fixed bands. The new function DeleteEmptyBandsFixed lets you define what happens if a fixed band has zero records.
-
Improved the experimental Lazarus support. FlexCel can't still be compiled with Lazarus stable as it hasn't got anonymous methods yet. But we've modified the code to adapt for the changes in Lazarus trunk.
-
Bug Fix. When recreating a table by calling AddTable and SetTable, the cell references could become invalid
-
Bug Fix. The functions IFERROR, ISERROR and ISERR could sometimes return the error instead of the result of the function.
-
Bug Fix. The functions COUNTIF, SUMIF and similar could behave wrong in some cases where you used wildcards. See https://support.tmssoftware.com/t/countif-formula-with-wildcard-failing-after-recalc-method-is-called/19266
-
Bug Fix. The function TRIM in Excel removes double spaces in the middle of a text, while FlexCel's implementation would remove only spaces at the beginning at end. Also Excel's TRIM only removes spaces (character 32) and not other whitespace like tabs. FlexCel's implementation now does the same.
-
Bug Fix. FlexCel could fail to read some encrypted files raising an error 'Error in CryptoAPI: $80090004'.
-
Bug Fix. The function =NUMBERVALUE() could throw an Exception in some border cases
-
Bug Fix. Setup would fail to install if there was a "," in the path