Bug 55954 - Font overridden by style sheet when pasting Writer RTF as cells
Summary: Font overridden by style sheet when pasting Writer RTF as cells
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: RTF-Paste
  Show dependency treegraph
 
Reported: 2012-10-13 15:44 UTC by bugquestcontri
Modified: 2025-06-18 13:51 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
the calc file used as paste target, I will try to add the the original writer file in bugzilla (11.25 KB, application/vnd.oasis.opendocument.text)
2012-10-13 15:44 UTC, bugquestcontri
Details
the orignal file from where I copied Japanese text (10.01 KB, application/vnd.oasis.opendocument.text)
2012-10-13 15:47 UTC, bugquestcontri
Details
new test - ods test file (23.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-04-21 10:55 UTC, bugquestcontri
Details

Note You need to log in before you can comment on or make changes to this bug.
Description bugquestcontri 2012-10-13 15:44:52 UTC
Created attachment 68525 [details]
the calc file used as paste target, I will try to add the the original writer file in bugzilla

Problem description: 
copy & paste of Japanese text from writer to calc shows inconsistency opf the paste results depending on the paste methode (pasting directly into cells or pasting into the input line). Details are to be seen in the attached files

Steps to reproduce:
1. copy a Japanese text in writer
2. paste directly into a cell in calc creates a too small font neither matching the font in writer nor default in calc, color is black
3. paste into the input line creates the same font result but color is gray. 
4. when increasing the font size in calc overlapping of Japanese characters occure depending on the width of the column (this can be seen in the attached calc sheet when changing the column width)

Current behavior:
as described above
The same issue should appear with all double byte word languages (Japanese, Chinese, Korean, Thai etc...)

Expected behavior:
when pasting Japanese from writer into calc the font should be as in writer or as the default font in calc (type, size, color)

I can be contacted for question: bugquestcontri@online.de

Platform (if different from the browser): 
LO 3.5.6.2 XP SP3
              
Browser: Mozilla/5.0 (Windows NT 5.1; rv:16.0) Gecko/20100101 Firefox/16.0
Comment 1 bugquestcontri 2012-10-13 15:47:39 UTC
Created attachment 68526 [details]
the orignal file from where I copied Japanese text
Comment 2 Urmas 2012-11-24 03:45:03 UTC
The font face and size still don't match the copied text properties with 4.0-master.
Comment 3 bugquestcontri 2013-04-15 02:16:50 UTC
Just made a test in Version 3.6.5.2 (Build ID: 5b93205)

Font in Writer: MS Mincho 10.5 pts

ctrl+C in Writer and ctrl+V in Calc
 - direct into cell gives format MS PGothic 6.8 pts
 - input line gives Lucidia Sans 6.8 pts

Font color is in both cases black as original text.
Comment 4 bugquestcontri 2014-09-27 14:19:51 UTC
As the last test was made in an rather old LibO version, I made a test in Version: 4.2.6.2
Build ID: 185f2ce4dcc34af9bd97dec29e6d42c39557298f
XP/SP3

Writer font: MS Mincho 10.5
ctrl+ c in Writer
- ctrl+v in Calc directly into cell; MSP Gothic 10
- ctrl+C in Calc in input line: Segoe UI 6.8


In both cased the text is wrapped into the cell which is according my default style of the alignment

Changing the cell alignment to NOT warp
Writer font: MS Mincho 10.5
ctrl+ c in Writer
- ctrl+v directly into the call: MSP Gothic 10 and wrapped into the cell
- ctrl+v into the input line: Segoe UI 6.8 and not wrapped into the cell


Hope my comment helps.
Comment 5 Matthew Francis 2015-04-07 11:46:14 UTC
The issue occurs with the attached file back to OOo / LO 3.3.0

I haven't yet been able to reproduce it from scratch, but I can see that for some reason in the case of pasting into the Calc input line, the font selected is the CTL font from the paragraph style rather than the CJK font

-> Version: Inherited from OOo
Comment 6 bugquestcontri 2015-04-21 10:55:08 UTC
Created attachment 114986 [details]
new test - ods test file

I made new test in v 4.3.6.1 on an XP machine. 
The bug is still there. 
For details look into the file. 
I added a screenshot (it is inside the ods-file) of the wrong font to avoid that  opening on a different LibO version does not change the situation.
Comment 7 QA Administrators 2016-09-20 09:34:03 UTC Comment hidden (obsolete)
Comment 8 madmalkav 2016-12-10 11:40:17 UTC
I just tried and the bug persists in 5.3.0 beta1. I copy/pasted a table with both spanish and japanese texts and only the japanese ones are suffering the problem.
Comment 9 QA Administrators 2017-12-11 08:53:39 UTC Comment hidden (obsolete)
Comment 10 madmalkav 2018-01-13 16:32:59 UTC
Bug persists.

Version: 6.0.0.2 (x64)
Build ID: 06b618bb6f431d27fd2def25aa19c833e29b61cd
CPU threads: 8; OS: Windows 10.0; UI render: default; 
Locale: es-ES (es_ES); Calc: group
Comment 11 QA Administrators 2019-01-14 03:51:56 UTC Comment hidden (obsolete)
Comment 12 Mark Hung 2020-10-23 23:15:29 UTC
Still reproducible in 

版本:6.4.6.2 (x64)
組建 ID:0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU 執行緒:16; OS:Windows 10.0 Build 18363; UI 算繪:GL; VCL: win; 
語言地區:zh-TW (zh_TW); 介面語言:zh-TW
Calc: CL
Comment 13 Mark Hung 2020-11-22 11:24:04 UTC
Change it back to NEW - as I mistakenly set it to RESOLVED.
Comment 14 Xisco Faulí 2021-03-31 13:48:22 UTC
Dear Mark Hung,
This bug has been in ASSIGNED status for more than 3 months without any
activity. Resetting it to NEW.
Please assign it back to yourself if you're still working on this.
Comment 15 QA Administrators 2023-04-01 03:23:32 UTC Comment hidden (obsolete)
Comment 16 QA Administrators 2025-04-01 03:21:11 UTC Comment hidden (obsolete)
Comment 17 Jonathan Clark 2025-06-18 13:51:47 UTC
This bug is not specific to CJK.

When pasting formatted text outside of cell edit mode, Calc overrides the font with stylesheet attributes. This happens for all languages/script types, including English. The code that does this is around sc/source/filter/rtf/eeimpars.cxx:328, at time of writing.

This is fixable, but I'm not sure if it's unintentional.