Bug 158390

Summary: Android Viewer: Cannot tap cells to add to formula via Formula Bar
Product: LibreOffice Reporter: Kira Tubo <kira.tubo>
Component: Android ViewerAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: miguelangelrv, stephane.guillou
Priority: medium    
Version: 7.6.3.2 release   
Hardware: All   
OS: Android   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108660    
Attachments: Video - cells not added to formula

Description Kira Tubo 2023-11-27 07:47:21 UTC
Description:
Cells are not added to the formula using the keyboard opened up by the Formula Bar

Steps to Reproduce:
Prerequisite: Experimental mode is turned on (home page > 3 dot menu > Settings)
1. Open Android Viewer
2. Open a Calc ods document
3. Enter a number into a cell (ex: cell A1)
4. Close the keyboard
5. Tap on another cell (ex: cell B1)
6. Tap on the Formula Bar to open the keyboard
7. Type an equal sign ("=")
8. Tap on the cell from step 3 and note results

Actual Results:
The cell is not added to the formula. Instead, the cell from step 3 is selected, and the cell from step 5 is no longer being edited. 
Note: this does not occur if the keyboard is opened via keyboard button at the top of the page. 

Expected Results:
The cell is added to the formula. For example, the formula should now display as "=A1" 


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.3.2.0+
Build ID: 0e982fe4db35
Device: Google Pixel 6
Android version: 14
Comment 1 Kira Tubo 2023-11-27 07:49:24 UTC
Created attachment 191054 [details]
Video - cells not added to formula
Comment 2 m_a_riosv 2023-11-27 10:06:30 UTC
Please take a look on:
https://wiki.documentfoundation.org/Android
"Editing documents in LibreOffice Viewer is experimental (and only available when the experimental editing mode has been enabled in the app's settings). We're looking for people who are interested in trying out tools that might still have a few rough edges."
Comment 3 Stéphane Guillou (stragu) 2023-11-27 11:59:03 UTC
Thanks Kira!
Reproduced in:

Version: 7.6.3.2 (X86_64) / LibreOffice Community
Build ID: 29d686fea9f6705b262d369fede658f824154cc0
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

(In reply to m.a.riosv from comment #2)
It's true that the feature is experimental, and that we are in need of Android devs, but Kira is aware of those things, and it doesn't mean we should refrain from reporting bug. (If that's what you meant?)
From the same wiki page:
> "As a beta product, we're looking forward to working through bug reports as they come in."

The Android Viewer was last week's "QA weekly focus", synced with the app being made available on Google Play again, which is why there has been some activity in that space. See: https://lists.freedesktop.org/archives/libreoffice-qa/2023-November/011579.html and https://blog.documentfoundation.org/blog/2023/11/24/libreoffice-viewer-app-for-android/
Comment 4 m_a_riosv 2023-11-27 19:31:23 UTC
Fine, but if it is not implemented yet, more than a bug looks as a request for enhancement.