Bug: wrong conversion when numbers are formatted as currency

[micheledallatorre]

Hello, I am using a QUERY() function to create a tablet in a sheet that is then sent via email using Google Apps Scripts with your library.

When the numbers are formatted as currency (e.g. €), the email with the table is wrong. In particular, all the numbers have €-2 prepended.

For example € 2 (as seen in the spreadsheets) becomes € -220 (in the email receveid) and so on.

[rubenrivera]

Nowadays Apps Script include getDisplayValues(). I'm using it instead of getNumberFormats().