[Libreoffice-bugs] [Bug 138477] New: FILEOPEN XLSX: Wrong string displayed in Calc cell (strange "_x000D_" is appended)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138477
           Summary: FILEOPEN XLSX: Wrong string displayed in Calc cell
                    (strange "_x000D_" is appended)
           Product: LibreOffice
           Version: 7.1.0.0.alpha1+
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: suokunlong at 126.com

Created attachment 167552
  --> https://bugs.documentfoundation.org/attachment.cgi?id=167552&action=edit
test xlsx file

Steps to Reproduce:
1. Open the attached xlsx file.
2. Observe the text in the cell.

Current Result:

"""
sselect m.*_x000D_
from_x000D_
(select fa as fout,1000 as fout_menge,fd as fdate,fg as finput,fk as
finput_menge ,_x000D_
fa || '_' || to_char(fd,'yyyyMM') as fparent, fg || '_' || to_char(fd,'yyyyMM')
as fsub_x000D_
 from CTF_SAP_BOM where FI = 'M' AND fk>0_x000D_
 )_x000D_
 m_x000D_
start with ( m.fout like '82%' )_x000D_
_x000D_
connect by prior m.fsub = m.fparent
"""

Expected Result:

"""
select m.*
from
(select fa as fout,1000 as fout_menge,fd as fdate,fg as finput,fk as
finput_menge ,
fa || '_' || to_char(fd,'yyyyMM') as fparent, fg || '_' || to_char(fd,'yyyyMM')
as fsub
 from CTF_SAP_BOM where FI = 'M' AND fk>0
 )
 m
start with ( m.fout like '82%' )

connect by prior m.fsub = m.fparent
"""

Version 7.1 alpha1+ and 6.4.7.2 release.

-- 
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/20201125/428ce224/attachment.htm>