hello, in Calc ver. 4.2.6, if I select a number of columns, is there a way to count them other than manually? i.e. there are a lot of columns in this file and I just wanna know how many
I think there are a couple of functions that can help:
Reference is the reference to a cell or cell area whose first column number is to be found.
Array is the reference to a cell range whose total number of columns is to be found. The argument can also be a single cell.
“… there are a lot of columns in this file and I just wanna know how many[.]”
If there is not intended to apply a function:
If the info field at the right side of the status bar is set to ‘Selection count’ we get the number of columns by selecting only one (the first?) cell of every column. D1:F1~I1:M1~Q1:S1 selected will show 11, e.g.
This worked well for me because some of the columns were emtpy and I actually wanted to count only the ones with content, which appears to be what “selection count” does - and because I don’t know how to apply functions in Calc, so didn’t try that.
Just 2 remarks:
’Selection count’ does count the empty (blank) cells in a collection as well.
What reason to use Calc if you don’t want tu use formulae?