Bug 73730 - Navigating with arrow does not change the value shown in the formulabox if the first line is similar.
Summary: Navigating with arrow does not change the value shown in the formulabox if th...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.3.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-01-17 09:03 UTC by Tim van Steenbergen
Modified: 2019-01-05 16:42 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
.xlsx doc with the bug (7.04 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-01-17 09:03 UTC, Tim van Steenbergen
Details
Starting position (99.05 KB, image/png)
2014-01-20 12:07 UTC, Tim van Steenbergen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Tim van Steenbergen 2014-01-17 09:03:07 UTC
Created attachment 92268 [details]
.xlsx doc with the bug

I have a .xls-document with column k containing strings of a couple of hundreds characters. Also I pulled down the formulabox to show more than one line, thus showing the entire field.
The bug is that navigating with arrow-up or arrow-down does not change the formulabox if the first line of the box is the same.

Also happens if I save the document as .ods

If you go from one cell to the other, and the first line of the box is the same as the previous cell, then the contents of the formula box does not change. No harm, except when there are differences in character beyond that. In that case you see the string of the previous cell and not the string of the other cell.

If you do the same but navigate by clicking instead of the arrows, then the contents of the formula box does change, as expected.

Also if you make the window wide enough, making the formula box wide enough and thus change the first line upon navigating, then the contents of the formula box does change, as expected.
Comment 1 Jean-Baptiste Faure 2014-01-19 17:35:30 UTC
Comment on attachment 92268 [details]
.xlsx doc with the bug

fixing mime type
Comment 2 Jean-Baptiste Faure 2014-01-19 17:46:55 UTC
I do not understand: the formulabox shows the first line of the formula. Where is the problem?
If I pull down the formulabox to see more than one line, I see what is shown on the cell when I navigate with arrow up and down keys.

Please, could you attach a screenshot showing the problem?

Best regards. JBF
Comment 3 Tim van Steenbergen 2014-01-20 12:07:10 UTC
Created attachment 92445 [details]
Starting position

From this starting position, press Arrow-up, taking you to K4. Formulabox does not change, although the cell value of K4 is different to K5 (...utm_term=bedanktemail... instead of ...utm_term=bedanktpagina...)

Press Arrow-down 4 times, nothing changes, you are in K9 now.

Press Arrow down once more going to K10, formulabox changes. (...utm_medium=auto... changes to ...utm_medium=recht...)

Clicking a cell almost always changes the formulabox correctly. Except if you click after having pressed Arrow-up(or down) without the formulabox changing.
For instance: go to K6, press arrow-up. Now click K4, K5, K7, K8 or K9. Formulabox stays the same.
Now click anywhere else, Formulabox changes nicely.
Now click K4, K5, K7, K8 or K9 again. Formulabox changes nicely.

Kind of weird.
Comment 4 Jean-Baptiste Faure 2014-01-21 20:39:25 UTC
I do not reproduce with generic Linux version 4.1.4.2 and with my own build of 4.2.1.0.0+ on Ubuntu 13.10 x86-64.

It would be very useful if you could install the current generic Linux version and check if you still encounter the same behavior.

Best regards. JBF
Comment 5 Dominique Boutry 2014-01-29 14:49:31 UTC
I confirm the bug on LibO 4.2.0.3 rc on Win7.

The key point to reproduce the bug is to have the formula box bit wide enough so that the content is wrapped to 3 lines at minimum, in the formula box expanded by the "Expand Formula Bar" arrow.
Comment 6 Jean-Baptiste Faure 2014-02-01 14:40:56 UTC
(In reply to comment #5)
> I confirm the bug on LibO 4.2.0.3 rc on Win7.
> 
> The key point to reproduce the bug is to have the formula box bit wide
> enough so that the content is wrapped to 3 lines at minimum, in the formula
> box expanded by the "Expand Formula Bar" arrow.

Indeed, you are right. Now I can reproduce the problem with LO 4.2.1.0.0+ on Ubuntu 13.10.

Best regards. JBF
Comment 7 Joel Madero 2015-05-02 15:44:02 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2015-06-21 12:56:47 UTC
(In reply to Dominique Boutry from comment #5)
> I confirm the bug on LibO 4.2.0.3 rc on Win7.
> 
> The key point to reproduce the bug is to have the formula box bit wide
> enough so that the content is wrapped to 3 lines at minimum, in the formula
> box expanded by the "Expand Formula Bar" arrow.

Repro. 2 lines is ok, but when I made the LibO window narrower so they go to 3 lines, they stopped updating (except when going over 8 & 9).

Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+
Build ID: 3ecef8cedb215e49237a11607197edc91639bfcd
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-06-19_23:16:58
Locale: fi-FI (fi_FI)
Comment 9 QA Administrators 2016-09-20 10:11:15 UTC Comment hidden (obsolete)
Comment 10 Jean-Baptiste Faure 2016-09-25 16:03:51 UTC
Still reproducible in LO 5.2.3.0+ and current master, both built at home under Ubuntu 16.04 x86-64.

Best regards. JBF
Comment 11 Xisco Faulí 2017-09-29 08:53:01 UTC Comment hidden (obsolete)
Comment 12 Jean-Baptiste Faure 2017-10-29 06:48:39 UTC
Still reproducible with current master built at home under Ubuntu 16.04.

Best regards. JBF
Comment 13 QA Administrators 2018-10-30 03:56:15 UTC Comment hidden (obsolete)
Comment 14 Jean-Baptiste Faure 2019-01-05 16:42:40 UTC
Not reproducible anymore with LO 6.2.0.1.0+ under Ubuntu 18.04.

Closing as WorkForMe. Please, feel free to reopen if you disagree.

Best regards. JBF