Hello,
There is a "#REF!" error in a cell with formula "=INDIRECT("C[+1]"; FALSE)" . Excel runs this formula with no error.
Thank you
SpreadsheetControl does not recognize the plus sign in the INDIRECT function's arguments if the R1C1 type of reference is used
Answers approved by DevExpress Support
We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.
Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.
- v16.1.4Download Official Update
- v15.2.5Download Official Update
- v15.1.10Download Official Update
Hello Dmitry,
I've reproduced the issue and passed this ticket to my team. Our developers will research this issue in detail. We will get back to you once we have any results.
In the meantime, you can avoid the issue if remove the plus sign in this formula.