https://bugs.documentfoundation.org/show_bug.cgi?id=173581
--- Comment #8 from David Lynch <[email protected]> --- I am aware of Step 3 and believe I am using LAMBDA properly. However, to avoid confusion, I attach a spreadsheet showing the bug from an example on the microsoft support pages, example 2 on <https://support.microsoft.com/en-us/excel/functions/byrow-function>. A1:D6 contain data and formulas identical in the Excel example and the Calc attachment. As expected, the results are the same. Column E contains the formulas in column D. D6:D7 add a STYLE function to the formulas in D6:D7. The result is incorrect. D11:D12 contain the same calculations and apply the same STYLE function, but without using a dynamic array function. The result is correct. D6:D7 should be the same as D11:D12. The only relevant difference is that D6:D7 perform the calculation through BYROW()/LAMBDA(). -- You are receiving this mail because: You are the assignee for the bug.
