using the Function Wizard if a function uses just a cell content as argument, it's normal that now it retrns an interval?
Example: in a cell A1 I write the function Today() and in cell B1 want to extract just the year. Using the Function Wizard I obtain the following output: Year(A1:A1) while with all previous LO versions the result was simply Year(A1).
Why this new Function Wizard single cell working? Considering that both Year(A1:A1) and Year(A1) works good and produce the same correct result, why to use the 1st one?
Confirmed, the result in the input bar is =YEAR(.A1:A1), if works correctly without the function wizard i.e. entering =YEAR() directly in the cell.
Build ID: 1a27be92e320f97c20d581a69ef1c8b99ea9885d
Works well with Version: 22.214.171.124
Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a
So regression confirmed. - Set as New - added regression to Whiteboard - Changed Plateform - Sophie
Looks very much related to bug 73235, taking.
Resolved with fix for bug 73235.