Bug 130506 - Calc to Writer copy paste as LO Spreadsheet does not preserve non-present table style with font color (from comment #18)
Summary: Calc to Writer copy paste as LO Spreadsheet does not preserve non-present tab...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
6.3.4.2 release
Hardware: All All
: low normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-02-07 09:04 UTC by Jim Martin
Modified: 2022-12-02 03:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
LO 6.3.4.2 Writer document containing 1. descrption of 2 issues; 2. steps to produce both issues; 3. screen shots of originals; 4. 4. Writer text document showing displayed problem (315.29 KB, application/vnd.oasis.opendocument.text)
2020-02-07 09:08 UTC, Jim Martin 		Details
LO_test.ods and LO_test.odt (32.37 KB, application/vnd.oasis.opendocument.text)
2020-02-16 04:12 UTC, Jim Martin 		Details
LO Calc .ods file (16.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-02-16 07:24 UTC, Jim Martin 		Details
LO_test_3.odt test file. Result of copy - paste special operation demonstrating problem (14.59 KB, application/vnd.oasis.opendocument.text)
2020-02-18 08:55 UTC, Jim Martin 		Details
LO_test_3.ods (7.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-02-18 08:55 UTC, Jim Martin 		Details
LO_test_3_information_message (184.94 KB, image/png)
2020-02-18 08:56 UTC, Jim Martin 		Details
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jim Martin 2020-02-07 09:04:10 UTC 
Description:
(IS IT POSSIBLE TO UPLOAD AN LO FILE THAT CONTAINS IMAGES OF THE PROBLEM?)

Version: 6.3.4.2
Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU threads: 4; OS: Mac OS X 10.15.3; UI render: default; VCL: osx; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

Two issues:

1. Calc object formatting distorted (screenshot 1) in Writer copy (text example follows).

Began with LO v. 6.3.4.

2. Incorrect popup message requiring a response appears during insertion operation (see screenshot 2).  Only LO Writer and Calc used for create, edit, and save files.

Began with LO v. 6.3 or earlier.


Screenshot 1: original Calc selection (CANNOT UPLOAD SCREENSHOT?) 



Screenshot 2: LO Writer popup message (CANNOT UPLOAD SCREENSHOT?)



Steps that create the problems:

Calc:

1. define selection area cells: AW6 : BD16
2. see screenshot 1 (CANNOT UPLOAD SCREENSHOT?)
3. select copy: CTRL-C
4. Cells are selected: crawling selection border appears

Writer:

1. Page style is “Default Style” with no modifications.
2. Paragraph style is “Default style”
    • Style includes: a) no space (0.00”) before; b) no space (0.00”) after; and c) the “Don’t add space between...” button is not checked.
    • Style modified to use Palatino and SongTC (Chinese Song, traditional character) fonts. 
3. Dummy text entered is complete lines of “Dummy text.  Dummy text.” repeated from beginning to end of line for three full lines, finalized with a CRLF (hard return).

Perform insertion using 2 methods: Place cursor at position 1 in line 2 of dummy text.

Insertion method one

1. Edit → Paste
2. view pop-up message (see screenshot 2) (CANNOT UPLOAD SCREENSHOT?)
3. select “no”
4. results: a) paragraph mark (CRLF) inserted automatically at end of line 1; b) object anchor placed at position 1 of line 2; c) Calc selection inserted
5. CRLF placed at end of line 1, and no space is inserted between first paragraph and second paragraph, both of which are “Default Style.” (CANNOT UPLOAD SCREENSHOT?)

Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  
Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  

Insertion method two:

1. Edit → Paste Special → Paste Special → Selection → LibreOffice 6.3 spreadsheet → OK
2. view pop-up message (see screenshot 2) (CANNOT UPLOAD SCREENSHOT?)
3. select “no”
4. results: a) paragraph mark (CRLF) inserted automatically at end of line 1; b) object anchor placed at position 1 of line 2; c) Calc selection inserted

5. CRLF placed at end of line 1, but space is inserted between first paragraph and second paragraph, both of which are “Default Style.” (CANNOT UPLOAD SCREENSHOT?)
Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text. 
Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  
Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  


Steps to Reproduce:
(IS IT POSSIBLE TO UPLOAD AN LO FILE THAT CONTAINS IMAGES OF THE PROBLEM?)

Two issues:

