https://bugs.documentfoundation.org/show_bug.cgi?id=151817
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #6 from m.a.riosv <[email protected]> --- There is not a bug. I'll try to explain. After you have the range to apply: P3:P500;X3:X500 After the formula is: AND(P3<>0;O3>119;O3<130;P3<80) And it is fine because the formula has relative addresses, so it is calculated in relation with the cell for what it is calculated. It's the same principle that you apply to rows, When calculate for P3 then AND(P3 it's taken to calculate. When calculate for X500 then AND(X500 IT'S taken for the calculation. If fact, if I'm not wrong, the colored cells are the same in both sheets Please when you have this kind of questions/dudes first put the question in ask.libreoffice.org. -- You are receiving this mail because: You are the assignee for the bug.
