CalculateFormula throws if values are longer than 255 chars


#1

Hi,

This throws invalid formula exception if any of the strings is longer than 255 chars:
new Workbook().Worksheets[0].CalculateFormula("\"String1\"=\"String2\"");

Is there any “compatibility level” that can be set to make it work?

.Net 19.10.0


#2

@FluentDocs,

I tried your formula in MS Excel manually (having a long string) but I got an error e.g “Text values in formulas are limited to 255 characters…”. In short, this is not supported in MS Excel either, so it cannot be accomplished by Aspose.Cells. If you could accomplish the task in MS Excel, give us sample file containing your desired formula (that works fine), save the file and provide us, we will check it soon.