Google Spreadsheets Formula – How to Exclude Blank Cells in a Formula

I just experienced the same issue and the problem seemed to be surrounding date formatting. The spreadsheet settings (file/spreadsheet settings) locale was set to United States and I'm in Canada. When I changed the locale to Canada, my sheet threw up the exact same error pattern as I saw in the final stage of the print process. I had to change a few cells that pulled date information (they were what were causing errors throughout the rest of the sheet) - specifically ones using the date() function. Once that was cleaned up, everything printed flawlessly.

The reason you get an error is that this function is parsing the formula from which it's called, and does so with the assumption that it's the only part of the formula. But since it's not, the regular expressions match wrong bits, e.g., /\((.*)\,/ greedily matches (sum(L7:AP7)>0,sumColoredCells(L7:AP7,AP7),

Here's one way to make the regexes more specific, so they don't pick up extra stuff:

var rangeA1Notation = formula.match(/sumColoredCells\(([^,]*),/).pop();

and also

var colorCellA1Notation = formula.match(/,(\w{2,})\)/).pop();