Hello
I have founded (v.8.2.2.2), 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());
b4.setValue(1);
System.out.println("Should out: 1 - 12,546 : " + b4.getDisplayStringValue() + " - " + c4.getDisplayStringValue());
}