Whenever we save a spreadsheet, that contains an excel data validation, to spreadsheetML, the resulting XML would contain a bad value. For example, we noticed that an equal sign (=) is used instead of a double quote (") in the datavalidation area (see line 7252 in datavalidation.xml attached).

To test this we simply opened datavalidation.xls attached with Aspose and saved it in SpreadsheetML format:

Workbook workbook = new Workbook();
workbook.Open("c:\\datavalidation.xls", FileFormatType.Default);

workbook.Save("c:\\datavalidation.xml", FileFormatType.SpreadsheetML);

-Steve

Hi,

 

Thank you for the template file, we will figure out the issue soon.

 

---

Karen Huang
Developer
Aspose Nanjing Team
About Us
Contact Us

Hi,

Kindly try the fix (Aspose.Cells version 4.5.0.3) posted in the thread @: http://www.aspose.com/community/forums/thread/134097/support-for-replace-function-in-.net.aspx

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Nanjing Team
Contact Us