Questions on UI for ASP.NET AJAX Forum

4 answers

134 views

Hi,
I try to export radgrid to excel with RadGrid1.MasterTableView.ExportToExcel(). I am using MS office 2010. Before excel is opened, it always popups a warning that says the file format is not correct. It seems that ExportToExcel() creates a .xls file, while excel 2010 default is .xlsx file. I wonder if there is way for ExportToExcel() to generate a .xls file. Thanks.

Grid

answered on 21 Dec 2011

3 answers

126 views

Format Excel from Export

I am exporting to Excel from radGrid and three different things I can not figure out. And I was hoping someone had some insight.

1. I want to style the headers of the columns, how do you do this?
2. I want to put an image in the top left of the Excel sheet, is this possible?
3. I want to show grid lines in the Excel instead of a white background. But only in Excel not the grid.

I'm able to get the normal data styled using this:

protected void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)

{

GridDataItem item1 = e.Cell.Parent as GridDataItem;

if (e.FormattedColumn.UniqueName == "UniqueName")

{

TableCell cell = item["UniqueName"];

cell.Style["background-color"] = "Red";

}

Thanks for any help, I'm pretty stuck.

Grid

answered on 21 Dec 2011

9 answers

241 views

two depended combobox in template form

I am trying to reproduce the functionality as posted in the article below for an older version of the controls. I am using VB for this project and not C#, but was able to convert the code since I know both languages. However I suspect that the problem is with the actual responsescript. I have spent two days working on this solution, your assistance is appreciated. I am using RadControls for ASPNET AJAX Q3 2008

http://www.telerik.com/community/forums/aspnet/grid/two-depended-combobox-in-template-form.aspx

I am unable to use responsescripts for the grid, and have used the AjaxPanel to add the responsescripts as suggested in some articles I have read. The responsescripts get added to the panel (I have stepped through the code and know the lines are executing), but the javascript call to the firstcombo, secondcombo throws and error, firstcombo is undefined, when the page loads. I made modifications to the responsescript replacing window with $find as below:

Dim responseScript As String = String.Format("var secondCombo = $find['{0}'];var firstCombo = $find['{1}'];SecondComboInitialize();", e.Item.FindControl("cboActiveNormDoc").ClientID, e.Item.FindControl("cboNormDocStatus").ClientID)

Grid

answered on 21 Dec 2011

1 answer

403 views

Conditional display: ItemDataBound vs PreRender

I'm new to the grid so please bear with me. I've got a GridTemplateColumn which I'm using to display an image.

<telerik:GridTemplateColumn HeaderText="Address" UniqueName="Address" ItemStyle-Width="20">

<ItemTemplate>

<a href='<%# Eval("Address") %>' title='<%# Eval("Address") %>'><img src="images/go.gif" border="0" width="33"></a>

</ItemTemplate>

</telerik:GridTemplateColumn >

This shouldn't be visible if the data is empty, so in the ItemDataBound method, I did

Dim item As GridDataItem = CType(e.Item, GridDataItem)

If condition Then

item("Address").Controls(0).Visible = False

End If

And this worked just fine under FireFox. But with IE8, it doesn't. Instead, I had to move this to the PreRender method where I had to iterate through the items with the same logic to get it to work. And this approach also works fine under FireFox too, so that's good.

But since I'm new to the grid, I'm wondering, is there a "correct" or recommended place to do this kind of logic? I initially went with the ItemDataBound because that's where similar approaches that I'd found (e.g. here ) had done it. But that obviously didn't work for me with IE8.

Grid

answered on 21 Dec 2011

2 answers

300 views

GridCheckBoxColumn is too grayed-out in regular mode (in which it is disabled)

Hi,

I created a RadGrid control on the page and it has one GridCheckBoxColumn bind to a boolean field value in the database. I found that it looks too grayed-out in regular mode (in which the checkbox is disabled). Is there anyway to make it look more readable like in Edit Mode (in which the checkbbox is enabled).

Thanks

Lamk.

Grid

answered on 21 Dec 2011

1 answer

96 views

Change expand collapse image

How can I change the expand collapse image from the default plus/minus?

TreeList

answered on 21 Dec 2011

4 answers

160 views

Remove Hourly option in RadSchedulerRecurrenceEditor

Hi,

I don't want to provide Hourly option in RadSchedulerRecurrenceEditor for user. So please let me know how can i remove that. For easy understand look into my attached file i mark with red round.

Thanks,
Maddela.

Scheduler

answered on 21 Dec 2011

0 answers

111 views

Problem with Exporting Radgrid to EXCEL

I have a problem when exporting RadGrid to excel.i'm using the following code

RadGrid1.ExportSettings.IgnorePaging = true; (or false)

RadGrid1.ExportSettings.OpenInNewWindow = false;

RadGrid1.ExportSettings.ExportOnlyData = true;

RadGrid1.MasterTableView.ExportToExcel();

strange thing is i have three computers my development machine, testing server and production server in all three machines
i'm using the same code but it's works fine only in my testing server.In other two machines when i click on export button it hangs
out permanently and nothing happens and the most serious issue is it uses the machine CPU almost up to 40% .
when this happen i have faced many more difficulties with my production server.since the CPU usage is high applications crashes.
CPU usage doesn't get normal until i terminate the process manually.thought to ask this from u before i remove the rad controls
from the application.please help me with this
in development machine i'm using telerik trial version downloaded several months ago.
in the testing and production my employer uses licence versions and i'm not pretty much sure about which versions are using but i'm
sure that they are also using a latest version

another thing when i try google crome browser on my development machine ,nothing happens just a post back on button click,not hanging out, not using CPU 40%

development machine
IE 8

test server
IE 8

production
IE 9

General Discussions

asked on 21 Dec 2011

3 answers

121 views

radmenu by user rights

hi,

I have a radmenu with sqldatasource.When the user log in the site,the menu will load according to the user rights.I check the user rights from the database.The code below doesn't work for me.How can I achieve this?

private void CreateMenuByUser()

{

RadMenu1.Visible = true;

DataTable table = GetDataTable("SELECT * FROM UserRights INNER JOIN Users ON UserRights.UserID = Users.UserID WHERE Users.UserID = '" + Session["UserID"] + "'");

//RadMenuItemCollection menuItems = RadMenu1.Items;

RadMenuItem disabledItems = new RadMenuItem();

foreach (DataRow item in table.Rows)

{

if (bool.Parse(item["rRead"].ToString()) == false)

{

foreach (RadMenuItem menuItem in RadMenu1.Items)-->>>this line cause the error Index was out of the range error

{

if (menuItem.Value == item["MenuID"].ToString()) disabledItems = menuItem;

if (menuItem.Items.Count > 0) GetAllChildItems(menuItem, item["MenuID"].ToString());

}

RadMenu1.Items.Remove(disabledItems);

}

private void GetAllChildItems(RadMenuItem itemsList, string MenuId)

{

RadMenuItemCollection menuItems = itemsList.Items;

RadMenuItem disabledItems = new RadMenuItem();

foreach (RadMenuItem menuItem in itemsList.Items)

{

if (menuItem.Value == MenuId) disabledItems = menuItem;

}

menuItems.Remove(disabledItems);

}

Menu

answered on 20 Dec 2011

1 answer

109 views

Export Invisible Columns

I have several columns in my radGrid that are set to visible = false. Is there a way to export those columns also? Right now they don't show in the export. I'm trying to export to Excel.

Thanks!

Grid

answered on 20 Dec 2011