Created attachment 173198 [details] 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
Created attachment 173199 [details] Example file from Excel with Bottom 10 type condition
Created attachment 173200 [details] Example file with Top10 type condition saved by Calc
Created attachment 173201 [details] Example file with Bottom 10 type condition saved by Calc
Created attachment 173202 [details] Screenshot of the original document with Top10 condition side by side in Excel and Calc
Created attachment 173203 [details] Screenshot of the exported document with Top10 condition side by side in Excel and Calc
Created attachment 173204 [details] Screenshot of the original document with Bottom 10 condition side by side in Excel and Calc
Created attachment 173205 [details] Screenshot of the exported document with Bottom 10 condition side by side in Excel and Calc
Repro Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 6805efdecb240fad8c82a5c1756a2a0e92f12b7d CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d79de2a2975db6b34f47b7ccfe8d18692373d6f0 tdf#143068 XLSX: fix export of top10 filter condition It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Tünde Tóth committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/b17df21168796c0b6907200f8600b065d7e602ad tdf#143068 XLSX: fix export of top10 filter condition It will be available in 7.2.0.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: d1f1f546b212ecd651146addeb328806bb270d5f CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded