FlexCel Studio for .NET 7.14 released

FLX TMS FlexCel Studio for .NET
,
1

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

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

New in v 7.14 - January 2022

  • Improved floating point handing in .NET Core 3.0 or newer, .NET 5 or newer. .Net 3.0 completely rewrote the floating point parsing and formatting and this lead to many small but noticeable changes in how FlexCel rendered files. For example, in .NET Core 3 the code Console.WriteLine((-1.0/3.0).ToString("0")); will write "-0" instead of "0" as before. Or Console.WriteLine((4.5).ToString("F0")); will write "4" instead of "5" as before. There are many other similar changes. We've done a big review of the code to try to ensure we behave like Excel, not like .NET Core 3 when rendering a file.

  • Removed support for .NET framework 2.0. Now the minimum .NET version supported is 3.5

  • Support for bubble charts. Now FlexCel can render Bubble charts. You can also enter them with the API and APIMate will show you the code to do it.

  • New <#Swap Series> tag for reports. The new <#Swap Series> tag allows you to create charts that grow or decrease their number of series according to the data available.

  • New CustomizeChart event for reports. The new CustomizeChart event allows you to further customize the charts in the report once they have been generated.

  • Support for optional lambda parameters. There is now full support for the new optional lambda parameters in Excel.

  • IsOmitted function support. There is now full support for the new IsOmitted function.

  • Improved recovery mode. RecoveryMode can now load more types of invalid files.

  • Support for localized versions of the CELL function. Now you can write the first argument of function CELL in 24 languages, and FlexCel will understand them anyway. Before only English was understood. The languages added are Catalan, Croatian, Czech, Danish, Dutch, Finnish, French, Galician, German, Hungarian, Italian, Kazakh, Korean, Norwegian, Polish, Portuguese-Brazil, Portuguese-Portugal, Russian, Slovak, Slovenian, Spanish, Swedish, Turkish and Ukrainian

  • Bug Fix. Now FlexCel will throw an exception if you try to save a chart with more than 255 series. Before this release, FlexCel would just save the file, but a file with more than 255 series crashes Excel.

  • Bug Fix. APIMate wouldn't report deleted chart titles, which could lead to chart titles appearing when there was a series with a name.

  • Bug Fix. It was impossible to manually enter lambda formulas referring to names if AllowEnteringUnknownFunctionsAndNames was false.

  • Bug Fix. A horizontal fixed band in a report would insert columns if using more than the fixed space, instead of just overwriting the cells.

  • Bug Fix. Sometimes it was not possible to read properties from xls files.