On 06/10/09 11:28, Jan Holst Jensen wrote:
> I am trying to work with ranges in Calc. However, I cannot figure out
> how to instantiate a non-contiguous cell range from its address string.
> The code below (result of AllRanges.AbsoluteName) may for example show
> "$Sheet1.$C$3:$C$5;$Sheet1.$E$3:$E$4" if my selection consists of two
> separate ranges.
>
> 1) I can't figure out how to instantiate a range from the string
> "$Sheet1.$C$3:$C$5;$Sheet1.$E$3:$E$4". getCellRangeByName won't do it
> and neither will insertByName("", "$Sheet1....").
There's addRangeAddresses with a sequence of CellRangeAddress, but not
directly with a string. You can parse a single CellRangeAddress with
com.sun.star.table.CellRangeAddressConversion, if you find the
separators yourself (a sheet name can contain a semicolon, so if you
want to be perfect in finding the separators, you have to handle quoting).
> 2) Can I easily get the total cell count of my AllRanges object ?
> AllRanges.Cells.Count seemed intuitive but does not exist.
To count the non-empty cells, you can use
AllRanges.computeFunction(com.sun.star.sheet.GeneralFunction.COUNT).
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail:
dev-unsubscribe@...
For additional commands, e-mail:
dev-help@...
