chrisbra
columns width behaviours an others tests
Hi Christian,
here below I submit some screenshots to show some minor points/possible small issues:
column widths (collpase feature)
see:
ArrangeColumn do great job here! Nevertheless a possible useful feature could be to have a width collapse to show the minimum-necessary spaces, in the screen above there are many spaces between a column and another, that's clear but minimize the number of columns in view. Maybe a "Collapse" flag (why not a optional paremeter of ArrangeColumn command?) could help to set in view the max number of columns avoiding much panning (in case of many columns)... it's just a feature (BTW I tested Fixed columns feature but I had no success, myabe I didn't well understood behaviour).
To be fully clear, now is like that:
TITLE OF COLUMN 1 | LONG TITLE OF COLUMN 2 | ...
1890 | alfa | ...
1894 | beta | ...
1890 | gamma | ...
visualization proposed as optional ("ArrangeColumn collapse"):
MN 1 | LUMN 2 | ...
1890 | alfa | ...
1894 | beta | ...
1890 | gamma | ...
Setting vim numbering
If I set numbering on a CVV file, : set nu I got this:
so the header become dis-aligned. Minor point. if I reset vim numbering, all back correct:
ArrangeColumn does not fix sometime
Here below I edited line 11381 changing a filed in column 3 with vi command cwgiorgioybr01 and I got this:
strangely neither ArrangeColumn or %ArrangeColumn correct visualization.
CSVTable
if I run: :CSVTable
it seem that Header is not keep inside:
Searching
Searching inside an (highlihghted) column is a great feature! I experienced sometime that is printed sort of vimscript in last vim line. just a bit confusing at first glance, but it's real a minor point :-)
Sorry for my "picky" notes, is just to reward your great work on csv.vim!
respect giorgio
Hi Giorgio!
Okay, let me see, what I can do here for you.
On Do, 22 Jan 2015, Giorgio Robino wrote:
Hi Christian,
here below I submit some screenshots to show some minor points/possible small issues:
column widths (collpase feature)
see:
ArrangeColumn do great job here, nevertheless a possible useful feature could be to have a width collapse to show the minimum-necessary spaces, in the screen above there are many spaces between a column and another, that's clear but minimize the number of columns in view. Maybe a "Collapse-Column could help to set in view the max number of columns avoiding panning... just a feature (BTW I tested Fixed columns feature but I had no success).
To be fully clear:
now:
TITLE OF COLUMN 1 | LONG TITLE OF COLUMN 2 | ...
1890 | alfa | ... 1894 | beta | ... 1890 | gamma | ...visualization proposed (Column Collapse): ` MN 1 | LUMN 2 | ... 1890 | alfa | ... 1894 | beta | ... 1890 | gamma | ...
Should that only apply to the heading? Perhaps I can conceal the header to a fixed width... I need to think about that.
Setting vim numbering
If I set numbering on a CVV file,
: set nu
I got this:
so the header become dis-aligned
if I reset vim numbering, all back correct:
Okay, I can only workaround the issue, since there is no autocommand for setting some options or changing the appearance of windows, I can only hook into CursorHold autocommand to adjust for changes of the numbering option. That has the drawback, that you have to wait for some seconds until this is corrected, but other than that, it should work and that is how I have implemented it now.
ArrangeColumn does not fix sometime maybe:
Here below I edited line 11381 changing a filed in column 3 with vi command cwgiorgioybr01 and I got this:
strangely neither ArrangeColumn or %ArrangeColumn correct visualization.
You need :%ArrangeColumn! (only when the '!' is used, the width will be newly calculated, otherwise it uses the cached values to be a little bit faster).
CSVTable
if I run :CSVTable it seem that Header is not keep inside:
Was there an empty newline after the header? By default using :CSVTable without a range, it will try to guess the region and if there is an empty line, it will guess wrong.
Try visually selecting the region and then use :Table, so that it looks like this :'<,'>CSVTable This should adjust the borders correctly.
Searching
Searching inside an (highlihghted) column is a great feature! I experienced sometime that is printed sort of vimscript in last vim line. just a bit confusing at first glance, but it's real a minor point :-)
What you are seeing here, is the regular expression that is generated to search within that particular column. I have fixed that now, so it will not be displayed anymore.
Thanks for the feedback!
Best,
Christian
Wenn ein Politiker stirbt, kommen viele zur Beerdigung nur deshalb, um sicher zu sein, daß man ihn wirklich begräbt. -- Georges Clemenceau
visualization proposed (Column Collapse):
Should that only apply to the heading? Perhaps I can conceal the header to a fixed width... I need to >think about that.
what I mean is reduce automatically the column width to a MINIMUM fxed size for each column, truncating eventually the header line in compliance, for example in this case:
instead of this (as now behave):
long header title 1 | long header title 2 | ...
1900 | 2001 | ...
1901 | 2002 | ...
1902 | 2003 | ...
1903 | 2004 | ...
optionally having this:
le 1 | le 2 | ...
-----------------
1900 | 2001 | ...
1901 | 2002 | ...
1902 | 2003 | ...
1903 | 2004 | ...
Okay, I can only workaround the issue, since there is no autocommand for setting some options or >changing the appearance of windows, I can only hook into CursorHold autocommand to adjust for >changes of the numbering option. That has the drawback, that you have to wait for some seconds >until this is corrected, but other than that, it should work and that is how I have implemented it now.
no problems. In facts setting line (= rows) numbers with :set nu is a plus, and the row line appear in the standard vim bottom line..
You need :%ArrangeColumn! (only when the '!' is used, the width will be newly calculated, >otherwise it uses the cached values to be a little bit faster).
I see, Ok!
CSVTable / CSVTabularize
Let consider this file:
$ cat TeamsHalf.csv | more yearID,lgID,teamID,Half,divID,DivWin,Rank,G,W,L 1981,NL,ATL,1,W,N,4,54,25,29 1981,NL,ATL,2,W,N,5,52,25,27 1981,AL,BAL,1,E,N,2,54,31,23 1981,AL,BAL,2,E,N,4,51,28,23 1981,AL,BOS,1,E,N,5,56,30,26 1981,AL,BOS,2,E,N,2,52,29,23 1981,AL,CAL,1,W,N,4,60,31,29 1981,AL,CAL,2,W,N,6,50,20,30 1981,AL,CHA,1,W,N,3,53,31,22 1981,AL,CHA,2,W,N,6,53,23,30 1981,NL,CHN,1,E,N,6,52,15,37 1981,NL,CHN,2,E,N,5,51,23,28 1981,NL,CIN,1,W,N,2,56,35,21 1981,NL,CIN,2,W,N,2,52,31,21 1981,AL,CLE,1,E,N,6,50,26,24 1981,AL,CLE,2,E,N,5,53,26,27 1981,AL,DET,1,E,N,4,57,31,26 1981,AL,DET,2,E,N,2,52,29,23 1981,NL,HOU,1,W,N,3,57,28,29 1981,NL,HOU,2,W,N,1,53,33,20 1981,AL,KCA,1,W,N,5,50,20,30 1981,AL,KCA,2,W,N,1,53,30,23 1981,NL,LAN,1,W,N,1,57,36,21 1981,NL,LAN,2,W,N,4,53,27,26 1981,AL,MIN,1,W,N,7,56,17,39 1981,AL,MIN,2,W,N,4,53,24,29 1981,AL,ML4,1,E,N,3,56,31,25 1981,AL,ML4,2,E,N,1,53,31,22 1981,NL,MON,1,E,N,3,55,30,25 1981,NL,MON,2,E,N,1,53,30,23 1981,AL,NYA,1,E,N,1,56,34,22 1981,AL,NYA,2,E,N,5,51,25,26 1981,NL,NYN,1,E,N,5,51,17,34 1981,NL,NYN,2,E,N,4,52,24,28 1981,AL,OAK,1,W,N,1,60,37,23 1981,AL,OAK,2,W,N,2,49,27,22 1981,NL,PHI,1,E,N,1,55,34,21 1981,NL,PHI,2,E,N,3,52,25,27 1981,NL,PIT,1,E,N,4,48,25,23 1981,NL,PIT,2,E,N,6,54,21,33 1981,NL,SDN,1,W,N,6,56,23,33 1981,NL,SDN,2,W,N,6,54,18,36 1981,AL,SEA,1,W,N,6,57,21,36 1981,AL,SEA,2,W,N,5,52,23,29 1981,NL,SFN,1,W,N,5,59,27,32 1981,NL,SFN,2,W,N,3,52,29,23 1981,NL,SLN,1,E,N,2,50,30,20 1981,NL,SLN,2,E,N,2,52,29,23 1981,AL,TEX,1,W,N,2,55,33,22 1981,AL,TEX,2,W,N,3,50,24,26 1981,AL,TOR,1,E,N,7,58,16,42 1981,AL,TOR,2,E,N,6,48,21,27
plugin seem to detect perfectly:
if i now run
:%CSVTable
I got:
now, if I Undo and I run:
:%CSVTabularize
I got:
and strangely, if i do
vi TeamsHalf.csv :%CSVTabularize
I got
thanks for you patience giorgio
The Table command should be fixed now. I leave the issue still open for the collapse feature
Hi just a thought here on correcting the header misalignment when doing :set nu.
Instead of using the CursorHold autocommand, would using either the FocusLost/FocusGained autocommand pair, or the VimResized autocommand work? When a misalignment is noted, the user could then click away to another window (or desktop) in the first case, or in the second case change the window size slightly. Might be faster than CursorHold. Just a thought.
Thanks for this plugin, and keep up the great work!!
Hi jubilatious1!
On Fr, 18 Dez 2015, jubilatious1 wrote:
Hi just a thought here on correcting the header misalignment when doing :set nu.
Instead of using the CursorHold autocommand, would using either the FocusLost/FocusGained autocommand pair, or the VimResized autocommand work? When a misalignment is noted, the user could then click away to another window (or desktop) in the first case, or in the second case change the window size slightly. Might be faster than CursorHold. Just a thought.
Thanks for this plugin, and keep up the great work!!
You mean for the header command? Did you notice any misalignments, that do not come from setting relativenumber, number or foldcolumn?
For now I have added an extra autocommand for the VimResized,FocusLost/FocusGained command, but not sure how well this will work...
Best,
Christian
Gast: "Ich warte schon seit zwei Stunden auf mein Fünf-Minuten-Steak." Kellner: "Seien Sie froh, daß Sie keine Tagessuppe bestellt haben."
Hi Christian! Thanks for the fast response!
Regarding your changes, maybe user:solyaris can give us his review? I'll check what you ask and post back here. Thanks again for all your hard work!
Hello, Apologies for responding to such an old thread, however, I had the exact same functionality in mind that @solyarisoftware shows in his example:
le 1 | le 2 | ...
-----------------
1900 | 2001 | ...
1901 | 2002 | ...
1902 | 2003 | ...
1903 | 2004 | ...
This idea solves the computational needs of ArrangeColumn: each column is collapsed to the same width, and possible un-collapsed when the cursor is active in it.
I've been scanning the documentation, but I have not found if something like this is possible in the newer version of csv.vim. I can imagine that if this is not possible in the current version of csv.vim, it would take considerable effort to add! I have read in other, more recent issues that you're no longer actively using the plugin yourself, so I understand if this is no longer possible.
Kind regards and thank you for the plugin
Florian
Thanks for the feedback and the nice words. Unfortunately, it is not really possible to collapse a column. We would need some kind of vertical folding for that, but this is not available in Vim yet. I once started to implement this. There is the :VertFold command that implements something like this using concealing.
But even then, if collapsing would be available, I think it wouldn't buy us much, :ArrangeCol would still need to re-calculate the columns widths, because data could have been changed (therefore it does this only when using the ! attribute, to speed up things, else caches the existing width).
Perhaps using vim9script could speed up things a bit, not sure.
And yes you are right, I am not using this plugin much anymore. Nevertheless, I am trying to fix bugs reported here.