On Mon, 12 Dec 2016, Eric Douglas wrote:
I found one sample that shows how to code the condition using org.apache.poi.ss.usermodel.SheetConditionalFormatting.addConditionalFormatting() to put in the formula that would color each cell if it's in an even numbered row, but I'm having trouble figuring out the API to apply the formula to every cell on the worksheet.
For every cell on a sheet, just give a cellrangeaddress that covers the whole extent
For every formula cell, you'd need to loop over all cells checking the cell type, then add just those
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
