We are pleased to announce the release of FlexCel Studio for VCL & FMX 7.15.
To be notified of new releases open Topics tagged flexcel-vcl-release and watch the tag.
New in v 7.15 - July 2022
-
Experimental Lazarus support. We now experimentally support compiling in Lazarus. See the new Lazarus guide for more details.
-
Support for functions FILTER, SORT, SORTBY, and UNIQUE. There is now support for the functions introduced in office 2021 : FILTER, SORT, SORTBY, and UNIQUE.
-
Support for functions MAP, REDUCE, SCAN, MAKEARRAY, BYROW, and BYCOL. There is now support for the functions introduced in office 365 : MAP, REDUCE, SCAN, MAKEARRAY, BYROW, and BYCOL.
-
Support for functions TEXTBEFORE, TEXTAFTER, TEXTSPLIT, HSTACK, VSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS, and EXPAND. There is now support for the new functions introduced in office 365 beta : TEXTBEFORE, TEXTAFTER, TEXTSPLIT, HSTACK, VSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS, and EXPAND.
-
New SHEET VISIBLE tag that allows to change the visibility of a sheet in a report. You can now use the new Sheet Visible tag to hide or unhide sheets. See https://support.tmssoftware.com/t/hide-worksheet-in-report-tags/18336/2
-
You can now run reports on TList<primitive> like TList<double>. Now you can use a list of a primitive type like TList<string> in reports. You have to write <#list.Value> in the template for it to work. See the modified example of using lists as datasets. See https://support.tmssoftware.com/t/using-list-as-datasource/18513/4
-
Ability to change the newline separator when exporting to CSV or Fixed-lenght text files. By default FlexCel exports to CSV or fixed length using the newline separator from the OS. (that's CR/LF in Windows and LF in Unix/macOS). Now you can explicitly define the newline string when calling Export See https://support.tmssoftware.com/t/settings-for-new-line-character-when-saving-texcelfile-to-csv/17886/3
-
Support for Array formulas, UDFs, external names and Lambda names in Tokens. Tokens now support Array formulas, user-defined functions (UDF), names that refer to external files, and Lambda names (like if you write in a formula "=MyName(4)" and MyName is a lambda function.). Standalone lambda functions (without using names) were already supported. The only thing not supported in tokens right now is what-if tables.
-
Function "INDEX" is now array-enabled. Now you can pass arrays in the col and row parameters of the INDEX function and FlexCel will return an array of results.
-
Improved behavior when inside Docker containers. Now when you try to run FlexCel in a Docker container without any fonts installed, FlexCel will tell you the problem and how to fix it. There is also a new tip explaining how to handle fonts inside docker containers.
-
Bug Fix. The functions SWITCH and IFS could fail is some border cases.
-
Bug Fix. Bubble charts could render bubbles of the wrong size if there were empty points in the chart data with bubble size different from 0.
-
Bug Fix. Negative dates now show empty instead of "########" when they are labels of charts. This is the behavior Excel has too.
-
Bug Fix. Cells with diagonal borders, but borders style set to none could be rendered by FlexCel in some cases.
-
Bug Fix. Some files containing khmer characters (or other complex scripts) could raise an exception when exporting to pdf.
-
Bug Fix. Sometimes RenderObjects would not render the images. See https://support.tmssoftware.com/t/images-disappear-sometimes/18567/6
-
Bug Fix. There could be errors in some specific cases when copying sheets from one file to another which had linked formulas.
-
Bug Fix. The limit for custom formats in xls files was in 4000 when it really is 4050. We've updated FlexCel to allow 4050 custom formats when saving as xls.
-
Bug Fix. The TYPE function didn't return 128 for lambda functions.
-
Bug Fix. When third-party files had invalid modify/creation dates, FlexCel would refuse to open them. Now it will just ignore invalid dates and let those properties empty.
-
Bug Fix. APIMate generated some code with invalid syntax in C++.