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

            Bug ID: 102273
           Summary: Cell data validity imported from xlxs fails
           Product: LibreOffice
           Version: 5.2.1.2 rc
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: n...@cyviz.com

Created attachment 127424
  --> https://bugs.documentfoundation.org/attachment.cgi?id=127424&action=edit
Spreadsheet demonstrating the bug.

The data validity fails after importing the attached xlsx spreadsheet.

I am unable to look at the original formatting details, as I do not have access
to MS Excel, but after import, the criteria tab show Allow:All values. Other
fields in this tab is greyed out, but the grey fields contain Data:valid range,
Minimum:OR(K26="Y",K25="N"), Maximum:0, suggesting the original format may be
incompatible with Libreoffice Calc, and needs converting.

The Error Alert tab, have the "show error messages when invalid values are
entered" checked, and Action=Stop, Title=Invalid Entry!, Error message:Press
enter Y or N (Yes/No).

This obviously was written to check if you enter y or n, but it fails with the
above error message, no matter what you try to type in the cell. Since criteria
apparently was converted to allow all, but still fails, this looks like a bug.
But of course, the preference would be proper conversion or support for the
original condition.

FYI:The attached xlsx spreadsheet can also be found in bug#102272 since it
contains two bugs.

-- 
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

Reply via email to