https://bugs.documentfoundation.org/show_bug.cgi?id=99808
Theodore Matula Jr. <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #1 from Theodore Matula Jr. <[email protected]> ---
Created attachment 125016
--> https://bugs.documentfoundation.org/attachment.cgi?id=125016&action=edit
Test At Step 9
Summary: I can confirm this on Version: 5.1.3.2 in Windows 10, but with some
stipulations. When applying a background as conditional formatting to a block
of merged cells, only the first "original" cell will get the background
applied. However, If you double click the cell and then click and other cell,
the formatting will be applied to the entire merged block. Though, this may be
exclusive to my version of LibreOffice, so I do not know If this "fix" works
for earlier versions.
Steps:
1. Open a new LibreOffice Calc spreadsheet.
2. Highlight cells A1-A5 and right click on the cells. (I used cells D1-D5, but
it doesn't really matter)
3. Click Merge cells
4. Click the new block of merged cells and type 0 in it.
5. From the Menu, click Format>Conditional Formatting>Condition...
6. Click add to add a new condition
7. In this new Condition, set the condition to "Cell value is" "Equal to" "0"
8. From the drop down menu next to Apply Style, click New Style. Click the
background tab, choose any non-white color, and click OK.
9. Click OK to close the conditional formatting window.
Expected Result: The entire merged cell's background color is what you selected
in the conditional formatting
Actual Result: Only the first "original cell" in the merged block has the
formatting applied to it.
After Step 9, you can quickly fix the issue by the following steps:
10. Double click the merged cell. It should turn white and the text input
cursor should appear in it.
11. Click on any cell outside of the merged cell block. the background color
should now be applied to the entire merged block.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
