Bug 33201 - UI: Highlight (not select) current row and column in spreadsheet
Summary: UI: Highlight (not select) current row and column in spreadsheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL: http://ask.libreoffice.org/en/questio...
Whiteboard: feature
Keywords:
: 78682 93702 (view as bug list)
Depends on:
Blocks: Calc-Enhancements
  Show dependency treegraph
 
Reported: 2011-01-17 02:33 UTC by Thomas
Modified: 2019-08-07 14:27 UTC (History)
18 users (show)

See Also:
Crash report or crash signature:


Attachments
Mockup of what this feature would look like. (102.22 KB, image/jpeg)
2014-09-23 10:41 UTC, Owen Genat (retired)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas 2011-01-17 02:33:45 UTC
On large screens in large spreadsheets, it is hard to track which cells are in the same row (or column). It should be at least optional that all cells in the same column/row should be highlighted, e.g. by being darker, lighter, or with some additional semi-transparent color.
Note: This is not the same as selecting rows/columns via Ctrl+Space or Shift+Space. My request is optical only, it does not change the content or functionality of a spreadsheet.
Comment 1 Kohei Yoshida 2011-01-21 07:09:34 UTC
Someone else had requested this before.  In fact, there was even a patch (though not implemented correctly).

I'll keep this meanwhile.
Comment 2 Thomas 2012-01-25 02:06:54 UTC
Happy anniversary!
Kohei: Any news about this bug?
If someone else requested this before, is there are a bug report on this? Where can I get the patch you are speaking of?
Comment 3 Joel Madero 2012-09-07 16:57:45 UTC
Any progress on this Kohei? This would be a really useful feature, I was actually looking for it in MS Office at my work today thinking "man that would be useful" from what I can see, they don't have it, it would be awesome if we did :) Let me know if there's something I can do to help - if you link to the old patch I might be able to see what I can do with it
Comment 4 Kohei Yoshida 2012-09-07 16:58:43 UTC
Unassign.  No time for this.
Comment 5 Joel Madero 2012-09-07 19:44:37 UTC
Thanks for the update. After I'm done moving measurements I might take a stab at this, until then I'll try to find someone else to pawn it off on :)
Comment 6 Joel Madero 2014-05-16 19:43:26 UTC
*** Bug 78682 has been marked as a duplicate of this bug. ***
Comment 7 Owen Genat (retired) 2014-09-23 02:54:27 UTC
Related AskLO thread: http://ask.libreoffice.org/en/question/40153/
Comment 8 Joel Madero 2014-09-23 03:53:23 UTC
Apparently this is quite difficult to implement...which is unfortunate. Maybe a decent GSoC idea for the next round
Comment 9 Owen Genat (retired) 2014-09-23 10:39:06 UTC
(In reply to comment #7)
> Related AskLO thread: http://ask.libreoffice.org/en/question/40153/

Sorry. That was a duplicate thread. Original AskLO thread and LO forum thread (which contains a clear mockup) added to URL field. My comments are info only (for clarity of others) and not a desire to see this issue pushed. @Joel, shame about the difficulty all the same as it does seem a decent feature.
Comment 10 Owen Genat (retired) 2014-09-23 10:41:55 UTC
Created attachment 106721 [details]
Mockup of what this feature would look like.

Mockup from LO forum thread added for ease of use.
Comment 11 putt1ck 2015-02-02 12:05:17 UTC
This would be a really great feature and plenty of users would vote for it if they only knew how they could - or that this RFE existed...
Comment 12 alejsek 2015-02-21 03:40:59 UTC
It is obvious no author of excel/calc really uses it for serious work with big tables, otherwise this feature would already be there. Sorry for OT, but it is like debating if we need graphical representation for cursor. In the end, You can just start writing and see where it is, or You can just click with mouse to ensure its location, so where is the problem?
Comment 13 Joel Madero 2015-02-21 07:12:19 UTC
Please refrain from adding useless comments that add nothing to getting the enhancement moving forward. http://joelmadero.wordpress.com/2014/10/11/user-expectations-and-the-reality-of-our-community/?sn=c&c=326#comment-326

Of course - if you have the skills (and aren't just demanding other people to put in time) - patches more than welcome
Comment 14 raal 2015-08-31 08:33:17 UTC
*** Bug 93702 has been marked as a duplicate of this bug. ***
Comment 15 marcostinez 2015-10-05 11:08:32 UTC
Just want to state that I personally think it would be a useful feature, if possible even with some sort of options menu where you can chose the kind of highlighting and whether to select the complete row column (like a cross +) or only the two sides related to the row column (L-form).
I am aware, depending on the implied work, this might be more or less prioritized, but it's one of those things that might make a positive impression on potential new users, encouraging LO usage.
Comment 16 Thomas 2016-01-18 06:02:14 UTC
Happy 5th anniversary!
So, most agree that this is a good idea. Anyone actually working on it?
Comment 17 Joel Madero 2016-01-18 07:22:02 UTC
No - we don't give ETAs or guarantees. A volunteer with some pretty serious skills would have to take an interest and put in the time. Talking to one of the experienced developers...it's no trivial task. It might never be implemented, really just depends on if a volunteer wants to do it.
Comment 18 Romano Giannetti 2016-10-09 15:33:00 UTC
It seems a quite popular request even in Excel, where there is a (commercial) extension set that does it, and a series of hacks with VBA. 

Just saying --- I'd love to have the skill for implementing it, so I will not whine ;-).

See https://www.extendoffice.com/documents/excel/1494-excel-highlight-active-row-and-column.html
Comment 19 Igal 2017-10-31 20:19:11 UTC
I can take a swing at this issue if given a starting point by someone more familiar with the project.

Are there any instructions on how to set up the project in an IDE like Eclipse or IntelliJ IDEA?
Comment 20 Dan Dascalescu 2017-11-26 04:19:12 UTC
Sad to hear it's not a trivial task to highlight the current row.
Comment 21 Jan Pospíšil 2017-12-09 16:20:46 UTC
I completely agree, the VBA macro for excel is something like 25 lines of code, pretty sparse code In fact it just dynamically sets the background color property of all cells in active row/column. Is it really so difficult to implement something similar in LibreOffice that it takes several years?
Comment 22 horus 2018-09-01 10:58:22 UTC
Oh, how I really hope time travel would be real.  Because I am pretty sure that given 30 years, LO or OO or whatever succeeds them will have this function implemented natively without the use of macro.  Or maybe Microsoft Office would be totally free and there's no need to use OO or LO.  So I just need to go to 2048 and grap a copy of the software!
Comment 23 business 2018-11-03 09:49:39 UTC
I am not a programmer, but this lack of a feature has always baffled me for its seemingly simple solution, and the lack of it has made working from a spreadsheet much more tedious (when calling hundreds of phone numbers from a contact list, for example.) I've never understood why this is such a difficult task, considering so many other programs, like gnucash, are able to highlight (or put a temporary border) around the row and/or column last clicked on. 

It sees to me, and this is for anyone who does have the notion for programming it in, that it should be as simple as duplicating the routines in the select row/column action that cause the selected row/column to highlight. It is obvious this routine analyzes the position of the cell, figures out which column and row it is in, determines which cell in that row is the first one in the sheet that is actively being displayed on the screen, and then paints a background color in that originating cell, and continues +1 until all actively displayed cells in the row/column are painted. 

Couldn't a duplicate of this routine be created for a highlighting function (turned on and off in a menu item?) The only difference would be using a different color. This routine also wouldn't select the first cell in the column/row you select, as you would be selecting a cell first, and calling the routine to highlight second.
Comment 24 cpohle 2019-01-15 13:59:00 UTC
+1!
Comment 25 Rich 2019-04-03 20:14:20 UTC
I have a vision problem that makes going across a row difficult some days to follow. This is just what I need. While I cannot code I would be willing to test such a patch.
Comment 26 Ben 2019-07-29 11:54:02 UTC
+1 Similar to Rich with the vision. Having the highlight would be of a big help.