[Libreoffice-bugs] [Bug 139450] New: CONDITIONAL FORMATTING in Calc: smear of conditional formatting

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139450
           Summary: CONDITIONAL FORMATTING in Calc: smear of conditional
                    formatting
           Product: LibreOffice
           Version: 7.0.3.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: cecconidaniele at gmail.com

Description:
The condition "giorno.settimana(a2;2)=6" (in italian) of conditional formatting
on a range of dates produces a fill of colors even in empty cells. With values
1,2,3,4,5,7 the formula works correctly

Steps to Reproduce:
1.a1 = 31/12/2020
2.a2 = a1 + 1
3.copy a2 down to line 182
4.move the January days to B2
5.move the days of February to D2
...
9.move the days of June to L2
10.select B2: L32
11.cell format to DD
12. select range B2:L32
13.conditional formatting B2: L32
14.condition
14.a- the formula is -> GIORNO.SETTIMANA(B2;2)=7
14.b- new style
14.c- background -> RED 3
14.d- font -> 12 pt
14.e- font color -> yellow 2
15. OK
16. Correct conditional formatting.
17. Manage rules
17.a change in the formula the "7" to "6"


Actual Results:
the conditional formatting fills all the empty spaces in the range.

Expected Results:
the same results as the values 1,2,3,4,5,7


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Versione: 7.0.3.1 (x64)
Build d7547858d014d4cf69878db179d326fc3483e082
thread CPU: 4  SO:Windows 10.0 Build 19041
Resa Interfaccia Skia/Raster;  VCL: win
Locale it-IT (it_IT); interfaccia utente: it-IT
Varie: Calc:threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210106/9d83521a/attachment-0001.htm>