Blank cells displaying

  • Resolved murraystewart

    (@murraystewart)


    9 years, 7 months ago

    Love this plugin. Only issue I am having is that my source sheet has formulas in cells to row 1000 that pull data from other sheets. Where there is no data pulled the cell is blank by default. With the inline viewer all cells to 1000 row are displayed with the last 600 blank. Is there some way to not pull the currently blank rows automatically until they have actual data in them. I was thinking of an if formula with “” as the false return but not sure if this would still show in the inline version.

    https://www.ads-software.com/plugins/inline-google-spreadsheet-viewer/

Viewing 1 replies (of 1 total)
  • Plugin Author Meitar

    (@meitar)

    Is there some way to not pull the currently blank rows automatically until they have actual data in them.

    Yes. Use a query with a where clause that excludes blank results:

    [gdoc key="ABCDEFG" query="select * where X != ''"]

    or similar. See the Google Query Language reference for more options.

Viewing 1 replies (of 1 total)
  • The topic ‘Blank cells displaying’ is closed to new replies.