ONLYOFFICE
SUM of nested XLOOKUP returns #VALUE! error
This issue is unique.
- [X] I have used the search tool and did not find an issue describing my bug.
Operating System
macOS 10.12 or higher
Version information
8.1.1
Expected Behavior
Sum a dynamic range of values using XLOOKUP:
=SUM(XLOOKUP(lookup,lookup_array,return_array):XLOOKUP(lookup,lookup_array,return_array))
Where each "return_array" is also an XLOOKUP function. So the full formula looks like:
=SUM(XLOOKUP(RowA,Row_Headings,XLOOKUP(ColumnA,Column_Headings,Data)):XLOOKUP(RowB,Row_Headings,XLOOKUP(ColumnB,Column_Headings,Data)))
Named Ranges used for "RowA", "RowB", "ColumnA", "ColumnB" allows the formula to sum a dynamic range of values (see attached).
However, when XLOOKUP is nested like this within SUM, there is #VALUE! error.
Actual Behavior
SUM of nested XLOOKUP returns #VALUE!, even though each nested XLOOKUP function on its own seems to operate correctly.
Reproduction Steps
=SUM(XLOOKUP(RowA,Row_Headings,XLOOKUP(ColumnA,Column_Headings,Data)):XLOOKUP(RowB,Row_Headings,XLOOKUP(ColumnB,Column_Headings,Data)))
Additional information
Hello @cottontail-12, I created ticket #70550 with your issue. When some fixes will be done we'll text you here in this issue. Thank you for the report!
Hello,
@cottontail-12 I'm happy to report that the issue has been fixed and no longer occurs in the release version 8.3.0. This issue has been addressed in the commit. Don't miss updates. Have a good day!
DocumentServer v8.3.0 is released so I close this issue. Feel free to comment or reopen it if you got further questions.