You are here

libreoffice

Ivan Radovanovic's picture

How to check if row is visible when filter is active in OpenOffice Calc or Excel

For example to check if row 5 is visible use formula subtotal(2; A5:A5) - that will return 1 if row is visible, and 0 if it is not. It should work in Excel as well.

Subscribe to RSS - libreoffice