Description: Ich habe bei bedingter Formatierung der eigenen Zelle keine Probleme, aber wenn zB links Sonntag steht und die Zellen rechts davon grau hinterlegt werden sollen (wg geschlossen), ist das Ergebnis anders herum. Steps to Reproduce: 1.=GANZZAHL(ZUFALLSZAHL()*50)für a1:a24 2. a1:a24 Bed Format Zellwert is > 40 3. b1:b24 Bed Form Zellw $Tabelle1.$A1>41 Jeweils belibige Vorlage Actual Results: in Spalte A wie gewünscht in B genau anderesherum ?invertier? Expected Results: Spalte a und b identisch, in M$ Office regelmäßig angewendet. Reproducible: Always User Profile Reset: No Additional Info: Verschiedene 5 und 6 libreOffice 3 PCs getestet, mit M$ Office klappte es, meine Fähigkeiten scheinen nicht das Problem zu sein. User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0
Created attachment 140242 [details] Bedingung der Spalte B
Danke, dies ist mein 1. Bugreport.
Hi York, Thanks for reporting the issue. Is this translation from google translate accurate? description: I have no problems with conditional formatting of my own cell, but if, for example, left is Sunday and the cells to the right are to be grayed out (wg closed), the result is the other way round. Steps to Reproduce: 1. = INTEGER (RANDOM COUNT () * 50) for a1: a24 2. a1: a24 bed format cell value is> 40 3. b1: b24 Bed Form Cell w $ Table1. $ A1> 41 Each template Actual Results: in column A, as desired, in B exactly the other way round? Expected Results: Columns a and b are identical, applied regularly in M $ Office. Reproducible: Always User Profile Reset: No
Du musst bei der Bedingung für Spalte B "Formel ist" einstellen, nicht "Zellwert ist". Use "Formula is" instead of "Cell value is" for column B.
Yes you are right. Tested and it is running as aspected. Thank you
Yes you are right. Tested and it is running as aspected. Thank you(In reply to Xisco Faulí from comment #3) > Hi York, > Thanks for reporting the issue. > > Is this translation from google translate accurate? > > description: > I have no problems with conditional formatting of my own cell, but if, for > example, left is Sunday and the cells to the right are to be grayed out (wg > closed), the result is the other way round. > > Steps to Reproduce: > 1. = INTEGER (RANDOM COUNT () * 50) for a1: a24 > 2. a1: a24 bed format cell value is> 40 > 3. b1: b24 Bed Form Cell w $ Table1. $ A1> 41 > Each template > > Actual Results: > in column A, as desired, in B exactly the other way round? > > Expected Results: > Columns a and b are identical, applied regularly in M $ Office. > > > Reproducible: Always > > > User Profile Reset: No 'wg' = wegen = 'because of' (the restaurant is closed). But it is not a bug, just a wrong choise of mine.