Validation issue for boolean values

Aspose.Cells Product Family
1

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!

2

@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.

3

@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)

4

Thanks for the fix. This works as expected.

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

5

@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.

6

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