My existing Excel spreadsheet has many formulas with the concatenation function as CONCAT rather than CONCATENATE spelled out. I’m getting #NAME! errors and was wondering if GemBox.Spreadsheet accepts CONCAT as a function or must it be CONCATENATE? Thanks.
Replying to my own post, my tests show that CONCAT is not currently recognized as a synonym for the CONCATENATE formula function. I hope GemBox will consider adding this to be compatible with Microsoft Excel which allows this.
Hi Bob,
Please try again with this bugfix:
https://www.gemboxsoftware.com/spreadsheet/nightlybuilds/GBS47v1238.zip
Or this NuGet package:
Install-Package GemBox.Spreadsheet -Version 47.0.1238-hotfix
Does this solve your issue?
Regards,
Mario
Mario, Yes this fixes the CONCAT issue, thanks.