https://bugs.documentfoundation.org/show_bug.cgi?id=120190

Mike Kaganski <mikekagan...@hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |er...@redhat.com

--- Comment #9 from Mike Kaganski <mikekagan...@hotmail.com> ---
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.

Reply via email to