JQuery :: Tablesorter Not Correctly Sorting Money?
Sep 20, 2010
I have some vaules such as:
£90.00
£84.26
£83.07
£83.00
£82.50
£81.00
£80.00
£102.00
£101.00
£100.00
As you can see it's fine up to the point where I get into 100's as it seems to put them lower than the 90's.
View 1 Replies
ADVERTISEMENT
Jun 17, 2011
Assuming a structure like:
<table><thead><tr>
<th>Sample</th>
</tr></thead>
<tbody><tr>
<td><ul><li>25
<ul><li>Some Name</li>
</ul></li></ul>
</td></tr>
</tbody>
</table>
How can I use textExtraction to sort based on whatever number is in that first LI element? I have tried various things, but just can't seem to get it.
//Various forms of the below... trying to find the right path to the element.
textExtractionCustom: { 0: function(o) { return $('li','ul.serversgs',o).html(); } }
textExtraction: { 0: function(o) { return $('li','ul.serversgs',o).html(); } }
// This from within my own function called by whatever column I'm sorting by (0 above).
return
node.childNodes[0
].childNodes[0
].innerHTML;
Am I wrong and I cannot do this, even though the sample above is directly from the Tablesorter site as an example of bypassing HTML markup inside the TDs?
View 1 Replies
View Related
Nov 29, 2010
I'm using tablesorter in my app and it's working great except.. the ip address sorting seems to be slightly broken. It will sort on the first two groups fine, on the third group it tries to sort once and gets it wrong and on the last group it won't sort at all.bob
After a bit of debugging the issue is that an ip address is being detected as a digit, i.e 192.168.1.100 is detected as the number 192.168 and hence only sorting on the first two groups. I fixed this by moving the digit to the end of the parsers. This is not a proper fix but works for me. Secondly the parser needs to be changed as follows. Without the debug line obviously. It was limiting each group to 2 characters and only sorting the first two groups.
[Code]...
View 2 Replies
View Related
Jan 17, 2009
I have a table in which the first column is the row number (always from 1 at the top to 100 at the bottom) so no matter how the other columns are sorted that first column should be the 'rank' for that particular
sort. Is it possible to do this with tablesorter? Could I change the values in the first column after tablesorter did it's work? I see how to disable sorting on the first column but that is not what I want.
View 5 Replies
View Related
Nov 17, 2010
I need to exclude a table row from the sorting with tablesorter.
View 4 Replies
View Related
Apr 19, 2011
I have been using tablesorter2.0 plugin to sort the table. My requirement is such that I don't want few rows to be sorted. Like i can add a class like <tr class="nosort"> for rows to whom sorting should not be applied. And rest all rows should be sorted. Can't find a way to do this.
View 7 Replies
View Related
Aug 21, 2009
I've been working on getting a table with a super header and sub headers to only sort by the sub headers. The example at [URL] shows this is possible but everytime I try to run the code the items in the top row are used to sort columns starting with 0. I've tried two different versions of jquery and re-downloaded Tablesorter twice now. It seems as if this should be easy and I'm just missing some amazingly simple thing.
Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/
TR/html4/strict.dtd"> <html>
<head>
[code]....
View 2 Replies
View Related
Dec 16, 2011
I would like it very much if there was an option to have sorting disabled when there is only a single row in the table.
View 1 Replies
View Related
Oct 22, 2009
I have a div container that is used to specify where the table I retrieve via ajax is placed $("#div_reveal").html(AjaxResponse). I have tried to add an onSuccess function to update the table function (){ $("table").trigger("update"); } but the table does not sort. When I copy the output table directly into the page (static) it sorts. Therefore, I am assuming that the new table is not being added to the Dom and and is not being "recognized" by tablesorter. Does anyone know of a solution to retrieve and display a full html table via ajax and get tablesorter to sort it.
View 1 Replies
View Related
Jun 29, 2009
I'm using Tablesorter since few months and it was working very well.I did a small change yesterday in my php code: numbers over 1000 are nowformatted like this: 1 000, 1 000 000 instead of 1000 or 1000000.Since I did this change Tablesorter seems to have problems sorting this kindof formatted numbers with spaces. It just doesn't sort the way it should
View 1 Replies
View Related
Dec 9, 2011
i wonder if tablesorter does not properly parse the number of a table cell since it sorts a col of length values like this:
...
23 cm
115 cm
13 cm
May it be it takes only the very first digit into account? How to handle this without a core hack?
View 6 Replies
View Related
Sep 12, 2011
I'm using JQuery Tablesorter, and I would like to DISABLE Multi-column sorting option from tablesorter plugin.
View 2 Replies
View Related
Oct 14, 2010
I need to do javascript money validation for a field. the condtions are
1) depending on the Locale (not sure if this can be done in JS like US,Germany..)
2) verify if it has $,pound symbol, yen symbol..
3) group the digits either like 00,00,000 or 000,000,000
4) accept 2 digits decimal 000,000.00
View 4 Replies
View Related
Nov 28, 2011
Im trying to find a code for such a ''Reckoner'' script as it is here: [url]
Of course the datas should be instantly updates when exchange rates between currencies changes and it does changing very often (daily). I thought I could ask their webmaster for the code but the script is not the same to what is needed because there should be some rounding also done to the nearest 5. What do I mean with ''nearest 5'' is shown here:
[url]
I have seen those four scripts already but they are different:
[url]
Its very important for me that updates are being changed by trustful source (website) which will really stay up 24/7 forever and will get (this source) new exchange rates instantly. If source would be unavailable that means the script on page of my website would be unavailable too. Also I should not need to republish page (or entire website) when the datas are changed. When I mentoined changes should be instantly, on html page, I meant when page (or website) is being reloaded. So since the source of exchange rate is important, the code should not contain any values at all (except for rounding) because those values (exchange rates) are changing very often (daily).
View 2 Replies
View Related
Aug 21, 2010
Well basically i have coded a java script well edited from here i think.
This is the page at the moment [url]
But I'm trying to edit to i have drop down boxes with:
Start
End
Then the same for karaoke start and finish.
But the hard part it getting the right
So minium booking is 2 hours for 100 and then every hour after is 30 and 15 for 30 Min's karaoke is 5 an hour.
View 3 Replies
View Related
Aug 28, 2009
I am trying to find an adjustable counter that I can use on our site to show a steady increase in dollars collected. I guess similar to the the national debt counter, but the values need to be programmable and adjustable (starting amount, increment amount, speed, etc) by me.
It is only a representation counter and does not need to collect data from anywhere. We will update and adjust real values on a regular basis as the data is received through other sources.
View 3 Replies
View Related
Nov 30, 2011
Function below will output price value in text field based on drop-menu option. It's working but I want it's always show value in 2 decimal point.[code]...
View 3 Replies
View Related
Oct 14, 2010
I have an input in the form, where i have to do the following validations.
1) see if it is a number
2) allow digit grouping wither like 00,00,000(Asia format) or 000,000,000 (us format)
3) allow 2 decimal points 000,000.00
4) if the money does not conform to this format return false
View 4 Replies
View Related
Oct 15, 2010
I need to do javascript money validation for a field. the condtions are
1) depending on the Locale (not sure if this can be done in JS like US,Germany..)
2) verify if it has $,pound symbol, yen symbol..
3) group the digits either like 00,00,000 or 000,000,000
4) accept 2 digits decimal 000,000.00
View 1 Replies
View Related
Nov 12, 2010
Im trying to write a code to covert dollar to real(Brazilian money) how to do that?
View 1 Replies
View Related
Mar 15, 2011
I'm trying to get tablesorter working on my site, as per [URL]
Here's the page I'm working on: [URL]
I've included references to jquery-1.5.1.min.js and jquery.tablesorter.min.js in the page header, and uploaded the files to my site. I'm sure the references are OK, because if I use firefox web developer to view javascript it can find both of these.
I've included a script in the header to sort the table:
<script type="text/javascript">
$(document).ready(function()
{
$("#myTable").tablesorter();
[Code].....
The table has an id of "myTable" and is of class "tablesorter".
I've uploaded the css file, and again, I'm sure this is being located OK, because the table has the look and feel of a tablesorter class, and again web Developer is able to display the css correctly.
BUT, the icons aren't appearing, and the table is not sorting. I've put copies of the icons in root, in the same directory as the page and the same directory as the jquery files for good measure, but they're not being found. And no amount of clicking will sort the columns.
View 1 Replies
View Related
Dec 31, 2010
I use table sorter ( latest 2.0.5) and Jquery latest for sort table !
It works fine!
BUT! in some tables, I've link for open image in a light box !
On the first page, all works fine !
But, as soon as i set the second ( or more ) page in the table, the link work like a classic link, not like a "lightbox class" link !
I've try with fancybox => same !
with shadowbox => same !
and with lightbox => same !
So, the problem come from tablesorter or the pager !
View 1 Replies
View Related
Apr 30, 2009
I'm trying to get tablesorter [URL] working but pasting the example table, when the given document.ready() function fires, I get a javascript error saying that $ ("myTable").tablesorter(); is not a function. Can anyone confirm this works with Jquery 1.2.3?
View 1 Replies
View Related
Jun 3, 2009
The tablesorter plug-in by Christian Bach has what I think are a couple of bugs/anomalies. 1) a column that starts with a zero is not identified as a 'digit'. I think it should be. 2) a column that starts with an IP address that looks like 192.168.1.1 or 1.127.77.1 -- that is any IP with a single digit is not identified as an IP address because the "is" function only looks for d{2,3} instead of d{1,3}. 3) some of the examples in the source code are wrong. Otherwise a great plug-in and worth the effort to debug.
View 1 Replies
View Related
May 27, 2009
I am trying out the Tablesorter in Wordpress 2.7.1 to make a membership list sortable. For some reason the sortable features isn't being enabled (or at least visible). Here are the steps I've taken so far: 1) In the header.php file I added the following code between the head
tags:
<head>
<script type="text/javascript" src="library/scripts/jquery-
latest.js"></script>
<script type="text/javascript" src="library/scripts/
jquery.tablesorter.js"></script>
[Code].....
But, while the table shows up on the page, the sortable features are not visible. NOTE: In Wordpress I have the WP-Table Reloaded plugin activated, but to trouble shoot this issue, I am not using the shortcode and using a HTML table directly in the page, for now.
View 16 Replies
View Related
May 29, 2009
at least going to be a double post from in the jQuery Plugin list. I'm being moderated yet on that list, and it doesn't seem to get much activity.I'm going to post this here since the Tablesorter developer hasn't gotten back to me yet.I took a copy of the latest version in SVN and modified it to have jQuery UI Theme support. It seems to work very well and anyone is welcome to use it.[code]I was hoping this would be included into tablesorter so I just threw up the modified version on my work site for now.
View 3 Replies
View Related