Google Spreadsheet vertical alignment

  • 1
  • Problem
  • Updated 3 years ago
  • Not a Problem
I have linked more than one spreadsheet with no problems, but when I display more than one column they all appear to have a default of vertical alignment in the centre of each row. I want the vertical cell alignment in each row to be at the top as per screenshot below:
Photo of Andrew

Andrew

  • 294 Points 250 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Hi Andrew,

The default layout for the Spreadsheet Gadget isn't set up for this.  You can however, create a custom layout and set that up so that the alignment is at the top.  This page contains information on custom layouts for the Spreadsheet Gadget.

Thanks.
Photo of Andrew

Andrew

  • 294 Points 250 badge 2x thumb
Thanks for the response. I think that solution is for a very rainy day when I have done everything else that needs doing!
Photo of Andy Cleff

Andy Cleff

  • 60 Points
Andrew, did that rainy day ever arrive?

I have a similar need - an easy way to top align all rows in a sheet...

@neal - the link above from a year ago is returning 404...
Photo of Andrew

Andrew

  • 294 Points 250 badge 2x thumb
Hi Andy,

The new Gadget does allow for horizontal alignment, but I can't find any way to set vertical alignment and as you pointed out the linked page does 404.
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Gentlemen,

I discussed this with the Developer, and there is indeed no option to set a vertical alignment in the Gadget itself. I think this would have to be done via a custom layout. Unfortunately that page no longer exists, so it results in a 404.

Let me see what I can do about getting you some more answers on how to do this.

Thanks!
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Gentlemen,

I was able to get some examples for you from our GitHub repo for the Spreadsheet Widget, check these out: https://github.com/Rise-Vision/widget-google-spreadsheet/tree/master/examples

I wanted to make sure you were aware that there are currently some issues with the Spreadsheet widget that will impact custom layouts that you can see here: https://github.com/Rise-Vision/widget-google-spreadsheet/issues.

Let us know how you make out!