1. Calc object formatting distorted (screenshot 1) in Writer copy (text example follows).

Began with LO v. 6.3.4.

2. Incorrect popup message requiring a response appears during insertion operation (see screenshot 2).  Only LO Writer and Calc used for create, edit, and save files.

Began with LO v. 6.3 or earlier.


Screenshot 1: original Calc selection



Screenshot 2: LO Writer popup message



Steps that create the problems:

Calc:

1. define selection area cells: AW6 : BD16
2. see screenshot 1
3. select copy: CTRL-C
4. Cells are selected: crawling selection border appears

Writer:

1. Page style is “Default Style” with no modifications.
2. Paragraph style is “Default style”
    • Style includes: a) no space (0.00”) before; b) no space (0.00”) after; and c) the “Don’t add space between...” button is not checked.
    • Style modified to use Palatino and SongTC (Chinese Song, traditional character) fonts. 
3. Dummy text entered is complete lines of “Dummy text.  Dummy text.” repeated from beginning to end of line for three full lines, finalized with a CRLF (hard return).

Perform insertion using 2 methods: Place cursor at position 1 in line 2 of dummy text.

Insertion method one

1. Edit → Paste
2. view pop-up message (see screenshot 2)
3. select “no”
4. results: a) paragraph mark (CRLF) inserted automatically at end of line 1; b) object anchor placed at position 1 of line 2; c) Calc selection inserted
5. CRLF placed at end of line 1, and no space is inserted between first paragraph and second paragraph, both of which are “Default Style.”

Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  
Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  

Insertion method two:

1. Edit → Paste Special → Paste Special → Selection → LibreOffice 6.3 spreadsheet → OK
2. view pop-up message (see screenshot 2)
3. select “no”
4. results: a) paragraph mark (CRLF) inserted automatically at end of line 1; b) object anchor placed at position 1 of line 2; c) Calc selection inserted
5. CRLF placed at end of line 1, but space is inserted between first paragraph and second paragraph, both of which are “Default Style.”
Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text. 
Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  
Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  


Actual Results:
(IS IT POSSIBLE TO UPLOAD AN LO FILE THAT CONTAINS IMAGES OF THE PROBLEM?)

Two issues:

1. Calc object formatting distorted (screenshot 1) in Writer copy (text example follows).

Began with LO v. 6.3.4.

2. Incorrect popup message requiring a response appears during insertion operation (see screenshot 2).  Only LO Writer and Calc used for create, edit, and save files.

Began with LO v. 6.3 or earlier.


Screenshot 1: original Calc selection



Screenshot 2: LO Writer popup message



Steps that create the problems:

Calc:

1. define selection area cells: AW6 : BD16
2. see screenshot 1
3. select copy: CTRL-C
4. Cells are selected: crawling selection border appears

Writer:

1. Page style is “Default Style” with no modifications.
2. Paragraph style is “Default style”
    • Style includes: a) no space (0.00”) before; b) no space (0.00”) after; and c) the “Don’t add space between...” button is not checked.
    • Style modified to use Palatino and SongTC (Chinese Song, traditional character) fonts. 
3. Dummy text entered is complete lines of “Dummy text.  Dummy text.” repeated from beginning to end of line for three full lines, finalized with a CRLF (hard return).

Perform insertion using 2 methods: Place cursor at position 1 in line 2 of dummy text.

Insertion method one

1. Edit → Paste
2. view pop-up message (see screenshot 2)
3. select “no”
4. results: a) paragraph mark (CRLF) inserted automatically at end of line 1; b) object anchor placed at position 1 of line 2; c) Calc selection inserted
5. CRLF placed at end of line 1, and no space is inserted between first paragraph and second paragraph, both of which are “Default Style.”

Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  
Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  Dummy text.  

Insertion method two:

1. Edit → Paste Special → Paste Special → Selection → LibreOffice 6.3 spreadsheet → OK
2. view pop-up message (see screenshot 2)
3. select “no”
4. results: a) paragraph mark (CRLF) inserted automatically at end of line 1; b) object anchor placed at position 1 of line 2; c) Calc selection inserted
5. CRLF placed at end of line 1, but space is inserted between first paragraph and second paragraph, both of which are “Default Style.”


Expected Results:
1. LO Writer does not display the incorrect information popup.
2. Copied Calc object formatting is not distorted in Writer.


Reproducible: Always


User Profile Reset: No



