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
Created attachment 137845 [details] Example of non visible borders around elements of array formulas
System info - Ubuntu 16.04 64 bit, LibreOffice 5.4.3.2. Th issue is reproducible also with earlier version of 5.4.x.
(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.
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.
(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!
(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.
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
It looks solved in 5.4.4.1 so this report can be closed.
Great, thanks for testing.
Works for me on Win10 for 5.4 6.0 6.1 with or without OpenGL enable.