Loss of validation with SpreadsheetML


#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 at www.aspose.com/downloads. We have found and fixed this problem.


#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…