SaveToStream vs. Save(Stream-FileFormat)

I have been using MemoryStrean stream = workbook.SaveToStream(), but now I am streaming to either PDF or Excel memory stream based on the passed in parameter, so now I have switched to

MemoryStream stream = new MemeoryStream();

workbook.Save(stream, isPDF ? FileFormatType.Pdf : FileFormatType.Default)

I looked up the documentation on Save(Stream, FileFormatType) and FileFormatType.Default stands for Excel2003. Is it the same format that my prior workbook.SaveToStream was using? I actually need to be backwards compatible with even older versions of Excel, so will probably need toswitch to FileFormatType.Excel2000, but before I do I'd like to know what format I was using before with the SaveToStream method, as so far noone has complained, although the number we have, so far, had mostly internal users who have Excel2003 or later, but we stream data out to a browser, so external users very well may have older versions of Excel or perhaps even OpenOffice spreadsheet or other, non-microsoft spreadsheets, and that is why I'd like to stick to older, simpler (more compatible?) file versions

I loo

Hi,

Thanks for your inquiry.

Well, there is not much difference b/w MS Excel 97 - 2003 file format specifications, they are the same. So, you may use any file format type for your need, e.g FileFormatType.Excel97, FileFormatType.Excel2000, FileFormatType.ExcelXP, FileFormatType.Excel2003, FileFormatType.Default or even you do not specify file format type. And, yes, in older versions of Aspose.Cells for .NET, the FileFormatType.Default refers to Excel2000 and in the newer versions. it refers to Excel2003. Also, the SaveToStream method refers to the Default format type if you are saving xls file. Moreover, it does not matter if your clients (having Excel 2000 on their machines) open the files (generated by Aspose.Cells using FileFormatType.Default) on their ends, it will work just fine.

Thank you.