Bug 156375 - cell formatting from calc/excel is wrong in writer
Summary: cell formatting from calc/excel is wrong in writer
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
7.5.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-07-19 10:23 UTC by johnks
Modified: 2023-07-19 14:32 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
.odt output file (12.28 KB, application/vnd.oasis.opendocument.text)
2023-07-19 10:24 UTC, johnks 		Details
input file to be opened in calc and excel (9.91 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-07-19 10:24 UTC, johnks 		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 johnks 2023-07-19 10:23:29 UTC 
Description:
copying cells from excel or calc and pasting into writer .odt is not 1:1.

this is not  a problem with calc or excel because both work 1:1 on the same data so this must be problem in writer

Steps to Reproduce:
1. open .xls file in calc or excel. both produce different results in writer
2. open .xls file in calc, copy the cells and paste in writer .odt file and compare
3. open .xls file in excel, copy the cells and paste in writer .odt file and compare.
4. open xls file in excel or calc and copy paste to another .xls file saved in the other software and compare. only this one is 1:1

Actual Results:
cell formatting does not get shown in writer. 

Expected Results:
cell formatting should be shown same as in excel and calc. 


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.5.4.2 (X86_64) / LibreOffice Community
Build ID: 36ccfdc35048b057fd9854c757a8b67ec53977b6
CPU threads: 12; OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded

excel 2019
Comment 1 johnks 2023-07-19 10:24:09 UTC 
Created attachment 188465 [details]
.odt output file
Comment 2 johnks 2023-07-19 10:24:35 UTC 
Created attachment 188466 [details]
input file to be opened in calc and excel
Comment 3 Rafael Lima 2023-07-19 14:30:58 UTC 
I believe this is a duplicate of bug 142544.
Comment 4 Rafael Lima 2023-07-19 14:32:31 UTC 
(In reply to Rafael Lima from comment #3)
> I believe this is a duplicate of bug 142544.

Well actually not a dupe, but rather a similar request... bug 142544 requests the same for Impress, whereas this ticket requests to retain cell formatting in Writer.