kmcclory

After further research, I was able to find a thread with the answer to my question. The custom code looks like this:

“aoColumnDefs”: [ { “sType”: “currency_sorting”, “aTargets”: [ “column-2”, “column-3”, “column-4”, “column-5” ] } ]

Thanks for you help.

Tobias,

I’ve added the plugin and applied the custom code as described in the first post and it seems to be working correctly; however, we’re using 4 columns with dollar values and the example only addresses 1 column.

Can you clarify the custom code so that it can be applied to columns 2 thru 5?

Thanks,

Kevin

Tobias,

Sorry for adding to an 8 month old post but I’m using your code from this page and noticed an issue that I’m hoping you can help with. When you add a $ sign to the field it changes the type from numeric to alpha which changes the results from the Table Tools sort function.

The column is right justified but the numbers are sorted by the first char value rather then the numbers value. So for example, 350 comes before 90 and after 2000.

the numbers look like this now:
1
10
100
2
20
200

is there a way to change they type back to number and still display the $ sign?

Thanks,

Kevin

One of the tables we’re using has more then 1000 rows. We can upload the file using the CSV upload tool with no problems but when we edit the table it gets cut-off at row 1001.

The host feels this is an issue with the plugin code and not a problem with the server settings. Is there an upper limit to the number of rows your plugin can handle?

I think our table is currently around 1307 rows and 8 columns. In the future the table may get a little larger then this.

thanks,

K