https://bugs.documentfoundation.org/show_bug.cgi?id=154750
--- Comment #12 from Darrell O'Brien <darre...@tpg.com.au> --- Created attachment 186648 --> https://bugs.documentfoundation.org/attachment.cgi?id=186648&action=edit football tipping program open spreadsheet open enter tips select person enter team number 1 to 18 for team selection to fill cell alongside team number with team name from lookup table (total of nine teams)) if one team name from a choice of 2 teams (condition 1 and condition 2) for that same round match (Fixture round number) the condition is true and colours the cell in enter tips. example sheet enter tips select cell U32 enter team number 10 or 12 name of team is inserted into cell V32 (Round 6) from lookup table if team name matches Fixture sheet cell V11 (condition 1 ) if team name matches fixture sheet cell V12 (condition 2) V32 condition is true and colours cell to verify an entry is correct. continue for rest of matches. Problem What was happening was if I entered a team value in team Cell V32 the team name would appear and colour and change a random previous entry team name to no colour or team name of entered number would not confirm by changing to colour. As reported this has been working for 5 years and after update of Libre program this problem appeared. Now since I have reset auto calc it seams to work ok. I need to to wait until next week to confirm. -- You are receiving this mail because: You are the assignee for the bug.