Readerclass - Errors with autofilter

[StefanSchmoecker]

1.) If ZCL_EXCEL_READER_2007 finds an autofilter which has no filter critera ( filter just exists ) it hides all lines that are mentioned in the autofilter, even though they do not meet any filter criteria

2.) If a worksheet has an autofilter assigned for some columns and later this autofilter gets switched off, the ZCL_EXCEL_READER_2007 still sees the previous autofilter

[StefanSchmoecker]

1. corrected with revision 445

[StefanSchmoecker]

ad 2) If filtervalues are present, they are being ignored by readerclass completly. This will result in an existing autofilter appearing and the lines that were filtered out by the original autofilter are hidden but the autofilter is not showing that it is responsible for this hiding of rows

[StefanSchmoecker]

3. Autofilters with multiple values shown: Hidden-status of rows not calculated correctly
4. Only single-values filter supported, missing features: Text- and Numberfilters with filter rules
5. When adding a new autofilter with ZCL_EXCEL->ADD_NEW_AUTOFILTER to a sheet that already has an autofilter, then the existing autofilter is returned instead of an exception ( or the method is named poorly )
6. Class ZCL_EXCEL_AUTOFILTERS is very inconsistent in worksheet-parameter of the various methods. When a worksheet is needed as parameter it is sometimes expected as TYPE REF TO ZCL_EXCEL_WORKSHEET and sometime as TYPE UUID. The latter is somewhat unexpected - this is the first time I have realized we have an UUID for the sheets and I AM working with A2X. I consider switching the parameter to "TYPE ANY" with a comment that we accept either worksheet or uuid and make these methods behave in a uniform way

**) I like the fact that the constant C_AUTOFILTER is part of class ZCL_EXCEL_AUTOFILTERS. ( This is needed by the reader- and writerclass to examine/build the ixml document ). But unfortunately this approach ends here. In my opinion this class could take over (at least part of) the reading/creating of the ixml structures in the reader and writerclass. But this is something that could be said of some other classes as well,would require some redesigning in the reader- and writerclasses and should be discussed in the otherwise quite deserted SAP Community Network - Open Source space

[StefanSchmoecker]

Some issues solved with latest build - I'll update the topic to reflect which problems remain and which have been solved

[StefanSchmoecker]

Followup: Which problems have been solved or which have arisen with V 7-_0_5 Autofilters not written out correctly any more,
Reader still doesn't read in filter area correctly

[miskohut]

So there is no possibility to select more values for one filter of one column?

[ivanfemia]

@miskohut the issue is in the reader class... If you generate an excel you're able to select multiple values

[miskohut]

@ivanfemia Hi, please check issue #440, there is problem with multiple values in writer class as well.