Disable Formulas?

[patchcad]

Hello,

Is there a way to disable formulas altogether? So even if content with formulas is pasted from Excel or a string like "=123-2" is entered into a cell, it is treated as the literal string rather than a formula.

Thank you!

[jingwood]

Currently it isn't possible to disable formula feature. If you don't use formula at all, you can use ReoGrid Minimum Build edition - Single DLL edition, which doesn't provide formula feature. So you can put any formula as string into cells.

Input text starts with single quotation (') will be ignored as formula, so an alternative solution is to check the input string of cell, when a formula is inputted, change it to text.

sheet.CellDataChanged += (s, e) =>
{
	var cell = e.Cell;
	if (cell.HasFormula)
	{
		string text = cell.Formula;
		cell.Formula = null;
		cell.Data = "'=" + text;
	}
};

[jingwood]

Provide an option to disable formula feature.