Hi
I am a trying to export radgrid to excel.
My Export settings are as follows
<ExportSettings FileName="Reports" ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true" Excel-Format="Html"></ExportSettings>
I am setting border below in
protected void RadGrid1_HTMLExporting(object sender, GridHTMLExportingEventArgs e)
{
e.Styles.Append("th { border:solid 0.1pt #CCCCCC; }");
}
I am able to export with border. But my Group Column was separated as 2 cell in output.
I have attached 2 images (expected results vs error_output)
Please help!!!
I'm applying MailMerge example mentioned here in our system
I added code related to custom dropdown only, to test insertion
After selection an option, I just get a title window, like shown in screenshot_1.png attached
here's what shown in debugger, as shown in debugger.png attached. Reading values seems working fine, but the insertion itself doesn't happen, instead that message only shows.
I have a few columns with balances showing on the grid that I export to excel.
I only show the $ sign in the footer totals and the rows are displayed without the $. So my column looks like below:
<telerik:GridBoundColumn Aggregate="Sum" DataField="PlanExpense" HeaderText="Annual Plan Expense" UniqueName="PlanExpense"
DataFormatString="{0:#,##0.00;(#,##0.00)}" HeaderStyle-Width="9%" FooterAggregateFormatString="{0:c2}" />
protected void grid_ExportCellFormatting(object source, ExportCellFormattingEventArgs e)
{
if (e.FormattedColumn.ColumnType == "GridTemplateColumn")
{
GridTemplateColumn templateCol = (GridTemplateColumn)e.FormattedColumn;
if (templateCol.DataTypeName == "System.Decimal" || templateCol.DataTypeName == "System.Double")
{
e.Cell.Style["mso-number-format"] = "$#,##0.00;($#,##0.00)";
}
}
if (e.FormattedColumn.ColumnType == "GridBoundColumn")
{
GridBoundColumn boundCol = (GridBoundColumn)e.FormattedColumn;
if (boundCol.DataFormatString.ToLower().Contains("0:c") || boundCol.DataFormatString.ToLower().Contains("$"))
{
//e.Cell.Style["mso-number-format"] = "$#,##0.00;($#,##0.00)";
e.Cell.Style["mso-number-format"] = "-$* #,##0.00_-;$* (#,##0.00-);_-$* \" - \"??_-;_-@_-";
}
else if (boundCol.DataFormatString.ToLower().Contains("%"))
{
e.Cell.Style["mso-number-format"] = "0.##%;(0.##%)";
}
else if (boundCol.DataFormatString.ToLower().Contains("0:#,##0.00"))
{
e.Cell.Style["mso-number-format"] = "0:#,##0.00;(#,##0.00)";
}
else if (boundCol.DataFormatString.Contains("{0:P}"))
{
e.Cell.Style["mso-number-format"] = @"Percent";
}
else if (boundCol.DataFormatString.Contains("{0:#,##0;(#,##0)}"))
{
e.Cell.Style["mso-number-format"] = "$#,##0;($#,##0)";
}
}
}
I specify formatting in the exportcellformatting event as shown above, but it seems that is only applicable to the data rows and not the footer. Currently excel displays a negative currency in red parenthesis and I do not want to show the negative in red, only in parentheses.
Is there a way I can format the footer to do that?
Hi,
I'm trying to add a RadButton as checkbox type to toggle "Enabled" and "Disabled" a RadNumericTextBox. Can someone help me please?
ASPX Code:
<td>
<telerik:RadNumericTextBox ID="PAPTestDays" runat="server" DataType="System.Int32" Font-Names="Calibri" Font-Size="9pt" MaxLength="3" Skin="Metro" Width="100px">
<NegativeStyle Resize="None" />
<NumberFormat DecimalDigits="0" ZeroPattern="n" />
<EmptyMessageStyle Resize="None" />
<ReadOnlyStyle Resize="None" />
<FocusedStyle Resize="None" />
<DisabledStyle Resize="None" />
<InvalidStyle Resize="None" />
<HoveredStyle Resize="None" />
<EnabledStyle Resize="None" />
</telerik:RadNumericTextBox>
<asp:RangeValidator ID="PAPTestDaysxRangeValidator" runat="server" ControlToValidate="PAPTestDays" ErrorMessage="This value should be between 30 and 365!" Display="Dynamic"
MaximumValue="365" MinimumValue="30" Type="Integer" ForeColor="Red" Font-Names ="Calibri" Font-Size="9pt">
</asp:RangeValidator>
<telerik:RadButton RenderMode="Lightweight" ID="PAPTestDaysEnabled" runat="server" ToggleType="CustomToggle" ButtonType="ToggleButton" AutoPostBack="False" OnClientCheckedChanged="PAPTestDaysEnabled_OnCheckedChanged">
<ToggleStates>
<telerik:RadButtonToggleState Text="" PrimaryIconCssClass="rbToggleCheckbox" />
<telerik:RadButtonToggleState Text="" PrimaryIconCssClass="rbToggleCheckboxChecked" />
</ToggleStates>
</telerik:RadButton>
</td>
JavaScript Code:
function PAPTestDaysEnabled_OnCheckedChanged() {
var checkBox = $find("<%= PAPTestDaysEnabled.ClientID %>");
var PAPTestDaysTextBox = $find("<%= PAPTestDays.ClientID %>");
if (checkBox.get_checked()) {
PAPTestDaysTextBox.enable();
} else {
PAPTestDaysTextBox.disable();
}
}