Forum Discussion
Solved
Excel interop adds @ sign to formulas
Hi, when creating a spreadsheet using Excel interop's and VB.NET I need to add a formula to a cell. for example the filter formula. I add it as =Filter but when it appears on the spreadsheet it ...
I don't have much experience w/ office 365, but it's my understanding there is a range.formula and range.formula2 property - the difference being how excel evaluates the formula (legacy implicit intersection or new dynamic array).
https://docs.microsoft.com/en-us/office/vba/excel/concepts/cells-and-ranges/range-formula-vs-formula2
I don't have much experience w/ office 365, but it's my understanding there is a range.formula and range.formula2 property - the difference being how excel evaluates the formula (legacy implicit intersection or new dynamic array).
https://docs.microsoft.com/en-us/office/vba/excel/concepts/cells-and-ranges/range-formula-vs-formula2
