[Libreoffice-bugs] [Bug 140469] FILEOPEN XLSX Autofilter opened incorrectly with more than 8 filtering conditions

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=140469

--- Comment #5 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
Created attachment 169817
  --> https://bugs.documentfoundation.org/attachment.cgi?id=169817&action=edit
Another example file with filtered date column

This is attachment #141122 from bug #116818 saved with current Calc master.

Here the filtering condition changes in the XML (but works the same in Excel),
from:

    <filterColumn colId="0">
      <filters>
        <dateGroupItem year="2014" dateTimeGrouping="year"/>
        <dateGroupItem year="2012" dateTimeGrouping="year"/>
      </filters>
    </filterColumn>

changes is Calc export to:

    <filterColumn colId="0">
      <filters>
        <dateGroupItem year="2014" month="12" day="12" dateTimeGrouping="day"/>
        <dateGroupItem year="2014" month="12" day="13" dateTimeGrouping="day"/>
        <dateGroupItem year="2014" month="12" day="14" dateTimeGrouping="day"/>
        <dateGroupItem year="2014" month="12" day="15" dateTimeGrouping="day"/>
        <dateGroupItem year="2014" month="12" day="16" dateTimeGrouping="day"/>
        <dateGroupItem year="2014" month="12" day="17" dateTimeGrouping="day"/>
        <dateGroupItem year="2012" month="12" day="02" dateTimeGrouping="day"/>
        <dateGroupItem year="2012" month="12" day="03" dateTimeGrouping="day"/>
        <dateGroupItem year="2012" month="12" day="04" dateTimeGrouping="day"/>
        <dateGroupItem year="2012" month="12" day="05" dateTimeGrouping="day"/>
        <dateGroupItem year="2012" month="12" day="06" dateTimeGrouping="day"/>
      </filters>
    </filterColumn>

This puts it above the 8 conditions limit and fails to display in Calc.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210217/128c2bca/attachment.htm>