PurchaseCurrency, percentage and similar column in wpDataTablesHow to display numeric data with additional symbols (currency, percentage, units)
Sometimes you need more than an integer or a float column when you’re referring to a percentage, or to amounts in euros, dollars, etc.
Adding all these examples as column types would make the plugin usage confusing for users, so we found a different solution: we added a “Cell content prefix” and a “Cell content suffix” block for each of the column settings.
Whatever you enter in the “Cell content prefix” (for example a $, or other currency sign) will be rendered in each cell of this column before the actual cell value; whatever you enter in the “Cell content suffix” (For example “%” or “pcs.”) will be rendered after the actual cell value. These entrees will not affect sorting, filtering, or any other column functions.
E.g. for this table the “Yearly revenue” column has a “$” sign defined in the “Cell content prefix“:
- Creating editable tables and filling the table data manually
- Creating non-editable tables from Excel files
- Creating non-editable tables from Google Spreadsheets
- String columns
- Integer columns
- Float columns
- Date columns
- DateTime columns
- Time columns
- Image columns
- URL link columns
- E-mail link columns
- Formula (calculated) columns
- Coloring and styling columns
- Hiding columns
