Hi!
I'm using Advanced Excel to create a dynamic template-based report and I found out that R1C1 reference notation throws errors in formulas created and calculated by the component.
For instance, formulas like =SUM(INDIRECT("A1:A3")) work perfectly, but =SUM(INDIRECT("R1C1:R3C1"; FALSE)) works only if I write it as text and then evaluate manually after downloading.
Is that a bug or out of scope?
Hi @Daryna Kravets
It could be that the INDIRECT function is not supported in the version of EPPlus we are using, or that the R1C1 notation is the issue but we'll need to look into it and confirm.
Hanno
Reading your post again I see that you have confirmed that INDIRECT already works but when you use R1C1 notation it does not.