Calc filter bug in 3.5.0?

classic Classic list List threaded Threaded
7 messages Options
Steven Shelton Steven Shelton
Reply | Threaded
Open this post in threaded view
|

Calc filter bug in 3.5.0?


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
Has anyone encountered a bug in LibO 3.5's calc wherein filters refuse
to work?

I want to get some data from my database, so I establish the connection
to the correct table from the "Data Sources" panel. The data from the
table all shows up. So I hit the filter button and enter "DATE", ">=",
and "02/01/2012", then hit "OK". Nothing happens; the data stays exactly
the same without filtering at all. And when I open up the filter dialog
again, it appears as it did before I made any changes at all. It works
fine in LibO 3.4.5 on my other PC. (These are both Windows XP boxes.)

Has anyone else encountered this? Before I put it into the bug database,
I want to make sure I haven't screwed something up somewhere (and that
I'm not duplicating someone else's bug report).

- --
Steven Shelton
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.12 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
 
iEYEARECAAYFAk9FTd4ACgkQXUonIzCvpdOIBQCfbCpCo1p+T9KR/nz8Kf57t9SW
7ycAnRtkh7c4Ezv+rv4GETwz5XvFk3PK
=fMky
-----END PGP SIGNATURE-----


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Dan Lewis Dan Lewis
Reply | Threaded
Open this post in threaded view
|

Re: Calc filter bug in 3.5.0?

On Wed, 2012-02-22 at 15:19 -0500, Steven Shelton wrote:

> Has anyone encountered a bug in LibO 3.5's calc wherein filters refuse
> to work?
>
> I want to get some data from my database, so I establish the connection
> to the correct table from the "Data Sources" panel. The data from the
> table all shows up. So I hit the filter button and enter "DATE", ">=",
> and "02/01/2012", then hit "OK". Nothing happens; the data stays exactly
> the same without filtering at all. And when I open up the filter dialog
> again, it appears as it did before I made any changes at all. It works
> fine in LibO 3.4.5 on my other PC. (These are both Windows XP boxes.)
>
> Has anyone else encountered this? Before I put it into the bug database,
> I want to make sure I haven't screwed something up somewhere (and that
> I'm not duplicating someone else's bug report).

     Yes, this is a bug. I use Ubuntu, and I get the same results. The
filtering works when using 3.4.5 but does not work using 3.5.0.

--Dan



--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Steven Shelton Steven Shelton
Reply | Threaded
Open this post in threaded view
|

Re: Calc filter bug in 3.5.0?


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
On 2/22/2012 3:59 PM, Dan Lewis wrote:
> Yes, this is a bug. I use Ubuntu, and I get the same results. The
filtering works when using 3.4.5 but does not work using 3.5.0. --Dan


Do you know if this has been filed in Bugzilla, and if so, what the bug
# might be?

- --
Steven Shelton
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.12 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
 
iEYEARECAAYFAk9FXXsACgkQXUonIzCvpdO3NgCfXW5AcAMPcW0ljyOwKGmkXE6U
w1YAmgO9e7PFPwvvQl4nDmPC0GxTBpGH
=CfCB
-----END PGP SIGNATURE-----


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
drewjensen drewjensen
Reply | Threaded
Open this post in threaded view
|

Re: Calc filter bug in 3.5.0?

On Wed, 2012-02-22 at 16:26 -0500, Steven Shelton wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>  
> On 2/22/2012 3:59 PM, Dan Lewis wrote:
> > Yes, this is a bug. I use Ubuntu, and I get the same results. The
> filtering works when using 3.4.5 but does not work using 3.5.0. --Dan
>
>
> Do you know if this has been filed in Bugzilla, and if so, what the bug
> # might be?

Hi Steven,

This is using the mysql connector, yes?

//drew


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Document Foundation Mail Archives
drewjensen drewjensen
Reply | Threaded
Open this post in threaded view
|

Re: Calc filter bug in 3.5.0?

On Wed, 2012-02-22 at 16:32 -0500, drew wrote:

> On Wed, 2012-02-22 at 16:26 -0500, Steven Shelton wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >  
> > On 2/22/2012 3:59 PM, Dan Lewis wrote:
> > > Yes, this is a bug. I use Ubuntu, and I get the same results. The
> > filtering works when using 3.4.5 but does not work using 3.5.0. --Dan
> >
> >
> > Do you know if this has been filed in Bugzilla, and if so, what the bug
> > # might be?
>
> Hi Steven,
>
> This is using the mysql connector, yes?

Ah I see now - I tried a HSQL based database and tried form based
filters and autofilter - both of those worked (LibO 3.5)
- but just now tried the standard filter dialog and nope it doesn't
work..

//drew

>
> //drew
>
>



--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Document Foundation Mail Archives
Steven Shelton Steven Shelton
Reply | Threaded
Open this post in threaded view
|

Re: Calc filter bug in 3.5.0?

In reply to this post by drewjensen

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
On 2/22/2012 4:32 PM, drew wrote:
> This is using the mysql connector, yes?

No. Connecting to an HSQL file using the java connector. I just filed a
bug on it, *Bug 46480*
<https://bugs.freedesktop.org/show_bug.cgi?id=46480>, after not finding
anything else in Bugzilla that describes it. (My apologies if it ends up
being a duplicate; I often have trouble finding things on the Bugzilla
search.)

- --
Steven Shelton
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.12 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
 
iEYEARECAAYFAk9FYYcACgkQXUonIzCvpdOkDwCfUqwnNvAg+l5IxsqvjsoK849j
XSQAni+M2cng3kddi5WibVAowQenm+w4
=SoxF
-----END PGP SIGNATURE-----


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
drewjensen drewjensen
Reply | Threaded
Open this post in threaded view
|

Re: Calc filter bug in 3.5.0?

On Wed, 2012-02-22 at 16:43 -0500, Steven Shelton wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>  
> On 2/22/2012 4:32 PM, drew wrote:
> > This is using the mysql connector, yes?
>
> No. Connecting to an HSQL file using the java connector. I just filed a
> bug on it, *Bug 46480*
> <https://bugs.freedesktop.org/show_bug.cgi?id=46480>, after not finding
> anything else in Bugzilla that describes it. (My apologies if it ends up
> being a duplicate; I often have trouble finding things on the Bugzilla
> search.)

*chuckling* - you are not alone my friend. the new system can be a bear.
Not sure if you have tried using the Bug reporting assistant:
http://www.libreoffice.org/get-help/bug/
(though just now it doesn't seem to want to work :(

Anyway - it has a much nicer front end, particularly where searching is
concerned, as it automatically does so.

//drew

>
> - --
> Steven Shelton
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.12 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>  
> iEYEARECAAYFAk9FYYcACgkQXUonIzCvpdOkDwCfUqwnNvAg+l5IxsqvjsoK849j
> XSQAni+M2cng3kddi5WibVAowQenm+w4
> =SoxF
> -----END PGP SIGNATURE-----
>
>



--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Document Foundation Mail Archives