Bug 64641 - EDITING: Filtering in Mac-Addressbook is not possible
Summary: EDITING: Filtering in Mac-Addressbook is not possible
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.0.3.3 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on: 126961
Blocks: Data-Filter
  Show dependency treegraph
 
Reported: 2013-05-15 15:30 UTC by g_winkelmann
Modified: 2023-06-19 03:13 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
after sorting most cells show "0" because #REF in formula (123.51 KB, image/png)
2013-05-16 15:51 UTC, g_winkelmann
Details
data to filter (234.17 KB, image/jpeg)
2013-05-17 21:04 UTC, g_winkelmann
Details
query after filter (34.59 KB, image/png)
2013-05-17 21:04 UTC, g_winkelmann
Details

Note You need to log in before you can comment on or make changes to this bug.
Description g_winkelmann 2013-05-15 15:30:05 UTC
I can use Auto-Filter and the Search  and the words are found. But using filter criteria the result is EMPTY. Why?
It doesn't matter if I try in table or query - all the same.
Comment 1 Robert Großkopf 2013-05-15 19:52:06 UTC
Could you please write down a step-by step description? Also an attachment would be helpful.

Please don't use Importance "high" and "blocker" for a bug in base, which has nothing to do with data-loss.
Comment 2 g_winkelmann 2013-05-16 13:48:55 UTC
I gave a screen-shot and a step by step description onto the way at creation.
Where is it?
Comment 3 Robert Großkopf 2013-05-16 14:24:03 UTC
(In reply to comment #2)
> I gave a screen-shot and a step by step description onto the way at creation.
> Where is it?

Don't know. There isn't any attachment for this bug. Please add a new.
I have tried filter in tables of a LO 4.0.3.3 - Linux-rpm-version of LO. I can't find any problem.
Comment 4 g_winkelmann 2013-05-16 15:51:31 UTC
Created attachment 79434 [details]
after sorting most cells show "0" because #REF in formula

step by step:
1. 2 files in relation to 
2. sort by certain column (other than the 1st)

behaviour:
loosing relation after sorting? Sorting by 1st column not as many as before get to "0"

expected:
sorting and using these results
Comment 5 g_winkelmann 2013-05-16 16:05:09 UTC
I forgot:
I am working on a Mac. But just this moment I tested on Win XP with the same result.
Even I found that nevertheless there is no "#REF!" but the right information in the formula the result is "0".
Not the result I get in Excel or else...
Comment 6 Robert Großkopf 2013-05-16 19:20:55 UTC
I have had a look at the screenshot. It's a screenshot of Calc, not a screenshot of Base. So the screenshot shows nothing about filtering in Base.
Why do you add a screenshot for sorting in Calc to a bug for filtering in Base?
Comment 7 g_winkelmann 2013-05-17 21:04:13 UTC
Created attachment 79483 [details]
data to filter
Comment 8 g_winkelmann 2013-05-17 21:04:58 UTC
Created attachment 79484 [details]
query after filter
Comment 9 g_winkelmann 2013-05-17 21:11:21 UTC
sorry I mixed up with another problem n Calc.
I added 2 screen-shot.

step by step.
1. take any database
2. use the filter button and
3. enter any text wit or without an asterisk
4. Is the text not exactly the same as the whole text in the cell you have lost the game :-(
Comment 10 Robert Großkopf 2013-05-18 07:39:48 UTC
I have had a look at the screenshot. You will filter data from the Mac-Adressbook. This special configuration could only be tested by persons, who will use a Mac.
So I have tried it with LO under Linux and the Thunderbird-Adressbook. Couldn't get any contact to the adressbook with LO 4.0.3.3 - another bug. When I try the filter with LO 3.3.4 Base will shutdown immediately - recovering next start.
The normal filtering of internal databases work with both versions. So I will change the title to "Mac-Adressbook" to give a hint for other persons.
Comment 11 Emir Sarı 2013-06-20 14:15:01 UTC
I can reproduce the problem, OS X 10.7.5, Version: 4.2.0.0.alpha0+
Build ID: b5295b15d36198c2d1c8bf0075afe52c42f9a503
Comment 12 Urmas 2013-07-28 08:31:53 UTC
Closing a PowerPC-specific bug. Please reopen if it can be reproduced on Intel hardware too.
Comment 13 g_winkelmann 2013-07-28 08:47:21 UTC
After closing I find the bug is classified as on PowerPC platform.
But MY problem exists on Mac OSX 10.6.8!
So cannot understand how it can be marked as resolved.
STRANGE!
Comment 14 Julien Nabet 2013-09-14 08:02:06 UTC
On LO 4.1.1.2 with MacOs 10.7.5, I reproduced the problem for MacAddressBook
In comparison, I gave a try on LO 4.1.1.2 Debian package with the same syntax:
like   'A%' it worked.

Alex: put you in cc since you might be interested in this one.
Comment 15 Alex Thurgood 2015-01-03 17:40:11 UTC Comment hidden (no-value)
Comment 16 QA Administrators 2016-01-17 20:02:21 UTC Comment hidden (obsolete)
Comment 17 Alex Thurgood 2016-01-19 12:43:25 UTC
Still present in 

Version: 5.0.3.2
Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75
Locale : fr-FR (fr.UTF-8)

OSX 10.11.2
Comment 18 QA Administrators 2017-03-06 13:52:50 UTC Comment hidden (obsolete)
Comment 19 eisa01 2017-08-27 00:11:40 UTC
Still present

I click standard filter, select the "First" name field, select "like", type in one of the first names in my address book, and nothing shows up

Version: 5.4.0.3
Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 20 QA Administrators 2018-08-28 02:42:44 UTC Comment hidden (obsolete)
Comment 21 Alex Thurgood 2018-09-19 10:42:26 UTC
Still broken in 

Version: 6.1.1.2
Build ID: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b
Threads CPU : 8; OS : Mac OS X 10.13.6; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group threaded
Comment 22 QA Administrators 2021-01-14 04:06:50 UTC Comment hidden (obsolete)
Comment 23 eisa01 2021-01-23 20:25:14 UTC
I can't currently test this as trying to create a new address book database crashes Libreoffice. Creating a new database also give this error:

The connection to the external data source could not be established. No SDBC driver was found for the URL 'sdbc:embedded:hsqldb'.

Assuming the bug is still there

Version: 7.1.0.2 / LibreOffice Community
Build ID: 53d68d29d90fd16448721a60aad68c28ff0809f5
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 24 Alex Thurgood 2021-06-18 13:01:00 UTC
(In reply to eisa01 from comment #23)
> I can't currently test this as trying to create a new address book database
> crashes Libreoffice. Creating a new database also give this error:
> 
> The connection to the external data source could not be established. No SDBC
> driver was found for the URL 'sdbc:embedded:hsqldb'.
> 

Have set this as blocked for testing on macOS by bug 126961
Comment 25 QA Administrators 2023-06-19 03:13:13 UTC
Dear g_winkelmann,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

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

Warm Regards,
QA Team

MassPing-UntouchedBug