Bug 151505

Summary:	Autofilter in xslb file ignored
Product:	LibreOffice	Reporter:	Peter Hopfgartner <phopfgartner>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	79045_79045, aron.budea, raal
Priority:	medium	Keywords:	bibisected, bisected, regression
Version:	5.1.0.3 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=91367 https://bugs.documentfoundation.org/show_bug.cgi?id=157689
Whiteboard:
Crash report or crash signature:		Regression By:	Markus Mohrhard
Bug Depends on:
Bug Blocks:	123807
Attachments:	Sample file with filter enabled

Description Peter Hopfgartner 2022-10-13 11:48:54 UTC

Description:
A file with an AutoFilter is created and saved as xslb (Excel Binary). When opening it with LibreOffice, the filter is ignored.

Steps to Reproduce:
1.Create file with filter in Excel 360
2.Save as xslb
3.Open in LO

Actual Results:
No filter in the first row

Expected Results:
filter in the first row


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.4.1.2 (x64) / LibreOffice Community
Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (de_IT); UI: en-US
Calc: threaded

Comment 1 Peter Hopfgartner 2022-10-13 11:49:43 UTC

Created attachment 183012 [details]
Sample file with filter enabled

Comment 2 raal 2022-10-17 16:22:43 UTC

Confirm with Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: 2e887e04c0008a4eb6cbf34050b6fa463a33599f
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

Works in Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

Comment 3 raal 2022-10-17 16:30:29 UTC

This seems to have begun at the below commit.
Adding Cc: to Markus Mohrhard; Could you possibly take a look at this one?
Thanks
 62694407c461f2e095bd0a2497b13014988af9d4 is the first bad commit
commit 62694407c461f2e095bd0a2497b13014988af9d4
Author: Matthew Francis <mjay.francis@gmail.com>
Date:   Wed May 27 23:36:24 2015 +0800

    source-hash-c43a25a7268c1b6ab81e9ba694a1f22223a24afa
    
    commit c43a25a7268c1b6ab81e9ba694a1f22223a24afa
    Author:     Markus Mohrhard <markus.mohrhard@googlemail.com>
    AuthorDate: Tue May 19 01:45:57 2015 +0200
    Commit:     Markus Mohrhard <markus.mohrhard@googlemail.com>
    CommitDate: Tue May 19 02:27:55 2015 +0200
    
        replace import with direct ScCompiler calls, related tdf#91367