kktsvetkov / heiho Goto Github PK

Make the spreadsheet header row "stick" when scrolling down on the rows. Must keep the same column proportions as the rows below.

Must be able to show what the preview looks like

It would be great to be able to add this via Yarn.

Resize column widths according to the data that is previewed in them. Without this, the browsers set the column width and wrap some of the content that can be presented on multiple rows. Find a balance where a column is wide enough to show more of the data inside it, but it is not that wide to make the whole preview harder to read.

Track data length in each column and optimize around median values and not the extremes.

After closing the preview restore the document.body scroll position.

Instead of showing the preview only when the data is fully loaded, try to load the preview first, show a "Loading..." message, and then load the rows. This will help with some big spreadsheets, where now there is some delay between the command is triggered and when the preview is shown.

Add options function for the contents of the loading element in the same way options.title and options.truncates are used.

This script is previewing only CSVs, not real spreadsheets. In almost all of the CSVs the first row is the header row with the titles of the columns. It makes sense to have it styled differently so that is more obvious that this is the row with the column titles. No need for anything flashy, just making them bold might be enough.

Considering #3 perhaps this first row must also stick to the top of the preview.

All of this is best to be configurable through the options so that there is some options flag that instructs the preview whether to treat the first row differently or not. Some research into how this can be auto-detected will probably help with the default behaviour of this setting when nothing explicitly is specified.