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

Free Support Forum - aspose.com

Conditional formatting error

Aspose.Cells Product Family
#1

Hi. I have found, that cell.getDisplayStyle() returns now incorrect value, that should be returned only when condition is true.

@Test
public void test() throws Exception {
    Workbook workbook = new Workbook("E://in.xlsx");

    Cell cell = workbook.getWorksheets().get(0).getCells().get("K13");
    Style style = cell.getDisplayStyle();

    Color color = style.getForegroundColor();
    byte red = color.getR();
    byte green = color.getG();
    byte blue = color.getB();

    System.out.println(red + "," + green + "," + blue);
}

in.zip (7.6 KB)

Best regards. Alexey

#2

@makarovalv,

Thanks for the sample code and template file.

After an initial test, I am able to reproduce the issue as you mentioned by using the following sample code with your template file. I found an issue with conditional formatting in Style.getDisplayStyle method. I noticed it gives same values whether the condition is true or false.
e.g
Sample code:

Workbook workbook = new Workbook("f:\\files\\in.xlsx");

        Cell cell = workbook.getWorksheets().get(0).getCells().get("K13");
        Style style = cell.getDisplayStyle();

        Color color = style.getForegroundColor();
        byte red = color.getR();
        byte green = color.getG();
        byte blue = color.getB();

        System.out.println("Condition False: " + red + "," + green + "," + blue);

        cell.putValue(5);

        style = cell.getDisplayStyle();

        color = style.getForegroundColor();
        red = color.getR();
        green = color.getG();
        blue = color.getB();

        System.out.println("Condition True: " + red + "," + green + "," + blue);

Output:

Condition False: 112,-83,71
Condition True: 112,-83,71 //Even the green value is not right.

I have logged a ticket with an id “CELLSJAVA-42932” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

#3

@makarovalv,
Please try our latest version/fix: Aspose.Cells for Java v18.5.7:
aspose-cells-19.5.7.zip (6.5 MB)

Your issue should be fixed in it.

Let us know your feedback.

#4

The issues you have found earlier (filed as CELLSJAVA-42932) have been fixed in Aspose.Cells for Java 19.6. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi