[Libreoffice-bugs] [Bug 47628] VIEWING no background color on protected sheet with enabled 'Value Highlighting'

[bugzilla-daemon]

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

--- Comment #14 from tomber  ---
Technology becomes part of our life. Most people are interested to know the
details of the latest updates. Here you can check this https://cracko.org for
more details about the updates.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47628] VIEWING no background color on protected sheet with enabled ' Value Highlighting'

[bugzilla-daemon]

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

Thomas Lendo  changed:

   What|Removed |Added

 Blocks||112451


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=112451
[Bug 112451] [META] Value highlighting bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 47628] VIEWING no background color on protected sheet with enabled 'Value Highlighting'

[bugzilla-daemon]

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

Rainer Bielefeld libreoff...@bielefeldundbuss.de changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOTABUG

--- Comment #13 from Rainer Bielefeld libreoff...@bielefeldundbuss.de ---
Due to https://bugs.freedesktop.org/show_bug.cgi?id=60875#c2

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

[Libreoffice-bugs] [Bug 47628] VIEWING no background color on protected sheet with enabled 'Value Highlighting'

[bugzilla-daemon]

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

Rainer Bielefeld libreoff...@bielefeldundbuss.de changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #11 from Rainer Bielefeld libreoff...@bielefeldundbuss.de ---
Help: Text cells are formatted in black, formulas in green, and number cells
in blue, no matter how their display is formatted.

So it's not totally unexpected that user defined background will be ignored.

Let's wait for results in Bug 60875 - LOCALHELP incomplete for Menu 'View -
Value Highlighting' of protected cells

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

[Libreoffice-bugs] [Bug 47628] VIEWING no background color on protected sheet with enabled 'Value Highlighting'

[bugzilla-daemon]

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

Rainer Bielefeld libreoff...@bielefeldundbuss.de changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
   See Also||https://bugs.freedesktop.or
   ||g/show_bug.cgi?id=60875
 Ever confirmed|1   |0

--- Comment #12 from Rainer Bielefeld libreoff...@bielefeldundbuss.de ---
BTW, I don't think that it's a good idea that community should expect a fix
(Status=NEW) for every effect I do not understand ;-)

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

[Libreoffice-bugs] [Bug 47628] VIEWING no background color on protected sheet with enabled 'Value Highlighting'

[bugzilla-daemon]

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

Rainer Bielefeld libreoff...@bielefeldundbuss.de changed:

   What|Removed |Added

Version|3.4.4 release   |3.3.0 Beta2

--- Comment #10 from Rainer Bielefeld libreoff...@bielefeldundbuss.de ---
(In reply to comment #7)
Version changed

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

[Libreoffice-bugs] [Bug 47628] VIEWING no background color on protected sheet with enabled 'Value Highlighting'

[bugzilla-daemon]

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

Joel Madero jmadero@gmail.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||jmadero@gmail.com
 Ever confirmed|0   |1

--- Comment #9 from Joel Madero jmadero@gmail.com ---
I am going to mark as NEW as Rainer has confirmed but I'm not going to
prioritize as previous QA'er is already involved.

Thanks for reporting and for being patient as we triage.

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

[Libreoffice-bugs] [Bug 47628] VIEWING no background color on protected sheet with enabled 'Value Highlighting'

[bugzilla-daemon]

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

[Libreoffice-bugs] [Bug 47628] VIEWING no background color on protected sheet with enabled 'Value Highlighting'

[bugzilla-daemon]

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

Rainer Bielefeld libreoff...@bielefeldundbuss.de changed:

   What|Removed |Added

 OS/Version|Mac OS X (All)  |All
 Status|NEEDINFO|UNCONFIRMED
 Ever Confirmed|1   |0
Summary|Formatting: background  |VIEWING no background color
   |colour not shown on screen  |on protected sheet with
   |in protected sheets |enabled 'Value
   ||Highlighting'

--- Comment #7 from Rainer Bielefeld libreoff...@bielefeldundbuss.de 
2012-03-31 07:40:58 PDT ---
The effect is reproducible with reporter's sample documents and with
LibreOffice 3.5.2.2 German UI/Locale [Build-ID:
281b639-6baa1d3-ef66a77-d866f25-f36d45f] on German WIN7 Home Premium (64bit),
but I can't tell whether its a bug.

You see the  effect in a document with protected sheet, when you 
1. Open attached Calc Document sample.ods'
you see some cells with contents, 
 B1:B4 will not be protected
 already done: Menu 'Tools - Protect Document - Sheet - ok
2. Toggle Menu 'Viewing - Values Highlighting'
   With highlighting activated all protected cells will show grey background

I never saw that in an other way (since OOo 1.1.4), but I can't see the
advantage of that behavior. Bug or feature, that is the question here.

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