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?
I do not think that the
options clause has any effect when you are using Google Visualization API Query Language in a
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.