jquery.tablesorter RegExp() for currency is false
Closed, ResolvedPublic

Assigned To
None
Priority
Needs Triage
Author
MatthiasDD
Subscribers
TheDJ, MatthiasDD, Krinkle and 2 others
Projects
Reference
bz39284
Description

Folow line is from jquery.tablesorter.js function cacheRegexs() currency:
Line 465: new RegExp( /^[£$€?.]/)

The ? and . is not a currency character. Use RegExp( /^[£$€¥¢]/) instead or RegExp( /^[\u00a2\u00a3$\u20ac\u00a4\u00a5]/) for [cents pound dollar euro yen currency].

For enhancement leave the ^ so that RegExp( /[£$€¥¢]/) or RegExp( /[\u00a2\u00a3$\u20ac\u00a4\u00a5]/) find the currency character also at end. In many languages, so in German, is the currency character at end: 10,50 €

In German Wikipedia the bug produces a unsortable column. If the year not set in template {{dts|20|07|}} a sortkey "?-07-2020. Juli" is used and sorting to currency gives in all rows 0 at digit-sortkey - this is unsortable. (see: [[w:de:Vorlage_Diskussion:Dts#Vorlage_ohne_Jahr_nutzlos]] )

here is table to test it:
{| class="wikitable sortable"
! dts !! key !! 3 !! 4

-
{{dts198}}
?-08-19
$ 15.00
15.00 €
-
{{dts2807}}
?-07-28
$ 10
10 €
-
{{dts237}}
?-07-23
$3.50
3.50€
}

Version: 1.20.x
Severity: major

bzimport added a project: MediaWiki-JavaScript.Via ConduitNov 22 2014, 12:45 AM
bzimport added a subscriber: wikibugs-l.
bzimport set Reference to bz39284.
MatthiasDD created this task.Via LegacyAug 12 2012, 12:17 PM
MatthiasDD added a comment.Via ConduitAug 12 2012, 12:22 PM
  • This bug has been confirmed by popular vote. ***

Add Comment

Column Prototype
This is a very early prototype of a persistent column. It is not expected to work yet, and leaving it open will activate other new features which will break things. Press "\" (backslash) on your keyboard to close it now.