| <telerik:GridTemplateColumn AllowFiltering="false" HeaderText="Date" UniqueName="Date" Visible="true"> |
| <ItemTemplate> |
| <telerik:RadDatePicker Skin="Web20" ID="RadDate" runat="server" Width="95px"> |
| <Calendar ID="Calendar" runat="server" > |
| </Calendar> |
| <DateInput ID="DateInput_GateWayDate" runat="server" Width = "60px" |
| DateFormat="M/d/yyyy" > |
| </DateInput> |
| <DatePopupButton HoverImageUrl="" ImageUrl="" /> |
| </telerik:RadDatePicker> |
Hi
I am working on Export Excel; But I am looking for few answers...
1. How to align Caption to Right side.... I need Caption only for Excel so I am creating it while calling Excel only.... I tried using CssClass but it is not working..... I am not using "CommandItemTemplate"......
2. I am getting extra column on right side on excel for all views, except default mastertable view... Could you please suggest wht is that I am doing wrong? And how to remove to extra column?
3. Also Table is not getting border completly.... Top side of Header and bottom side of table is not showing border... could you suggest the way to achieve it..
Please see below look of Excel ........Caption is set in 3 rows, but it is showing me in center, I want it on right side....
Also please extra column on right hand side...and border issues....
Thanks,
Pradip
| Client Name | |||||||||||||
| Detail | |||||||||||||
| Detail 2 | |||||||||||||
| Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | |
| Client 1 | '08/'09 | 81,691,829 | 81,691,829 | 81,691,829 | $6,044,001 | $6,044,001 | $6,044,001 | $0.074 | $0.074 | $0.074 | |||
| Sub 1 | '08/'09 | 7,038,183 | 7,038,183 | 7,038,183 | $692,072 | $692,072 | $692,072 | $0.098 | $0.098 | $0.098 | |||
| Sub 4 | '08/'09 | 16,773,133 | 16,773,133 | 16,773,133 | $1,660,219 | $1,660,219 | $1,660,219 | $0.099 | $0.099 | $0.099 | |||
| Sub 5 | '08/'09 | 6,692,000 | 6,692,000 | 6,692,000 | $886,796 | $886,796 | $886,796 | $0.133 | $0.133 | $0.133 | |||
| Client 2 | '08/'09 | 152,417,843 | 152,417,843 | 152,417,843 | $8,635,388 | $8,635,388 | $8,635,388 | $0.057 | $0.057 | $0.057 | |||
| Client3 | '08/'09 | 35,796,307 | 35,796,307 | 35,796,307 | $276,533 | $276,533 | $276,533 | $0.008 | $0.008 | $0.008 | |||
| Client 4 | '08/'09 | 3,387,345 | 3,387,345 | 3,387,345 | $54,711 | $54,711 | $54,711 | $0.016 | $0.016 | $0.016 | |||
I have found that for the telerik provided skins that produce a border around the cell, for example Inox which just has a horizontal border, I must change blank values to to see that border when the value is blank.
Is there a better way to handle this situation where I must change the value in itemdatabound to get the border to show?
ex:
if
(dataView["CodeDesc"].ToString().Trim().Length == 0)
{
dataitem[
"CodeDesc"].Text = " ";
}
| <%@ Register src="ContactGrid.ascx" tagname="ContactGrid" tagprefix="uc2" %> |
| <%@ Register src="ContactSelected.ascx" tagname="ContactSelected" tagprefix="uc4" %> |
| <telerik:RadScriptBlock runat="server" ID="scriptBlock"> |
| <script type="text/javascript"> |
| <!-- |
| function onRowDropping(sender, args) |
| { |
| if (sender.get_id() == "<%=uc2_RadGrid1.ClientID %>") |
| { |
| var node = args.get_destinationHtmlElement(); |
| if(!isChildOf('<%=uc4_RadGrid1.ClientID %>', node) && !isChildOf('<%=uc2_RadGrid1.ClientID %>', node) ) |
| { |
| args.set_cancel(true); |
| } |
| } |
| else |
| { |
| var node = args.get_destinationHtmlElement(); |
| if(!isChildOf('trashCan', node)) |
| { |
| args.set_cancel(true); |
| } |
| else |
| { |
| if (confirm("Are you sure you want to delete this selection?")) |
| args.set_destinationHtmlElement($get('trashCan')); |
| else |
| args.set_cancel(true); |
| } |
| } |
| } |
| function isChildOf(parentId, element) |
| { |
| while(element) |
| { |
| if (element.id && element.id.indexOf(parentId) > -1) |
| { |
| return true; |
| } |
| element = element.parentNode; |
| } |
| return false; |
| } |
| --> |
| </script> |
| </telerik:RadScriptBlock> |