Dear Abu,
1.Going through excel view,like other edit, i need something like $grid["reloadedit"] = true;, which reloads after cells being editted and saved.
2. the edit box(not inline) goes off the screen due to too many fields to edits. even i tried this:
$grid["add_options"] = array('width'=>'420',
"closeAfterEdit"=>true, // close dialog after add/edit
"top"=>"200", // absolute top position of dialog
"left"=>"200" // absolute left position of dialog
);
3. i could not centered the text of group header. i used
$grid["form"]["position"] = "center";
Regards
1) Add following to reload grid after saving cell:
$grid["afterSaveCell"] = "function() { jQuery(this).trigger('reloadGrid'); }";
$g->set_options($grid);
2) You may split the fields in 2/3 columns. Refer demos/editing/dialog-layout.php
e.g. $col["formoptions"] = array("rowpos"=>"2", "colpos"=>"1");
3) Add this css:
<style>.ui-th-column-header {text-align:center;}</style>