Xlsb in MS Excel 2016

[KrzysztofDusko]

Hello, XLSB file created with dafault settiings cannot be sorted in Excel 2016.. (Excel crashes).

            using var edw = ExcelDataWriter.Create("fileSylvan.xlsb", new ExcelDataWriterOptions() {  CompressionLevel = cLvl});
            DbDataReader dr;
            dr = Dt.CreateDataReader(); // dt = some datatable but this is irrelevant
            edw.Write(dr, "sheetName");

In excel 2019 everything works fine.. I have te same problem with my library :( (https://github.com/KrzysztofDusko/SpreadSheetTasks) I will investigate this yourself in some time.

[KrzysztofDusko]

for sure issue is related with autofilter. Seems than excel 2016 requies than autofilter is defined in sheet + in workbook(xml/bin) in defined names .

[MarkPflug]

I think I've decided I'm going to ignore this issue. To me, this is a bug in Excel 2016, which has been fixed in later versions. Excel 2016 is old enough now that people should move on.