Autofilter causes Excel to display the filter dropdown button even if no filter is set
I am trying to write a worksheet which contains a single table. I can set the auto_filter property to None, because I do not want the filter buttons to be displayed in Excel when I will open the generated file. Up to the moment I call save method on my workbook, the autofilter is not really None but an instance of AutoFilter which has a None ref, which I guess is OK. However when being serialized, it appears that the element "auto_filter" is output with a ref corresponting to my table ref, ie A1:AJ11. I checked that after write my table auto_filter has not been changed. This means that instead of using the table auto_filter value, at some point the serialization defines a "default" auto_filter which is highly unwanted, as we lose the intent (no filter)