https://bugs.documentfoundation.org/show_bug.cgi?id=135482
Bug ID: 135482
Summary: EDITING: Data validity fails after copying sheet and
deleting original sheet
Product: LibreOffice
Version: 6.3.6.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
After defining a "cell range" data validity in a sheet and then copying that
sheet, the data validity is RIGHT in the new sheet. If you then delete the
original sheet, the data validity is WRONG in the new sheet. Instead of
containing valid entries, the selection list contains only "#REF!".
Steps to Reproduce:
1. Load the attached spreadsheet.
2. On Sheet2, observe that D1’s selection list works correctly.
3. Delete Sheet1.
4. On Sheet2, observe that D1’s selection list now works incorrectly.
Actual Results:
After deleting Sheet1, Sheet2.D1's selection list contains only "#REF!".
Expected Results:
After deleting Sheet1, Sheet2.D1's selection list should still contain "aaa",
"bbb", and "ccc".
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
>From "Help / About LibreOffice":
Version: 6.3.6.2 (x64)
Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497
CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
OS: Microsoft Windows 10 Home, Version 10.0.19041 Build 19041
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
