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: [email protected]
Reporter: [email protected]
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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
