https://bugs.documentfoundation.org/show_bug.cgi?id=90324
Bug ID: 90324
Summary: xlsx export : Text formatted custom validated cell
does not allow entry of valid numbers
Product: LibreOffice
Version: 4.4.1.2 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 114445
--> https://bugs.documentfoundation.org/attachment.cgi?id=114445&action=edit
xlsx file with text formatted cell having custom validation
Steps to reproduce
1. Open the attached xlsx file in calc
2. Edit cell C6 and enter the number 0.34
3. Calc cell validator error popup comes up saying that entry is invalid even
though the entry is valid per the custom validation formula set in Excel.
I can confirm that this problem does not happen when editing this file in Excel
2013.
The custom validation formula for cell C6 is :
=AND(VALUE(C6)>=0,VALUE(C6)<100,(LEN(C6)-FIND(".",C6,1))=2,ISNUMBER(VALUE(RIGHT(C6,1))),ISNUMBER(VALUE(LEFT(C6,1))))
Tested OSes : Fedora 21, Windows 7
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
