Bug 48200

Summary: Calc FILEOPEN: Regex option in database range filters not saved.
Product: LibreOffice Reporter: Andreas Säger <villeroy>
Component: CalcAssignee: Noel Power <nopower>
Status: RESOLVED FIXED    
Severity: normal CC: iplaw67, sasha.libreoffice
Priority: medium Keywords: regression
Version: 3.5.2 release   
Hardware: Other   
OS: All   
Whiteboard: target:3.7.0 target:3.6.2
Crash report or crash signature: Regression By:
Attachments: Spredsheet with a db-range filtered by regex. Refresh the db-range and see.

Description Andreas Säger 2012-04-02 08:38:52 UTC
When I define a regex filter for a database range the regex option is turned off when I reload the document.
Comment 1 sasha.libreoffice 2012-06-29 03:21:09 UTC
Thanks for bugreport
Please, attach screenshot of this bug
Comment 2 Alex Thurgood 2012-07-02 00:44:10 UTC
Andreas,

Could you provide us with a sample db and the regex expression you are using please ?

Does the problem still occur in 3.5.4 stable ?

Alex
Comment 3 Andreas Säger 2012-07-14 08:24:59 UTC
Created attachment 64193 [details]
Spredsheet with a db-range filtered by regex. Refresh the db-range and see.
Comment 4 sasha.libreoffice 2012-07-20 10:27:25 UTC
Thanks for attachment with test case and explanations.
Reproduced in 3.6.beta1 on Fedora 64 bit
Not reproduced in 3.3.4 , therefore regression

Steps to reproduce:
0. Open attachment
1. Click cell with autofilter there, select "Standard filter"
2. Click "More options" button there and enable "Regular expression" option
3. Save document
4. File->Reload
Expected: "Regular expression" option remains enabled
Actually: it disabled

When I save document in 3.6.b1 with "Regular expression" option enabled, then open in 3.3.4, this option remains enabled. Therefore 3.6.b1 saves this option correctly, but can not load.
Comment 5 Noel Power 2012-08-16 12:53:08 UTC
I take a shot at fixing this
Comment 6 Noel Power 2012-08-16 16:40:53 UTC
fixed I think
Comment 7 Not Assigned 2012-08-16 16:43:12 UTC
Noel Power committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=094654fcebe35af07a9e12137becdf85277ef706

fix for fdo#48200.diff import regrex state for filter
Comment 8 Not Assigned 2012-08-16 16:49:08 UTC
Noel Power committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=d88325f73e6912928913eb41297e6aa4643655f5

Revert "fix for fdo#48200.diff import regrex state for filter"
Comment 9 Not Assigned 2012-08-16 16:49:28 UTC
Noel Power committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=b94bff540a47a9fc5ce0586aa58e28321c96e4aa

fix for fdo#48200.diff import regrex state for filter
Comment 10 Not Assigned 2012-08-20 15:42:20 UTC
Noel Power committed a patch related to this issue.
It has been pushed to "libreoffice-3-6":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=f1c26949e29278a3eae0c167f172a0fd4895fd2f&g=libreoffice-3-6

fix for fdo#48200.diff import regrex state for filter


It will be available in LibreOffice 3.6.2.