Get KoolPHP UI with 30% OFF!

How to edit multiple rows - spreadsheet like data entry

Scott
How can I go about displaying a grid and then having a user edit a cell in multiple rows without needing to click edit for each row.
Basically I am setting up an order entry screen, where a user needs to enter shelf levels for items.
I would like them to click in the cell, enter and then click or tab to the next cell in the next row.
Thoughts on the attack using KoolGrid?
Posted Oct 24, 2015 Kool
David
Hi Scott,
Currently we have not supported edit mode for individual cells yet so if you wanted to only edit cells of a certain column you would have to set the other columns' ReadOnly be true. As for making multiple rows in edit mode I think you could catch the grid's onload event with the following listener:
<?php
$grid = new KoolGrid("mygrid");
...
$grid->ClientSettings->ClientEvents["OnLoad"] = "Handle_OnLoad";
...
?>
...
<script type="text/javascript">
function Handle_OnLoad()
{
  var rows = mygrid.getMasterTable().getRows();
  for (var i=0; i<rows.length; i+=1) 
    rows[i].startEdit();
  mygrid.commit();
}
</script>

Please let us know if this answers your question.
Rgds,
Posted Oct 26, 2015 , edited Oct 26, 2015 Kool
Abraham
I have nerver donde that....
"Im guessing here"
Have you tried to use the OncelClick event handler and then call the row.startEdit() method???
<?php
	$grid->ClientSettings->ClientEvents["OnCellClick"] = "HandleOnCellClick";//event listener
?>
<script type="text/javacript">
	function HandleOnCellClick(sender,args)
	{
		var _cell = args["Cell"];
		var _row = _cell.getRow();
		_row.startEdit();
		grid.commit();
	}
</script>

hope this helps some way.
Posted Nov 13, 2015 , edited Nov 13, 2015 Kool