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