Is there a formula to get row and column of range end in openoffice calc?

Question

I am using OpenOffice Calc. I have a text which is address range, indirectly used for my calculations. My text is "C5:K5". It may vary at times.

I use ROW("C5:K5") and COLUMN("C5:K5") functions to get row as 5 and column as 3. So, these are values of "C5". How can I get row and column of "K5" from "C5:K5"? That is the second part of the range

I tried COLUMN(indirect(text)), but it gives from the first part only.