Telerik Forums
UI for ASP.NET AJAX Forum
4 answers
285 views
I'm having a variety of issues with exporting data from a radGrid to Excel:
I'm using the default excel export format.

1. The spreadsheet generated does not show any excel default gridlines (i.e. the ones you see when you create a new, blank spreadsheet. the light blue ones). is there a way to retain these?

2. I have a column in my Grid that shows Address information (string value) for display purposes to the web page screen, I put a <br /> in between the Address street line and the city, state line so that there's always a line break before it shows the city and state information. This html line break is causing excel to put the contents into a new cell, instead of keep the street address and city and state information in the same cell and just wrap it. How can I fix it? (Maybe i could intercept the contents/value of this column and replace the <br /> with a blank, if so, what code can I use to do such a thing?

3. I was also interested in checking out the Excel Format ExcelML, but when I turn it on, I get a blank spreadsheet. Where are there good, quality, demos on how to use the ExcelML option for formatting and exporting of Grid data?

my current export code:

 rgFailedRecords.ExportSettings.ExportOnlyData = True 
        rgFailedRecords.ExportSettings.IgnorePaging = True 
        rgFailedRecords.ExportSettings.OpenInNewWindow = True 
 
        rgFailedRecords.MasterTableView.ExportToExcel() 

I'm also setting some formatting stuff within rgFailedRecords_ExcelExportCellFormatting; just some cell style width's, style, etc.
Paul J
Top achievements
Rank 1
 answered on 09 Feb 2010
1 answer
167 views
I am demoing this product for possible purchase and for the life of me I cannot figure out how to get the resources to display on the Time Line view.  I am using VS2008 and SQLServer 2008 and Entity Data Model to bind data.  I have no problems inserting, updating or deleting data.  My resources would be a list of users from the database and they display fine when adding or inserting records but they do not display on any of the available scedule view.  This seems to be such a simple and trivial thing to do yet I cannot find any documentation or examples of how to do it.  Please see the attached screen shots for additional details.  Can someone please help me??
Peter
Telerik team
 answered on 09 Feb 2010
6 answers
237 views
Our database has large amount of data. So I want to filter the appointments based on the scheduler date. How can I pass the scheduler date to the select procedure so that only the relevant appointments are returned from the backend database?

I am sure many of you have faced similar situation. Any help is appreciated. Thanks.
Peter
Telerik team
 answered on 09 Feb 2010
1 answer
113 views
Hi,

I have a problem with the spin buttons for my RadNumericTextBox. They are displayed slightly on top of the right corner of the textbox so they are not outside of the box but not on the inside either and this looks really ugly. Can someone help me please?

<telerik:RadNumericTextBox ID="numericTextbox" runat="server" Width="200" AutoPostBack="true" ShowSpinButtons="true"  ButtonsPosition="Right" IncrementSettings-Step="1" MinValue="1" Value="1"></telerik:RadNumericTextBox></div> 

Kind Regards
Cecilia
Dimo
Telerik team
 answered on 09 Feb 2010
1 answer
85 views
Hi there,

Is it possible to have the scheduler in week view, grouped by a resource like in your Resource Grouping demo, but then have a longer period of time showing than just a week? So in your demo with both Group by options checked, displaying Vertically, but then the date range would scroll downwards longer than just a week?

Thanks
Gavin
Peter
Telerik team
 answered on 09 Feb 2010
3 answers
267 views
hi,

I'm using a radeditor ctrl in my ascx page where the find and replace (like binaculars), when clicked on it appears.
The problem I'm facing is , the find button doesnot have a button appearance instead just the text "find" appears. but we're able to click on it and it does the functionality.But why does 'find' is missing the button appearance(same thing with replace).

Even I get 'Match case'. But this one is missing the checkbox? what should I do to configure this. Plzs help me with code.



Rumen
Telerik team
 answered on 09 Feb 2010
1 answer
92 views
Hi

When im populating my panelbar with simple textboxes, checkboxes the collapsing is very smooth. However, when I populate with a radCalender suddenly my panel bar stutters when opening the panel. Is there someway to help this?
Yana
Telerik team
 answered on 09 Feb 2010
4 answers
133 views

When a non-modal RadWindow is displayed, I'd like it to close if the user clicks off the RadWindow onto the parent form beneath. How can that be done?
Jeremy Yoder
Top achievements
Rank 1
 answered on 09 Feb 2010
1 answer
94 views
So, I'm having a little difficulty populating appointments to my RadScheduler.  I've exported the recurring events to iCal and imported them into Outlook (which works fine), but the scheduler doesn't look like it renders past the initially selected window.  For instance, if I set it on month view and page forward (where events should be recurring into), I get nothing.  Same thing goes for navigating backward.  If I set it on week view, I get the same behavior only with the next and previous weeks.

I'm loading all my appointments on Page_Load using the recurring ranges.  Is there a way of doing this and if so, what event am I looking for to manipulate the appointment collection?
Peter
Telerik team
 answered on 09 Feb 2010
2 answers
187 views
Hi,

I have a a radgrid connected to an Oracle table.

The grid contains several columns, one of which is a date/time field.

All the columns have filters on them at the top, with the date/time field having a pop up calendar to select the date (built into telerik).

Now, when I select a date from the calendar, no records are selected.  This is because it looks at BOTH the date AND time portion of the data for exact matches (and as I have specified ONLY a date, the time defaults to 00:00:00), and finds no matches, even though I know there should be matches.

What is the point of this? I'm NEVER going to look for 25/12/09 23:59:59 am I? But I DO want to search for 25/12/09 on it's own, regardless of the time.

Yes, I know I can strip the date out in my code, and display the time in another column, but I should't have to - that's extra work, and I buy telerik to reduce my work, not create more!  Other grids allow you to search for just the date, so why can't Telerik?

I've asked before for Telerik to address this, in support tickets, but nothings been done, so PLEASE can we get date filtering working 'correctly', it really does cause me lots of issues with users unable to filter by date.

Thanks.
John Daldry
Top achievements
Rank 1
 answered on 09 Feb 2010
Narrow your results
Selected tags
Tags
+? more
Top users last month
Jake
Top achievements
Rank 1
RBarnes
Top achievements
Rank 1
Iron
Iron
Rami
Top achievements
Rank 1
Iron
Veteran
Nathan
Top achievements
Rank 1
Kumeri
Top achievements
Rank 1
Iron
Veteran
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Jake
Top achievements
Rank 1
RBarnes
Top achievements
Rank 1
Iron
Iron
Rami
Top achievements
Rank 1
Iron
Veteran
Nathan
Top achievements
Rank 1
Kumeri
Top achievements
Rank 1
Iron
Veteran
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?