If I enter a bad formula into the WPF XamSpreadSheet, such as "=sum(1+...+50)", I get an endless display of error dialogs and am not able to clear or continue working on the formula. For all practical purposes it locks up our software.
How can I get out of this endless loop.
Richard
Hello Richard,
I am able to get the same behavior with MS Excel as you explained but not with XamSpreadsheet.
To test this scenario i use your excel sheet .BadFormula.xlsx and load it into XamSpreadsheet and not able to reproduce the behavior you described.
I attached my test sample here for your reference , if i am missing something please feel free to modify it and send me back for further investigation.
WpfApp14.zip
I just enter "=sum(1+...+50)" with no commas into excel I get #NAME? in the cell and i retain the ability to edit the formula. In the XamSpreadSheet I get an error dialog which I can exit but when i click on the cell or the top bar to edit the formula to fix it I get the dialog again. I can close it again but anything I do I always get the dialog again and again and again. It happens with any bad formula, you can also use "=sum(" .BadFormula.xlsx
Hello,
Try to use the same formula to MS excel and test what is the behavior you are getting ? Is it different ?
Can you share your excel containing the formula so that i can try to load it into XamSpredSheet to test it or you can also share your own sample to investigation it .