We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Conditional formatting for values not working


I have founded (v., that conditional formatting for values is not working properly. We have a workbook with conditional formatting, that format number to 3 decimal digits. But when i use getDisplayStringValue() for cell, it returns value, formatted according with formatting cell (without conditional format)

public void conditionalFormatValue() throws Exception {
Workbook wb = new Workbook(“D://in.xlsx”);

Cells cells = wb.getWorksheets().get(0).getCells();

Cell b4 = cells.get(“B4”);
Cell c4 = cells.get(“C4”);

System.out.println("Should out: 0 - 12,54587 : " + b4.getDisplayStringValue() + " - " + c4.getDisplayStringValue());

System.out.println("Should out: 1 - 12,546 : " + b4.getDisplayStringValue() + " - " + c4.getDisplayStringValue());


Hi Alexey,

Thank you for contacting Aspose support.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for Java, and we are able to replicate the behavior of reading conditionally formatted values with DisplayStringValue. We have logged this incident in our bug tracking system under the ticket CELLSJAVA-41085 for further investigation. Please spare us little time to properly investigate the problem cause, and to provide the fix (if applicable). In the meanwhile, we will keep you posted with updates in this regard.


Please try our latest fix/version: Aspose.Cells for Java v8.3.0.1

We have fixed your issue "CELLSJAVA-41085" now.

Let us know your feedback.

Thank you.

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.