Is Xamarin XlsIO support macro formulas in the imported Excel?
formula is :=VLOOKUP(pt,'Table A'!$C$45:$R$74,14)
I have requirement like..
1. Excel file with extension .xlsm (macro formula supported excel file). Am imported local excel and edited some cell values and get value of another output cell(cell with macro formula) its returns zero value. So here the maraca formula not working.
2. Unable to create new excel using with same local excel the Hangs while "SaveAs" method.
SSSridhar Sukumar Syncfusion Team March 17, 2017 12:43 PM UTC
Thank you for contacting Syncfusion support.
We have tried with shared code snippet and are unable to reproduce the issue. We suspect that issue is reproduced from the “122L085V03-AYSA.xlsm” Excel macro file. We request you to share us the Excel macro file which will be helpful for us to give you a prompt solution at earliest.