[Libreoffice-bugs] [Bug 118470] New: Calc doesn't display correctly the newline and carriage return characters

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118470
           Summary: Calc doesn't display correctly the newline and
                    carriage return characters
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: marcos.fdz at gmail.com

Description:
The hex strings "_x000D_" get shown inside Calc cells.
They should be converted and treated as an special character "\r".

Steps to Reproduce:
It's necessary to generate an Excel (XLSX; OOXML) file containing carriage
return and newline characters inside the cells.
It's not possible to generate directly with Excel, since it deletes the "\r"
symbols.

It's necessary to generate it with a library or to edit the "sheet1.xml" inside
the OOXML file.

I generated those XLSX file from a R-lang library:
https://github.com/ropensci/writexl/issues/22


Actual Results:
The hex string "_x000D_" gets shown inside the cells.

Expected Results:
It was expected to transform the hex string "_x000D_" to a real carriage return
inside the cell.
Or, at least, to delete the string "_x000D_".


Reproducible: Always


User Profile Reset: No



Additional Info:
It should check if there is a newline character "\n" just after the "_x000D_"
string. And then delete the "_x000D_" string from the cell.

If there is a "_x000D_" string without a "\n" after, it should transform it
into a newline char.

-- 
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/20180630/c8cee272/attachment.html>