Tagged: column headers
July 10, 2014 at 2:31 pm #18644
When I’m using the CSV / TSV / DSV modes in EmEditor to view a file, its often some kind of log file, or some other column-based file (obviously).
Such files often have a title row at the top of the file, containing column titles for all the columns. However, it is very easy to get lost between the columns when scrolling down in the file, so a very useful option would be to be able to lock the first line when using CSV / TSV / DSV mode, in order to always see the column titles even when scrolling down into the file. This is actually quite a common feature i table-based viewers like Excel etc.
So, could you please implement this?
It would make my lifetime license so much more fun to have if I knew this was coming in a future version. 😉July 11, 2014 at 3:38 am #18648
I’ll second this!July 11, 2014 at 7:19 am #18649
>>Option to lock first line when using CSV / TSV / DSV mode
It’s already possible:
– execute Window > Split
– split to two horizontal panes (put the vertical delimiter far to the right to not split vertically),
—- while making the top of both panels very small, so you just see the first lines.
Now you can scroll the file in the lower pane as far as you like, while seeing the header line still in the upper pane.
.July 11, 2014 at 4:20 pm #18651
Thanks for the reply!
As far as I can see though, there isn’t a way to lock the side-scrolling for the two split windows? This sadly makes it impossible to use for me, since I use files with many columns, that always need side-scrolling, and in that case I would need the column headers to move in sync when I scroll the bottom window with the contents, otherwise I still can’t know which column is which.
Is this also possible?
Could you otherwise add an option for it?
It would be a very useful addition to this already nice split feature!July 12, 2014 at 9:02 am #18655
Yes, you are right, as long as no horizontal scrolling is required what you suggest can indeed work. And this has an extra benefit when a file has some extra header lines before the column headers. It keeps the complete upper portion of the columnar file stationary and visible and allows one to scroll vertically and bring just the column headings into view.
But sadly enough, “LifeTime” is right too! There is probably no possibility to lock the side-scrolling for the two split windows.
So Yutaka, I would strongly suggest that your implementation of such a feature will:
1) take into account an arbitrary number of extra header lines, and
2) enable horizontal scrolling,
otherwise its usefulness will be rather limited.
MeirJuly 12, 2014 at 2:50 pm #18657
The next version will add an ability to fix the first line as the Header.
Thanks!July 12, 2014 at 10:38 pm #18659
Please see my comment above. Just one line will make it useful for me only rarely…
MeirJuly 13, 2014 at 11:18 am #18663
How about checking the first lines and only locking the first line that is actually CSV/TSV/DSV?
In my case these extra header lines are not CSV/TSV/DSV.
MeirJuly 13, 2014 at 4:27 pm #18664
Thanks a lot Mr Emura for adding this!
Oh, and in order to make it as flexible as possible, i.e. in order to e.g. please the opinions mentioned in this thread, I could suggest to make the number of locked rows configurable, or perhaps even more simple than that, do what I suggested above already, i.e. simply add the boolean option to synchronize the side-scrolling of split windows, and people could then split however they like and achieve this themselves, just like you originally suggested in this thread?July 15, 2014 at 4:14 pm #18681
There is already the “Synchronize Horizontal Scrolling when Split” command available on the Window menu.
Thanks!July 16, 2014 at 12:17 am #18684
Dear, dear Yutaka!
1) Case closed, as far as I am concerned!
2) Which brings to me an old issue: “Tip-of-the-day”. Please make a bank of tips to be presented as part of the opening splash screen. The tip selected might be random but in a perfect world it might be based on the user’s profile and forum participation. It might require a more expanded profile (Languages used, features liked, etc.) It might also require attaching tags to forum posts.
For your consideration…August 5, 2014 at 5:41 pm #18723
Yes, I agree ” locked rows configurable”. Sometimes we only need lock first line, but perhaps others would like to lock two or more lines. It’s better to give users the options to decide how many lines the would like.August 6, 2014 at 2:16 pm #18725
I’m afraid I just noticed one big disadvantage of the split window solution, and that is that it’s not scriptable/recordable to a macro, which is very handy to have instead of constantly having to do some 5-10 mouse click routine to activate it when necessary, so a custom option for it, with a configurable number of locked rows, which is in turn scriptable/recordable to a macro, would indeed be the best solution I think.September 3, 2014 at 5:33 pm #18865
v14.6.0 beta 1 includes this feature (Heading).
You must be logged in to reply to this topic.