OpenOffice Calc Tips

To determine the number of occurences of a particular letter in a
string - replace it with a empty character and compare the lenghts
of the original and modified strings.

To find the number of ‘g’s in A1…

=LEN(A1)-LEN(SUBSTITUTE(A1;”g”;”"))

A simple macro for sorting sheets in a spreadsheet in ascending alphabetical order.

(more…)

In SUBTOTAL function allows you to perform basic spreadsheet operations on the visible cells in AutoFilter mode.

(more…)