[Libreoffice-bugs] [Bug 120190] New: Data "Formula to Value" don't preserve line break with multi-line text value

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 120190
           Summary: Data "Formula to Value" don't preserve line break with
                    multi-line text value
           Product: LibreOffice
           Version: 6.0.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: chdeul1823 at gmail.com

When you try to use Data "Formula to Value" , it don't preserve line break with
multi-line text value.

At UI level : the rendering becomes different and not lisible, it's a very
severe issue, because this is a very frequent case ...

To reproduce , simply enter un text with line breaks (Ctrl enter) in a cell,
in a second cell , create a formua   =1st Cell,

Then call  menu Data / Compute / formula to value : you see the problem

In xml content of Saved file : 
original value is : 
<text:p>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa</text:p>
<text:p>Bbbbbbbbbbbbbbbbbbbbbbb</text:p>
<text:p>Cccccccccccccccccccccc</text:p>


replace value is :
<text:p>aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
<text:line-break/>Bbbbbbbbbbbbbbbbbbbbbbb
<text:line-break/>Cccccccccccccccccccccc
</text:p>

It is coherent

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180929/d10faf93/attachment.html>