Infragistics.Documents.Excel is somehow not recognizing an xlsx file that has columns referencing an external xlsm file in a formula. Before I dig in further to see what is wrong, I just want to confirm if this scenario is supported.
Thanks,
Hello Joseph,
My team and I have done an initial review of this thread, and I am a little confused on what exactly is not being recognized in this case. Is the .xlsx file failing to load, or is the formula referencing the external .xlsm file not being evaluated? In either case, are you receiving any sort of exception when trying to do this? If so, what is the exception you are seeing?
Please let me know if you have any other questions or concerns on this matter.
Here is the exception;
Infragistics.Documents.Excel.FormulaParseException: A function in the formula has no closing parenthesis. Portion with error: VLOOKUP($D6,[1]
Here is a sample formula for one of the cells;
=IF($D6="","",VLOOKUP($D6,'C:\Users\...\Documents\Product.Group.Pricing\cedar.boards.xlsm'!margin_table[#Data],MATCH([@Q],'C:\Users\...\Documents\Product.Group.Pricing\cedar.boards.xlsm'!margin_table[#Headers],0),FALSE))
... - represents 40 chars redacted text