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
Created attachment 188465 [details] .odt output file
Created attachment 188466 [details] input file to be opened in calc and excel
I believe this is a duplicate of bug 142544.
(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.
You may also throw a glance on this Q&A topic and my (Lupp's) comment there: https://ask.libreoffice.org/t/formatting-loss-pasting-from-spreadsheet-to-text-doc/93951.
From Calc, if I click Edit > Paste special > Paste special > HyperText Markup Language (HTML) then the full formatting is pasted into Writer as a table with all font colours, background colours, italics and bolding. So it is possible, just doesn't do it for default paste
(In reply to Alistair Saywell from comment #6) > From Calc, if I click > Edit > Paste special > Paste special > HyperText Markup Language (HTML) > then the full formatting is pasted into Writer as a table with all font > colours, background colours, italics and bolding. > > So it is possible, just doesn't do it for default paste Doesn't work for me (and would be gravely misleading, imo). For me ordinary pasting does the job if exactly one cell from a Calc sheet was copied. Having copied a true range No Paste Special... option preserves the formats - except the full insertion as an OLE object.
There are other bug reports about formatting not being copied across between Calc cells and a Writer table when they actually could. - strikethrough text: bug 155019 - background colour: bug 149661 I guess what isn't already covered (unless I haven't found the report) is the red font colour in your example. I think it would be a good idea to focus this report on the font colour, so we have focused tasks that are more actionable?
copied from calc to excel. zero formatting on normal paste. on paste special> html, then full formatting and all features get pasted. including red color Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1 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