Hi,
When using Aspose.Cells 4.7.1, I found that the created combobox cannot be saved by Workbook.Save ( String fileName, FileFormatType fileFormatType ). Is it possible in Aspose.Cells 4.7.1? Is it possible with latest version?
With 4.7.1, I do can create combobox on an existing workbook (with fileFormatType as 7) and successfully saved it with Workbook.Save ( String fileName ) without giving file extention in the fileName, then change the saved file's extension to xls and open to see the combobox works properly.
Even so, I don't know how to open the saved workbook with Aspose API (since I don't its format), and noticed the locked cells are not locked anymore, is it the same behavior as the latest version?
To illustrate the problematic saving, here is an example:
//Open the existing workbook
FileStream fs = new FileStream(exisitingFilePath, FileMode.Open)
WorkbookDesigner designer = new WorkbookDesigner();
designer.Workbook.Open(fs, (FileFormatType)Enum.Parse(typeof(FileFormatType), (FileFormatType)Enum.Parse(typeof(FileFormatType), "7")));
//Create the combobox
Aspose.Cells.ComboBox comboBox = designer.Workbook.Worksheets[0].Shapes.AddComboBox(2, 0, 2, 0, 22, 100);
comboBox.LinkedCell = "A1";
comboBox.InputRange = "C1:C5";
//Save it
designer.Workbook.Save(@"D:\test.xls", (FileFormatType)Enum.Parse(typeof(FileFormatType), "7"));
` //Then there's NO combobox can be found in the saved excel
Is it a bug in latest version?
Thanks