Bug 158311

Summary: Android Viewer: Edits via Formula bar do not display in cells after changes to first cell (canvas does not refresh)
Product: LibreOffice Reporter: Kira Tubo <kira.tubo>
Component: Android ViewerAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: m.weghorn, sophie.sipasseuth, stephane.guillou
Priority: medium    
Version: 7.6.3.2 release   
Hardware: ARM   
OS: Android   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=158392
https://bugs.documentfoundation.org/show_bug.cgi?id=96769
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 117913    
Attachments: Video - Calc doc of edits via Formula bar
Screenshot - edit to calc file using Formula bar

Description Kira Tubo 2023-11-22 07:31:02 UTC 
Description:
When the user tries to edit Calc files using the Formula bar, the first cell displays changes, however, subsequent edits in other cells do not. 

Steps to Reproduce:
Prerequisite: on the home page, go to 3 dot menu > Settings > enable Experimental Mode
1. Open any Calc ods file
2. Tap on any cell 
3. Tap on the Formula bar
4. Type some text
5. Tap checkmark button on keyboard to confirm changes
6. Note the results (expected: the cell displays the changes)
7. Repeat steps 2-5
8. Note the results (not expected: the cell does not display the changes)

Actual Results:
When the formula bar is being used to make changes to the cell, the cell does not always display those changes. This usually occurs after the first cell is edited. 
- Workaround: after making the changes, the user has to pinch zoom to refresh the view so that the changes are displayed. 
- Note: this issue does not occur if the user taps on a cell, then taps on the keyboard icon at the top of the page to make edits to the cell. 

Expected Results:
If the formula bar is being used to make changes to the cell, then the cell should display the changes. 


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.3.2.0+
Build ID: 0e982fe4db35
Device: Google Pixel 6
Android Version: 13
Comment 1 Kira Tubo 2023-11-22 07:32:18 UTC 
Created attachment 190954 [details]
Video - Calc doc of edits via Formula bar
Comment 2 Kira Tubo 2023-11-22 07:43:03 UTC 
Created attachment 190957 [details]
Screenshot - edit to calc file using Formula bar
Comment 3 Kira Tubo 2023-11-22 07:44:04 UTC 
Note that above reproduction steps are for Android Viewer, NOT LibreOffice Calc on desktop
Comment 4 Michael Weghorn 2023-11-22 08:09:04 UTC 
Reproduced with


Version: 24.2.0.0.alpha0+
Build ID: 42edec63fba4
Comment 5 Michael Weghorn 2023-11-24 22:47:04 UTC 
*** Bug 158335 has been marked as a duplicate of this bug. ***
Comment 6 Stéphane Guillou (stragu) 2023-11-27 11:42:07 UTC 
(In reply to Kira Tubo from comment #0)
> Steps to Reproduce:
> Prerequisite: on the home page, go to 3 dot menu > Settings > enable
> Experimental Mode
> 1. Open any Calc ods file
> 2. Tap on any cell 
> 3. Tap on the Formula bar
> 4. Type some text
> 5. Tap checkmark button on keyboard to confirm changes
> 6. Note the results (expected: the cell displays the changes)
> 7. Repeat steps 2-5
> 8. Note the results (not expected: the cell does not display the changes)
In step 5, some keyboard might have the button "Done" instead of a checkmark.
One might have to repeat steps 2-5 a few times to see the issue manifest.

Version: 7.6.3.2.0+
Build ID: 0e982fe4db35
Android 9, Galaxy A20e
Comment 7 Sophie Sipasseuth 2023-11-27 13:37:36 UTC 
Repro like Stéphane with 
Version: 7.6.3.2.0+
Build ID: 0e982fe4db35
But Android 13, Galaxy A52s G.