Column format as currency

  • vipworks

    (@vipworks)


    5 years ago

    Hello,
    I’ve a custom field that I am currently exporting it to the excel. I want the output of that field to be in a currency format, i.e. $ sign prefixed to each value.

    Is there any prebuilt filter in your plugin by which it can be done?

    Regards,
    Vipworks

Viewing 1 replies (of 1 total)
  • Plugin Author Doeke Norg

    (@doekenorg)

    Hi @vipworks,

    As of this moment you can only format cells as “string”, “boolean” or “numeric”. I think the last one comes closest to what you need for now. You can find more info about that right here in the FAQ.

    On the Generic settings page for this plugin (/wp-admin/admin.php?page=gf_settings&subview=gf-entries-in-excel) you check select Export prices as numeric fields, without currency symbol ($). This way all product type fields are already formatted as numeric values.

    That being said, I’ve opened up an issue on the Github repository to add this feature. I want to think a bit how to implement this. In think the first iteration will be to add a filter hook where you can return a format name; but a GUI would be nice in the future.

    If you have Github you can subscribe to the issue.

Viewing 1 replies (of 1 total)
  • The topic ‘Column format as currency’ is closed to new replies.