Guriddo » Topic: Unformat does not work when trying to change decimal separator

Unformat does not work when trying to change decimal separator

Guriddo
custom_formatter
Unformat does not work when trying to change decimal separator

Tagged: custom_formatter

This topic has 8 replies, 2 voices, and was last updated 9 years ago by guriddo.support.

Creator

Topic

October 5, 2016 at 9:46 am #125579

bogdanm

Participant

I tried to use this example, to change the decimal separator from “.” to “,”
http://stackoverflow.com/questions/9276375/jqgrid-number-format-with-comma-as-decimal-point

Here’s my code:

$grid->setColProperty('hourlyrate', array("label"=>"Rate (&euro;)", "width"=>"40", "fixed"=>true, "align"=>"right", "formatter"=>"js:numFormat", "unformat"=>"js:numUnformat"));

$custom = <<<CUSTOM
... other functions here
function numFormat(cellvalue, options, rowObject){
        return cellvalue.replace(".",",");
}
function numUnformat(cellvalue, options, rowObject){
        return cellvalue.replace(",",".");
}
CUSTOM;

$grid->setJSCode($custom);

$grid->setColProperty('hourlyrate', array("label"=>"Rate (€)", "width"=>"40", "fixed"=>true, "align"=>"right", "formatter"=>"js:numFormat", "unformat"=>"js:numUnformat"));

$custom = <<<CUSTOM

... other functions here

function numFormat(cellvalue, options, rowObject){

return cellvalue.replace(".",",");

}

function numUnformat(cellvalue, options, rowObject){

return cellvalue.replace(",",".");

}

CUSTOM;

$grid->setJSCode($custom);

In the grid, the numbers appear with “,” as decimal separators, but in edit mode it still requires “.” as decimal separator, which leads me to believe that the unformat function is not working or is incorrect.

What is the correct method of introducing numbers with a comma as decimal separator?

Creator

Topic

Viewing 8 replies - 1 through 8 (of 8 total)

Author

Replies

October 6, 2016 at 8:50 am #125581

guriddo.support

Participant

Hello,

The unformat function works. Your problem is that you have unformat function.

Let see what is happen.

The number source data that is loaded to the grid has a decimal separator “.”.
The format function convert the “.” to “,” and it is displayed correct to the grod.
When you edit a unformat function is applied – which again convert the “,” to “.”.

In order this to work you will need to remove the unformat function.

If you want to post the data to server again with “.” you may need to use serializeEditData to convert the “,” to “.”.

Kind Regards,

Will

Guriddo Support Team

October 7, 2016 at 10:43 am #125582

bogdanm

Participant

Aha, what I need to do is something like this?


$grid->setColProperty('hourlyrate', array("label"=>"Rate (&euro;)", "width"=>"40", "fixed"=>true, "align"=>"right", "formatter"=>"js:numFormat"));

$custom = <<<CUSTOM
function numFormat(cellvalue, options, rowObject){
        return cellvalue.replace(".",",");
}
CUSTOM;

$replacecomma = <<<REPLACECOMMA
function replacecomma(){
   what do I put here?
}
REPLACECOMMA;

$grid->setNavEvent('edit', 'serializeEditData', $replacecomma);
$grid->setNavEvent('add', 'serializeEditData', $replacecomma);

$grid->setJSCode($custom);

$grid->setColProperty('hourlyrate', array("label"=>"Rate (€)", "width"=>"40", "fixed"=>true, "align"=>"right", "formatter"=>"js:numFormat"));

$custom = <<<CUSTOM

function numFormat(cellvalue, options, rowObject){

return cellvalue.replace(".",",");

}

CUSTOM;

$replacecomma = <<<REPLACECOMMA

function replacecomma(){

what do I put here?

}

REPLACECOMMA;

$grid->setNavEvent('edit', 'serializeEditData', $replacecomma);

$grid->setNavEvent('add', 'serializeEditData', $replacecomma);

$grid->setJSCode($custom);

How do I create the function that changes just some columns?

This reply was modified 9 years ago by bogdanm.

October 10, 2016 at 10:04 am #125585

guriddo.support

Participant

Hello,

The same what you do on unformat function

$replacecomma = <<<REPLACECOMMA
function replacecomma( postdata ){
   var rate = postdata['hourlyrate'];
   postdata['hourlyrate'] = rate.replace(",",".");
   return postdata;
}
REPLACECOMMA;
 
$grid->setNavEvent('edit', 'serializeEditData', $replacecomma);
$grid->setNavEvent('add', 'serializeEditData', $replacecomma);
 
$grid->setJSCode($custom);

$replacecomma = <<<REPLACECOMMA

function replacecomma( postdata ){

var rate = postdata['hourlyrate'];

postdata['hourlyrate'] = rate.replace(",",".");

return postdata;

}

REPLACECOMMA;

$grid->setNavEvent('edit', 'serializeEditData', $replacecomma);

$grid->setNavEvent('add', 'serializeEditData', $replacecomma);

$grid->setJSCode($custom);

