Google-sheets – Google Sheet filling with minutes

If the row you are using for labels contains dates, the spreadsheet supposes that you need an accurate representation of time. So it arranges the data chronologically and marks the time axis at equal time intervals:

If you want the specific dates to be used as labels, this means they should be used like text labels. Select the top row and apply Format->Number->Plain Text:

Now the columns are labeled with the text from the top row, and they are presented in the order of appearance in the spreadsheet.

Well, if don't see the solution, you can write it :)

I created a Python application that can be deployed in Google Cloud (and will work within free quota unless under heavy load).

If you deploy it to your-foo-app.appspot.com (which is really simple), and your published spreadsheet is https://docs.google.com/spreadsheets/d/Bar12345/pubhtml?gid=67890, than your-foo-app.appspot.com/Bar12345/67890 will provide link to the scrollable-with-frozen-rows version of published sheet, and your-foo-app.appspot.com/Bar12345/ will provide the whole spreadsheet with improvised switching tabs. Works in modern browsers.

Here is the working version of the app. Just don't use it in production, because it may get overloaded; deploy your own copy instead.