“The formula must start with an equals sign. Portion with error: #REF!”
Hello GarthGrainger,
This means that you have a reference or formula which does not start with an equals (=) sign. I took some time to review your workbook, removed all references and formulas from 'GFE' sheet and it was still throwing this exception. I discover that there is an 'ADMIN' sheet which is protected by password. It also has references and formulas but I was not able to modify it in any way. Please try removing the formulas from the second sheet and let me know of the results.
I have unlock the attached Data File.
Hello awdhes,
Yes, this issue has been fixed in the latest service releases of versions 12.1 and 12.2 of NetAdvantage for Windows Forms. Please try it out.
Is the issue releted to case 'CAS-100109-W8N8G7' has been resolved, if yes then which version of ingragistich DLL have those fixed.
Hello,
I created the following case for you: 'CAS-100109-W8N8G7 ' and will update you through it.
Code to reproduce the error :-
Workbook excelBook1 = Workbook.Load(file, false);
Sample Data file is attached.
If I am going to raise a ticket for this I will need a very simple(as it can be) sample which reproduces this issue. I will create the project but I am not able to create an xlsx file which would case this issue. This is why I am not able to log this. Could you please try to create such file yourself, simple, clean, which reproduces the behavior.