Export to Excel number problems

General Discussions
Top achievements
Rank 2
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

0
Kevin Babcock
Top achievements
Rank 1
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" %> Untitled Page

 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
0
John Martin
Top achievements
Rank 2
answered on 22 Jul 2008, 08:31 AM
Hi Kevin

Thanks for getting back to me. As far as I can tell the SIMNumber is being stored as

@@SIMNumber varchar

(20) = NULL,

I am also writing in VB.Net. Will your method still be appropiate and if so can you return it in VB?

Many thanks

Steve

0
Kevin Babcock
Top achievements
Rank 1
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
0
John Martin
Top achievements
Rank 2
answered on 22 Jul 2008, 01:09 PM
Remove incorrect data.
0
John Martin
Top achievements
Rank 2
answered on 23 Jul 2008, 08:13 AM

Thanks

<%

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

<%

<%

<%

<%

<%

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

<

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

<

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

<script type="text/javascript" language="javascript">

<!--

{

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>

<

<tr>

<%

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

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

<table cellspacing="2" class="module" border="0px" style="width: 100%; text-align: center;">

</table>

</td>

<td rowspan="8" style="width: 100%;" valign="top">

<table style="width: 100%; height: 51px">

<tr>

<td style="height: 15px" align="center">

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

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

DataSourceID="dsV1MerchantSystemDropDown" HorizontalAlign="NotSet">

<CommandItemTemplate>

<div style="float: right">

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>&nbsp;

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

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

</div>

</CommandItemTemplate>

<Columns>

<ItemStyle HorizontalAlign="Left" Width="40px" />

</Columns>

<ExpandCollapseColumn Visible="False">

</ExpandCollapseColumn>

<RowIndicatorColumn Visible="False">

</RowIndicatorColumn>

<EditFormSettings>

<EditColumn UniqueName="EditCommandColumn1">

</EditColumn>

</EditFormSettings>

</MasterTableView>

</td>

</tr>

</table>

</td>

</tr>

</table>

<br />

</asp:Panel>

<%

--</div>--%>

<MasterTableView DataKeyNames="mkAccountBuildRequestId" DataSourceID="dsAccountBuildRequests" HorizontalAlign="NotSet" AllowSorting="True" CommandItemDisplay="Top">

<EditFormSettings>

<EditColumn UniqueName="EditCommandColumn1">

</EditColumn>

</EditFormSettings>

<%

--Main Grid COMAND template--%>

<CommandItemTemplate>

<div style="float: right; padding: 2px 2px 0px 0px;">

<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>

</div>

</CommandItemTemplate>

<%

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

<Columns>

<ItemTemplate>

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

</ItemTemplate>

</Columns>

<ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn" Visible="False">

</ExpandCollapseColumn>

<RowIndicatorColumn UniqueName="RowIndicator" Visible="False">

</RowIndicatorColumn>

</MasterTableView>

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

TypeName="DataManager" UpdateMethod="AccountBuildRequestUpdate">

<SelectParameters>

<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">

<SelectParameters>

<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">

<SelectParameters>

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

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

</SelectParameters>

</asp:ObjectDataSource>

</td>

</tr>

</table>

<AjaxSettings>

<UpdatedControls>

</UpdatedControls>

</AjaxSettings>

<

</

</

</

asp:Content>

0
John Martin
Top achievements
Rank 2
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.

<MasterTableView CommandItemDisplay="Top" DataKeyNames="mkSimId" DataSourceID="dsMobileSims" HorizontalAlign="NotSet" Width="100%">

<CommandItemTemplate>

<div style="float:left;">

</div>

<div style="float:right">

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

<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" />&nbsp;

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

</div>

</CommandItemTemplate>

<Columns>

<ItemTemplate>

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

</ItemTemplate>

<ItemStyle Width="50px" />

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

<ItemStyle HorizontalAlign="Center" />

<ItemStyle HorizontalAlign="Center" />

<ItemTemplate>

<table>

<tr>

<td align="center">

<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>

<ItemStyle HorizontalAlign="Center" Width="100px" />

<ItemTemplate>

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

</ItemTemplate>

<ItemStyle HorizontalAlign="Right" />

</Columns>

<EditFormSettings EditFormType="Template">

<FormTemplate>

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

<table class="module" cellspacing="2" style="width: 500px">

<td align="center" colspan="5" style="font-size:12px; color:White">

<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>

<td style="vertical-align: top;">

<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>

<td colspan="5">

<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>

<td colspan="3">

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

</td>

</tr>

</table>

</asp:Panel>

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

<table class="module" cellspacing="2" style="width: 500px">

<td colspan="2" align="center">

<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>

<td colspan="2">

<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>

<td colspan="2">

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

</td>

</tr>

</table>

</asp:Panel>

</FormTemplate>

</EditFormSettings>

<ExpandCollapseColumn Visible="False" Resizable="False">

</ExpandCollapseColumn>

<RowIndicatorColumn Visible="False">

</RowIndicatorColumn>

</MasterTableView>

<ExportSettings>

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

</ExportSettings>

0
Iana Tsolova
Telerik team
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.
0
Kevin Babcock
Top achievements
Rank 1
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.

Regards,
Kevin Babcock
0
Inbal
Top achievements
Rank 1
answered on 02 Nov 2008, 12:55 PM
Hi,

I have the same problem with the numbers while exporting to excel.
Can you please tell me what version of AJAX do i need to change to.

Thanks,
Inbal
0
Sebastian
Telerik team
answered on 03 Nov 2008, 07:23 AM
Hello inbal,

I assume that you familiarized yourself with the communication in the forum thread so far. Additionally, you may consider migrating to the latest version 2008.2.1001 of RadControls for ASP.NET AJAX (Q2 2008 SP2) following the instructions from this KB article.

Best regards,
Stephen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
ArtiCut
Top achievements
Rank 1
answered on 06 Nov 2016, 11:32 AM

I have the same problem - large numbers get format of scientific (like: 3.01E+08 etc.) and DateTime column displays with '#' chars.

We use controls version 2015

I set the property SuppressColumnDataFormatStrings to true, but still the column formated.

I want toe remove the formating

Tags
General Discussions
John Martin
Top achievements
Rank 2
Kevin Babcock
Top achievements
Rank 1
John Martin
Top achievements
Rank 2
Iana Tsolova
Telerik team
Inbal
Top achievements
Rank 1
Sebastian
Telerik team
ArtiCut
Top achievements
Rank 1