WordPress.org

Forums

TablePress
[resolved] Format cells or column as currency (8 posts)

  1. jsem1101
    Member
    Posted 1 year ago #

    Hello Tobias

    Can i ask (possibly) stupid question?

    How do you format a cell, or more importantly for me, a whole column as currency (in my case GBP £0.00)?

    Do i need to use css or am i missing something obvious?

    Many thanks for your help
    Jason

    http://wordpress.org/plugins/tablepress/

  2. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Jason,

    thanks for your question, and sorry for the trouble.

    Well, you'll just have to type in the currency symbol ("GBP" or "£" for example) into the cell.
    Unfortunately, there's no real way to do this with CSS unfortunately :-(

    Regards,
    Tobias

  3. jsem1101
    Member
    Posted 1 year ago #

    Tobias, no problem at all. Just didn't want to go to the trouble of typing the symbol if it wasn't necessary.

    Thanks for your quick reply and great support as always!

    Cheers
    Jason

  4. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    yeah, I also wish that there was an easier solution for this in HTML/CSS :-(

    One idea maybe: You could export the table to CSV, open that in Excel, set the currency format there, save to CSV again and re-import that into TablePress. I haven't tested this, but if you are lucky, the currency symbol will be exported by Excel, too, so that you would save all the typing.

    Best wishes,
    Tobias

    P.S.: In case you haven't, please rate TablePress here in the plugin directory. Thanks!

  5. jsem1101
    Member
    Posted 1 year ago #

    Thanks for the follow up Tobias.

    That worked actually (the CSV import method).
    In this particular case, it wasn't such a big deal since there aren't many rows to contend with.

    But i'll bear in mind for future reference (unless you find a way to format columns and rows with data types in a future update)? ;)

    Until then 1 star! :) (joke)

    Best regards
    Jason

  6. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Jason,

    great! Thanks for the confirmation!
    And yes that idea formatting columns with data types is on my list, but I have not yet found a nice way (and the time...) to implement it.

    Thanks for the rating, I really appreciate it!

    Best wishes,
    Tobias

  7. bmcgoff
    Member
    Posted 1 year ago #

    Tobias,

    Awesome plugin! :I'm having trouble sorting by anything other than plain numbers. For example, currencies and percentages:

    http://sharktankstudies.com/shark-tank-results-list/

    I imported this table as a CSV file with currency/date/percentage formulas embedded. But it seems to be sorting these values alphabetically.

    Any ideas?

    -Brock

  8. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Brock,

    thanks for your post, and sorry for the trouble.

    The reason for this is that currencies/dates/percentages require different sorting algorithms. For the sorting that TablePress uses, those can be added with this TablePress Extension: http://tablepress.org/extensions/datatables-sorting-plugins/

    Regards,
    Tobias

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • TablePress
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic