https://bugs.freedesktop.org/show_bug.cgi?id=84670

            Bug ID: 84670
           Summary: Conditional formatting changes row height
           Product: LibreOffice
           Version: 4.1.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
          Assignee: [email protected]
          Reporter: [email protected]

Applying conditional formatting changes the row height (specifically, adds some
margin to the top of the cell).

My default style is defined as

Liberation Sans Narrow + 8pt + Automatic + Centered vertically + Automatic +
FALSE + TRUE + Left margin: 0.03inch, Top margin: 0.0inch, Right margin:
0.03inch, Bottom margin: 0.0inch + White, Transparent.

I have defined a style named Challenge which is linked with Default and defined
as

8pt + Left margin: 0.03inch, Top margin: 0.0inch, Right margin: 0.03inch,
Bbottom margin: 0.0inch + RGB(191, 152, 229), Not Transparent

If I apply conditional formatting to a range of cells, where a cell that passes
the conditional formula is set to style Challenge, all of the rows with cells
in that range get an extra pixel or two of top margin above the text
(regardless off what condition applies within the cells).

If I apply the formatting manually, or by use of STYLE() within formulas, this
doesn't happen: the cells retain their correct height and margin.

I've observed this before with different style settings.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to