Sep 17, 2013, 10:57 PM
[CLOSED] Cell Editor navigation in a Grid
Using the ideas presented in this post (http://forums.ext.net/showthread.php?21924) I created a grid with locking columns and a highlighted selected row that would allow the user to move between the editor between cells using up, down, enter, tab, shift+enter, and shift+tab. basically making my grid act like a Excel spreadsheet.
As soon as I did that the newly focused cell stopped going into "edit" mode until I hit the enter key a second time.
To make matters worse, adding the following property (which was the reason I was updating to the latest build) causes my navigation code to fail completely -- unless the user changes the value of the cell/field.
Since the IgnoreNoChange property was the main reason to update to the latest build, I am going to pull it and roll back to the 2.2 version for now but with 2.3 around the corner I really need to know how to deal with the upcoming changes.
Thanks in advance for your help and insight.
Regards,
<%@ Page Language="C#" %>
<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e) {
if (!X.IsAjaxRequest) {
this.GridPanel1.Store.Primary.DataSource = new object[]
{
new object[] { "3m Co", 71.72, 0.02, 0.03, "9/1 12:00am" },
new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, "9/1 12:00am" },
new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, "9/1 12:00am" },
new object[] { "American Express Company", 52.55, 0.01, 0.02, "9/1 12:00am" },
new object[] { "American International Group, Inc.", 64.13, 0.31, 0.49, "9/1 12:00am" },
new object[] { "AT&T Inc.", 31.61, -0.48, -1.54, "9/1 12:00am" },
new object[] { "Boeing Co.", 75.43, 0.53, 0.71, "9/1 12:00am" },
new object[] { "Caterpillar Inc.", 67.27, 0.92, 1.39, "9/1 12:00am" },
new object[] { "Citigroup, Inc.", 49.37, 0.02, 0.04, "9/1 12:00am" },
new object[] { "E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, "9/1 12:00am" },
new object[] { "Exxon Mobil Corp", 68.1, -0.43, -0.64, "9/1 12:00am" },
new object[] { "General Electric Company", 34.14, -0.08, -0.23, "9/1 12:00am" },
new object[] { "General Motors Corporation", 30.27, 1.09, 3.74, "9/1 12:00am" },
new object[] { "Hewlett-Packard Co.", 36.53, -0.03, -0.08, "9/1 12:00am" },
new object[] { "Honeywell Intl Inc", 38.77, 0.05, 0.13, "9/1 12:00am" },
new object[] { "Intel Corporation", 19.88, 0.31, 1.58, "9/1 12:00am" },
new object[] { "International Business Machines", 81.41, 0.44, 0.54, "9/1 12:00am" },
new object[] { "Johnson & Johnson", 64.72, 0.06, 0.09, "9/1 12:00am" },
new object[] { "JP Morgan & Chase & Co", 45.73, 0.07, 0.15, "9/1 12:00am" },
new object[] { "McDonald\"s Corporation", 36.76, 0.86, 2.40, "9/1 12:00am" },
new object[] { "Merck & Co., Inc.", 40.96, 0.41, 1.01, "9/1 12:00am" },
new object[] { "Microsoft Corporation", 25.84, 0.14, 0.54, "9/1 12:00am" },
new object[] { "Pfizer Inc", 27.96, 0.4, 1.45, "9/1 12:00am" },
new object[] { "The Coca-Cola Company", 45.07, 0.26, 0.58, "9/1 12:00am" },
new object[] { "The Home Depot, Inc.", 34.64, 0.35, 1.02, "9/1 12:00am" },
new object[] { "The Procter & Gamble Company", 61.91, 0.01, 0.02, "9/1 12:00am" },
new object[] { "United Technologies Corporation", 63.26, 0.55, 0.88, "9/1 12:00am" },
new object[] { "Verizon Communications", 35.57, 0.39, 1.11, "9/1 12:00am" },
new object[] { "Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, "9/1 12:00am" }
};
this.GridPanel1.Store.Primary.DataBind();
}
}
</script>
<!DOCTYPE html>
<html>
<head id="Head1" runat="server">
<title>Locking Column Cell Editing - Ext.NET Examples</title>
<link href="/resources/css/examples.css" rel="stylesheet" />
<script>
var template = '<span style="color:{0};">{1}</span>';
var change = function (value) {
return Ext.String.format(template, (value > 0) ? "green" : "red", value);
};
var pctChange = function (value) {
return Ext.String.format(template, (value > 0) ? "green" : "red", value + "%");
};
var TriggerField_SpecialKey = function (sender, e, eOpts) {
var grid = App.GridPanel1;
if (e.getKey() === e.TAB) {
grid.tabWasPressed = true;
e.keyCode = e.ENTER;
}
if (e.shiftKey) {
grid.shiftWasPressed = true;
};
if (e.getKey() === e.UP) {
grid.shiftWasPressed = true;
grid.enterWasPressed = true;
e.keyCode = e.ENTER;
}
if (e.getKey() === e.DOWN) {
grid.enterWasPressed = true;
e.keyCode = e.ENTER;
}
if (e.getKey() === e.ENTER) {
grid.enterWasPressed = true;
}
}
var editCourseGradebook_Edit = function (sender, context, eOpts) {
var grid = App.GridPanel1;
if (grid.enterWasPressed) {
var index = grid.shiftWasPressed ? -1 : 1;
sender.startEdit(context.rowIdx + index, context.column);
}
if (grid.tabWasPressed) {
var index = grid.shiftWasPressed ? -1 : 1;
sender.startEdit(context.rowIdx, context.colIdx + index);
}
grid.tabWasPressed = false;
grid.enterWasPressed = false;
grid.shiftWasPressed = false;
}
</script>
</head>
<body>
<ext:ResourceManager ID="ResourceManager1" runat="server" />
<ext:GridPanel
ID="GridPanel1"
runat="server"
ColumnLines="true"
Title="Locking Grid Column"
Width="600"
Height="350">
<Store>
<ext:Store ID="Store1" runat="server">
<Model>
<ext:Model ID="Model1" runat="server">
<Fields>
<ext:ModelField Name="company" />
<ext:ModelField Name="price" Type="Float" />
<ext:ModelField Name="change" Type="Float" />
<ext:ModelField Name="pctChange" Type="Float" />
<ext:ModelField Name="lastChange" Type="Date" DateFormat="M/d hh:mmtt" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
<ColumnModel>
<Columns>
<ext:Column ID="Column1" runat="server" Text="Company<br>Name" DataIndex="company" Width="200" Locked="true" Sortable="false">
<Editor>
<ext:TextField ID="TextField1" runat="server" />
</Editor>
</ext:Column>
<ext:Column ID="Column2" runat="server" Text="Price" DataIndex="price" Width="97" Lockable="false">
<Renderer Format="UsMoney" />
<EditorOptions IgnoreNoChange="true" />
<Editor>
<ext:TriggerField ID="NumberField1" runat="server" EnableKeyEvents="true" SelectOnFocus="true" >
<Listeners>
<SpecialKey Fn="TriggerField_SpecialKey"></SpecialKey>
</Listeners>
</ext:TriggerField>
</Editor>
</ext:Column>
<ext:Column ID="Column3" runat="server" Text="Change" DataIndex="change" Width="97">
<Renderer Fn="change" />
<EditorOptions IgnoreNoChange="true" />
<Editor>
<ext:TriggerField ID="NumberField2" runat="server" EnableKeyEvents="true" SelectOnFocus="true" >
<Listeners>
<SpecialKey Fn="TriggerField_SpecialKey"></SpecialKey>
</Listeners>
</ext:TriggerField>
</Editor>
</ext:Column>
<ext:Column ID="Column4" runat="server" Text="% Change" DataIndex="pctChange" Width="97">
<Renderer Fn="pctChange" />
<EditorOptions IgnoreNoChange="true" />
<Editor >
<ext:TriggerField ID="NumberField3" runat="server" EnableKeyEvents="true" SelectOnFocus="true" >
<Listeners>
<SpecialKey Fn="TriggerField_SpecialKey"></SpecialKey>
</Listeners>
</ext:TriggerField>
</Editor>
</ext:Column>
</Columns>
</ColumnModel>
<SelectionModel>
<ext:RowSelectionModel ID="CellSelectionModel1" runat="server" />
</SelectionModel>
<Plugins>
<ext:CellEditing ID="CellEditing1" runat="server" ClicksToEdit="1" >
<Listeners>
<Edit Fn="editCourseGradebook_Edit" />
</Listeners>
</ext:CellEditing>
</Plugins>
</ext:GridPanel>
</body>
</html>
My solution worked great (version 2.2 release), until I updated to the latest build from the SVN.As soon as I did that the newly focused cell stopped going into "edit" mode until I hit the enter key a second time.
To make matters worse, adding the following property (which was the reason I was updating to the latest build) causes my navigation code to fail completely -- unless the user changes the value of the cell/field.
<EditorOptions IgnoreNoChange="true" />
What do I need to do to make it work? I really need the ability to move the editor within the grid and keep the current row highlighted (my updates are being done via a DirectMethod called from the GridPanel's Edit listener -- not shown). Since the IgnoreNoChange property was the main reason to update to the latest build, I am going to pull it and roll back to the 2.2 version for now but with 2.3 around the corner I really need to know how to deal with the upcoming changes.
Thanks in advance for your help and insight.
Regards,
Last edited by Daniil; Sep 25, 2013 at 3:32 AM.
Reason: [CLOSED]