search

BdR76 / CSVLint

CSV Lint plug-in for Notepad++ for syntax highlighting, csv validation, automatic column and datatype detecting, fixed width datasets, change datetime format, decimal separator, sort data, count unique values, convert to xml, json, sql etc. A plugin for data cleaning and working with messy data files.
GNU General Public License v3.0
151 stars 8 forks source link

Lock first row when scrolling #74

Closed B5A7 closed 11 months ago

B5A7 commented 11 months ago

Hi

Would this be a possibility, like the feature in Excel?

Thanks Brad

BdR76 commented 11 months ago

I don't think something like the Freeze Panes of Excel is technically possible in Notepad++. The only thing I can think of is using folding/collapsable groups.

Currently, the plugin doesn't use the folding feature at all, so I mean like the [+] signs on the left next to the row number, for example when you open an XML file. Theoretically the CSV plug-in could mark each 10 or 50 rows (or something like that) as folding groups so are foldable/collapsable. And then the top row header names would also be one folding group so you can leave that one open/visible.

Still though, this wouldn't come close to the "Freeze Panes" functionality of Excel.

B5A7 commented 11 months ago

No worries. I am dealing with files where you have several Y/N flags in a row and always struggle to remember which column is which. Thanks anyway for your consideration. Still a great product.

BdR76 commented 11 months ago

I was thinking about some sort of "Columns Highlight" function. So you could set the syntax highlighting to only certain column(s).

So for example, if you select column 5, 7, 12 then everything would be white and only the values of columns 5, 7 and 12 would have a color. That would be useful in your case as well right?

Not sure if I can add this feature though, just speculating.

B5A7 commented 11 months ago

Found a workaround - https://stackoverflow.com/questions/38348383/how-can-i-fixate-a-number-of-rows-as-a-sort-of-header-in-notepad. Cheers