Bug 158392

Summary:	Android Viewer: Tapping on checkmark in action bar does not confirm changes to formula
Product:	LibreOffice	Reporter:	Kira Tubo <kira.tubo>
Component:	Android Viewer	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal
Priority:	medium
Version:	7.6.3.2 release
Hardware:	All
OS:	Android
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=158311
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108660
Attachments:	Video - confirm formula with checkmark in action bar

Description Kira Tubo 2023-11-27 08:19:19 UTC

Description:
If the user inserts a formula into a cell, then taps on the checkmark in the action bar at the top left corner of the page, the changes are not confirmed. 

Steps to Reproduce:
Prerequisite: Experiment mode is turned on (home page > 3 dot menu > Settings)
1. Open Android Viewer
2. Open Calc ods document
3. Tap on any empty cell
4. Tap on either the formula bar or keyboard button to display the keyboard
5. Type a formula e.g. "=12+12"
6. Tap on the checkmark icon in action bar at top left corner of the screen
7. Note changes

Actual Results:
Depending on how you got the keyboard to display in step 4, the results may differ. 
- If the keyboard was opened up by tapping on the formula bar, then no changes to the cell are displayed. 
- If the keyboard was opened up by tapping on the keyboard button, then the formula is displayed as "=12+12" rather than the final calculation. 

Expected Results:
Tapping on the checkmark in the action bar should confirm changes to the formula. In this case, the cell should display the final calculation "24", not the formula. 


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 08:21:39 UTC

Created attachment 191055 [details]
Video - confirm formula with checkmark in action bar

Comment 2 Stéphane Guillou (stragu) 2023-11-27 11:50:24 UTC

Thanks Kira!
Reproduced in:

Version: 7.6.3.2.0+
Build ID: 0e982fe4db35
Android 9, Galaxy A20e

(In reply to Kira Tubo from comment #0)
> - If the keyboard was opened up by tapping on the formula bar, then no
> changes to the cell are displayed. 
...and the formula bar still displays the formula, even when tapping on another cell. No change is registered, as user is not prompted to save when closing the document.
> - If the keyboard was opened up by tapping on the keyboard button, then the
> formula is displayed as "=12+12" rather than the final calculation. 
...and the cell is still in edit mode, which means tapping another cell will add its coordinates to the formula. Change is however registered, as user is prompted to save when closing the document.