Bug 138477 - FILEOPEN XLSX: Wrong string displayed in Calc cell (strange "_x000D_" is appended)
Summary: FILEOPEN XLSX: Wrong string displayed in Calc cell (strange "_x000D_" is appe...
Status: RESOLVED DUPLICATE of bug 118470
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-11-25 08:14 UTC by Kevin Suo
Modified: 2021-01-26 11:49 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
test xlsx file (7.96 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-11-25 08:14 UTC, Kevin Suo
Details
Comparison LibreOffice 7.1 master and MSO 2010 (106.39 KB, image/png)
2020-11-25 11:28 UTC, Xisco Faulí
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2020-11-25 08:14:23 UTC
Created attachment 167552 [details]
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.
Comment 1 Xisco Faulí 2020-11-25 11:28:28 UTC
Created attachment 167557 [details]
Comparison LibreOffice 7.1 master and  MSO 2010
Comment 2 Xisco Faulí 2020-11-25 11:30:52 UTC
Reproduced in

Version: 7.1.0.0.beta1+
Build ID: e2cffcf55b04838abc7497f6c18518c7600b670b
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 5.7; Render: default; 

Version: 4.3.0.0.alpha1+
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

Version: 4.1.0.0.alpha1+
Build ID: 54a1feb9b9bd654774b9aa60cda7ef9a1cd1106
Comment 3 m_a_riosv 2020-11-25 14:36:06 UTC
This is how looks in the file.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="1" uniqueCount="1"><si><t xml:space="preserve">select m.*&#10;from&#10;(select fa as fout,1000 as fout_menge,fd as fdate,fg as finput,fk as finput_menge ,&#10;fa || &apos;_&apos; || to_char(fd,&apos;yyyyMM&apos;) as fparent, fg || &apos;_&apos; || to_char(fd,&apos;yyyyMM&apos;) as fsub&#10; from CTF_SAP_BOM where FI = &apos;M&apos; AND fk&gt;0&#10; )&#10; m&#10;start with ( m.fout like &apos;82%&apos; )&#10;&#10;connect by prior m.fsub = m.fparent</t></si></sst>

Seems the line feed '&#10' is not well imported, but if I'm not wrong for windows should be &#13&#10
Comment 4 Andras Timar 2021-01-26 11:49:52 UTC

*** This bug has been marked as a duplicate of bug 118470 ***