Hi we are using Aspose.Cells for Java v2.1 as part of our Aspose.Total licence.
We have a problem where an excel workbook that contains conditional formatting is opened and then saved using Aspose.Cells. The conditional formatting gets really messed up when strikethroughs are used in the formatting.
I have two examples, one that is attached that shows a before and after file. You can see that the conditional formatting of the strikethroughs is removed on the “after” file for the cell with the number 44444 in it. The other example is much more complex and comes directly from our customer, in this example all cells are being marked with a strikethrough in the “after” file. I cannot post this directly on to an open forum as it contains customer information, but I am happy to share directly with a support engineer.
I have written a very simple test method so the problem can highlighted easilly As you can see this code does nothing else but open and then save the file.
public static void testExcel( String path, String filename )
throws Exception
{
FileInputStream fis = null;
FileOutputStream fos = null;
try
{
fis = new FileInputStream( new File( path + filename ) );
File outputFile = new File( path + “output\” + “after_” + filename );
outputFile.createNewFile();
fos = new FileOutputStream( outputFile );
Workbook mExcelWorkbookObj;
mExcelWorkbookObj = new Workbook();
int formatType = mExcelWorkbookObj.getFileFormatType();
System.out.println( "open it, formatType = " + formatType );
mExcelWorkbookObj.open( fis );
System.out.println( “save it” );
mExcelWorkbookObj.save( fos, formatType );
System.out.println( “done” );
}
catch ( Exception e )
{
System.out.println( "error = " + e );
}
}
I look forward to hearing from you ASAP.
Regards
Mike