[Libreoffice-bugs] [Bug 135482] New: EDITING: Data validity fails after copying sheet and deleting original sheet

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: rmkelly314 at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200806/ba14bbe6/attachment-0001.htm>