Free Support Forum - aspose.com

Error opening xlsx- if it contains a combo box

I'm using cells for java 2.2.1.0 and I'm generating a combobox Cells cells = sheet.getCells();
int i = 1;
for (Option option : somelist)
{
i++;
cells.getCell("A" + i).setValue(option.getKey());
cells.getCell("B" + i).setValue(
option.getKey() + " " + option.getLabel());
}
ComboBox comboBox = sheet.getShapes().addComboBox(2, 4, 0, 0, 250, 20);
comboBox.setLinkedCell(cells.getCell("A1").getName());
comboBox.setInputRange(COMBO_INPUT + i);
comboBox.setDropDownLines(40);

I store the workbook as *.xlsx. Some user opens the grid, selects some value in the combo box. I try to read in the workbook again with aspose

InputStream in=...;
workbook = new Workbook();
workbook.open(in);

and I get the error

java.io.IOException: It is not a valid file: Invalid selected index.

at line "...open(in)..."

If the user doesn't select any value in the combo box everything works well.

Hi,

Could you post your generated Excel file by Aspose.Cells for Java. We will check your issue soon.

Thank you.

Hi,

After an initial test, I have found the issue using your template file. I have logged your issue into our issue tracking system with an id: CELLSJAVA-18701. We will figure your issue out soon.

Thank you.

Hi,

Please try the attached version.

We have fixed the bug of reading Excel2007 file with combo box.

Thank you.

Thank you - it works!

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


This message was posted using Notification2Forum from Downloads module by aspose.notifier.