[Libreoffice-bugs] [Bug 108673] New: FILESAVE XLSX: Copy-pasting cell validation may result in a sheet reference error saved as invalid xlsx content

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108673

            Bug ID: 108673
           Summary: FILESAVE XLSX: Copy-pasting cell validation may result
                    in a sheet reference error saved as invalid xlsx
                    content
           Product: LibreOffice
           Version: 5.4.0.0.beta2
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 134188
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134188&action=edit
Example source file

Attached file has two sheets, with cell validation in the B1 cells.

When copy-pasting the B1 cell from both sheets to the firsd sheet of a new
spreadsheet document, the sheet reference part of the validation source becomes
a #REF! error: $Sheet2.$A$1:$A$3 becomes $#REF!.$A$1:$A$3

This may make some sense in itself, as there is no second sheet in the new
document. Adding a new sheet and pasting there gives correct results.

The main problem is that the validation source with #REF! error can be saved to
both ODS and XLSX format, and in the case of XLSX, Excel 2013 considers it an
invalid file.

-- 
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/20170621/dd527ab4/attachment.html>