Le 06/06/2016 14:59, James Pollard a écrit :

Hi, I'm trying to workout how to select a range of cells then change the 
background colour
This is what I've tried so far as well as variations of this


I'm assuming I've tried doing it the wrong way

Any help pointing me in the right direction would be appreciated


You must iterate on each cell :

        final Range r = Range.parse(rangeString);
        for (int y = r.getStartPoint().y; y <= r.getEndPoint().y; y++) {
            for (int x = r.getStartPoint().x; x <= r.getEndPoint().x; x++) {
                getCellAt(x, y).setBackgroundColor(color);



--- You received this message because you are subscribed to the Google Groups "jOpenDocument" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jopendocument+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to