Questions on UI for ASP.NET AJAX Forum

2 answers

1.3K+ views

RadTextbox with number and decimal point

I just need validation on my rad textbox . Only alllow only number with $ and decimal point. Textbox inside radgrid template column

example $ 123.33 or $ 12342.00.

Thanks

Input

answered on 09 Oct 2018

2 answers

73 views

No buttons, only links

RadNavigation and RadTabStrip work fine in Visual Studio when test using IE11. After publishing and implementing on Web Server, IE only shows links for the navigation and the tabs will not work. Chrome works fine. Testing on the web server with IE11 also works fine. Have to use IE11, can't use Edge either.

Navigation

answered on 08 Oct 2018

3 answers

446 views

Export to Excel footer format

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?

Grid

answered on 08 Oct 2018

1 answer

179 views

RadButton to toggle RadNumericTextBox's enabled and disabled

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:

JavaScript Code:

Button

answered on 08 Oct 2018

4 answers

379 views

Hide Save Button

Hi,
Is there a way to hide the Save button in asp.net ajax spreadsheet control?

Thanks

Mic

Spreadsheet

answered on 08 Oct 2018

1 answer

276 views

How to delete cells from the radspreadsheet

I am trying to create a dynamic html table generator using ken-do Rad Spreadsheet. I am creating my custom toolbar that works fine but my question is, how can i remove Formula Bar, Column Header, Row Header and cells. I have attach a image, that is actually i am trying to achieve. can someone suggest me how can i do this am new to telerik.

Spreadsheet

answered on 05 Oct 2018

2 answers

162 views

Add Variables inside Editor Content

I'm trying to make a Report Builder in RadEditor, where admin user of our solution can define his own report template, adding some pieces of information as variables, so the other user of less privileges of our system, can just fill the values of these variables, manually or pull from server.

As shown in the attached image, variables are wrapped up with square brackets []. Their names should be retrieved from database.

Please advice how to do that.
Thank you!

Editor

answered on 05 Oct 2018

3 answers

119 views

Using Grid in edit window

Dear all,

In my application I use Radgrid and customized insert window which contains another Radgrid. The grid contains selection column and user can select multiple records. I have a problem when the user selects any records and close the window without saving. It looks list of selected items remains stored somewhere and when I open window again I have a problem. At first look it looks fine but if I click on 'Select All' checkbox nothing happened. I try to debug it JS and I see values in _selectedItemsInternal property, but it contains old values (which were selected for the first time before window close).

I execute JS function when window is closed. So I hope I can remove any selection in this, but I tested a lot of functions:

grid.clearSelectedItems();

grid.get_masterTableView().set_visible(false);

grid.get_masterTableView().set_dataSource([]);

$('[id$="' + grid.ID + '_ClientState"]').val("");

masterGrid.get_masterTableView().cancelInsert();

But nothing helps me and when I open it again I have always the same problem. The checkbox 'Select All' doesn't work. When I select records manually one by one then it works.

Do you have any idea what can be wrong with header checkbox or how to clean correctly old values.

Thank you,
Petr

Grid

answered on 05 Oct 2018

3 answers

418 views

How to display the tooltips on all markers combined with server databinding?

Puzzled on how to solve this. Tried the script from this thread:
https://www.telerik.com/forums/marker-tooltip-show-on-load

But I cannot get it working combined with server side binding?

Using the ItemDatabound event then .visible is not a valid property of the tooltipsetting,
best effort for now is to switch off the autohide

Private Sub RadMap1_ItemDataBound(sender As Object, e As MapItemDataBoundEventArgs) Handles RadMap1.ItemDataBound<br> CType(e.Item, Telerik.Web.UI.MapMarker).TooltipSettings.AutoHide = False

End Sub

Any clue appreciated.

Map

answered on 05 Oct 2018

1 answer

253 views

Dynamically setting cell background color on PDF Export

I have a RadGrid that I set the cell background colors dynamically based on cell value but none of this formatting carries over to PDF like it does in Excel export.

an someone point me to any sources I can use to program this?

Grid

answered on 05 Oct 2018