https://bugs.documentfoundation.org/show_bug.cgi?id=143211
Rafael Lima changed:
What|Removed |Added
Assignee|libreoffice-b...@lists.free |rafael.palma.l...@gmail.com
https://bugs.documentfoundation.org/show_bug.cgi?id=143211
--- Comment #7 from Andreas Säger ---
OK, but the user input is not evaluated and this is confusing me. Name it
CellValue. The Boolean return value is more important.
--
You are receiving this mail because:
You are the assignee for the
https://bugs.documentfoundation.org/show_bug.cgi?id=143211
--- Comment #6 from Andreas Säger ---
Created attachment 173395
--> https://bugs.documentfoundation.org/attachment.cgi?id=173395=edit
Test validation formulas
Indeed, a condition is a formula expression (or two), and it is evaluated.
https://bugs.documentfoundation.org/show_bug.cgi?id=143211
--- Comment #5 from Rafael Lima ---
It makes sense... LO does not evaluate the formula before validating cell
content.
My only concern about using "CellFormula" instead of "CellValue" is that it
would cause the same confusion in users.
https://bugs.documentfoundation.org/show_bug.cgi?id=143211
--- Comment #4 from Andreas Säger ---
With or without macro, the validation feature evaluates the literal user input
(the formula). As far as I know, there is no way to catch formula results, no
calculation event or anything like that.
https://bugs.documentfoundation.org/show_bug.cgi?id=143211
Rafael Lima changed:
What|Removed |Added
Ever confirmed|0 |1
Status|UNCONFIRMED
https://bugs.documentfoundation.org/show_bug.cgi?id=143211
--- Comment #3 from Rafael Lima ---
Created attachment 173386
--> https://bugs.documentfoundation.org/attachment.cgi?id=173386=edit
Cell Formula Example
--
You are receiving this mail because:
You are the assignee for the
https://bugs.documentfoundation.org/show_bug.cgi?id=143211
--- Comment #2 from Rafael Lima ---
Hi Andreas!
Thanks for reporting this issue. I agree with you that the example can be
improved. I also tested your code and it works.
There's just one thing I don't understand. Do you have any idea
https://bugs.documentfoundation.org/show_bug.cgi?id=143211
--- Comment #1 from Andreas Säger ---
Created attachment 173376
--> https://bugs.documentfoundation.org/attachment.cgi?id=173376=edit
Validation example based on suggested example macro
The validation in the green area accepts