https://bugs.documentfoundation.org/show_bug.cgi?id=153214
Bug ID: 153214
Summary: Custom validation breaks after saving (FILEOPEN
issue?)
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Hi,
I've been trying to set a custom validation on a cell with the following
procedure :
1) Create a new calc file
2) Select the A1 cell
3) Go to Data > Validity...
4) Allow=Custom / Keep "Allow empty cells" checked
5) Set formula to : IF(ISNUMBER(A1), AND(INT(A1)=A1, A1 >= 10, A1 <= 20),
COUNTIF({"NC","ND"}, A1)>0)
Therefore, I am allowed to put in A1 cell an integer between 10 and 20 OR a
string among NC or ND.
However, as soon as I do the following, validation doesn't work anymore :
1) Delete the content (only) of A1 cell (the validation rule is still applied)
2) Save the file in .xlsx format
3) Close and reopen it
4) Try to put NC or ND in the A1 cell -> refused
5) Try to put an integer between 10 and 20 -> accepted
I manage to make it work again by resetting the validation formula (ie:
deleting and rewriting one character in the formula and click OK). But it has
to be done after each opening. Therefore I assume there is something missing
during FILEOPEN?
I get the same result with v7.3.7.2 and v7.4.3.2
--
You are receiving this mail because:
You are the assignee for the bug.