Kind Regards,
Will

Guriddo Support Team

October 11, 2016 at 2:53 pm #125587

bogdanm

Participant

Thanks, it worked.

I tried also to use a summary row, but the values there are not formatted according to the custom function I defined. Is there a way to have the numbers in the summary row shown with comma as decimal separator?

October 12, 2016 at 9:07 am #125588

bogdanm

Participant

I forgot to mention that the summary is not displayed correctly only when using:

$grid->setGridOptions(array(
    "grouping"=>true,
    "groupingView"=>array(
        "groupSummary" => array(true)
    )
));

$grid->setGridOptions(array(

"grouping"=>true,

"groupingView"=>array(

"groupSummary" => array(true)

)

));

If I don’t use grouping in setGridOptions, the summaries are formatted correctly if used like this:

$summaryrows = array(
    "somecolumn"=>array("somecolumn"=>"SUM")
);
$grid->renderGrid('#grid','#pager',true, $summaryrows, null, true,true);

$summaryrows = array(

"somecolumn"=>array("somecolumn"=>"SUM")

);

$grid->renderGrid('#grid','#pager',true, $summaryrows, null, true,true);

October 13, 2016 at 10:35 am #125589

guriddo.support

Participant

Hello,

Formatter and custom formatter should work in grouping.

It all depend what is written in the code.

Could you please send us or post a full test example which demostrates the problem?

Please look at this demo in order to see that the formatters work

Kind Regards,

Will

Guriddo Support Team

October 17, 2016 at 11:12 am #125595

bogdanm

Participant

Here is the relevant code:

$grid->setGridOptions(array(
    "grouping"=>true,
    "groupingView"=>array(
        "groupSummary" => array(true)
    )
));

$grid->setColProperty('bvnet', array("editable"=>false, formatter"=>"js:formatBVnumber", "unformat"=>"js:unformat", "summaryType"=>"sum"));

$custom = <<<CUSTOM
function formatBVnumber(cellValue, options, rowObject) {
    // first we replace dot with comma
    var modifiedCellValue = cellValue.replace(".",",");
    // we then format the number with spaces as thousands separator (this column always has 2 decimal places)
    if ( modifiedCellValue.length >= 10 ) {
        modifiedCellValue = modifiedCellValue.slice(0,-9) + " " + modifiedCellValue.slice(-9,-6) + " " + modifiedCellValue.slice(-6);
    } else if ( modifiedCellValue.length >= 7 ) {
        modifiedCellValue = modifiedCellValue.slice(0,-6) + " " + modifiedCellValue.slice(-6);
    }
    // then we change the color of the font
    var cellHtml = "<span style='color:SteelBlue' originalValue='" +
                   cellValue + "'>" + modifiedCellValue + "</span>";
    return cellHtml;
}
function unformat(cellValue, options, cellObject) {
    return $(cellObject.html()).attr("originalValue");
}
CUSTOM;

$grid->setJSCode($custom);

$grid->setGridOptions(array(

"grouping"=>true,

"groupingView"=>array(

"groupSummary" => array(true)

)

));

$grid->setColProperty('bvnet', array("editable"=>false, formatter"=>"js:formatBVnumber", "unformat"=>"js:unformat", "summaryType"=>"sum"));

$custom = <<<CUSTOM

function formatBVnumber(cellValue, options, rowObject) {

// first we replace dot with comma

var modifiedCellValue = cellValue.replace(".",",");

// we then format the number with spaces as thousands separator (this column always has 2 decimal places)

if ( modifiedCellValue.length >= 10 ) {

modifiedCellValue = modifiedCellValue.slice(0,-9) + " " + modifiedCellValue.slice(-9,-6) + " " + modifiedCellValue.slice(-6);

} else if ( modifiedCellValue.length >= 7 ) {

modifiedCellValue = modifiedCellValue.slice(0,-6) + " " + modifiedCellValue.slice(-6);

}

// then we change the color of the font

var cellHtml = "<span style='color:SteelBlue' originalValue='" +

cellValue + "'>" + modifiedCellValue + "</span>";

return cellHtml;

}

function unformat(cellValue, options, cellObject) {

return $(cellObject.html()).attr("originalValue");

}

CUSTOM;

$grid->setJSCode($custom);

The cells in this column look as intended, but the sums are black and have the default formatting (no spaces as thousands separator and has dot as decimal separator).

October 18, 2016 at 10:36 am #125600

guriddo.support

Participant

Hello,

The problem you have here is that the summary value of the column is Float, while you try to use it as string

...
var modifiedCellValue = cellValue.replace(".",",");

1 2	... var modifiedCellValue = cellValue.replace(".",",");

In order to fix the problem just make sure that the cellValue is a string.

cellVAlue += "";
var modifiedCellValue = cellValue.replace(".",",");

1 2	cellVAlue += ""; var modifiedCellValue = cellValue.replace(".",",");

Unformat does not work when trying to change decimal separator

Search Forum

Recent Replies

Forum Statistics

UserOnline