This is a migrated thread and some comments may be shown as answers.

Export to Excel number problems

11 Answers 587 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

John Martin asked on 21 Jul 2008, 01:56 PM

Hello

Below is a sample of an export to Excel we do. I am getting these strange numbers from row 4 onwards and finding that zeros are chopped off at the begining and above 15 characters the number are set to zero? Please advise.

Thanks

Steve

Sim Id	Sim Number	Phone Number	Network
612	33333	7845698584	Orange
613	5555555555	7865984558	O2
614	77777777777	7845898568	T-Mobile
616	6.05643E+19	7886400749	Orange
617	4.84783E+19	8189428786	Orange
618	7.86511E+19	5873120201	Orange
619	2.18533E+19	9137077548	Orange
620	4.63874E+19	8268437527	Orange
621	5.72428E+19	3478728312	Orange
622	4.31133E+19	8275787977	Orange
623	2.38482E+18	5451253979	Orange
624	6.94754E+19	1153142640	Orange
625	4.73383E+19	3272183543	Orange
626	9.50517E+19	1133185943	Orange
627	4.45572E+19	4538341455	Orange
628	3.11145E+19	2844557113	Orange
629	3.03666E+19	9437130953	Orange
630	9.91132E+19	245415386	Orange
631	2.32191E+19	5993223235	Orange
632	7.02665E+19	5953534740	Orange

11 Answers, 1 is accepted

answered on 21 Jul 2008, 03:55 PM

Hello John,

The numbers are displaying in scientific notation in order to save space. This is the default behavior when using numbers as large as you are. You have a couple of options to fix this. For starters, you might consider converting that data type to a string instead of a double (which is what I am assuming you have the values saved as). Since the column name is "Sim Number" I am guessing the number is more for identification purposes than for performing calculations, and therefore a string would be appropriate to use.

If you do not want to change the data's type (or just want a quicker fix), then you can include a format string in your RadGrid to format the output of the data. You can read about standard data format strings here, and I have created a simple demo which will show how to format your data so that the entire number is visible.

    
            <%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %> 
        
            <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> 
        
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
        
            <html xmlns="http://www.w3.org/1999/xhtml"> 
        
            <head runat="server"> 
        
                <title>Untitled Page</title> 
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server"> 
        
                    <telerik:RadScriptManager ID="RadScriptManager1" runat="server" />   
        
                    <telerik:RadGrid ID="RadGrid1" runat="server"   
        
                        AutoGenerateColumns="False" 
        
                        OnNeedDataSource="RadGrid1_NeedDataSource"> 
        
                        <MasterTableView> 
        
                            <Columns> 
        
                                <telerik:GridBoundColumn DataField="Number"  
        
                                    DataType="System.Double"                         
        
                                    DataFormatString="{0:N0}" /> 
        
                            </Columns> 
        
                        </MasterTableView> 
        
                    </telerik:RadGrid> 
        
                    <asp:Button ID="Button1" runat="server"  
        
                        Text="Export"  
        
                        OnClick="Button1_Click" />       
        
                </form> 
        
            </body> 
        
            </html>

    
            using System; 
        
            public partial class _Default : System.Web.UI.Page  
        
            { 
        
                protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) 
        
                { 
        
                    var data = new [] { 
        
                        new { Number =  1212432423423423234243423.23423 }, 
        
                        new { Number = 6786786787612323887812397821233198.90980 } 
        
                    }; 
        
                    RadGrid1.DataSource = data; 
        
                } 
        
                protected void Button1_Click(object sender, EventArgs e) 
        
                { 
        
                    RadGrid1.MasterTableView.ExportToExcel(); 
        
                } 
        
            }

I hope this was helpful. If you continue to have questions, please let me know.

Sincerely,
Kevin Babcock

answered on 22 Jul 2008, 12:34 PM

Hi John,

