We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Excel Data Validation and Saving as SpreadsheetML

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



<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

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


Kindly try the fix (Aspose.Cells version posted in the thread @: <A href="https://forum.aspose.com/t/88644</A></P> <P>Thank you.</P>