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

m.a.riosv <miguelange...@libreoffice.org> changed:

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

--- Comment #19 from m.a.riosv <miguelange...@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 the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to