Created attachment 111651 [details] Frame around reference cell not visible during formula editing If a formula contains more then one references to the same cell, coloured frame around that cell is not visible or selectable by cursor during editing of formula, if one reference is moved to another cell by cursor. So it is necessary to enter formula several times to move all references. In case of long Array formulas it is really inconvenient and it's very easy to make mistakes, because not all references are visible. Screen-shot of reference cell without coloured frame is attached to the report The way to reproduce: 1. Open attached file. 2. Select formula in D1 by double click 3. Move cursor to B1 cell 4. Press left mouse button over B1 cell and move coloured frame to C1 5. Release left mouse button. Normally A1, B1 and C1 should have coloured frames at a point 5, but only A1 and C1 have coloured frame. If entering formula one more time, all reference cells have frames around. It is really problematic bug, when complicate formulas have to be edited. Ubuntu 14.04, 32 bit, Libreoffice 4.3.5.2
Created attachment 111652 [details] Sample formula of 2 references to the same cell
I can confirm with Version: 4.5.0.0.alpha0+ Build ID: 7f476fea47f06a7f8cc961dd4f6595a524346fa5 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-12-27_23:36:28
New release of 4.4.2 still have this problem. It seems to be related to a new feature - the same colour to all references to particular cell. To me it's not valuable, therefore I would be happy with previous status, because it is now really terribly with long formula editing.
Still in 4.4.3.1. It seems that this regression is considered to be a feature :) It is really annoying and I didn't find any workaround for that to be able to move several references to the same cell in formula without entering formula several times. I would be very thankful also for any workaround, because now it is a mess in editing complex formulas.
Hi, I'm reporter of bug 78221. This bug is tagged FIXED in Master and 4.4.2. I confirm the fix in Version: 4.5.0.0.alpha0+ Build ID: f9f53c4a8c9e1cd2fa1a9f48576b09f1bfd023ae TinderBox: Win-x86@39, Branch:master, Time: 2015-04-16_00:26:27 Don't have 4.4.x bersion for testing. Did you confirm that 4.4.3 still reproduce the bug? *** This bug has been marked as a duplicate of bug 78221 ***
Sorry, it is fixed! I messed up versions. I opened it in 4.3.7.1 instead of 4.4.3.1. In 4.4.3.1 everything is fine. Thank you for great work! > > Don't have 4.4.x bersion for testing. Did you confirm that 4.4.3 still > reproduce the bug? > > *** This bug has been marked as a duplicate of bug 78221 ***