https://bugs.documentfoundation.org/show_bug.cgi?id=125914
Bug ID: 125914
Summary: XLSX Validation with cells referencing themselves
always gives error
Product: LibreOffice
Version: 4.0.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 108897, 108988
Created attachment 152179
--> https://bugs.documentfoundation.org/attachment.cgi?id=152179&action=edit
Sample XLSX
Open the attached spreadsheet, created in Excel.
In the B column, next to the description validation criteria is set with "equal
to" setting that refers to the cell itself. This means only the basic criteria
is taken into account (whole number, decimal, date, time), and any such entry
can be entered.
Enter values like:
- 645789
- -1956.56
- 1999-08-31
- 23:59
These are all allowed in Excel, but none of them is allowed in Calc. Note that
in Excel the value criteria can be a cell reference, however Calc shows cell
references as values (eg. "B1" instead of "=B1"), and doesn't allow selecting a
referenced cell.
Observed using LO 6.4.0.0.alpha0+ (95462a02a3aee1e3e7f9aa8fc50ba25fee3fa592),
4.0.0.3 / Windows 7.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
https://bugs.documentfoundation.org/show_bug.cgi?id=108988
[Bug 108988] [META] Validity-related bugs and enhancements
--
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
