Free Support Forum -

Conditional Format Problem

Hi, im reading this file using Aspose.Cells, it has an pivot table, and this pivot table has conditional format for a column on it. when I write some data to the book and save it, the conditional formnat get lost.

Can you help me?

thanks in advance.

Code used to write to the book:

Workbook wb=new Workbook();
try {
if(is!=null && is.available()>0){;
}catch(IOException eIO){
System.out.println(“IOException Occurred:”+eIO.getMessage());

and some lines before …

for(int i=1;i<=iColumns;++i){
cell = sheet.getCells().getCell(iFirstRow-1, i-1);
case Types.BIT:
case Types.BOOLEAN:
case Types.TINYINT:
case Types.INTEGER:
case Types.SMALLINT:
case Types.BIGINT:
intValue = rs.getInt(i);
case Types.NUMERIC:
case Types.DECIMAL:
case Types.FLOAT:
case Types.REAL:
case Types.DOUBLE:
doubleValue = rs.getDouble(i);
case Types.DATE:
case Types.TIMESTAMP:
dateValue = rs.getDate(i);
case Types.NULL:
case Types.TIME:
stringValue = rs.getString(i);
if(!rs.wasNull() && !stringValue.trim().equals("")){


I have found the issue after an initial test, we will figure it out soon.

Your issue has been logged into our issue tracking system with an issue id: CELLSJAVA-12493.

Thank you.

Ok, thanks, I’ii be waitting the hotfix.

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Please try the attached new fix( Currently, we do not support to parse such kind of Conditional Format of Excel2007. We just keep the original data of such kind of Conditional Format and re-save it back when saving file as excel2007. We will support to parse and manipulate such Conditional Formats in future.

Thank You & Best Regards,

Sorry about the delay, I was searching for another solution.
The fix doesn’t work, I still having the same problem.


Well, we have conduct some tests, opening your template file, filling some data to the source range for the pivot table and then re-save the file, the conditional formatting are not lost. We appreciate if you could create a simple console application (with all the details) to reproduce the issue. Also, post your saved file here to point out where the issue lies. We will check your issue soon.

Thank you.

The issues you have found earlier (filed as 12493) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.