It appears that the value is being cast to a numeric format, due to the fact that it is being displayed in scientific notation. Would you mind posting the code for your RadGrid (and any associated code-behind methods) here so I can take a look. It might help me better understand what is causing your Sim Number column to display like that.

    
            Imports System 
        
            Public Partial Class _Default 
        
                Inherits System.Web.UI.Page 
        
                Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) 
        
                    Dim data As Numbers = New Numbers() { New Numbers(1.21243242342342E+24), New Numbers(6.78678678761232E+33) } 
        
                    RadGrid1.DataSource = data 
        
                End Sub 
        
                Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) 
        
                    RadGrid1.MasterTableView.ExportToExcel() 
        
                End Sub 
        
            End Class 
        
            Public Class Numbers 
        
                Public Sub New(ByVal value As Double) 
        
                    Me.Numbers = value 
        
                End Sub 
        
                Private _number As Double 
        
                Public Property Number() As Double 
        
                    Get 
        
                        Return Me._number 
        
                    End Get 
        
                    Set 
        
                        Me._number = value 
        
                    End Set 
        
                End Property 
        
            End Class

In the meantime, here is the code I gave you, converted to VB. In the future, you can use Telerik's Code Converter to convert any code from C# to VB, and vice versa. Certainly a handy tool when you want to use the code from a demo but aren't familiar with the language.

Regards,
Kevin Babcock

answered on 23 Jul 2008, 08:13 AM

Sorry but for some reason this grid did not upload last time. Please advise.

Thanks

<%

@ Page Language="VB" Theme="halo" MasterPageFile="~/MasterPages/MenuMaster.master" AutoEventWireup="false" CodeFile="SuccessfulBuildRequests.aspx.vb" Inherits="_SuccessfulBuildRequests" title="Halo - DCM - Build Requests" %>

@ Register Assembly="RadWindow.Net2" Namespace="Telerik.WebControls" TagPrefix="rad" %>

@ Register Assembly="RadAjax.Net2" Namespace="Telerik.WebControls" TagPrefix="radA" %>

@ Register Assembly="RadComboBox.Net2" Namespace="Telerik.WebControls" TagPrefix="radC" %>

@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %>

@ OutputCache NoStore="true" Location="none" VaryByParam="none" %>

asp:Content ID="Content1" ContentPlaceHolderID="CPH1" Runat="Server">

script src="../Javascript/Utilities.js" type="text/javascript"></script>

<!--

function blankTextboxAlert()

