google spreadsheet data format font size and orientation

  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a placeholder running prices for specials on my display.  I have the concurrent ranges running at 8 second intervals to correlate to the pictures on the menu.  My problem is that the font size in the data format is not customizable, the highest I can go is 96, which is not big enough for my graphic.  Further more, is it possible to centre the text within the place holder?  to put it simply, while the "10.99" fits perfectly within my graphic, the "6.99" is too far off to the left.

I can't change the orientation of the Data Format font to be placed in the middle.  It's very aesthetically unpleasant. 
Photo of Mohamed tafesh

Mohamed tafesh

  • 256 Points 250 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Hi Mohamed,

96px is the largest font size that the Spreadsheet Widget supports. There is also no aligning options for fonts in the Spreadsheet Widget.

You may want to check out our Spreadsheet Component, which is a little more involved to set up, but may accomplish what you need.
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Hi Mohamed,

Actually, both a custom font size and alignment are available in the Spreadsheet Widget! You're just using an older version of the Widget in this presentation.

If you could, click any placeholder with a Spreadsheet in this presentation, click more, then search for Spreadsheet Widget in the store. This will add Google Spreadsheet Widget Version 2.0.0 to your placeholder, which supports both custom fonts and alignment. You will need to replace each Spreadsheet Widget in your presentation in order to make use of these features.
Photo of Mohamed tafesh

Mohamed tafesh

  • 256 Points 250 badge 2x thumb
I just tried it and it works perfectly.  My only issue it that I didn't select any background color for the placeholder but it still gives me a white background, is this an issue that can be remedied?  I have no background selected on both the placeholder or the text option for the spreadsheet font.

Thank you.
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Mohamed, yes it can be solved!

Just set your row colors as below,
Photo of Mohamed tafesh

Mohamed tafesh

  • 256 Points 250 badge 2x thumb
That works!  Thank you.