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.
Someone else had requested this before. In fact, there was even a patch (though not implemented correctly).
I'll keep this meanwhile.
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?
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
Unassign. No time for this.
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 :)
*** Bug 78682 has been marked as a duplicate of this bug. ***
Related AskLO thread: http://ask.libreoffice.org/en/question/40153/
Apparently this is quite difficult to implement...which is unfortunate. Maybe a decent GSoC idea for the next round
(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.
Created attachment 106721 [details]
Mockup of what this feature would look like.
Mockup from LO forum thread added for ease of use.
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...
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?
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
*** Bug 93702 has been marked as a duplicate of this bug. ***
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.
Happy 5th anniversary!
So, most agree that this is a good idea. Anyone actually working on it?
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.
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 ;-).
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?
Sad to hear it's not a trivial task to highlight the current row.
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?
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!
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.
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.
+1 Similar to Rich with the vision. Having the highlight would be of a big help.
+1 i really need this feature.
*** Bug 129545 has been marked as a duplicate of this bug. ***
+1 similar to Rich and Ben
I can understand this might be difficult to implement. A compromise could be a function to momentarily select the row and/or column of the current cell.
It could be a shortcut you press to highlight the row and/or column for one second, or it could highlight the row/column for an instant each time you press the left/up or right/down arrow.
Instead of changing the behaviour of the software can this perhaps be implemented with a sort of modifier keys?
The user selects the cell and the behaviour is unchanged but if the user uses key+click to select the cell that highlights the row and the column.
Would this be easier to implement?
Sorry for not being able to bring a bigger contribution to this.
Seems like no user of OOo 1 has read this bug so far, because that feature was already in OOo (or was it Star Calc?) before. And yes, it was EXTREMELY helpfull!! I think it vanished when Windows XP arrived, because there was a problem with the new Theme back then. But that is ages ago ;)
Count me in to the people that want that feature (back) in LibO. It really is so hard to copy lines to paper by hand, if there is no visual highlight of the current line/row... I started to select the line that I'm working on right now, but thats more of a workaround, not a permanent solution...
Feature still missing in 22.214.171.124
Created attachment 164684 [details]
Transparent rectangle for the current row & column
Maybe there's an easy way to implement this in v7!
I saw in the LO 7 release notes that there's now support for transparent text in Writer and other components.
Can that code be reused to apply a transparent rectangle over the current row and column, as illustrated at https://superuser.com/questions/899479/how-to-highlight-whole-row-and-column-under-cursor-in-openoffice-calc?
Actually, this SHOULD be easy to implement - just do exactly what clicking a row or column header does (or Shift+Space), but with a different color.
I also need this feature for work with long and wide spreadsheets.
It seems such feature is present in Windows version? Or is it only system feature there? I am a Linux user (KDE), have only seen it by other people.
(In reply to Wojciech from comment #38)
> It seems such feature is present in Windows version?
I wish that would be so... Don't worry, Linux users are not disadvantaged here, there is currently no highlight, on any OS.
(In reply to Dan Dascalescu from comment #37)
> Actually, this SHOULD be easy to implement - just do exactly what clicking a
> row or column header does (or Shift+Space), but with a different color.
Thanks for the hint on Shift + Space. That makes the situation already a bit better ;)
All. This feature request is more then ten years old now. It is funny that we are still in the same shame.
+1, this should be an extremely helpful feature.
CTRL+SPACE and Shift+Space does not work for me on
Version: 126.96.36.199 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 8; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: hu-HU
Ubuntu package version: 1:7.1.4~rc2-0ubuntu0.20.04.1~lo1
Ctrl+space OR shift+space alone itself are working, but cannot highlight the current cell as a +, due to the complete sheet gets highlighted upon pressing the second set of keyboard shortcuts.
Sounds like a good enhancement. We should make it optional in both on/off and color. Tools > Options > Calc > View: "[x] Highlight col/row <Blue>" (default color ideally taken from the system theme). And it requires an entry under the View main menu and a good shortcut. Perhaps alt+space since ctrl/shift+space select the col/row. A selection overwrites the highlighting, of course.
It could be a highlight (transparent shade of color) or even a border (similar to selection highlight in another color, maybe, or just a colored border making a "cross" row-column).
I use to have to explore big student data spreadsheets (thousands of rows and around one hundred columns) and this would be a life safer --- now I sometimes have to select a column and use an on-screen horizontal ruler to be sure to pick the right spot.
Heiko's suggestions seem spot on!
Was looking into the code but it seems to be a tricky thing. We could use either ScOutputData::DrawBackground() or ScOutputData::DrawGrid() for the highlighting (would suggest to add a boolean parameter to the function because it's also used for print and other previews), which is called from ScGridWindow::DrawContent() (gridwin4.cxx). But no idea what cells is focused at this position.
(In reply to Heiko Tietze from comment #42)
> Sounds like a good enhancement. We should make it optional in both on/off
> and color. Tools > Options > Calc > View: "[x] Highlight col/row <Blue>"
> (default color ideally taken from the system theme).
Marked selection is already blue, so that should be something different.
> shortcut. Perhaps alt+space
No, because Alt+Space opens the window menu in at least GNOME and other window managers.
(In reply to Heiko Tietze from comment #44)
> Was looking into the code but it seems to be a tricky thing. We could use
> either ScOutputData::DrawBackground() or ScOutputData::DrawGrid()
Anything ScOutputData would be wrong because it's not related to data at all, nor styles. It also wouldn't be a background.
Take a look at ScTabView::MarkRows() and ScTabView::MarkColumns(), which are called for .uno:SelectRow and .uno:SelectColumn, it would be almost the same (without the actual mark and selection of course) and should be a HighlightOverlay added to the OverlayManager, similar to the SelectionOverlay that is updated from InitBlockMode() as ScGridWindow::UpdateSelectionOverlay(), e.g. like UpdateHighlightOverlay() and so on. They could share a great portion of code.
Thanks Heiko and Eike for working on this :)
(In reply to Eike Rathke from comment #45)
> (In reply to Heiko Tietze from comment #42)
> > Sounds like a good enhancement. We should make it optional in both on/off
> > and color. Tools > Options > Calc > View: "[x] Highlight col/row <Blue>"
> > (default color ideally taken from the system theme).
> Marked selection is already blue, so that should be something different.
I just played with colors:
- Color only on the Border (as someone suggested) → In my opinion too subtle to be really helpful in crowded tables.
- Blue highlight → I tried it with less opaque versions of the "selection blue" and indeed that doesn't work, as the “selection blue” is already quite light, and you can't really go much lighter. Darker is also bad because you lose contrast to the content then. So Eike is right, it has to be another color then the "selection blue".
Too difficult for me. ScTabView::MarkColumns() and *Rows() take a lot of conditions into account such as merged cells (not perfectly correct though), other selection, and many more situations that are not clear to me.
I also wonder if adding a selection is the right way. We could do it on-the-fly in ScGridWindow::UpdateSelectionOverlay(), and perhaps only if nothing else is selected. The range would be from 0 to max_view (GetScrSize()?) with GetCurX/Y() by cell width (no idea how to calculate the width/height in px) and has to respond to ScGridWindow::CursorChanged() but also resize and scroll.
Bayram, is this something for you?
(In reply to Heiko Tietze from comment #47)
> Bayram, is this something for you?
I'm not sure, but I'll work on it as soon as possible.
For LO 7.4 beta1?
(In reply to Phil from comment #49)
> Any progress?
> For LO 7.4 beta1?
no progress so far.
In the meanwhile, I discovered that (at least on Gnome Shell) I can use the "Universal access" hairline zoom feature, which helps a lot.
There is an explanation here: https://askubuntu.com/a/1095983/16395 --- if you choose a very transparent color for the airline cursor and a default zoom factor of 1.00, you can then use the keyboard (by default super+alt+8, but you can change it) to superpose to the mouse cursor a full-screen crossline.
Clearly not the same thing, because it follows the mouse and not the active cell, but it's better than nothing on very big sheets.