Hello, I am having trouble with the conditional formatting on an Excel sheet being manipulated using POI (HSSF). This is an existing Excel worksheet that I am adding data to one sheet (Data) which is referenced in another (Summary). The "Summary" sheet then uses a combo box to populate from a specific row in the "Data" sheet based on the date selected. Depending on the values here there is some conditional formatting to style the cells background color (this conditional formatting is pre existing and is not manipulated with POI). I am finding that the formatting is not taking place. If I go into the Excel spreadsheet and manually re-enter the values and hit enter the formatting is then updated (or changing the combo box manually the formatting will update). Is there some way to trigger all conditional formatting to "reprocess" in Apache POI before writing the file?
Thanks, Jason -------------------------------------------------------------------------------- This information is directed in confidence solely to the person named above and may contain confidential and/or privileged material. This information may not otherwise be distributed, copied or disclosed. If you have received this e-mail in error, please notify the sender immediately via a return e-mail and destroy original message. Thank you for your cooperation. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
