Dec 14, 2017, 3:16 AM
[FIXED] [#1317] [4.5.0] Spreadsheet row number not working correctly when groupSummary enabled
Hi, Found row number not changing when grid has groupSummary enabled. Can reproduce with your demo code below.
To reproduce: click next page, the row number does not increase. It works fine if GroupSummary feature is removed.
Please help!
Thanks
-Szhang
To reproduce: click next page, the row number does not increase. It works fine if GroupSummary feature is removed.
Please help!
Thanks
-Szhang
<%@ Page Language="C#" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
this.Store1.DataSource = this.GetData();
}
}
public List<object> GetData()
{
var data = new List<object>();
var thisYear = DateTime.Today.Year;
var random = new Random();
for (int year = 1900; year <= thisYear; ++year)
{
data.Add(new object[]
{
year,
this.GetRandomNumber(-10, 100, random),
this.GetRandomNumber(-10, 100, random),
this.GetRandomNumber(-10, 200, random),
this.GetRandomNumber(-10, 200, random),
this.GetRandomNumber(-10, 200, random),
this.GetRandomNumber(-10, 300, random),
this.GetRandomNumber(-10, 300, random),
this.GetRandomNumber(-10, 300, random),
this.GetRandomNumber(-10, 600, random),
this.GetRandomNumber(-10, 500, random),
this.GetRandomNumber(-10, 200, random),
this.GetRandomNumber(-10, 100, random)
});
}
return data;
}
public int GetRandomNumber(int min, int max, Random r)
{
return (int)Math.Floor(r.NextDouble() * (max - min)) + min;
}
protected void ReloadData(object sender, DirectEventArgs e)
{
this.Store1.DataSource = this.GetData();
this.Store1.DataBind();
}
</script>
<!DOCTYPE html>
<html>
<head runat="server">
<title>Spreadsheet Selection Model - Ext.NET Examples</title>
<link href="/resources/css/examples.css" rel="stylesheet" />
</head>
<body>
<form runat="server">
<ext:ResourceManager runat="server" />
<ext:GridPanel
runat="server"
ColumnLines="true"
Height="400"
Width="775"
Title="Spreadsheet"
Frame="true">
<Store>
<ext:Store ID="Store1" runat="server">
<Model>
<ext:Model runat="server" IDProperty="year" PageSize="3">
<Fields>
<ext:ModelField Name="year" />
<ext:ModelField Name="jan" />
<ext:ModelField Name="feb" />
<ext:ModelField Name="mar" />
<ext:ModelField Name="apr" />
<ext:ModelField Name="may" />
<ext:ModelField Name="jun" />
<ext:ModelField Name="jul" />
<ext:ModelField Name="aug" />
<ext:ModelField Name="sep" />
<ext:ModelField Name="oct" />
<ext:ModelField Name="nov" />
<ext:ModelField Name="dec" />
</Fields>
</ext:Model>
</Model>
<Reader>
<ext:ArrayReader />
</Reader>
</ext:Store>
</Store>
<SelectionModel>
<ext:SpreadsheetSelectionModel
ID="SpreadsheetSelectionModel1"
runat="server"
RowSelect="true"
/>
</SelectionModel>
<ColumnModel>
<Columns>
<ext:Column runat="server" Text="Year" DataIndex="year" Flex="1" MinWidth="70" />
<ext:Column runat="server" Text="Jan" DataIndex="jan" Width="50" />
<ext:Column runat="server" Text="Feb" DataIndex="feb" Width="50" />
<ext:Column runat="server" Text="Mar" DataIndex="mar" Width="50" />
<ext:Column runat="server" Text="Apr" DataIndex="apr" Width="50" />
<ext:Column runat="server" Text="May" DataIndex="may" Width="50" />
<ext:Column runat="server" Text="Jun" DataIndex="jun" Width="50" />
<ext:Column runat="server" Text="Jul" DataIndex="jul" Width="50" />
<ext:Column runat="server" Text="Aug" DataIndex="aug" Width="50" />
<ext:Column runat="server" Text="Sep" DataIndex="sep" Width="50" />
<ext:Column runat="server" Text="Oct" DataIndex="oct" Width="50" />
<ext:Column runat="server" Text="Nov" DataIndex="nov" Width="50" />
<ext:Column runat="server" Text="Dec" DataIndex="dec" Width="50" />
</Columns>
</ColumnModel>
<ViewConfig TrackOver="false" />
<Tools>
<ext:Tool Type="Refresh" ToolTip="Reload Data" OnDirectClick="ReloadData" />
</Tools>
<BottomBar>
<ext:PagingToolbar runat="server"/>
</BottomBar>
<Features>
<ext:GroupingSummary ShowSummaryRow="true"
runat="server"
GroupHeaderTplString='{columnName}: {name} ({rows.length} Item{[values.rows.length > 1 ? "s" : ""]})' />
</Features>
</ext:GridPanel>
</form>
</body>
</html>
Last edited by fabricio.murta; Dec 20, 2017 at 12:44 PM.