https://bugs.documentfoundation.org/show_bug.cgi?id=120190
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #9 from Mike Kaganski <[email protected]> --- Consider the formula in A1: =1&CHAR(10)&2 Converting "Formula to Value", the visible result in the cell is "12", but the formula bar has the two lines. And "=LEN(A1)" gives 3. This is beautifully explained in comment 0, where paragraph-vs-linebreak difference is discussed. -- You are receiving this mail because: You are the assignee for the bug.
