Bug 66574 - FORMATTING: Formatting transformation when copy-paste
Summary: FORMATTING: Formatting transformation when copy-paste
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
Reported: 2013-07-04 06:42 UTC by pierre-yves samyn
Modified: 2017-10-11 18:24 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Demonstrate the bug 66574 (13.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-21 19:03 UTC, Pierre-Alain Dorange

Note You need to log in before you can comment on or make changes to this bug.
Description pierre-yves samyn 2013-07-04 06:42:56 UTC
Can't reproduce the problem each time. 

Sometime when copying a part of text from a source cell and paste it into another cell, the text pasted was transformed (often font size change and sometime font itself change).

It's more reproductible when :
- the source cell is a fusion (several cells into one)
- the destination and source cell has not the same formatting (before copy-paste)
- the copy text is only a part of the source text
- the source cell contain a text with different formatting (font size different)

Actual result:
Often the paste text change it size and sometime its font

Expected result:
the pasted text keep its original formatting (font, size, color...)
Platform: Mac OS X
Version: release
Comment 1 Joel Madero 2014-01-17 03:46:25 UTC
Please attach a document that you at least kind of can reproduce this with and tell us how to attempt on that document.

Marking as NEEDINFO - once you attach a document please mark the bug as UNCONFIRMED and we will try to reproduce. Thanks!
Comment 2 pierre-yves samyn 2014-01-17 08:57:46 UTC
Hello Joel

(In reply to comment #1)
> Please attach a document that you at least kind of can reproduce this with
> and tell us how to attempt on that document.

I submitted this bug but it was a translation of one submitted in french via the BSA.
I do not reproduce (but I do not use the same platform).
The author never added details. I would agree to close this bug.

Comment 3 Joel Madero 2014-01-17 15:46:18 UTC
:) If the user comes back, we'll try to get a document out of them. Thanks!
Comment 4 Pierre-Alain Dorange 2014-01-21 19:03:44 UTC
Created attachment 92538 [details]
Demonstrate the bug 66574
Comment 5 Pierre-Alain Dorange 2014-01-21 19:06:31 UTC
Sorry to be late, but i except this sample will show the "bug" (rather unexcepted result).
Samply copy the "Example" word from Source (Times 14 Red) and paste into destination1 (originnaly Arial 10 Black).
I got a "Example" word but in Arial 14 Red...

I except :
- Arial 10 Black (same as destination1)
- Times 14 Red (same as source)

But not a mix of the two format...

(sorry for my poor english, i'm french)
Comment 6 pierre-yves samyn 2014-01-22 13:51:11 UTC

Thank you for the document. I understand now & reproduce

The feature is not consistent with writer.

(I'm afraid my English is not better than yours...)

Comment 7 Joel Madero 2014-11-06 03:11:57 UTC
Moving to NEW as that's the appropriate status. Thanks!
Comment 8 QA Administrators 2015-12-20 16:15:52 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2017-01-03 19:49:21 UTC Comment hidden (obsolete)
Comment 10 Zineta 2017-10-11 13:17:34 UTC
Tested with:

OOo 3.3.0,LO 3.3.0  Mixed: Ariel,16,red,bold,italic (Inherited from OOo)

LO 5.2 same as destination1 (Ariel,10,black)

LO 6.0 the pasted text keep its original formatting (font, size, color...)
The behaviour in LO 6.0 as expected.So I think it's fixed.
Comment 11 Thomas Lendo 2017-10-11 18:24:35 UTC
As described in https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/RESOLVED#FIXED if a particular commit and a whiteboard status are missing then the correct status is RESOLVED WORKSFORME.