0

I have to replicate a Google Sheet, and am using ImportRange and Query together. I need Query also because the first sheet has urls under them, which I cannot have on the copied sheet. I was able to remove the urls by using Query Options no_format. Options no_value also does the same job. However, neither of them allow any format change to transfer, at least not that I have found. I want to have the bold format to transfer, font size to transfer, and new rows added in the middle of the sheet to transfer, but not color. Is there ability to do this in Query Options no_format or Options no_values? Or is there some other way I can make this happen?

1
0

I do not think that the options clause has any effect when you are using Google Visualization API Query Language in a query() formula.

The format clause works fine in a query() formula, but it does not let you transfer cell formatting such as font size, bolding or color. It only lets you specify number formatting for integers, floats, dates, times, datetimes and booleans.

See Query Language Reference.

1
  • Thank-you for your answer doubleunary. It seems I need to use a script. Does anyone know how to write a script that I could use to have all formats copy over with ImportRange except for color and underlying urls? – Wes Jun 7 at 19:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.