Quote marks in formula adding @ symbol

GemBox.Spreadsheet
1

Hi there,
I am inserting some formulas into a spreadsheet at runtime and have run into an issue with formulas containing quote marks.
When setting the .Formula value in a cell, eg.
ex.Worksheets["ALD"].Cells[3, 1].Formula = " =MAXIFS(PSD!D9:D27,PSD!D9:D27,\"<50\")";
When the Excel file is opened the formula reads as
=@MAXIFS(PSD!D9:D27,PSD!D9:D27,“<50”)

Is there a simple way of handling this that I am overlooking?

2

Hi Kieran,

Please try again with this latest NuGet package:

Install-Package GemBox.Spreadsheet -Version 49.0.1418-hotfix

Does this solve your issue?

Regards,
Mario