I am evaluting Aspose.Cells 4.7.1.0 for use in an application we are developing. I need to read an XLS spreadsheet and merge in an XML spreadsheet, but have encountered a few problems with settings being lost.
The code I am using is:
Dim wkbkAspose As New Aspose.Cells.Workbook(), wkbkMerge As New Aspose.Cells.Workbook()
wkbkAspose.Open("C:\Temp\Aspose_Test_Blank.xls")
wkbkMerge.Open("C:\Temp\Aspose_Test_Merge.xml")
wkbkAspose.Combine(wkbkMerge)
wkbkAspose.Save("C:\Temp\Aspose_Test_Tgt.xls")
wkbkAspose.Save("C:\Temp\Aspose_Test_Tgt.xml")
I have attached Aspose_Test.zip, which contains the source and generated files.
The following problems are occurring on Sheet4 of the Aspose_Test_Tgt files:
- AutoFilter is shown, but does not function. In the XML file, the _FilterDatabase range is defined twice. Also, the "Use AutoFilter" permission is not being preserved on the sheet.
- In the XLS version, the conditional formatting (e.g. D4) is not working. It appears that the formula was quoted in the XLS version (="$E$1<=100" instead of =$E$1<=100); may be due to the less than sign.
Please let me know if these problems can be resolved. We like your product, but need to know that it can handle our needs.
