FlexCel Studio for .NET 7.9 released

FLX TMS FlexCel Studio for .NET
,
1

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

To be notified of new releases open https://support.tmssoftware.com/tag/flexcel-net-release and watch the tag.

New in v 7.9 - April 2021

  • Support for functions LAMBDA and LET. We've reworked the recalculation engine to add support for LAMBDA and LET functions. With Lambda, the calculation engine is now turing-complete.

  • Support for functions SINGLE, VALUETOTEXT and VALUETOARRAY. Added support for SINGLE, VALUETOTEXT and ARRAYTOTEXT functions.

  • Breaking Change: Deprecated Android support in Visual Studio 2017. As google Play is now requiring a target framework of Android 10, we can't ship Android support in VS 2017 since it supports up to Android 9. To deploy FlexCel to android, you will need to upgrade to Visual Studio 2019 or compile it manually with an older target framework.

  • Support for rendering multi-level labels in category axis. In Excel you can set a category axis to have more than one row/column, and Excel will render those multi-level ranges in a different way than normal ranges. Now FlexCel will behave the same.

  • Support for legend keys in chart labels. Now when exporting to PDF/HTML, if the option "Legend key" is enabled in the label options of a chart, FlexCel will render them.

  • Support for "Label contains Value from range" option in charts. Now FlexCel will correctly handle the "Label Contains: " "Value from Cells" options for chart labels available in newer Excel versions. They will be exported to PDF/HTML and APIMate will show the code to create them in your programs.

  • Improved drawing of x-axis in charts. Now FlexCel will automatically adjust the x-axis labels to 45 degrees if needed, and also take the space from near labels if those are empty.

  • TXls3DRange now supports an external filename. The object TXls3DRange now has a property with the filename, in case that the range is from another file. This allows to use external files in user-defined functions.

  • Hyperlink Base support. Now FlexCel will correctly preserve Hyperlink Base in xlsx files (it was already preserved in xls). Now the hyperlink base is also used when exporting to HTML, SVG or PDF.

  • Support for using an expression like <#joinedtable.tablejoined.*> to make a generic report in only one of the joined tables. Now when you join tables in the template you can use <#joinedtable.tablejoined.*> or <#joinedtable.tablejoined.**> to create a generic report only in the fields of that subtable.

  • The <#ref> tag can now use tags in its parameters. Now you can write something like <#ref(<#dataset.#rowcount>,3)>. Before this version tags were not allowed as parameters.

  • New property "IsCameraObject" in TImageProperties. The new property IsCameraObject lets you know if an image is a camera object or not.

  • Improved compatibility with xlsx files created by SoftMarker Office. SoftMaker office adds many extensibility points in places of the xlsx where they are not allowed. FlexCel complained about that, but in the new version we ignore the ones we could identify.

  • Axis labels will now render with a background color if they have one. Now the axis labels will render the background color if you assign a color to them.

  • Bug Fix. FlexCel would always render labels in the category axis as not "linked to source" even if they were.

  • Bug Fix. Labels which come from cells that are formatted to show negative values in different colors show with that color in Excel, except in pie charts. FlexCel used to ignore that color, not it will display it.

  • Bug Fix. When rendering xlsx charts, labels which were manually positioned would ignore the default numeric formatting.

  • Bug Fix. Structured references with text formatting could be saved wrong to new xlsx files.

  • Bug Fix. Rotated labels in charts could a little below or above from where they should go.

  • Bug Fix. FlexCel could fail to parse a formula where the sheet name started with some Unicode characters, like for example "※MySheet"

  • Bug Fix. When reading structured references in Virtual Mode, the structure reference text would be wrong since it wasn't calculated until after the sheet was loaded.

  • Bug Fix. FlexCel didn't preserve or render text linked to cells in shapes inside charts.

  • Bug Fix. FlexCel would allow you to name a sheet starting with a single quote ('), and that would cause an invalid file. Now the quote at the start of the name will be replaced by a "_" as other invalid characters do.