Bug 63019 - filter problem
Summary: filter problem
Status: CLOSED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.1.2 release
Hardware: x86-64 (AMD64) Linux (All)
: highest critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-04-02 09:45 UTC by hfrancod
Modified: 2013-11-05 17:19 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
attachment-24296-0.html (3.32 KB, text/html)
2013-04-03 07:30 UTC, hfrancod
Details
attachment-24296-1.dat (1 bytes, multipart/alternative)
2013-04-03 07:30 UTC, hfrancod
Details
03 marzo 13.ods (12.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-04-03 07:30 UTC, hfrancod
Details
03 marzo 13.ods where I removed the filters. (23.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-04-03 12:18 UTC, Petr Mladek
Details

Note You need to log in before you can comment on or make changes to this bug.
Description hfrancod 2013-04-02 09:45:20 UTC
Can not filter a table (autofilter). When i use autofilter, the software hangs
Comment 1 Petr Mladek 2013-04-02 16:14:58 UTC
I am not able to reproduce this. I tested the official 4.0.2.1 and 4.0.2.2 builds on SLED11-SP2 x86_64. I tried to create and play with autofilter and it worked fine.

hfrancod@ could you please provide more details?

   1. What system are you using, please?  (Linux vendor, architecture)
   2. Did you get the packages from http://www.libreoffice.org/download/pre-releases/ or from any other 
       location, please?
   3. Could you please attach a test document the steps to reproduce the problems?

The best form is:

     1. Open test document in Calc
     2. Select in menu....
     3. Do this
     4. Do that
     ....

Result:  ...
Expected result: ...
Comment 2 hfrancod 2013-04-03 07:30:00 UTC
Created attachment 77356 [details]
attachment-24296-0.html

ok

1. Ubuntu 13.04 unity x86_64 bits
2. i have get the packages from distribution Ubuntu 13.04
3. open 03marzo 13.ods
it is not possible disable filter
when i try to filter LO calc block. It is necessaire to close the windows


Le 02/04/2013 18:14, bugzilla-daemon@freedesktop.org a écrit :
> Petr Mladek <mailto:pmladek@suse.cz> changed bug 63019 
> <https://bugs.freedesktop.org/show_bug.cgi?id=63019>
> What 	Removed 	Added
> Status 	UNCONFIRMED 	NEEDINFO
> Ever confirmed 		1
>
> *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=63019#c1> 
> on bug 63019 <https://bugs.freedesktop.org/show_bug.cgi?id=63019> from 
> Petr Mladek <mailto:pmladek@suse.cz> *
> I am not able to reproduce this. I tested the official 4.0.2.1 and 4.0.2.2
> builds on SLED11-SP2 x86_64. I tried to create and play with autofilter and it
> worked fine.
>
> hfrancod@ could you please provide more details?
>
>     1. What system are you using, please?  (Linux vendor, architecture)
>     2. Did you get the packages from
> http://www.libreoffice.org/download/pre-releases/  or from any other
>         location, please?
>     3. Could you please attach a test document the steps to reproduce the
> problems?
>
> The best form is:
>
>       1. Open test document in Calc
>       2. Select in menu....
>       3. Do this
>       4. Do that
>       ....
>
> Result:  ...
> Expected result: ...
> ------------------------------------------------------------------------
> You are receiving this mail because:
>
>   * You reported the bug.
>
Comment 3 hfrancod 2013-04-03 07:30:00 UTC
Created attachment 77357 [details]
attachment-24296-1.dat
Comment 4 hfrancod 2013-04-03 07:30:00 UTC
Created attachment 77358 [details]
03 marzo 13.ods
Comment 5 Petr Mladek 2013-04-03 12:14:29 UTC
Hmm, I am still not able to reproduce the freeze with your document and the official TDF build. It might be related to the system libraries used by the Ubuntu build => adding Ubuntu maintainer into CC.


Anyway, the autofilter in the document behaves strange way:

     + If I sort the column "A" descending, it moves the title line to the row "79". I would expect
         that the title line stays in the row "1".

        This problems go away when I remove the filter and create it again only for the columns "A-L". By 
        other words, only for the columns that have some string in the title cell.


     + Also I had troubles to remove the filter. I had to choose both menu entries: "Data/Filer/Remove
        Filter" and "Data/Filter/Hide Autofilter".

        I am not sure how is this supposed to work. Maybe there were more filters defined
        at the same time.

I add some Calc hackers who could comment on this.

The freeze is not reproducible with the official build. The strange behavior is visible also with older releases and can be solved => this bug should not block the official 4.0 bugfix releases with other useful fixes => lowering the severity a bit.
Comment 6 Petr Mladek 2013-04-03 12:18:49 UTC
Created attachment 77382 [details]
03 marzo 13.ods where I removed the filters.

I attach the document where I removed the filters. It might help you to continue the work.

Alternatively, you could try the official packages from http://www.libreoffice.org/download.

BTW: Is this a new problem with L0-4.0.2.1? Were you able to edit the same document with older LO Ubuntu builds without problems?
Comment 7 hfrancod 2013-04-03 12:39:46 UTC
i can edit the same document with older Ubuntu 12.04 LO 3.5.7.2
Version ID : 350m1(Build:2) without problems


2013/4/3 <bugzilla-daemon@freedesktop.org>

>   *Comment # 6 <https://bugs.freedesktop.org/show_bug.cgi?id=63019#c6> on bug
> 63019 <https://bugs.freedesktop.org/show_bug.cgi?id=63019> from Petr
> Mladek <pmladek@suse.cz> *
>
> Created attachment 77382 [details] <https://bugs.freedesktop.org/attachment.cgi?id=77382> [details] <https://bugs.freedesktop.org/attachment.cgi?id=77382&action=edit>
> 03 marzo 13.ods where I removed the filters.
>
> I attach the document where I removed the filters. It might help you to
> continue the work.
>
> Alternatively, you could try the official packages fromhttp://www.libreoffice.org/download.
>
> BTW: Is this a new problem with L0-4.0.2.1? Were you able to edit the same
> document with older LO Ubuntu builds without problems?
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>
Comment 8 QA Administrators 2013-11-04 22:18:22 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team
Comment 9 Eike Rathke 2013-11-05 17:19:35 UTC
The filter applied wasn't an AutoFilter but a Standard filter with filter buttons displayed and explicitly defined to have no column headers, hence those entries were treated as normal data and sorted.

Closing this bug as apparently nobody could reproduce the originally reported problem with hang/freeze.