Rails [AXLSX]: Change Currency

Question

I need to change the currency format on an Excel file that is exported. The default currency pattern is US (1,000.00) [One Thousand] and I need it to become PT-BR format (1.000,00) [One Thousand].

I have tried implementing this way:

    formated = workbook.styles.add_style(format_code: '$#.##0,00')

but the only thing it did, was add more zeroes after the .

How should I do it?

question from:https://stackoverflow.com/questions/65617686/rails-axlsx-change-currency

Answer 1

Welcome to SO :)

Yo might try this:

formated = workbook.styles.add_style(:format_code => '#.###,##')