Bug 158371 - Android Viewer: Search not working with particular file
Summary: Android Viewer: Search not working with particular file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Android Viewer (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: ARM Android
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-11-26 05:51 UTC by amadeus@paulussen.id
Modified: 2024-02-03 10:09 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Screen shots (2.13 MB, application/zip)
2023-11-26 05:51 UTC, amadeus@paulussen.id
Details

Note You need to log in before you can comment on or make changes to this bug.
Description amadeus@paulussen.id 2023-11-26 05:51:54 UTC
Created attachment 191041 [details]
Screen shots

# Steps
1. Open ODS document in LibreOffice Viewer app
2. Search (wrong results are being highlighted).
3. Filter (does not work at all, neither tapping, double tapping or long pressing on any of the UI elements has any effect whatsoever)
4. Sort (same as with Filter, nothing happens when interacting with the UI elements)

# System information
* Gigaset GX6
* Android 13
* LibreOffice Viewer 7.6.2.1 (F-Droid)
* LibreOffice 7.6.3.2 (Flatpak) on Arch Linux
Comment 1 Michael Weghorn 2023-11-26 19:20:13 UTC
Thank you for your report.

(In reply to amadeus@paulussen.id from comment #0)
> # Steps
> 1. Open ODS document in LibreOffice Viewer app
> 2. Search (wrong results are being highlighted).

Could you please attach the/a sample doc to reproduce/analyze this? I can see wrong search result highlighting in the screenshot, but it works fine with a simple sample document for me, so might be related to the actual document used.

> 3. Filter (does not work at all, neither tapping, double tapping or long
> pressing on any of the UI elements has any effect whatsoever)
> 4. Sort (same as with Filter, nothing happens when interacting with the UI
> elements)

I can confirm this, this functionality is currently not available in Android Viewer. Since it's independent of the wrong search highlighting, could you please create a separate bug report for these? (Then, the new ticket will be for lack of filter and sort, and this ticket will be used for the incorrect search highlighting, which makes it possible to better track the individual issues.)

Version: 7.6.3.2-android
Build ID: 8c4c8a83119e
(test build in preparation for F-Droid update, https://gitlab.com/fdroid/fdroiddata/-/merge_requests/14080 )
Comment 2 amadeus@paulussen.id 2024-01-12 05:43:09 UTC
Hi Michael(In reply to amadeus@paulussen.id from comment #0)
> Created attachment 191041 [details]
> Screen shots
> 
> # Steps
> 1. Open ODS document in LibreOffice Viewer app
> 2. Search (wrong results are being highlighted).
> 3. Filter (does not work at all, neither tapping, double tapping or long
> pressing on any of the UI elements has any effect whatsoever)
> 4. Sort (same as with Filter, nothing happens when interacting with the UI
> elements)
> 
> # System information
> * Gigaset GX6
> * Android 13
> * LibreOffice Viewer 7.6.2.1 (F-Droid)
> * LibreOffice 7.6.3.2 (Flatpak) on Arch Linux

Hi Michael

I have sent you the desired attachment in confidence by email.

Many thanks!

Best

Amadeus

PD: I will create a new ticket for the Filter thing, sure.
Comment 3 amadeus@paulussen.id 2024-01-12 05:49:56 UTC
I created a new issue for the filter and sort issue at: https://bugs.documentfoundation.org/show_bug.cgi?id=159142
Comment 4 Michael Weghorn 2024-01-12 10:04:59 UTC
(In reply to amadeus@paulussen.id from comment #2)
> Hi Michael
> 
> I have sent you the desired attachment in confidence by email.

Thanks a lot! I can reproduce with that sample file after zooming in.

The issue seems to be related to the issue that headers are misplaced, too:
When searching for "Citizen" (as shown in the first screenshot), the highlighted area is where the Calc headers suggest that the cell C132 should be. C132 actually contains the word "Citizen". But the headers are misaligned with the actual content, and what's actually at the highlighted area is the content of another cell that doesn't contain the word that was searched for.