[Libreoffice-bugs] [Bug 143068] New: FILESAVE XLSX Standard filter condition of Top10 lost

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 143068
           Summary: FILESAVE XLSX Standard filter condition of Top10 lost
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
            Blocks: 123807

Created attachment 173198
  --> https://bugs.documentfoundation.org/attachment.cgi?id=173198&action=edit
Example file from Excel with Top10 type condition

Attached example files were made in Excel and contain a Top10 standard filter
condition on the times in column D.
These are imported correctly in Calc, but are lost on save to XLSX.

Steps to reproduce:
    1. Open attached file in Calc
    2. Open the autofilter, select Standard Filter, notice there is Largest or
Smallest condition set.
    3. Save as XLSX, reopen in Calc or Excel, Open the autofilter, select
Standard Filter,

Actual results:
The Standard Filter dialog does not show the Largest or Smallest condition.

Expected results:
The Standard Filter dialog should show the Largest or Smallest condition.

LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 6805efdecb240fad8c82a5c1756a2a0e92f12b7d
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=123807
[Bug 123807] [META] XLSX Autofilter-related bugs
-- 
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/20210625/150547b6/attachment.htm>