FlexCel Studio for .NET 7.17 released

We are pleased to announce the release of FlexCel Studio for .NET 7.17.

To be notified of new releases open Topics tagged flexcel-net-release and watch the tag.

New in v 7.17 - June 2023

  • Optimized support for .NET 7. We include now packages compiled against .NET 7

  • SkiaSharp updated to 2.88.3. The minimum SkiaSharp now required is 2.88.3.

  • Removed support for .NET Core 3.1 and 5.0. As .NET Core 3.1 and 5.0 reached EOL, now the minimum .NET Core version supported is 6

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

  • 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. The function =NUMBERVALUE() could throw an Exception in some border cases