Created attachment 114445 [details]
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 :
Tested OSes : Fedora 21, Windows 7
Created attachment 114505 [details]
(In reply to raal from comment #1)
> Created attachment 114505 [details]
> excel 2010
In my language is delimiter comma ; (LEN(C6)-FIND(".",C6,1))=2 here is delimiter dot
I can confirm with LO 126.96.36.199, win7
I changed formula to accept delimiter "," and this doesn't work in LO.
I doesn't see formulas in data validation help, so I think it's not suppported. Marking as enhancement.
This should be fixed in LO 6.2, thanks to bug 96698. I tested percent-validation.xlsx and it accepted 0.11, 0.24 and 0.99. Perhaps the original responders can test their specific expectations and report back on whether they also consider it to be fixed.
Duplicate per last comment. Also works in current versions, sans the locale-specific difference in decimal separator. But that is also there in Excel.
*** This bug has been marked as a duplicate of bug 96698 ***