https://bugs.documentfoundation.org/show_bug.cgi?id=145103
Bug ID: 145103
Summary: "Invalid Value." window pops up by cells with Validity
check
Product: LibreOffice
Version: 7.2.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 175700
--> https://bugs.documentfoundation.org/attachment.cgi?id=175700&action=edit
Amazon SellerCentral Sheet, any English Letter in D25 gives an "Invalid Value."
error
In the attached excel sheet (generated by Amazon.com SellerCentral), there are
2 errors that occur with Libreoffice Calc but won't occur with MS Excel.
1. "Invalid Value"
In Cell D25 after "First Name:", enter any name such as "David", Calc will
report an error "Invalid Value.".
The cell has a Validity check, which is:
ISNUMBER(SUMPRODUCT(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ")))
However, English letters should have been in the range but somehow not
recognized by Calc.
2. "Re-type Password"
After opening the file for a while (or when one tries to edit other cells such
as J13:J16), a window will pop up asking to "Re-type Password", which cannot
even be cancelled unless one clicks the "Re-type" button after "...sheet Hash
incompatible", enters any password and confirms.
I'm not sure if both problems are related, so could someone please take a look?
Thank you very much.
--
You are receiving this mail because:
You are the assignee for the bug.
