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

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125914

--- Comment #5 from Aron Budea <baron at caesar.elte.hu> ---
(In reply to NISZ LibreOffice Team from comment #2)
> Reproduced in Calc, without involving an XLSX file:
Indeed, I was thinking the whole thing was unsupported in Calc, but since the
cell reference works, there's no reason why self-reference shouldn't work.

(In reply to m.a.riosv from comment #4)
> Change the value of a cell doesn't validate against itself, what it's
> wrong?, the opposite works as if no validation, so for what is needed the
> validation, in such case?.
The point of self-referring the cell is that you only want to allow the entry
of a specific type of data (ie. whole numbers, decimals etc.), but want to put
no further restriction on it. There's no such option in the "Data" dropdown, so
it can't be done in a different way AFAIK.

And even if there's another way, this is an interop issue between Excel and
Calc, because Excel accepts any entries in a cell with self-referencing
validity criteria, as long as it conforms to the selected type of data. You can
enter data in such cell in Excel, but not in Calc, what is that if not an
issue?

-- 
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/20191004/6ee32d30/attachment.html>