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:

Or this NuGet package:
Install-Package GemBox.Spreadsheet -Version 47.0.1238-hotfix

Does this solve your issue?


Mario, Yes this fixes the CONCAT issue, thanks.