https://bugs.documentfoundation.org/show_bug.cgi?id=154560
Bug ID: 154560
Summary: Data validity bugs in custom formulas and drop-down
lists.
Product: LibreOffice
Version: 7.5.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Two errors found.
1. Data validation by formula does not work when opening a file. Validation
starts working only after editing the data validation formula. FILEOPEN EDITING
2. When the file is saved, the values disappear from the data validation list.
FILESAVE
Steps to Reproduce:
Bug first. FILEOPEN
1. Open a file.
2. Change the value in column "A" in cells "A3", "A4", etc. (these cells with
data validation by the formula).
3. LibreOffice displays "Login not available" message. Validation failed. It's
error.
4. Fix this error: select cell 'A3' or 'A4' or etc. Click tab 'Data' ->
'Validity...' -> 'Ok'. Entry is available in this cell! Now data validation
works correctly!
Bug two. FILESAVE
1. Check the values in the data validation list for cells "B3", "B4", etc.
2. Change any other cell in the file. Save and close the file.
3. Open the file again and check the values in the data validation list for
cells "B3", "B4", etc. The bottom half of the values are not in the data
validation list.
The file in which the error occurs.
https://disk.yandex.ru/i/YcsnRgiFjdkbMQ
Actual Results:
Bug first. Formula data validation started working in cells 'A3', 'A4' etc.
Bug two. Missing values from dropdown data validation list in cells 'B3', 'B4'
etc.
Expected Results:
Bug first. The cell data validation formula should work as soon as the file is
opened.
Bug two. Values from the data validation list should not disappear after
saving.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
The file in which the error occurs.
https://disk.yandex.ru/i/YcsnRgiFjdkbMQ
--
You are receiving this mail because:
You are the assignee for the bug.
