dhtmlGrid

Discontinued products Uncategorized discussions
#1

Hi,



I am an employee of Razorsiht Software Solutions. We are using license version of dhtmlGrid.



we baught this from you people. Here I am loding the grid from normal HTML table, not thru xml file.



We are facing problems in column Custom Sorting.



I mailed You the same issue, long back. You guys replied and asked me to send the code sample.



Here I am attaching the code sample.



Appreciating your earlier response



thanks



satya










































GRID FOR CUSTOM SORTING on Columns Containg $ i.e, Monthly Excepion Amount and Retro-Credit Amount






<table width=“100%” border=“0” bordercolorlight="#000000" align=“left”

cellpadding=“0” cellspacing=“0”

id=“MyTableExceptionList”

gridHeight=“100%”

hlcolor=#FED079

gridWidth=“100%”

forceCellTypes=“true” dragAndDrop=“true”>







Audit Category

Audit Report

Exception Count

Monthly Exception Amount

Retro-Credit Amount

Exception Type







<tr align=“left” valign=“middle” bgcolor="#ffffff" class=“columntext”

onMouseOver="">

Billed Charges Report







Report of State Level Surcharge Costs







1



$79.21

$0.00

 





<tr align=“left” valign=“middle” bgcolor="#ffffff" class=“columntext”

onMouseOver="">

Invoice Charges Audit







CT/EF at Same Location as CFA







1



$231.49

$0.00

 





<tr align=“left” valign=“middle” bgcolor="#ffffff" class=“columntext”

onMouseOver="">

Invoice Charges Audit







Incorrect Facility Mileage Quantity







1



$545.08

$0.00

 





<tr align=“left” valign=“middle” bgcolor="#ffffff" class=“columntext”

onMouseOver="">

Invoice Charges Audit







Incorrect billed amount due to an incorrect Ratchet, PIU or Quantity







1



$231.49

$0.00

 





<tr align=“left” valign=“middle” bgcolor="#ffffff" class=“columntext”

onMouseOver="">

Provisioned Inventory to Invoice Audit







Billed Term Length Vs. Inventory Term Length







2



$776.57

$0.00

 





<tr align=“left” valign=“middle” bgcolor="#ffffff" class=“columntext”

onMouseOver="">

Provisioned Inventory to Invoice Audit







Incorrect PIU or PLU on circuits based on what percentage was ordered







2



$776.57

$0.00

 

















#2

Problem caused by the way how removeDollar function works, it returns data as (string) , so all further operation process it incorrectly.
Just replace
    return dollarVal;
with
    return parseInt(dollarVal);


Meanwhile grid supports “price” excell which work nearly the same, but it compatible with native sorting