Bug 162184 - [CALC] Paste Special is pasting format (fill) without the checkbox being selected
Summary: [CALC] Paste Special is pasting format (fill) without the checkbox being sele...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-07-25 07:55 UTC by Steven Jackson
Modified: 2025-12-26 03:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Steven Jackson 2024-07-25 07:55:49 UTC
Description:
As title.

This has started occurring in 24.2.5.2 and was not the case in 7.6.7.2 AFAICS

Select/copy formatted text in a cell/range and paste special into another cell/range in another LOCalc document.

May be occurring if document created with earlier version or specific formatting, could not replicate in New Spreadsheet to New Spreadsheet created in 24.5.2

Steps to Reproduce:
1. Open an existing spreadsheet (may need to have been created before 24.2.5.2)
2. Format a cell or range with something (font, size, text colour, bg fill, alignment, etc.)
3. Copy then 'Paste Special' into another spreadsheet (may need to have been created before 24.2.5.2)

Actual Results:
BG Fill was pasted along with other formatting in my documents.

Worked correctly with 'new' spreadsheets in 24.2.5.2

Expected Results:
To work as with new spreadsheet


Reproducible: Couldn't Reproduce


User Profile Reset: No

Additional Info:
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
Comment 1 m_a_riosv 2024-07-25 18:03:01 UTC
Please attach a sample file.
Comment 2 Steven Jackson 2024-07-26 14:37:44 UTC
I can't provide the sheet as it is commercially sensitive. Sorry.

Most of my older files are similarly sensitive so I'm not going to forward anything.

If no-one else confirms this issue then I guess it will just go unanswered but I have alternate office suites I can use if LO continues to mess up.
Comment 3 ady 2024-07-26 19:14:23 UTC
There are no precise steps to reproduce, no sample document, and not even a hint of which version to test with (except that it might happen with some spreadsheet that was saved with some unknown older version but probably not with the latest version).

ATM we don't really know how to start with some attempt to reproduce the problem.

I anyway attempted to follow the generic steps. I created 2 spreadsheets with some random cell formatting (including background color) with LO 7.6.6. Then, using LO 24.2.4, I used copy + paste special without format, and the result was as expected (and not as reported).

Without _specific_ steps and conditions / context, the reported behavior would not be easy to reproduce.
Comment 4 QA Administrators 2025-11-25 15:17:29 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2025-12-26 03:12:05 UTC
Dear Steven Jackson,

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