{

var allSelects = document.getElementsByTagName("input"); // get all input controls on the page

for (var i=0; i < allSelects.length; i++) // search through these input controls

{

if (allSelects[i].id == "ctl00_CPH1_mkSystemName") // if it's the system name text box

{

if (allSelects[i].value == "") // if it's blank then display the confirm box

{

return confirm('The merchant name is blank. This will result in a new merchant system being created. Click OK to confirm this.');

}

//-->

</script>

radA:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="LoadingPanel1" EnableOutsideScripts="true">

<tr>

--<div style="text-align:left; width:100%; margin: 0 auto;"> --%>

<asp:Panel ID="pnleditform" runat="server" Width="100%">

</table>

</td>

<tr>

<radG:RadGrid ID="RadGrid2" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True"

AllowAutomaticUpdates="True" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="dsV1MerchantSystemDropDown"

EnableAJAX="false" EnableAJAXLoadingTemplate="false" HorizontalAlign="NotSet"

OnItemCommand="RadGrid2_ItemCommand" PageSize="10"

BorderColor="black" BorderStyle="solid" BorderWidth="1px">

<MasterTableView AllowSorting="True" CommandItemDisplay="Top" DataKeyNames="mkSystemId"

DataSourceID="dsV1MerchantSystemDropDown" HorizontalAlign="NotSet">

Filter:

<asp:DropDownList ID="ddlFieldName" runat="server">

<asp:ListItem Text="Merchant Name" Value="MerchantName" Selected="True" ></asp:ListItem>

<asp:ListItem Text="System Id" Value="mkSystemId"></asp:ListItem>

</asp:DropDownList>

<asp:TextBox ID="txtSearch2" runat="server"></asp:TextBox> 

<asp:Button ID="btnSearch2" runat="server" CommandName="btnSearch2" Text="Filter" /> 

<asp:Button ID="btnShowAll2" runat="server" CommandName="btnShowAll2" Text="Remove Filter" />

</div>

</CommandItemTemplate>

<radG:GridButtonColumn CommandName="RadGrid2Select" Text="Select" UniqueName="column">

</radG:GridButtonColumn>

</Columns>

</ExpandCollapseColumn>

</RowIndicatorColumn>

</EditColumn>

</EditFormSettings>

</MasterTableView>

</radG:RadGrid>

</td>

</tr>

</table>

</td>

</tr>

</table>

<br />

</asp:Panel>

--</div>--%>

<radG:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" Width="100%" PageSize="10"

AllowAutomaticUpdates="True" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="dsAccountBuildRequests"

HorizontalAlign="NotSet" EnableAJAX="False" EnableAJAXLoadingTemplate="False">

</EditColumn>

</EditFormSettings>

--Main Grid COMAND template--%>

<asp:DropDownList ID="ddlFieldName" runat="server">

<asp:ListItem Value="AgreementId">Agreement Id</asp:ListItem>

<asp:ListItem Value="CustomerName">Customer Name</asp:ListItem>

<asp:ListItem Value="Name">Name</asp:ListItem>

<asp:ListItem Value="PrimaryMID">Primary MID</asp:ListItem>

<asp:ListItem Value="Code">Code</asp:ListItem>

<asp:ListItem Value="PrimaryTID">Primary TID</asp:ListItem>

</asp:DropDownList>

<asp:TextBox ID="txtSearch" runat="server" ></asp:TextBox>

<asp:Button ID="btnSearch" Text="Filter" runat="server" CommandName="btnSearch" TabIndex="0"></asp:Button>

<asp:Button ID="btnShowAll" runat="server" CommandName="btnShowAll" Text="Remove Filter" />

</div>

</CommandItemTemplate>

--End of Main Grid COMAND template--%>

<radG:GridTemplateColumn UniqueName="AccountBuildRequestEditCol" ItemStyle-Width="20px">

<asp:ImageButton ID="ibAccountBuildRequestEditCol" ToolTip="Edit" runat="server" CommandName="Edit" Visible='<%# Session("AllowUpdate") %>' ImageUrl="~\img\edit.gif" />

</ItemTemplate>

</radG:GridTemplateColumn>

</Columns>

</ExpandCollapseColumn>

</RowIndicatorColumn>

</MasterTableView>

<FilterMenu HoverBackColor="LightSteelBlue" HoverBorderColor="Navy" NotSelectedImageUrl="~/RadControls/Grid/Skins/Default/NotSelectedMenu.gif"

SelectColumnBackColor="Control" SelectedImageUrl="~/RadControls/Grid/Skins/Default/SelectedMenu.gif"

TextColumnBackColor="Window"></FilterMenu>

</radG:RadGrid>

<asp:ObjectDataSource ID="dsAccountBuildRequests" runat="server" SelectMethod="AccountBuildRequestList"

TypeName="DataManager" UpdateMethod="AccountBuildRequestUpdate">

<asp:Parameter Name="fieldName" Type="String" />

<asp:Parameter Name="filter" Type="String" />

</SelectParameters>

</asp:ObjectDataSource>

<asp:ObjectDataSource ID="dsAuthServerList" runat="server"

SelectMethod="AuthServerList" TypeName="DataManager" EnableCaching="true" SqlCacheDependency="hostedeft:authserver">

</asp:ObjectDataSource>

<asp:ObjectDataSource ID="dsV1AuthServerList" runat="server"

SelectMethod="V1AuthServerList" TypeName="DataManager">

</asp:ObjectDataSource>

<asp:ObjectDataSource ID="dsV1MerchantSystemDropDown" runat="server"

SelectMethod="V1MerchantSystemDropDown" TypeName="DataManager">

<asp:Parameter Name="filter" Type="String" />

<asp:Parameter Name="parameterValue" Type="String" />

</SelectParameters>

</asp:ObjectDataSource>

<asp:ObjectDataSource ID="dsMerchantSystemDropDown" runat="server"

SelectMethod="MerchantSystemDropDown" TypeName="DataManager">

<asp:Parameter Name="filter" Type="String" />

<asp:Parameter Name="parameterValue" Type="String" />

</SelectParameters>

</asp:ObjectDataSource>

</td>

</tr>

</table>

<radA:RadAjaxManager ID="RadAjaxManager1" runat="server" EnableOutsideScripts="True">

<radA:AjaxSetting AjaxControlID="RadGrid2">

<radA:AjaxUpdatedControl ControlID="RadGrid2" LoadingPanelID="LoadingPanel2" />

</UpdatedControls>

</radA:AjaxSetting>

</AjaxSettings>

</radA:RadAjaxManager>

rada:AjaxLoadingPanel ID="LoadingPanel1" runat="server" Height="75px" Width="75px">

<asp:Image ID="Image1" ImageUrl="~/RadControls/Ajax/Skins/Default/loading.gif" Runat="server" />

rada:AjaxLoadingPanel>

radA:RadAjaxPanel>

asp:Content>

answered on 23 Jul 2008, 08:19 AM

Sorry have realised I sent you the wrong data, that one I have a problem with RadAlert not popping up (although code works on other pages and when running it does access the line of code that runs the alert). Please find below RadGrid requested.

<radG:RadGrid AllowFilteringByColumn="false" ID="RadGrid1" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" Width="100%" PageSize="20"

AllowAutomaticUpdates="True" AllowPaging="true" AutoGenerateColumns="False" DataSourceID="dsMobileSims" AllowSorting="True"

HorizontalAlign="NotSet" EnableAJAXLoadingTemplate="True" EnableAJAX="false">

<asp:LinkButton ID="lbtnInsert" runat="server" Enabled='<%# Session("AllowInsert") %>' CommandName="InitInsert" Visible='<%# Not RadGrid1.MasterTableView.IsItemInserted %>'><img style="border:0px" alt="" src="../Img/AddRecord.gif" />Add new Sim</asp:LinkButton>

</div>

<asp:LinkButton ID="lbtnExportToExcel" runat="server" OnClick="Export" CommandName="ExportToExcel"><img style="border:0px" alt="" src="../Img/Excel.ico" /> Export to Excel</asp:LinkButton>   |  

<asp:Literal ID="Literal50" runat="server" Text="Filter:"></asp:Literal>

<asp:DropDownList ID="ddlFieldName" runat="server">

<asp:ListItem Text="SIM Number" Value="SIMNumber" Selected="True" ></asp:ListItem>

</asp:DropDownList>

<asp:TextBox ID="txtSearch" runat="server" onkeypress="doFilter(this, event)" MaxLength="50"></asp:TextBox>

<asp:Button ID="btnSearch" runat="server" CommandName="btnSearch" Text="Filter" /> 

<asp:Button ID="btnShowAll" runat="server" CommandName="btnShowAll" Text="Remove Filter" />

</div>

</CommandItemTemplate>

<radG:GridTemplateColumn UniqueName="MobileSIMEditCol">

<asp:ImageButton ID="ibMobileSIMEditCol" ToolTip="Edit" runat="server" CommandName="Edit" Visible='<%# Session("AllowUpdate") %>' ImageUrl="~\img\edit.gif" />

</ItemTemplate>

</radG:GridTemplateColumn>

<radG:GridBoundColumn DataField="mkSimId" AllowFiltering="False" HeaderText="Sim Id" UniqueName="SimId">

</radG:GridBoundColumn>

<radG:GridBoundColumn DataField="SimNumber" AllowFiltering="False" HeaderText="Sim Number" UniqueName="SimNumber">

</radG:GridBoundColumn>

<radG:GridBoundColumn DataField="SimNumber" AllowFiltering="False" HeaderText="Sim Number2" UniqueName="SimNumber2"

DataType="System.Double" DataFormatString="{0:N0}" >

</radG:GridBoundColumn>

<radG:GridBoundColumn DataField="PhoneNumber" HeaderText="Phone Number" UniqueName="PhoneNumber">

</radG:GridBoundColumn>

<radG:GridBoundColumn DataField="Network" HeaderText="Network" UniqueName="Network">

</radG:GridBoundColumn>

<radG:GridCheckBoxColumn DataField="Activated" HeaderText="Activated" UniqueName="Activated" DataType="System.Boolean">

</radG:GridCheckBoxColumn>

<radG:GridCheckBoxColumn DataField="Allocated" HeaderText="Allocated" UniqueName="Allocated" ConvertEmptyStringToNull="False" DataType="System.Boolean">

</radG:GridCheckBoxColumn>

<radG:GridTemplateColumn UniqueName="Reserve" SortExpression="EnableReserve" HeaderText="Reserve">

<table>

<tr>

<asp:Button ID="btnReserve" runat="server" Text="Reserve" CommandName="Edit" OnClick="btnReserve_Click" OnClientClick="return confirm('Reserve this sim?');" Enabled='<%# Bind("EnableReserve") %>' Visible='<%# Session("AllowUpdate") %>' />

</td>

</tr>

</table>

</ItemTemplate>

</radG:GridTemplateColumn>

<radG:GridTemplateColumn UniqueName="MobileSIMDelete">

<asp:ImageButton ID="ibMobileSIMDelete" runat="server" CommandName="Delete" OnClientClick="return confirm('Delete this sim?');" Visible='<%# Session("AllowDelete") %>' ImageUrl="~\img\delete.gif" />

</ItemTemplate>

</radG:GridTemplateColumn>

</Columns>

<asp:Panel ID="Panel1" runat="server" Width="100%">

<asp:Literal ID="Literal21" runat="server" Text='<%# IIf( DataBinder.Eval(Container, "OwnerTableView.IsItemInserted"),"New Mobile Sim","Edit details of Sim " & Eval("SimNumber")) %>'></asp:Literal>

<asp:Literal ID="lblMobileSIM_Timestamp" runat="server" Text='<%# Bind("MobileSIM_Timestamp")%>' Visible="false"></asp:Literal>

</td>

</tr>

<tr>

<td>

<asp:Label ID="Label1" runat="server" Text="Sim Number*:" Width="100px"></asp:Label></td>

<td>

<asp:TextBox ID="txtSimNumber" TabIndex="1" Width="200" runat="server" Text='<%# Bind("SimNumber") %>' MaxLength="20"></asp:TextBox>

<asp:RequiredFieldValidator ID="fvSimNumber" runat="server" ControlToValidate="txtSimNumber" EnableClientScript="false"

ErrorMessage="Sim Number: Sim Number required!" ValidationGroup="MobileSimsValidation">*</asp:RequiredFieldValidator>

<asp:RegularExpressionValidator

ID="NewSIMNumberValidator" runat="server" ControlToValidate="txtSimNumber" CssClass="validationControls"

EnableClientScript="false" ErrorMessage="SIM Number: Only Numeric characters are allowed (no spaces allowed either)"

ToolTip="SIM Number: Only Numeric characters are allowed (no spaces allowed either)"

ValidationExpression="\d{0,}" ValidationGroup="MobileSimsValidation">*</asp:RegularExpressionValidator>

</td>

</tr>

<tr>

<td>

<asp:Label ID="Label5" runat="server" Text="Phone Number*:" Width="100px"></asp:Label></td>

<td>

<asp:TextBox ID="txtPhoneNumber" TabIndex="1" runat="server" Text='<%# Bind("PhoneNumber") %>' MaxLength="20"></asp:TextBox>

<asp:RequiredFieldValidator ID="fvPhoneNumber" runat="server" ControlToValidate="txtPhoneNumber"

EnableClientScript="false" ErrorMessage="Phone Number: Phone Number is required!"

ValidationGroup="MobileSimsValidation">*</asp:RequiredFieldValidator>

<asp:RegularExpressionValidator

ID="NewPhoneNumberValidator" runat="server" ControlToValidate="txtPhoneNumber" CssClass="validationControls"

EnableClientScript="false" ErrorMessage="Phone Number: The phone number entered is in the incorrect format."

ToolTip="Phone Number: Only Numeric characters are allowed"

ValidationExpression="^(($?0\d{4}$?\s?\d{3}\s?\d{3})|($?0\d{3}$?\s?\d{3}\s?\d{4})|($?0\d{2}$?\s?\d{4}\s?\d{4}))(\s?\#(\d{4}|\d{3}))?$"

ValidationGroup="MobileSimsValidation">*</asp:RegularExpressionValidator>

</td><%--ValidationExpression="\d{1,}(\x20{1,1}\d{1,}){0,1}\d{0,}" --%>

</tr>

<tr>

<td>

<asp:Label ID="Literal3" runat="server" Text="Network*:" Visible="false"></asp:Label>

</td>

<td>

<asp:TextBox ID="txtNetwork" TabIndex="3" runat="server" Text='<%# Bind("Network") %>' Visible="false" MaxLength="20"></asp:TextBox>

<asp:RequiredFieldValidator ID="fvNetwork" runat="server" ControlToValidate="txtNetwork" EnableClientScript="false"

ErrorMessage="Network: Network name required!" ValidationGroup="MobileSimsValidation">*</asp:RequiredFieldValidator>

</td>

</tr>

<tr>

<td>

<asp:Label ID="Literal4" runat="server" Text="Activated:" Visible="false"></asp:Label>

</td>

<td>

<asp:CheckBox ID="chkActivated" TabIndex="4" runat="server" Visible="false" Checked='<%# Bind("Activated") %>'></asp:CheckBox>

</td>

</tr>

<tr>

<td>

<asp:Label ID="Literal2" runat="server" Text="Allocated:" Visible="false"></asp:Label>

</td>

<td>

<asp:CheckBox ID="chkAllocated" TabIndex="5" runat="server" Visible="false" Checked='<%# Bind("Allocated") %>'></asp:CheckBox>

</td>

</tr>

<tr>

<asp:Label ID="lblNoteCaption" runat="server" Text="Note (read only):" Visible="false" Width="100px"></asp:Label>

</td>

<td>

--<asp:Label ID="lblNoteField" runat="server" Text='<%# Bind("SIMNote") %>' ></asp:Label>--%>

<asp:TextBox ID="txtNote" ReadOnly="True" runat="server" Text='<%# Bind("SIMNote") %>' Enabled="True" Visible="false" MaxLength="500" Width="380px" Height="150px" TextMode="multiline"></asp:TextBox>

</td>

</tr>

<tr>

</tr>

<tr>

<asp:Button ID="btnUpdate" TabIndex="6" ValidationGroup="MobileSimsValidation"

runat="server" CommandName='<%# IIf( DataBinder.Eval(Container, "OwnerTableView.IsItemInserted"), "PerformInsert", "Update") %>'

Text='<%# IIf( DataBinder.Eval(Container, "OwnerTableView.IsItemInserted"), "Insert", "Update") %>'>

</asp:Button>

<asp:Button ID="btnCancel" TabIndex="7" runat="server" Text="Cancel" CommandName="Cancel" />

(* = Mandatory Fields)

</td>

</tr>

<tr>

<asp:ValidationSummary ID="vsMobileSims" runat="server" ValidationGroup="MobileSimsValidation" />

</td>

</tr>

</table>

</asp:Panel>

<asp:Panel ID="Panel2" runat="server" Visible="False" Width="100%">

<asp:Literal ID="Literal1" runat="server" Text="Please State a Reason for Reserving this SIM"></asp:Literal>

<asp:Literal ID="Literal5" Visible="false" runat="server" Text='<%# IIf( DataBinder.Eval(Container, "OwnerTableView.IsItemInserted"),"New Mobile Sim",Eval("mkSIMId")) %>'></asp:Literal>

</td>

</tr>

<tr>

<td>

Reserve Note*:

</td>

<td>

<asp:TextBox ID="txtReserveNote" TabIndex="1" TextMode="multiLine" runat="server" MaxLength="500" Height="150px" Width="380px" Visible="false"></asp:TextBox><asp:RequiredFieldValidator

ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtReserveNote"

CssClass="validationControls" EnableClientScript="True" ErrorMessage="Reserve Note: Reserve note is required!"

ValidationGroup="MobileSimsReserveValidation">*</asp:RequiredFieldValidator>

<asp:RegularExpressionValidator ID="rfvNote" runat="server" ControlToValidate="txtReserveNote" ValidationGroup="MobileSimsReserveValidation"

ErrorMessage="Note too long, please reduce the text (max = 500 characters)." EnableClientScript="true" ValidationExpression="[^$]{0,500}">*</asp:RegularExpressionValidator>

</td>

</tr>

<tr>

<asp:Button ID="btnConfirmReserve" runat="server" CommandName="PeformInsertReserve"

TabIndex="2" Text="Confirm"

ValidationGroup="MobileSimsReserveValidation" Visible="false" />

<asp:Button ID="btnCancelReserve" TabIndex="3" runat="server" Text="Cancel" CommandName="Cancel" Visible="false" />

(* = Mandatory Fields)

</td>

</tr>

<tr>

<asp:ValidationSummary ID="ValidationSummary1" runat="server" ValidationGroup="MobileSimsReserveValidation" />

</td>

</tr>

</table>

</asp:Panel>

</FormTemplate>

</EditFormSettings>

</ExpandCollapseColumn>

</RowIndicatorColumn>

</MasterTableView>

<Pdf PageBottomMargin="" PageFooterMargin="" PageHeaderMargin="" PageHeight="11in"

PageLeftMargin="" PageRightMargin="" PageTopMargin="" PageWidth="8.5in" />

</ExportSettings>

</radG:RadGrid>

answered on 24 Jul 2008, 11:21 AM

Hi John Martin,

The precision of double type in c# is up to 15-16 digits. That is why bigger numbers are displayed in scientific format (1.234E+33) and formatted with Numeric format, the signs after 15th are zero signs. Even if you convert them to string, it is not guaranteed that the true value of your double is displayed either using RadGrid to show the result or a simple Label.

Please find more about more about numeric formats and floating point data types in the following resources:
http://msdn.microsoft.com/en-us/library/s8s7t687(VS.71).aspx
http://msdn.microsoft.com/en-us/library/9ahet949(VS.71).aspx

I hope this helps.

Greetings,
Iana
the Telerik team

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

answered on 24 Jul 2008, 12:20 PM

Hello John,

Iana is certainly correct, but after performing some extensive testing of my own I am certain I know what your problem is. The RadGrid can display the numbers just fine if you display the values as a System.String. However, when exported to Excel, Excel immediately tries to cast them to the most appropriate data type (in this case, it thinks they are numeric values) and the RadGrid's cell formating is not persisted. This is perhaps due to the fact that you are using an older version of the RadControls. Unfortunately, only simple exporting was supported in the older version of RadControls for ASP.NET Classic which you are using. There has been an effort in the newer releases to provide you more control over how to export your data, but getting this support would require an upgrade to our RadControls for ASP.NET AJAX.

If you'd like more information, please don't hesitate to ask.

Regards,
Kevin Babcock

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Export to Excel number problems

11 Answers, 1 is accepted