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

Free Support Forum - aspose.com

Validation issue for boolean values

Hi,

I have encountered an issue where, if a cell has boolean values in drop down, cell.getValidationValue() returns false, even though the value is correct.

The file I am using is Book1.zip (6.6 KB)

The code I am using is as follows:

    Worksheet sheet = wb.getWorksheets().get(0);
    Cells cells = sheet.getCells();
    Cell d4 = cells.get("D4");

    if (d4.getValidationValue())
        System.out.println("d4 is valid");
    else
        System.out.println("d4 is not valid");

    Cell d6 = cells.get("D6");

    if (d6.getValidationValue())
        System.out.println("d6 is valid");
    else
        System.out.println("d6 is not valid");

The excepted output is

d4 is valid
d6 is valid

But the actual output is

 d4 is not valid
 d6 is valid

Note : If there is a blank value selected in the dropdown, the output is as expected.

Thanks in advance!

@dvector,

Thanks for the sample code and template file.

After an initial test, I am able to reproduce the issue as you mentioned by using your sample code with your template file. I have encountered an issue where, if a cell has boolean values in drop down, cell.getValidationValue() returns false, even though the value is correct. I have logged a ticket with an id “CELLSJAVA-43052” for your issue. We will look into it soon.

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

@dvector,

Please try our latest version/fix: Aspose.Cells for Java v19.11.3 (attached)

Your issue “CELLSJAVA-43052” should be fixed in it.

Let us know your feedback.
Aspose_Cells_Java_v19.11.3.zip (6.6 MB)

Thanks for the fix. This works as expected.

Can you please let me know when the fix will be rolled out officially?

@dvector,
You are welcome. The official release will be available before the last week of Dec 2019. You will be automatically notified about the release of this official version here.

The issues you have found earlier (filed as CELLSJAVA-43052) have been fixed in Aspose.Cells for Java v19.12. This message was posted using Bugs notification tool by ahsaniqbalsidiqui