Bug 153518 - Paste as RTF from Excel to Calc pastes only first color in a cell with mixed colors
Summary: Paste as RTF from Excel to Calc pastes only first color in a cell with mixed ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.0.0 alpha0+
Hardware: All All
: low normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:rtf
Depends on:
Blocks: Paste-From-MSO RTF-Paste
  Show dependency treegraph
 
Reported: 2023-02-10 12:01 UTC by Timur
Modified: 2023-02-24 13:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Excel XLSX (9.31 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-02-10 12:01 UTC, Timur
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Timur 2023-02-10 12:01:35 UTC
Created attachment 185282 [details]
Excel XLSX

Open attached XLSX in Excel (note colors).
Copy A1-A3 and paste to Calc, see it the same.
Paste as RTF, see just single color in A3 and other colors missing.
Comment 1 ady 2023-02-10 15:08:08 UTC
(In reply to Timur from comment #0)
> Paste as RTF, see just single color in A3 and other colors missing.

Calc > Paste Special > Paste Special > RTF.

The background color of A1 is different.
In A3, the font color of the first word seems OK, the rest of the text in that cell is not.


BTW, I know from bug 150598 that some improvements were made to Calc in relation to _background_ colors while importing xls(x). Which version of Calc was initially used?

FWIW, in bug 153392 the text within cells also uses different properties (instead of one and the same set of font properties for the entire cell's content.

I think I saw some other recent bug report in this same direction (text within cell with different properties), but I wasn't able to find it now before posting.
Comment 2 Timur 2023-02-15 15:19:46 UTC
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9d44236a62bf59d120dda89924d0d1407b2bd52b
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Comment 3 Stéphane Guillou (stragu) 2023-02-24 13:08:56 UTC
Reproduced with:

Version: 7.5.0.3 (x86) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: ab20dba30769a5a52830220daa347772485db6a2
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded

Regarding the issue ady mentioned:

For cell A1, colour in Excel is #DDEBF7 but is changed to #CCFFFF in Calc. Worse in Writer, the background colour is black (#000000).
This is regardless of if RTF paste is used, and needs a different report if it doesn't already exist.