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

--- Comment #8 from Pfuschi <ejgbr...@trashmail.net> 2012-04-01 06:10:15 PDT ---
I consider this to be a bug:

- Value Highlighting gives me some important information about cells:
    . value directly entered – eventually used for calculation (blue)
    . value derived by formula, cell should not be changed (destroyed) by
entering a data value – except on purposely changing formula (green)
    . locked cells, that cannot be changed, when sheet is 'in use', i.e. is
protected (shaded)
    . unlocked cells that are used for data entry and may be colour indicated
(blue, no shading, eventual conditional or unconditional background colour)

- Conditional colouring of cell background gives me information according to
the condition, e.g. minimum value, maximum value of values to be compared.

Conditional or unconditional background colour must not be dependent on Value
Highlighting; especially can a conditional format be underlaid to a calculated
cell value that is – for good reason - locked. In any case would I like to see,
if the condition is met, expressly when the sheet is locked.
Also would I want to see a background colour on cells used for data entry.

(Note: the provided sample does not show all this, but I did not want to see in
public more complex sheets I also own.)

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to