[Solved] Losing columns when using Scroll /w FrozenColumnsCount = 1

[Alex]

Have a basic setup on this one, nothing complex.

I have a Radgrid that has 30 columns that needs to be scrolled so I set the AllowScroll to True.

I also need the first column to be frozen so I set the FrozenColumnsCount to 1.

When I do this only 26 columns are shown out of my 30 columns, the last 4 columns to the left are not shown (but they are there because I can see part of the 27 column it's just not letting me scroll more).

If I set FrozenColumnsCount to 0 all my 30 columns are shown.

All my columns are auto-generated.

[Daniel]

Hello Alex,

I tried to reproduce this issue but I don't experience the behavior you mentioned. Please take a look at the attached example with 30 columns and let us know how the demo behaves on your end.

Kind regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Alex]

Thanks for the reply and your example does work, but it's not exactly like the one I have.

I've created an example project and opened a ticket.

[Daniel]

Hello Alex,

I would like to thank you for this simple and clear example you provided concerning this issue. Unfortunately I have to confirm that this is an issue in the current version of our RadControls for ASP.NET AJAX.

In sign of gratitude for your cooperation and isolation of this issue I updated your telerik points.

Excuse us for any inconvenience caused.

Kind Regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Mike]

I am having the same problem in my RadGrid.  There are 22 columns and the last four are not showing up when I add "FrozenColumnsCount=1"

[Daniel]

Hello Mike,

Please submit a support ticket with a simple working example illustrating the mentioned issue. Thus our developers will be able to test your project locally.

Greetings,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Andrson]

some problem ~
I already look example(AJAXEnabledWebApplication10.zip)
+ AutoGenerateColumns="false" 

to show "No records to display"

<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" GridLines="None" Skin="Office2007"  AllowPaging="True" Width="550px">
    <MasterTableView DataSourceID="SqlDataSource1" TableLayout="fixed" AutoGenerateColumns="false" >
        <RowIndicatorColumn >
            <HeaderStyle Width="20px"  />
        </RowIndicatorColumn>
        <ExpandCollapseColumn>
            <HeaderStyle Width="20px" />
        </ExpandCollapseColumn>
    </MasterTableView>
    <FilterMenu EnableTheming="True" Skin="Office2007">
        <CollapseAnimation Duration="200" Type="OutQuint" />
    </FilterMenu>
    <HeaderStyle Width="60px" />
    <ClientSettings>
        <Scrolling  AllowScroll="True" UseStaticHeaders="True"  FrozenColumnsCount="1" ScrollHeight="" />
    </ClientSettings>
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:F3ConnectionString4 %>"
    SelectCommand="SELECT * FROM [ComponentInformation]">
</asp:SqlDataSource>

[Daniel]

Hello Andrson,

Excuse me, but I'm not sure if I entirely understand your question. Could you please elaborate a bit?

Regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Alex]

Mike,

I opened a ticket on this issue in August (and even got points for it), I downloaded the new version Q3 and the problem is still there. Maybe in Q4 it will be resolved. 

