[Libreoffice-bugs] [Bug 125914] New: XLSX Validation with cells referencing themselves always gives error

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
            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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190614/75424cb4/attachment.html>