Created attachment 198216 [details] Autofilter in LO Autofiltered XLSX with mix of dates and text cannot be opened in MSO. Attached is LO created sample. Reproduced in 24.2 and 25.2+. When same file is opened in LO 7.0, checkboxes are not selected. If selected, saved XLSX opens in MSO. Seems regression, maybe from autofilter changes in 7.2.
Created attachment 198217 [details] Autofilter in LO 7.0
Created attachment 198218 [details] Autofilter in MSO
Reproducible Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 141f3fd15633803afa720837405a0bacbc2726cb CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Excel version Microsoft® Excel® para Microsoft 365 MSO (versión 2411 compilación 16.0.18227.20082) de 64 bits
Bisected to: commit eea523b686b27b4807ab21b62805ce9fbddf74ef [log] author Balazs Varga <balazs.varga991@gmail.com> Wed Jan 20 12:11:14 2021 committer László Németh <nemeth@numbertext.org> Tue Jan 26 13:44:38 2021 tdf#139809 sc ooxml export autofiltered date columns Export XML_dateGroupItem, XML_year, XML_month, XML_day, XML_dateTimeGrouping based on the OOXML standard. Follow up commit of: d101a6f8579df8241dcd8100908868cd7d7c3f8a (tdf#116818 sc OOXML: import autofiltered date columns) Balazs please see. Wnen dealing with this, best is to test all variants, like creating in LO, MSO, opening in other and resaving, and again opening in the original one.
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/8b492a1f3057d2b6c3daed7405000d0270ea3dd9 tdf#164417 ooxml export: fix autofilter wrong attribute order It will be available in 25.8.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.
Balazs Varga committed a patch related to this issue. It has been pushed to "libreoffice-25-2": https://git.libreoffice.org/core/commit/ad535c1b53a8ea72ee778e329d910c6495859c76 tdf#164417 ooxml export: fix autofilter wrong attribute order It will be available in 25.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.