Columns with number / Format and align

Hi Peter,

thanks for your post, and sorry for the trouble.

The reason for why this code is not working is that you are already using TablePress instead of the old WP-Table Reloaded (which is a good thing). Because of that, the CSS code also has to be adjusted to the needs of TablePress, and it can be shortened a little bit:

.tablepress-id-1 .column-2,
.tablepress-id-1 .column-4 {
	text-align: right;
}

Changing the number format (so that they have the . as a thousand separator) is not possible with CSS, unfortunately. You will have to add those directly in the table data. You will then however notice that the sorting does no longer work properly for that column, as the . is interpreted like a comma (decimal separator). To fix that again, you’ll then need to use this TablePress Extension: https://tablepress.org/extensions/datatables-sorting-plugins/

Regards,
Tobias

Hi Tobias,

thank you for the quick help. CSS works now.
As I use Excel for the import data I can adjust my formats in Excel. I’ll use the plugin Extension for the sort order then. Great!

Best regards
Peter

Hi,

no problem, you are very welcome! ?? Good to hear that this helped!

Best wishes,
Tobias

Hi Tobias,

I did download and install the plugin datatables-sorting-plugins

I entered the code (in additional commands):

"aoColumnDefs": [ { "sType": "numeric-comma", "aTargets": [ 3 ] } ]

As the 4th column “KAPAZITAET” = Col D is the one with numbers formatted like this:

12.000.000 (means 12 Mill.). There is no “,” and no decimal digits.

The sort order is the same as not entered the special code. There are “some” of the rows sorted wrong.

Here is the Table

Have I misunderstood the “how to” or is there something wrong? I did not find more documentation on the plugin but as my “problem” was there as a guideline I thought I got it…

Thank you for your help!

Best regards
Peter

Hi Peter,

I’m not exactly sure, but it’s likely that the - entries in that column cause trouble here. All cells in that column will need a real numeric value. Can you maybe try that?

Regards,
Tobias

Hi Tobias,

must be something else. I did replace the “-” with 0 and reimport. If you double click (for descending) you see the problem. It then starts with 780.000 going down to 20.000. The next entry is the biggest one: 13.000.000

I can get rid of the “.” but then it does not read so good anymore. But sorting especially for this column is essential. Any other idea what I made wrong?

Thank you.

Best regards
Peter

Hi Peter,

ah, that’s unfortunate.
I’ll have a look at the “numeric-comma” sorting algorithm in detail tomorrow. It might be possible that it actually only deals with the , as a decimal separator, but that it doesn’t also take care of the thousand separators. I’ll post here again as soon as I find something!

Regards,
Tobias

Hi,

I might have found a quick and easy solution. Please re-install the Sorting Plugins Extension again from https://tablepress.org/extensions/datatables-sorting-plugins/ and re-apply the “Custom Command” with the “numeric-comma” algorithm. That should now also sort your numbers without problems, even with the “-” which will be treated as 0.

Regards,
Tobias

Hi Tobias,

GREAT!! It works! Thank you for the quick help. You created great plugin with superb Extensions!

Best regards
Peter

Hi,

no problem, you are very welcome! ?? Good to hear that this helped!

Best wishes,
Tobias

Hallo, Tbias! How i can vary size my tables. I want relative width. How can I do it?

Hi,

thanks for your post, and sorry for the trouble.

I will reply in the thread at https://www.ads-software.com/support/topic/change-table-width-1 where you also asked.

Regards,
Tobias