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
inSheet.getCellAt("Sheet1.".concat((startPoint.concat(":")).concat(endPoint))).setBackgroundColor(Color.green); I'm assuming I've tried doing it the wrong way Any help pointing me in the right direction would be appreciated James -- --- 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.