Bug 113927

Summary:	Coloured borders around elements of array formulas not visible when formula is selected
Product:	LibreOffice	Reporter:	andis.lazdins
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	andis.lazdins, ilmari.lauhakangas, miguelangelrv
Priority:	medium
Version:	5.4.3.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Example of non visible borders around elements of array formulas

Description andis.lazdins 2017-11-19 07:51:44 UTC

Description:
Coloured border is not appearing around elements of selected array formulas like it is with simple formulas. It is also not possible to move elements of selected array formulas. It is not happening with simple formulas; respectively, coloured borders are visible, can be catch by mouse and can be moved to other place or expanded or reduced. The issue is specific for 5.4.x branch and do not appears in 6.0.x.

Steps to Reproduce:
1. Open attached file.
2. Go to cell E1 and press "Ctrl" + "/" to select formula

Actual Results:  
Borders around A1:A9 and B1:B9 are not visible and can't be catched by mouse cursor.

Expected Results:
Borders around A1:A9 and B1:B9 are visible and can be catched, moved, expanded and shrinked by mouse cursor.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0

Comment 1 andis.lazdins 2017-11-19 07:52:41 UTC

Created attachment 137845 [details]
Example of non visible borders around elements of array formulas

Comment 2 andis.lazdins 2017-11-19 07:54:17 UTC

System info - Ubuntu 16.04 64 bit, LibreOffice 5.4.3.2.  Th issue is reproducible also with earlier version of 5.4.x.

Comment 3 Buovjaga 2017-11-19 13:38:48 UTC

(In reply to andis.lazdins from comment #0)
> press "Ctrl" + "/" to select formula

What is the name of this command? I have Finnish keyboard and cannot give this shortcut. I would need to go to Customize and apply it to something else.

If I otherwise try to edit the formula, I get: You cannot change only part of an array.

Comment 4 m_a_riosv 2017-11-19 16:25:30 UTC

Hi @Buovjaga, the issue with this short-cut it's also for me with Spanish keyboard-, without the numeric keyboard, the '/' is on the shift of '7' for me, so it's no reachable.
Ctrl+/ <> Ctrl+Shift+/

@Andis after Ctrl+/ only the array is selected, you need [F2] to enter on edit mode and see the color borders.

For me not a bug.

Comment 5 andis.lazdins 2017-11-19 21:54:08 UTC

(In reply to m.a.riosv from comment #4)
> Hi @Buovjaga, the issue with this short-cut it's also for me with Spanish
> keyboard-, without the numeric keyboard, the '/' is on the shift of '7' for
> me, so it's no reachable.
> Ctrl+/ <> Ctrl+Shift+/
> 
> @Andis after Ctrl+/ only the array is selected, you need [F2] to enter on
> edit mode and see the color borders.
> 
> For me not a bug.

Thanks for advice! It is different behavior in comparison to 6.0 and 5.3, as well as to Microsoft Excel, where it is enough to select formula with Ctrl + / and putting cursor into the input line. This change in behavior is not mentioned also in list of "improvements".

And sorry for incomplete instructions in bug report! After clicking (single click) into E2 and pressing "Ctrl" + "/" or alternatives on other keyboards to select array formulas (https://help.libreoffice.org/Calc/Array_Functions) you need to put cursor into input line or press F2 to enter into edit mode, as it is written in help documentation. 

It looks like the option for entering into edit mode by putting cursor into input line is broken. If I'm putting cursor into input line after Ctrl + /, I can't get to edit mode also by pressing F2. I should press Esc to leave input line and then I can select array formula by F2.

It's not a big problem, because there is easy workaround with F2, but still something is broken and program behaves slightly different than it is written in help documentation. It's better to fix it before a version recommended for enterprises is released and people are disappointed with something "not working as they used to".

Best regards!

Comment 6 andis.lazdins 2017-11-19 21:56:18 UTC

(In reply to Buovjaga from comment #3)
> (In reply to andis.lazdins from comment #0)
> > press "Ctrl" + "/" to select formula
> 
> What is the name of this command? I have Finnish keyboard and cannot give
> this shortcut. I would need to go to Customize and apply it to something
> else.
> 
> If I otherwise try to edit the formula, I get: You cannot change only part
> of an array.

I already added more information in reply to following comment.
Sorry for incomplete instructions! After 20 years of use some things becomes automatic.

Comment 7 Buovjaga 2017-11-20 14:33:58 UTC

The function name is Select Array Formula and in the Customize dialog it is under "Ctrl+slash" by default. I added it to some saner key combo and tested.

After selecting and either F2 or clicking in the input line, I see coloured borders.

Arch Linux 64-bit
Version: 6.0.0.0.alpha1+
Build ID: 121303615054568c204def97872343d2014af4a0
CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on November 17th 2017

Comment 8 andis.lazdins 2017-12-10 13:27:31 UTC

It looks solved in 5.4.4.1 so this report can be closed.

Comment 9 Buovjaga 2017-12-10 13:41:31 UTC

Great, thanks for testing.

Comment 10 m_a_riosv 2017-12-10 16:30:43 UTC

Works for me on Win10 for 5.4 6.0 6.1 with or without OpenGL enable.