[Libreoffice-bugs] [Bug 125057] New: [FORMATTING] Conditional formatting KO while copying sheet
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Wed May 1 05:11:48 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=125057
Bug ID: 125057
Summary: [FORMATTING] Conditional formatting KO while copying
sheet
Product: LibreOffice
Version: 6.1.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: florent.mathis at gmail.com
Description:
When I copy a sheet which contains conditional formatting, it seems to be
working fine but the conditional formatting is broken on the new sheet. (see
attachment)
I have found a workaround while browsing issues regarding conditional
formatting by copying using the "paste special" directly on the cells after
copying the sheet. However, this workaround may be time-consuming if, like in
my case, one has to perform this operation multiple times.
Additionally, there is also a strange orange color which is automatically added
on the nonworking cells.
Steps to Reproduce:
1. create a worksheet
2. apply a conditional formating (in my case, it was a custom style with a
different background, conditionned on a LOV defined in another sheet)
3. copy the worksheet
Actual Results:
Conditional formatting broken in the new sheet.
Expected Results:
Copy the format with the sheet copy.
Reproducible: Always
User Profile Reset: No
Additional Info:
I also use a cell range for the broken cells. Both the definition of the cell
range, and the conditional formatting are based on a configuration sheet
_Status_LOV.
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190501/2bb0fbd5/attachment.html>
More information about the Libreoffice-bugs
mailing list