cxn03651/write_xlsx

Appending % to a formula

Opened this issue · 1 comments

Firstly, thanks for creating the gem, it's been very useful.

When a number requires the % symbol, the format workbook.add_format(num_format: '0.00%') can be used

However when a similar format is applied on a formula, it throws an error "comparison of String with 164 failed". Is there any workaround to this? (Appending a % to a formula output)

Thank you for using write_xlsx gem.

Can you give me sample source code which raises exception, please.