Hello Dave, Thanks for the quick response. I have implemented the correction you had suggested and it has not alleviated the problem. The conditional formatting is still not working. I also have a new problem. Previously, the HSSFSheetConditionalFormatting object was obtained as soon as the HSSFSheet object was created and was declared as a global variable. Now, I tried getting an instance of this HSSFSheetConditionalFormatting object everytime a conditional formatting had to be set on a cell. When I do this, I get the following error:
Stack Trace: java.lang.ClassCastException: org/apache/poi/hssf/record/aggregates/DataValidityTable incompatible with org/apache/poi/hssf/record/Record at org.apache.poi.hssf.model.RecordOrderer.findInsertPosForNewCondFormatTable(RecordOrderer.java:162) at org.apache.poi.hssf.model.RecordOrderer.findSheetInsertPos(RecordOrderer.java:101) at org.apache.poi.hssf.model.RecordOrderer.addNewSheetRecord(RecordOrderer.java:89) at org.apache.poi.hssf.model.Sheet.getConditionalFormattingTable(Sheet.java:483) at org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting.<init>(HSSFSheetConditionalFormatting.java:39) at org.apache.poi.hssf.usermodel.HSSFSheet.getSheetConditionalFormatting(HSSFSheet.java:1855) at com.xom.udocs.vudocssecurity.SecurityConfigSheet.createConditionalFormattingObjects(SecurityConfigSheet.java:237) at com.xom.udocs.vudocssecurity.SecurityConfigSheet.create(SecurityConfigSheet.java:145) at com.xom.udocs.actions.vudocssecurity.GenerateSecurityConfigSheetAction.execute(GenerateSecurityConfigSheetAction.java:30) at com.documentum.web.formext.action.ActionService.execute(ActionService.java:335) at com.documentum.web.formext.component.Component$ActionItem.execute(Component.java:1417) at com.documentum.web.formext.component.Component.onaction(Component.java:1557) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60) at java.lang.reflect.Method.invoke(Method.java:391) The line "com.xom.udocs.vudocssecurity.SecurityConfigSheet.createConditionalFormattingObjects(SecurityConfigSheet.java:237)" refers to HSSFSheetConditionalFormatting scf = m_dataSheet.getSheetConditionalFormatting(); in my code. I am not able to use POI 3.5 in my project because of the JDK 1.5 version dependency. I am working with third party API's and they requires JDK 1.4. If anyone has implemented conditional formatting in 3.2, please do let me know. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