Additional Info:
This problem is not addressed in LO help documentation.
Comment 1 Jim Martin 2020-02-07 09:08:52 UTC 
Created attachment 157726 [details]
LO 6.3.4.2 Writer document containing 1. descrption of 2 issues; 2. steps to produce both issues; 3. screen shots of originals; 4. 4. Writer text document showing displayed problem

File provides graphic documentation of 2 problems encountered and reported this date.
Comment 2 Dieter 2020-02-10 15:41:43 UTC 
Jim, thank you for reporting the bug. Could you please attach the original calc-document. This would make it easier to reproduce the problem. Thank you.

=> NEEDINFO
Comment 3 Jim Martin 2020-02-16 04:12:40 UTC Comment hidden (obsolete)
Comment 4 Jim Martin 2020-02-16 04:15:39 UTC Comment hidden (obsolete)
Comment 5 Dieter 2020-02-16 05:47:31 UTC 
Jim, comment 3 doesn't contain ods-file. So I tried to reproduce it with an own file, but couldn't reproduce the problems:
a) no pop-up message
b) no different results in layout

Version: 6.3.4.2 (x64)
Build-ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: threaded

A basic rule in Bugzilla is "Only one issue in one bug report". So it would be fine, if you could reduce this report to one problem and use a new report for the second issue.

To be sure, that appearing of the popup message is not related to corruption in the user profile, could you please reset your Libreoffice profile (https://wiki.documentfoundation.org/UserProfile) and re-test?
Comment 6 Jim Martin 2020-02-16 07:24:21 UTC 
Created attachment 157911 [details]
LO Calc .ods file

A followup .ods file to replace file attachment 157910 [details]: LO_test.ods and LO_test.odt.  Purpose of the file is to determine if bug 157726 report filed by original reporter is replicable by a user with a known, non-corrpted user profile
Comment 7 Jim Martin 2020-02-16 08:27:53 UTC 
Restarted LibreOffice in safe mode. Created new .ods and new .odt files.  Entered information into Calc cells.  Applied bold and border formatting. Selected cells. Copied selected cells to Writer using 2 methods:

1.  Edit → Paste special --> Paste Special → LibreOffice 6.3 Spreadsheet → OK.

and 

2. Ctrl-v (Mac OSX Cmd-V).

Results:

1. The format problem replicated using both methods.

and 

2. The popup LO information message described in report 157726 "This file was created in a different version..." that appears in not-safe mode _did_not_appear_ in safe mode.

Cannot submit files created for this safe mode test; attempted to save both files.  No LO dialog requesting name & location appeared.  Used Mac OS HD search utility to locate folder to which these files saved.  No results.  Assume files either a) not saved, or b) saved using file names not assigned by the user and therefore unknown.
Comment 8 Dieter 2020-02-17 13:11:58 UTC 
(In reply to Jim Martin from comment #7)
> 2. The popup LO information message described in report 157726 "This file
> was created in a different version..." that appears in not-safe mode
> _did_not_appear_ in safe mode.

If it doesn't appear in safe mode, it's not a bug, but a corruption of your user profile. Please refresh you user profile.
Comment 9 Xisco Faulí 2020-02-17 15:31:23 UTC Comment hidden (obsolete)
Comment 10 Dieter 2020-02-17 16:20:39 UTC 
(In reply to Xisco Faulí from comment #9)
> Yes, please clean your user profile.
> Closing as RESOLVED WORKSFORME

Xisco, there is still the first problem => Back to UNCONFIRMED
Comment 11 Jim Martin 2020-02-18 08:55:08 UTC 
Created attachment 157970 [details]
LO_test_3.odt test file. Result of copy - paste special operation demonstrating problem

This comment applies to 3 attachments. First is LO_test_3.odt.  Second is LO_test_3.ods. Third is LO_test_information_message.png.

I apologize for uploading multiple files separately.  I do not know whether it is possible to upload multiple attachments as one batch of files.

The procedure I followed reproduced exactly the 2 conditions described in the original bug report.  The steps followed were:

1. Restart LO:6.3.4.2 in safe mode.
2. Choose the instruction to reset user profile.
3. Quit LO.

4. Restart LO in normal mode.
5. Create Writer file LO_test_3.odt
6. Create Calc file LO_test_3.ods (see next attachment)
7. Select Calc cells for copy operation.
8. Switch to Writer.
9. Copy Calc object using Edit-->Paste special-->Paste special-->LO 6.3 spreadsheet-->OK.
10. Screen displayed the information/decision popup (see subsequent attachment).
11. Select "Yes" (do proceed with recalculation this instance only).
10. The Calc cells with distorted format appeared.

Conclusions:
1. Restarting in Safe Mode and selecting reset user profile option did not solve the problem upon subsequent restarts in normal mode.
2. The 2 issues raised in the original bug report are related and therefore constitute a single issue.
Comment 12 Jim Martin 2020-02-18 08:55:58 UTC 
Created attachment 157971 [details]
LO_test_3.ods
Comment 13 Jim Martin 2020-02-18 08:56:51 UTC 
Created attachment 157972 [details]
LO_test_3_information_message
Comment 14 Alex Thurgood 2020-02-18 10:02:27 UTC 
I'm afraid this bug report is a little bit hard to read, so I might have tested incorrectly.


1) I downloaded LO_test_3.odt and LO_test_3.ods.
2) Opened both in 