[Andrson]

	</telerik:RadGrid><br />
	<asp:Label ID="Label1" runat="server" Font-Size="10pt" Text="[相關文件列表:]"></asp:Label>
	<asp:Panel ID="Panel1" runat="server" Height="230px" ScrollBars="Auto" Width="660px">
	<telerik:RadGrid ID="RadGrid4" runat="server" AllowPaging="True" DataSourceID="SqlDataSource2"
	GridLines="None" Height="225px" PageSize="5" Skin="Office2007" Width="655px">
	<MasterTableView AutoGenerateColumns="False" CellPadding="0" DataSourceID="SqlDataSource2"
	GridLines="None">
	<RowIndicatorColumn>
	<HeaderStyle Width="20px" />
	</RowIndicatorColumn>
	<ExpandCollapseColumn>
	<HeaderStyle Width="20px" />
	</ExpandCollapseColumn>
	<Columns>
	<telerik:GridTemplateColumn HeaderText="檢視" UniqueName="TemplateColumn1">
	<ItemTemplate>
	<asp:Button ID="Button1" runat="server" Text="檢視" />
	</ItemTemplate>
	</telerik:GridTemplateColumn>
	<telerik:GridTemplateColumn HeaderText="下載" UniqueName="TemplateColumn2">
	<ItemTemplate>
	<asp:Button ID="Button2" runat="server" Text="下載" />
	</ItemTemplate>
	</telerik:GridTemplateColumn>
	<telerik:GridTemplateColumn HeaderText="詳細資訊" UniqueName="TemplateColumn">
	<ItemTemplate>
	<asp:Button ID="Button3" runat="server" Text="查看" />
	</ItemTemplate>
	</telerik:GridTemplateColumn>
	<telerik:GridBoundColumn DataField="狀態" EmptyDataText="&amp;nbsp;" HeaderText="狀態"
	SortExpression="狀態" UniqueName="狀態">
	</telerik:GridBoundColumn>
	<telerik:GridBoundColumn DataField="範本" EmptyDataText="&amp;nbsp;" HeaderText="範本"
	SortExpression="範本" UniqueName="範本">
	</telerik:GridBoundColumn>
	<telerik:GridBoundColumn DataField="文件編號" EmptyDataText="&amp;nbsp;" HeaderText="文件編號"
	SortExpression="文件編號" UniqueName="文件編號">
	</telerik:GridBoundColumn>
	<telerik:GridBoundColumn DataField="文件名稱" EmptyDataText="&amp;nbsp;" HeaderText="文件名稱"
	SortExpression="文件名稱" UniqueName="文件名稱">
	</telerik:GridBoundColumn>
	<telerik:GridBoundColumn DataField="版本" EmptyDataText="&amp;nbsp;" HeaderText="版本"
	SortExpression="版本" UniqueName="版本">
	</telerik:GridBoundColumn>
	<telerik:GridBoundColumn DataField="英文名稱" EmptyDataText="&amp;nbsp;" HeaderText="英文名稱"
	SortExpression="英文名稱" UniqueName="英文名稱">
	</telerik:GridBoundColumn>
	<telerik:GridBoundColumn DataField="所在路徑" EmptyDataText="&amp;nbsp;" HeaderText="所在路徑"
	SortExpression="所在路徑" UniqueName="所在路徑">
	</telerik:GridBoundColumn>
	<telerik:GridBoundColumn DataField="檔案名稱" EmptyDataText="&amp;nbsp;" HeaderText="檔案名稱"
	SortExpression="檔案名稱" UniqueName="檔案名稱">
	</telerik:GridBoundColumn>
	<telerik:GridBoundColumn DataField="文件類別" EmptyDataText="&amp;nbsp;" HeaderText="文件類別"
	SortExpression="文件類別" UniqueName="文件類別">
	</telerik:GridBoundColumn>
	</Columns>
	<PagerStyle Mode="NumericPages" />
	</MasterTableView>
	<HeaderStyle Width="60px" />
	<ClientSettings>
	<Scrolling AllowScroll="True" FrozenColumnsCount="3" UseStaticHeaders="True" />
	</ClientSettings>
	<FilterMenu EnableTheming="True" Skin="Office2007">
	<CollapseAnimation Duration="200" Type="OutQuint" />
	</FilterMenu>
	</telerik:RadGrid>  Hello,I have a problem about RadGrid. I used "FrozenColumns" function, but my Grid it's last columns lose. Sometimes last column words has been cut. Where should I edit my code? or what can i do now? pls kindly advise. Tks!!

[Daniel]

Hello Andrson,

I created a sample project (with minor modifications) based on the code you provided. Test it locally and let us know whether it's working as expected.

Kind regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Johann Herunter]

Hello,

I have the same problem as mentioned in the first post. My version of the RAD Grid is the trial version from Q3 2009.

From a variety of columns, the last two are not displayed.

I downloaded the example zip file ("AJAXEnabledWebApplication10.zip"), and it worked fine at startup! By searching for differences with my sample, I've come up with the conclusion that the web application stops working fine when there are only 28 or 29 columns. By 26 columns, the scrolling works fine again.

By further digging into, it seems that the example works fine with a FrozenColumnsCount of 1, but with a count of 5 (as we need it), the behaviour as noted above comes up.

Our grid needs at last up to 100 columns, thus I added 77 for testing purposes. Scrolling seems ok with this amount of columns, but now the grid (with a width of 1300px) always displays an empty place as columns after the last column of 478 pixel. (The header is displayed up to the right end)

This behaviour can also be reproduced, when the example is used with 29 columns and a FrozenColumnsCount of 1.


Could you please verify this issue with my explanations and the example you provided?

Kind regards,
Johann

[Daniel]

Hello Johann,

I confirm that such behavior is expected (although it's unwanted) because this feature comes from the Windows world and it is very hard to be implemented with JavaScript.

Unfortunately the Frozen Columns heavily relies on the browser's behavior - factors like alignment, calculations and performance mostly depend on the client's browser. Notable part of the issues related to this functionality are caused by the way the browsers calculate the columns' padding.

We are constantly trying to improve the user experience and to reduce the efforts needed to setup RadGrid in such scenarios. At this point, some further enhancements are planned since as you properly noticed, the columns' width should be manually tuned to avoid problems with missing content.

Best results could be achieved with a smaller number of columns (regular and frozen)

Thank you for your understanding

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Johann Herunter]

Hello Daniel,

thanks for your quick reply.

Unfortunately, our grid needs up to 100 columns AND at minimum 2 static columns on the left.

Do you have, or know, a recommended approach for such a scenario, as the built-in mechanism seems to have problems?

We can ignore neither demands, but maybe a workouround is possible. Some forum entries point into the direction to avoid huge amount of columns or something else, but this cannot be done for our project.

It would be very helpful, if you could provide some ideas to overcome this problem!


Regards,
Johann

[Daniel]

Hello Johann,

As I mentioned below, the columns' width should be manually adjusted to avoid such problems. I'm afraid that it is very hard to avoid the missing contents when you have a lot of columns. This functionality is quite complex and browser-dependent so I can't provide more specific suggestion at this time.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.