Consider equal sign as value not formula

Aspose.Cells Product Family
1

I have a data which has equal, plus signs as values. So when I am converting my data into CSV it shows “=A1” as formula and not simple value(which I understand is correct in excel terms) But I don’t want it to be considered as formula but just plain text.
Is there any way to do it?

I have tried multiple options like, but nothing worked :
LoadOptions opts = new LoadOptions(LoadFormat.CSV)
{
ParsingFormulaOnOpen = false
};

2

By default we do not take the value which starts with equal sign as formula when importing csv. If you do find the value has been parsed as formula by default, please provide us your test case which can reproduce the issue and we will investigate it.

If what you need is to find the way to parse such kind of values as formula, please use TxtLoadOptions with true value for HasFormula property.