[Libreoffice-bugs] [Bug 46480] New: Calc 3.5 Cannot Filter Fields from Data Sources

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Wed Feb 22 13:42:01 PST 2012


             Bug #: 46480
           Summary: Calc 3.5 Cannot Filter Fields from Data Sources
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.0 Release
          Platform: All
        OS/Version: All
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: steven at sheltonlegal.net

Recreate thusly:

1. Register a data source (say, a Base file).
2. Launch Calc.
3. Hit F4 to open the Data Sources panel.
4. Select a table from your data source.
5. Click on the "Standard Filter" icon on the Data Sources toolbar.
6. Enter search criteria (i.e., "Date >= 02/01/2012").
7. Hit OK.

Expected result: Only those rows in the table matching the criteria are

Actual result: All of the data is displayed, as if no filter was run at all. If
you click on the Standard Filter button again, the dialog will show that the
changes you made to the filter when you last opened the dialog did not "stick".

Interestingly, the data source filter seems to work fine in LibO 3.4.5 and
works in Writer in 3.5; as far as I can tell, only Calc is affected. This bug
also affects Ubuntu installs, so I am assuming it's a problem on all operating

I've debated whether this was a "Major", "Critical", or "Blocker" bug. I
decided on the lower of the three levels--since it affects only one component
of the suite (Calc) and still allows functionality of a great deal of the rest
of the suite--but it's enough of a blocker for my use of the software that I
have to remove 3.5 and revert to 3.4.5 (where this problem did not occur).

Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

More information about the Libreoffice-bugs mailing list