Question

I have a table with columns of numbers. The sorting of these columns works fine until I change some of the numbers to be a different color (I use red and green to make some numbers stand out in the table). I have attached a simple table to illustrate the problem. The third column doesn't sort properly (it is sorted as though the numbers are text strings). Is there a way to make this work?

TEST	Calls	Time
V5	97	10.1
V7	3077	12.6
V2	550	29.5
V3	303	120.2

Environment

-- JimKulikowski - 05 Mar 2008

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

TEST	Calls	Time
V5	97	0101 10.1
V7	3077	0126 12.6
V2	550	0295 29.5
V3	303	1202 120.2

-- FranzJosefGigler - 05 Mar 2008

THANKS Franz! In my version of twiki I was unable to set the HIDD and EN macros, but I just put the

"<div style=\"display:none\">" and "</div>" 

-- JimKulikowski - 06 Mar 2008

Yet you just need some SSP-wizardry to autocreate the sortable string of the numeric input. -- just kidding.

-- FranzJosefGigler - 06 Mar 2008