Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
micheledallatorre opened this issue Sep 11, 2017 · 1 comment
Open

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

micheledallatorre opened this issue Sep 11, 2017 · 1 comment

Comments

@micheledallatorre
Copy link

micheledallatorre commented Sep 11, 2017 •
edited
Loading

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
Copy link

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

phavel added a commit to phavel/SheetConverter that referenced this issue Aug 31, 2023
@phavel
mogsdad#9 FIX: wrong conversion when numbers are formatted as currency
0baf16e 
See mogsdad#9 comments.
@phavel phavel mentioned this issue Sep 6, 2023
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@micheledallatorre @rubenrivera