• Do not register here on develop.twiki.org, login with your twiki.org account.
• Use View topic Item7848 for generic doc work for TWiki-6.1.1. Use View topic Item7851 for doc work on extensions that are not part of a release. More... Close
• Anything you create or change in standard webs (Main, TWiki, Sandbox etc) will be automatically reverted on every SVN update.
Does this site look broken?. Use the LitterTray web for test cases.

Item6392: TABLE sorting doesn't recognize numbers with commas

Item Form Data

AppliesTo: Component: Priority: CurrentState: WaitingFor: TargetRelease ReleasedIn
Extension TablePlugin Normal New   n/a  

Edit Form Data

Summary:
Reported By:
Codebase:
Applies To:
Component:
Priority:
Current State:
Waiting For:
Target Release:
Released In:
 

Detail

In the US, numbers in the thousands can be formatted with commas. TABLE does not recognize these as numbers when sorting.

In the example below,

|ct|12|0|0.00%|8|66.67%|12|

should sort at the top when the table is sorted on column #2.

Country Total Total RSS % RSS !SpaceID % SpaceID Non-Rss
aa 10,296 7,316 71.06% 800 7.77% 2,980
ar 26,476 18,056 68.20% 1,148 4.34% 8,420
at 1,128 0 0.00% 976 86.52% 1,128
au 13,660 9,088 66.53% 800 5.86% 4,572
br 87,968 76,064 86.47% 2,984 3.39% 11,904
ca 110,808 94,960 85.70% 2,488 2.25% 15,848
cd 17,400 4,992 28.69% 7,004 40.25% 12,408
cf 11,040 9,280 84.06% 220 1.99% 1,760
ch 256 0 0.00% 152 59.38% 256
chfr 80 0 0.00% 36 45.00% 80
chit 32 0 0.00% 24 75.00% 32
ct 12 0 0.00% 8 66.67% 12

-- TWiki:Main/VickiBrown - 03 Feb 2010

ItemTemplate
Summary TABLE sorting doesn't recognize numbers with commas
ReportedBy TWiki:Main.VickiBrown
Codebase 4.2.4
SVN Range TWiki-5.0.0, Sat, 02 Jan 2010, build 18269
AppliesTo Extension
Component TablePlugin
Priority Normal
CurrentState New
WaitingFor

Checkins

TargetRelease n/a
ReleasedIn

Topic revision: r1 - 2010-02-03 - VickiBrown
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback