This issue to report a bug with the XLParser Library not being able to parse the OFFSET formulas in excel.
An example of the OFFSET formula is as follows:
=OFFSET('Sheet Name'!$D$1,MATCH($D7,'Sheet Name'!$D:$D,0)-1,1,COUNTIF('Sheet Name'!$D:$D,$D7),1)
The library currently parse the formula as a token of cell ranges but completely ignores the individual numeric values such as 1 used in the third and fifth argument parameters in this list.
Furthermore the -1 offset in second parameter of the formula in MATCH is also completely ignored along with the MATCH word itself which might be required by a user to know if a nested formula is present in the main formula or not and do further processing on it accordingly.
I hope this issue can be taken a look at and if possible be resolved. Thank you for your time and consideration to this issue.
Kind regards,
This issue to report a bug with the XLParser Library not being able to parse the OFFSET formulas in excel.
An example of the OFFSET formula is as follows:
=OFFSET('Sheet Name'!$D$1,MATCH($D7,'Sheet Name'!$D:$D,0)-1,1,COUNTIF('Sheet Name'!$D:$D,$D7),1)The library currently parse the formula as a token of cell ranges but completely ignores the individual numeric values such as
1used in the third and fifth argument parameters in this list.Furthermore the
-1offset in second parameter of the formula inMATCHis also completely ignored along with theMATCHword itself which might be required by a user to know if a nested formula is present in the main formula or not and do further processing on it accordingly.I hope this issue can be taken a look at and if possible be resolved. Thank you for your time and consideration to this issue.
Kind regards,