https://bugs.documentfoundation.org/show_bug.cgi?id=170278
Bug ID: 170278
Summary: BYROW function of MS office 365 shows #NAME? error in
LibreOffice Viewer
Product: LibreOffice
Version: 25.8.3.2 release
Hardware: All
OS: Android
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Android Viewer
Assignee: [email protected]
Reporter: [email protected]
Description:
I created a xlsx file by MS office 365 and when I open it by LibreOffice
Viewer, I get #NAME? error for the formula entered.
Enhancement request:
I find that BYROW and LAMBDA functions are not available in LibreOffice Calc.
These functions are very useful for writing a single cell formula for a spill
range, and one doesn't need to fill down formulas in the entire range like old
versions of Excel.
Also, to insert rows within the range becomes easier and one doesn't need to
re- fill down formulas for the inserted rows.
Google Sheets have already provided these functions.
Steps to Reproduce:
1. A1=1 A2=2 A3=3 B1=2 B2=3 B3=5
2. Formula in C1 =BYROW(A1:B3,LAMBDA(a,SUM(a)))
3. This formula creates a spill range of C1:C3.
Actual Results:
C1=#NAME? C2=#NAME? C3=#NAME?
Expected Results:
C1=3 C2=5 C3=8 (row-wise sum of the range A1:B3)
Reproducible: Always
User Profile Reset: No
Additional Info:
"BYROW" function changes how you write formulas. It is a versatile tool that
allows you to apply a specified function to each row of an array or range.
--
You are receiving this mail because:
You are the assignee for the bug.
