Open retsyo opened 1 year ago
System.InvalidOperationException: formula in specified cell contains errors, correct the formula firstly
The exception says that there is incorrect formula in the cell, can you please find out the formula and post here?
I have simplified my excel file which can be opened by MS Excel without incorrect formula rendering. In other words, I can't find out the wrong formula, so I attached the file here. not_working_one.xlsx
Could ReoGrid display which cell on which sheet has bad formula, or could ReoGrid render excel file even there is bad formula just like Excel does?
thanks
any news?
The simple code just do
reoGridControl1.Load(fn)
. For one of my excel's xlsx file, reogrid works and loads sheets without problem. But for another xlsx file, I recievedSorry, since the excel file is a private file, I can't attach it here. I know it is hard to tell the reason if I does not supply a sample file, but is there a way to let reogrid say which formula is bad? I know nothing about C# and do not know how to compile reogrid from source, so a debug version of unvell.ReoGrid.dll, which can display which formula is processing, is appreciated
Sorry again, the code is simple and is in pythonnet
thanks