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

--- Comment #4 from Markus Mohrhard <[email protected]> ---
(In reply to comment #3)
> (In reply to comment #2)
> 
> > the Manage Conditional Formats dialog and ...
> 
> Is where :-) ?

Format->Conditional Formatting->Manage

It has been introduced in 3.6 to allow a better overview about conditional
formatting and is a better tool to edit conditional formatting.

> 
> What I see now is that I can apply conditional formatting to a range and
> then select one cell and with the same dialog apply extra conditional
> formatting.
> Correct?

Until 3.5 a cell could only have a conditional formatting that was a cell
property. 3.6 moved to range based conditional formatting to allow formats that
are no longer only local to the current cell but take into account all the
other values in the range. For 4.0 I now made it also possible that a cell can
contain several independent conditional formats.

Imagine you apply a conditional format to A1:A4 for color scales which means
that the range the conditional format is applied to is important but you'd like
to format A2:A3 also with anothe conditional format. This is now possible by
just defining an additional conditional format for A2:A4 which will in contrast
to older behavior not overwrite the old conditional format (till 3.5) or change
the conditional of A1:A4 ( in 3.6 )

This is a major improvement that was one goal for range based conditional
formats. This improves interoperability with MSO and removes nearly all known
limitation od conditional formats that we had until now. Together with the new
conditional formats in master they are now a universal tool to improve the look
of complex spreadsheets.

-- 
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