[Libreoffice-bugs] [Bug 139649] New: [1] Wrong condition behavior with cell range and sheet name

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139649
           Summary: [1] Wrong condition behavior with cell range and sheet
                    name
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kardjoe at posteo.net

Description:
Sometimes in Libreoffice Calc I use condition to compare range of cells in one
field with respective range of cells in another field using 'Conditional'
button on the toolbar. I highlight cells instead of writing a range manually.
Let's say I use option 'Cell value is' in 'Conditional formatting'. I choose
'less than' option, put cursor on the right field, than I highlight cells.
Range of cells with sheet name appears in the field like $'Sheet
name'.$A$1:$A$10. After clicking OK sometimes compare process go wrong. For
example, if A1 is 1 and B1 is 1, formatting shows that A1 is bigger than B1.



Steps to Reproduce:
1. Create a sheet.
2. Fill range A1:A10 with some numbers.
3. Copy those numbers to range B1:B10 respectively.
4. Open 'Conditional' -> 'Manage'.
5. Click 'Add'.
6. Set 'Condition 1' as 'Cell value is'.
7. Set 'less than'.
8. Put cursor on the next field and highlight with cursor range of B1:B10.
9. Click 'Shrink' button at the left bottom corner.
10. Highlight range A1:A10.
11. Click OK.

Actual Results:
Number in one cell is highlighted as not equal to a number in respective cell
in another field when two these numbers are actually equal.

Expected Results:
Numbers in respective cells should not be highlighted when they are equal and
one use 'less than' condition.


Reproducible: Sometimes


User Profile Reset: Yes



Additional Info:
Version: 6.4.6.2
Build ID: 1:6.4.6-0ubuntu0.20.04.1
CPU threads: 24; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: ru-RU (en_US.UTF-8); UI-Language: en-US
Calc: threaded

Not sure if it depends on if I compare a simple number and a function result or
simple numbers.

Possible workaround - remove sheet name (like $'Sheet name') in 'Conditional
Formatting' in the right field.

Example with a Calc sheet where I see such  behavior is attached. Look at F and
G fields. I've faced this bug when I work with LO versions 6.4.6.2 and 7.0.4.2.

-- 
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/20210115/485fa7cf/attachment-0001.htm>