Bug 135311 - Incorrect data is shown in cell when opening sheet created in Word Online
Summary: Incorrect data is shown in cell when opening sheet created in Word Online
Status: CLOSED DUPLICATE of bug 118470
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: filter:ooxml
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-30 11:31 UTC by Radomir Terber
Modified: 2020-08-05 21:32 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Sheet File that shows incorrect values in LO (23.85 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-07-30 11:33 UTC, Radomir Terber
Details
How the cell valuess look in Word (77.00 KB, image/png)
2020-07-30 11:35 UTC, Radomir Terber
Details
How the cell values lok in LO (76.25 KB, image/png)
2020-07-30 11:36 UTC, Radomir Terber
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Radomir Terber 2020-07-30 11:31:51 UTC
Description:
The file has been created in Word Online (sharepoint.com) and downloaded. In the cells in column D there weas was unexpected character at end of lines, added by LO

When I edited the document in local installation of excel (from office 365) and saved it - the issue persisted. 

 

Actual Results:
extra characters at the end of rows inside cells

Expected Results:
extra characters are not in place, the text is shown exactly like in word


Reproducible: Always


User Profile Reset: No



Additional Info:
I am adding the file that cause these issues and also screenshots with correct and incorrect look. 

Tested in LO 6.4.2.2 and 7.0.0.beta?
Comment 1 Radomir Terber 2020-07-30 11:33:12 UTC
Created attachment 163762 [details]
Sheet File that shows incorrect values in LO
Comment 2 Radomir Terber 2020-07-30 11:35:47 UTC
Created attachment 163763 [details]
How the cell valuess look  in Word
Comment 3 Radomir Terber 2020-07-30 11:36:35 UTC
Created attachment 163764 [details]
How the cell values lok in LO
Comment 4 V Stuart Foote 2020-07-30 18:58:01 UTC
Confirmed on Windows 10 with 7.0.0rc1
 
The "_x000D_" extra character, would be a Carriage Return.

So, seems a string filter issue.
Comment 5 Eike Rathke 2020-08-05 21:32:36 UTC

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