[Libreoffice-ux-advise] [Bug 105394] A warning should be issued if one of the cells included in the computation has a value of any kind that is not taken into account in the result

[bugzilla-daemon at bugs.documentfoundation.org]

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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #19 from m.a.riosv <miguelangelrv at libreoffice.org> ---
I'm not for that, It implies analyze if it is a value as text for every cell,
and only can carry to reduce the calc's performance, that is currently not done
on ranges.

It can be controlled with formulas like, creating an 'Error' style.

=AVERAGE($A2:A2)+STYLE(IF(SUMPRODUCT(ISNUMBER($A2:A2))<>COLUMNS($A2:A2);"Error";""))

The same can be done with conditional format.

-- 
You are receiving this mail because:
You are on the CC list for the bug.