Bug 34394 - Standard Filter order of actions inconsistent between Calc and Base
Summary: Standard Filter order of actions inconsistent between Calc and Base
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: UI (show other bugs)
Version:
(earliest affected)
3.3.1 release
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Base-UX Data-Filter Base-Enhancements
  Show dependency treegraph
 
Reported: 2011-02-17 07:02 UTC by Rainer Bielefeld Retired
Modified: 2021-06-19 13:26 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshots Comparing Filter View in Database and Calc (152.90 KB, application/pdf)
2011-10-02 03:49 UTC, Rainer Bielefeld Retired
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2011-02-17 07:02:48 UTC
I found that with "LibreOffice 3.3.1 RC1 – WIN7  Home Premium  (64bit) German UI [OOO330m19 (build 7 / tag 3.3.1.1)]"

If you want to add an additional filter condition to standard filter in CALC:
1. select condition AND or OR (no other selection possible)
2. continue

If you want to add an additional filter condition to standard filter in BASE
(for example after <f4> for address data in WRITER:
1. select Field name (no other selection possible)
2. continue 

I can't see any reason why that should not be in the same order for both.
Comment 1 sasha.libreoffice 2011-03-16 06:50:48 UTC
As I can understand: in Calc we first select and/or and only then Field Name
and in Base in reverse order: first Field name and then and/or.
And should be available in both orders in Calc and in Base.
Comment 2 Rainer Bielefeld Retired 2011-03-16 23:03:46 UTC
> As I can understand: in Calc we first select and/or and only then Field
> Name and in Base in reverse order

@sasha:
Yes, that's my observation. Do you agree with my impression, that that difference is unexpected, or can you find a good reason for that different handling, so that it might be intended?
Comment 3 sasha.libreoffice 2011-03-16 23:28:04 UTC
Alas, I can not. I almost never use LibreBase because FirebirdSQL is unavailable in Base. And all my data is in Firebird database. So I have almost no experience using Base. My be in future Base will be more useful and I can use it with real world data. Then I can say what it better on practice.
Comment 4 Alex Thurgood 2011-06-05 23:00:09 UTC
(In reply to comment #3)
> Alas, I can not. I almost never use LibreBase because FirebirdSQL is
> unavailable in Base. And all my data is in Firebird database. So I have almost
> no experience using Base. My be in future Base will be more useful and I can
> use it with real world data. Then I can say what it better on practice.

Hi Sasha,

FYI, how to connect to firebird from OOo here :
http://www.ibphoenix.fr/spip.php?article24

The same should also be applicable for LibO.

Alex

PS: Sorry for hijacking the thread.
Comment 5 Alex Thurgood 2011-06-05 23:01:19 UTC
I can confirm this, although it seems to me (from memory) that this behaviour has been present for years. 

Alex
Comment 6 Alex Thurgood 2011-06-05 23:01:56 UTC
change status to confirmed. It would be a useful enhancement.
Comment 7 Alex Thurgood 2011-06-05 23:12:47 UTC
(In reply to comment #4)
> (In reply to comment #3)
> > Alas, I can not. I almost never use LibreBase because FirebirdSQL is
> > unavailable in Base. And all my data is in Firebird database. So I have almost
> > no experience using Base. My be in future Base will be more useful and I can
> > use it with real world data. Then I can say what it better on practice.
> 
> Hi Sasha,
> 
> FYI, how to connect to firebird from OOo here :
> http://www.ibphoenix.fr/spip.php?article24
> 
> The same should also be applicable for LibO.
> 
> Alex
> 
> PS: Sorry for hijacking the thread.

Also look up on Google or your favorite search engine :

OOoFBvp.pdf (be careful, lots of links that you can find lead nowhere and one even took me to a Spanish adult content site)

http://www.oooforum.org/forum/viewtopic.phtml?t=337

Alex
Comment 8 Alex Thurgood 2011-06-05 23:20:31 UTC
(In reply to comment #7)
> (In reply to comment #4)
> > (In reply to comment #3)
> > > Alas, I can not. I almost never use LibreBase because FirebirdSQL is
> > > unavailable in Base. And all my data is in Firebird database. So I have almost
> > > no experience using Base. My be in future Base will be more useful and I can
> > > use it with real world data. Then I can say what it better on practice.
> > 
> > Hi Sasha,
> > 
> > FYI, how to connect to firebird from OOo here :
> > http://www.ibphoenix.fr/spip.php?article24
> > 
> > The same should also be applicable for LibO.
> > 
> > Alex
> > 
> > PS: Sorry for hijacking the thread.
> 
> Also look up on Google or your favorite search engine :
> 
> OOoFBvp.pdf (be careful, lots of links that you can find lead nowhere and one
> even took me to a Spanish adult content site)
> 
> http://www.oooforum.org/forum/viewtopic.phtml?t=337
> 
> Alex


And this :

http://www.oooforum.org/forum/viewtopic.phtml?t=61507&highlight=firebird


Alex
Comment 9 sasha.libreoffice 2011-06-06 00:40:08 UTC
On Windows and Linux 32 bit using ODBC Firebird works OK.
But ODBC has restrictions on SQL language. It means that I can not copy-paste SQL statments from another program to LibreBase. I need write my own requests that they can work in Base.
On Linux 64 bit is Bug 34432 - firebird ODBC not work
It looks that it is not our bug. Problem somewhere in ODBC driver. And if LibO would have ability of direct connection to FirebirdSQL, no unnecessary dependency of such bugs would be.
Thanks for interesting in my problem
Comment 10 Julien Nabet 2011-10-01 06:19:10 UTC
On a Debian Wheezy x86-32, with a git version from Master repository, I made these tests :
- in Base, I opened the Address database and added 2 lines. Then I tried Standard filter and first condition is disabled. But as soon as you select the Field Name, the "Condition" and "Value" are enabled and you can choose your condition and value.
- same test on Writer with F4 and bibliography database, same results.

I tested too on a Win7 (since it's the environment indicated on this report) with LibreOffice 3.4.3 OOO340m1 (Build:302), I did the same 2 tests and I got the same results.


Have you still got this problem or did I missed something and did something wrong ?
Comment 11 Rainer Bielefeld Retired 2011-10-02 03:49:25 UTC
Created attachment 51872 [details]
Screenshots Comparing Filter View in Database and Calc

@Julien Nabet:
There is no problem, but an inconsistence. Your description seems to show the same observations as I did.

The observations can be reproduced easily with an arbitrary calc sheet and biblio database.
Comment 12 Björn Michaelsen 2011-12-23 11:53:20 UTC Comment hidden (obsolete)
Comment 13 sasha.libreoffice 2011-12-27 00:06:59 UTC
remains in LibO 3.5.0 beta 1
in database button and/or available only after selecting field name
(expected that user can select button and/or and only then select field names, as in Calc)
Comment 14 Joel Madero 2014-07-13 01:33:36 UTC Comment hidden (obsolete)
Comment 15 Alex Thurgood 2015-01-03 17:41:31 UTC Comment hidden (no-value)
Comment 16 Stéphane Guillou (stragu) 2021-06-19 13:25:33 UTC
Reproduced in:

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 94d552f94b427f884c004dba5d4619ecf729d605
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-18_13:30:27
Calc: threaded

Changing version to 3.3 as that was the earliest mentioned.
Adding some Meta bugs too.