Version: 6.4.0.0.beta1
Build ID: 4d7e5b0c40ed843384704eca3ce21981d4e98920
Threads CPU : 4; OS : Mac OS X 10.15.3; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

3) Selected a range of cells containing values in the Calc sheet and then Cmd-V

4) Switched to Writer document, then Paste > Paste Special > LO Calc sheet at some random point on the page

5) Observed the result.

6) The paste special operation into Writer did not produce an error message.

By default, the inserted object is incorrectly displayed with black overlay over at least some of the content instead of displaying the complete grid and associated values. Is that the issue that is being reported here ? If so, I can confirm.

I can't confirm any error message.
Comment 15 Alex Thurgood 2020-02-18 10:03:38 UTC Comment hidden (obsolete)
Comment 16 Jim Martin 2020-02-19 05:08:04 UTC 
(In reply to Alex Thurgood from comment #15)
> (In reply to Alex Thurgood from comment #14)
> 
> > 3) Selected a range of cells containing values in the Calc sheet and then
> > Cmd-V
> 
> 
> Sorry that should read Cmd-C

Mr. Thurgood,

You correctly describe the bug I reported.  The problem became apparent using
Version 6.3.4.2.  You report using Version 6.4.0.0.beta1.

1. The formatting of the copied cells is indeed not correct using v6.4.0.0.beta1.

My comment: The bug leading to the distorted formatting still exists in Version 6.4.0.0.beta1

2. The information message I uploaded in LO_test_3_information_message.png did not appear.

My comment: Absent information about any work on this second issue, I speculate but do not conclude that this issue has been resolved in the transition from 6.3.4.2 to 6.4.0.0.beta1.

Thank you for your work.

Jim Martin
Comment 17 Timur 2020-03-11 13:39:06 UTC Comment hidden (obsolete)
Comment 18 eisa01 2020-05-02 16:49:20 UTC 
Ok. If I read the previous comment right, the popup issue is gone.

What remains is a formatting issue. I tested the "LO_test_3.ods" file on macOS and Linux and at least the font color formatting is not preserved

Steps to reproduce:
 * Open Calc test file
 * Select table and copy
 * Open new Writer document
 * Paste Special as LO Spreadsheet
 * Observe that the green and blue text is now black

I tried to check for duplicates, but couldn't immediately find this

Version: 6.4.3.5
Build ID: 4db9852e73d9e9d662fc8a2783bace79addf1805
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 19 QA Administrators 2022-05-03 03:41:14 UTC Comment hidden (obsolete)
Comment 20 Timur 2022-05-04 13:24:58 UTC 
Repro 7.4+. But I don't know where the blue color comes from? 
Normal direct formatting like color is copied, just this blue is not.

Test is simple, no need for specific ODT, just copy from ODS to new ODT as Calc.
But it must first be clear about the blue. It didn't appear in old LO 4.
Comment 21 Timur 2022-05-04 13:48:44 UTC 
I changed this to Needinfo for a reporter to explain the source of blue text. 
It's something about table styles, but they don't seem present in ODS. 
So far, this seems like Invalid sample.
Comment 22 QA Administrators 2022-11-01 03:33:17 UTC Comment hidden (obsolete)
Comment 23 QA Administrators 2022-12-02 03:40:30 UTC 
Dear Jim Martin,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp