[Libreoffice-bugs] [Bug 143211] Better example macro

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Rafael Lima <rafael.palma.lima at gmail.com> ---
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 why the macro
deals with the cell formula instead of accessing the value directly? (I would
like to understand it so I can document it better)

The fact that the macro works with the cell formula leads to weird situations,
for instance (see the attached file): 
- Column A has some values
- Column C has a validity rule to accept only integer values that are <= 100;
if an error occurs, I call the macro you proposed
- Note that if the user inputs values directly, everything works as expected;
but if a formula is entered, the formula result is not validated; for example,
in cell C5 the result of the formula is 50 (which is <= 100) but still I get an
error.

So regardless of the formula result, the validation rule returns an error.
Hence, I don't know why LO implemented this feature using the cell formula.

I know that this is not related to the macro you proposed. But I think it's an
important point to address when updating the help page.

-- 
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/20210706/da90ff36/attachment-0001.htm>