Spreadsheet: Can't format some columns because they don't show up

  • 1
  • Problem
  • Updated 3 years ago
  • Not a Problem
I went in to edit a spreadsheet widget and in the Select Columns to Format area there is only the first column from the range I specified. I axed the widget, created a new widget and they all showed up -only to disappear on subsequent edits.
Photo of John Dietrich

John Dietrich

  • 132 Points 100 badge 2x thumb

Posted 3 years ago

  • 1
Photo of John Dietrich

John Dietrich

  • 132 Points 100 badge 2x thumb
Figured it out, I think.

The first row must have some text in each cell for them to show up in Format. This does not seem to hold for all of the spreadsheet widgets I'm using (others are fine with only one cell populated in the first row,) but it did seem to fix this one.
(Edited)
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
John,

We have seen in the past that the first line needs some content in order for cell formatting to work. Glad you were able to resolve this issue.
Photo of John Dietrich

John Dietrich

  • 132 Points 100 badge 2x thumb
Nope, came back, meaning format choices disapperared again.
Photo of John Dietrich

John Dietrich

  • 132 Points 100 badge 2x thumb
Got it to work again. I'll just leave it alone.