“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,
Thank you for the file. I was able to get around the error by removing from the' Formulas' tab => 'Name Manager' => delete 'Print_report'. So I guess that the error comes from that reference. Please check it out and let me know of the results.
Yes , file processed successfully after removing the 'Print_report', but what is the wrong with the 'Print_report' Name manager. (='P:\DATA\EXCEL\SAPUPLOD\ME-04-97.XLS'!Print_report)
Secondly, Infragistic Excel dll should have to handle this error gracefully and processed the file with out throwing any error.
Would you please raise a ticket to fix this?
Thanks!
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.
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.
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.