search

mogsdad / SheetConverter

Google Apps Script library - interprets Google Sheets Formats, converts to formatted text or html
49 stars 26 forks source link

Bug: wrong conversion when numbers are formatted as currency #9

Open micheledallatorre opened 6 years ago

micheledallatorre commented 6 years ago

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 commented 6 years ago

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