https://bugs.documentfoundation.org/show_bug.cgi?id=121619
Bug ID: 121619
Summary: Data validity has problems if input data is changed
Product: LibreOffice
Version: 6.1.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: laurentiusil...@gmail.com
Description:
Let's consider an .ods document which has two sheets: Sheet1 and Sheet2. On
Sheet1 there are two cells which are filled-in with number 1 in the first cell
and number 2 in the second one.
On the Sheet2, I want to validate data of column A using the values 1 and 2
from Sheet1; so, I want to have in column A from Sheet2 only the numbers 1 or 2
from Sheet1.
I go in Sheet2, I select column A and then go to Menu -> Data -> Validity ->
Criteria -> Allow: Cell range -> select the range from Sheet1 (numbers 1 and
number 2) and OK button.
Everything works, but after this, if in Sheet1 number 1 is replaced by number
3, on Sheet2 the cells which have been filled-in with number 1, remain with
number 1 and they are not changed with number 3 as they was changed in Sheet1.
Is this an error?
In my opinion it is because it should be the same situation like in A2=A1 and
if A1 is changed from value 1 to value 3, the A2 will be changed with value 3,
right?
Many thanks for your work!
Steps to Reproduce:
See Description
Actual Results:
See Description
Expected Results:
See Description
Reproducible: Always
User Profile Reset: No
Additional Info:
See Description
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs