Bug 156375 - Font color not copied from Calc to Writer
Summary: Font color not copied from Calc to Writer
Status: NEW
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: https://ask.libreoffice.org/t/formatt...
Whiteboard:
Keywords:
Depends on:
Blocks: Cut-Copy
  Show dependency treegraph
 
Reported: 2023-07-19 10:23 UTC by johnks
Modified: 2024-06-01 04:26 UTC (History)
4 users (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

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.
Comment 5 Wolfgang Jäger 2023-07-25 10:09:23 UTC
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.
Comment 6 Alistair Saywell 2023-07-25 10:48:16 UTC
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
Comment 7 Wolfgang Jäger 2023-07-25 11:19:28 UTC
(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.
Comment 8 Stéphane Guillou (stragu) 2023-08-02 17:51:49 UTC
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?
Comment 9 johnks 2024-06-01 04:26:05 UTC
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