https://bugs.documentfoundation.org/show_bug.cgi?id=154750
Bug ID: 154750
Summary: cell condition interacts with different columns and
rows
Product: LibreOffice
Version: 7.5.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have produced a football tipping program and use the condition if the
football round sheet cell matches The contents in the cell of a football
fixture sheet Choice of 1st cell (Condition one IE B17)or(condition two IE B18)
the condition is true and colour is set.This main reason is to show entered
value is correct.
Problem is sometimes previous column (or rounds with entries for previous
matches blank out colour and change reference cells of other cells. I have had
no problems with previous versions until I updated to version 7.5.2.2
Steps to Reproduce:
1.(Sheet 2) condition cell
2.in cell condition 1 equal to sheet 1 cell B17 (colour sheet 2 cell) else (no
colour) condition 2 equal to sheet 1 cell B18 (colour sheet 2 cell) else (no
Colour)
3.interaction with previous cells sheet 2 same column different players.
Actual Results:
conditioned cells change to no colour
Expected Results:
All cells conditioned should stay coloured
Reproducible: Always
User Profile Reset: No
Additional Info:
not interact with other cells and all matching cells remain coloured
can send a copy of program if required.
--
You are receiving this mail because:
You are the assignee for the bug.
