Bug 73171 - conditional formatting cannot be pasted
Summary: conditional formatting cannot be pasted
Status: RESOLVED DUPLICATE of bug 72735
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.4.2 release
Hardware: Other macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-12-30 22:23 UTC by LenoreHorner
Modified: 2014-07-24 08:37 UTC (History)
0 users

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 LenoreHorner 2013-12-30 22:23:17 UTC
I have a partially complete spreadsheet which conditional formatting.  All attempts to copy existing conditional formatting to new cells (single cells, groups of cells, entire columns) fail.  The last version causes a crash.

LibreOffice is effectively useless for my purposes until this is fixed.  (I upgraded to 4.1.4.2 because my previous (recent but don't remember which one) version was crashing randomly.
Comment 1 retired 2013-12-31 10:23:12 UTC
Can you please use https://www.libreoffice.org/get-help/bug/ and try to create more informative bug reports. The way you currently report is not too constructive since lots of info is missing. Every good bug report has exact repro steps. If we can't reproduce it's almost certain, your bug won't get fixed any time soon.

Basically: the better the report, the faster the issue will be fixed.

So: Can you please provide a test document so this can be tested against and subsequently be confirmed. If your document contains sensitive data, please clear that or replace it with random information.

A step-by-step description of how to reproduce the issue is most helpful and will help to speed up the processing of this problem a lot.

Setting to NEEDINFO until more detail is provided.

After providing the requested info, please reset this bug to UNCONFIRMED. Thanks :)
Comment 2 LenoreHorner 2013-12-31 17:18:23 UTC
Sorry, I thought the steps I listed were relatively clear.  I'll try to write clearer.

1) Open a new spreadsheet in LibreOffice.
2) Put something in a cell.
3) Create a conditional format for the cell.
4) Copy cell.
5) Select a whole column (click on column header).
6) Paste special leaving only formatting checked.
7) Spinning beachball is result. Cmd-opt-esc shows LibreOffice as "not responding".  


The original form of the error is much harder to produce.  Create a spreadsheet with some conditional formatting.  Copy/paste, fill-right, and fill-down to extend the spreadsheet.  Copy entire sheet to new sheet in workbook.  Then try to copy the formatting to cells with contents. The conditional part of the formatting will not copy.  This version, I subsequently found, can be cured by cleaning up the conditional formatting (the Copy/paste, fill-right, and fill-down produced a list of !30 conditional formatting commands most over several sets of cells) so there was one format applied to the whole sheet.  With only one conditional format, I can extend formatting to new cells by editing the range.  (I haven't tried pasting.)
Comment 3 QA Administrators 2014-07-08 17:29:26 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team
Comment 4 ign_christian 2014-07-23 14:54:55 UTC
Looks like duplicate to Bug 72735 or at least similar..
Comment 5 ign_christian 2014-07-24 08:37:55 UTC
Marking this duplicate to Bug 72735 since "Bugcruncher" also confirm his own bug (which is the same as this bug) a dup.

*** This bug has been marked as a duplicate of bug 72735 ***