For the newest LibreCalc, I have defined a range of cells within a column looking for duplicates. However, I notice that those ranges are not static. They change whenever a copy or cut function is used. Is there a method or option to make those conditional ranges LOCKED?
The function used for these is to create a staff grid based on calendar days. Each column represents a calendar day. There never should be a duplicate initial within a column and so conditions were used to double check any errors not caught visually. But sometimes, the range is modified to exclude a cell within a column. Ex: A3:A29; A31, A49 (or even another column for a particular range!)
Another option that would be interesting is a duplicate could be detected if there is any string of characters that are the same. Ex: AP and AP7-7 would be treated as a duplicate and not different.
Steps to Reproduce:
1. Copy/paste or deleting cells with info
2. Viewing Conditional Formatting under Format and Manage
3. Cell ranges change sporadically
Ranges defined in conditional formatting should be locked to only the cell range defined for that condition
User Profile Reset: No
Not that I can think of but willing to provide an example file if needed
*** This bug has been marked as a duplicate of bug 133027 ***