Thanks for all the inputs! Great stuff.
As I said, I wanted to count the number of non-blank cells in a column,
but as =COUNTA(A$2:A$1, ISBLANK=0) is above an otherwise empty
column returns the value 1, I am obviously not using the function
correctly. =COUNTA(A$2:A$1) does the trick. Thank
That is no surprise to me.
ISBLANK=0
is non-sensical and returns "#NAME?". COUNTA counts
that as a non-empty value. All is good.
Mike
On 6/25/22 15:05, users+h...@global.libreoffice.org wrote:
Subject:
[libreoffice-users] Calc function COUNTA
From:
Harvey Nimmo
Date:
6/25/22, 14:41
To:
Hi mailing list!
I am trying to change the x axis labels for a chart in 7.3 Calc in Collabora
Office for iOS created using the Chart Wizard. The procedure recommended in
the LibreOffice 7.2 Calc documentation (there does not yet seem to be a 7.3
Calc documentation) doesn’t work because there
HI.
Thank you, I'm beginning to figure out Master Documents. Still a few
issues but we'll get to them or solve them no doubt with the least
convenient method.
Book editors and publishers have submission formats they will accept.
They want a certain type face, size, margins and top and bott