Loss of validation with SpreadsheetML

Aspose.Cells Product Family
1

Hi,


When I load an excel spreadsheet(Excel97) in Aspose.Excel(3.5.3.4). Then save it
in SpreadsheetML format it looses list validation that was set on the
cells.

Is this likely to be supported in the near future?


Thank you


Verge

2

Hi Verge,

Please try this one. It's supported now.

3

Hi Laurence,



Thanks again for your quick response, sorry for my delay getting back to you.



Unfortunately I am getting the following error:



[NullReferenceException: Object reference not set to an instance of an object.]
   Aspose.Excel.Converter.ತ.ConvertToSSMLFormula(String formula, Int32 currRow, Int32 currCol) +63
   Aspose.Excel.Converter.Ӓ.ԛ(XmlTextWriter ԗ, Worksheet ԙ, Excel ӳ) +1178
   Aspose.Excel.Converter.Ӓ.ԝ(XmlTextWriter ԗ, Worksheet ԙ, Excel ӳ) +3140
   Aspose.Excel.Converter.Ӓ.Ԕ(Excel ӳ, Stream ԕ) +413
   Aspose.Excel.Converter.Ӓ.ConvertTo(Excel excel, Stream stream, FileFormatType format) +82
   Aspose.Excel.Excel.Save(Stream stream, FileFormatType fileFormatType) +48


When trying to save the attached Spreadsheet as a spreadsheetML file on the following line of code:



template.Excel.Save(myWriteStream, FileFormatType.SpreadsheetML);



Thanks



Verge
4

Hi Verge,

Please download and try v3.6.

5

Hi Laurence,



Thanks for that. It’s fixed that spreadsheet, but I am getting a very similar issue:



[ApplicationException: Invalid column expression: =Enum_ISO4217_currency_code]
   Aspose.Excel.Converter.ತ.ಬ(String צ, Int32 ӥ, Int32 Ӧ) +196
   Aspose.Excel.Converter.ತ.಩(StringBuilder ದ, String ց, Int32 ӥ, Int32 Ӧ, Int32 ಪ, Int32 ಫ) +506
   Aspose.Excel.Converter.ತ.ConvertToSSMLFormula(String formula, Int32 currRow, Int32 currCol) +351
   Aspose.Excel.Converter.Ӓ.ԛ(XmlTextWriter ԗ, Worksheet ԙ, Excel ӳ) +1087
   Aspose.Excel.Converter.Ӓ.ԝ(XmlTextWriter ԗ, Worksheet ԙ, Excel ӳ) +3141
   Aspose.Excel.Converter.Ӓ.Ԕ(Excel ӳ, Stream ԕ) +403
   Aspose.Excel.Converter.Ӓ.ConvertTo(Excel excel, Stream stream, FileFormatType format) +82
   Aspose.Excel.Excel.Save(Stream stream, FileFormatType fileFormatType) +48


In the same line of code:



template.Excel.Save(myWriteStream, FileFormatType.SpreadsheetML);



When saving the attached spreadsheet.



Cheers



Verge
6

Hi Verge,

Please try this attached fix.

7

Fantastic, that seems to have fixed it.



Thanks again…