facebooktwittermenuarrow-up

GemBox Support Forum

Cell Formula CONCATENATE function

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.