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
View All Add an attachment (proposed patch, testcase, etc.)

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 ***