Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
249 views
I love treelist. I have a web app needs to be viewed in mobile screens. To do so I need to hide some columns so treelist fits the screen. I did some experimets but none of them was successful.Lets say I have 10 columns and I need to hide 7 of them. I managed to hide them but rest of the columns nevert expanded to fill the screen. There always remain a white space at the left of treelist as if there's something occupies the space.


Can anyone please show me howto completely hide columns of threelist with CSS mediaquery please ? I've spent one week for this but no luck.

Best.
Eyup
Telerik team
 answered on 31 Jul 2019
3 answers
1.9K+ views

I am experiencing an issue and I am not sure it is a bug or just is an expected behavior from MS Excel.

I have a Telerik RadGrid, and there is a date column on the grid layout. The date format I am using to display date values is "dd/MM/yyyy". Then, I export that grid data to Excel file with GridExcelExportFormat.Biff type. The problem here is when I open the newly exported Excel file, the date format is changed to "MM/dd/yyyy". I think MS Excel did re-apply the default date format for my date column (?)

 

I want to keep displaying my date format "dd/MM/yyyy" in the Excel file after exporting the grid data, is there a way to do that?

 

Here is my code.

Default.aspx

01.<asp:LinkButton ID="linkBtnExportToExcel" runat="server" OnClick="linkBtnExportToExcel_Click">Export to Excel</asp:LinkButton>
02. 
03.  <telerik:RadGrid AutoGenerateColumns="false" ID="rgInvoices"
04.      AllowFilteringByColumn="false" AllowSorting="True"
05.      EnableLinqExpressions="false"
06.      ClientSettings-EnableAlternatingItems="false"
07.      GroupingSettings-CaseSensitive="false"
08.      AllowPaging="true" AllowCustomPaging="true" PageSize="20" runat="server"
09. 
10.      OnNeedDataSource="rgInvoices_NeedDataSource"
11.      OnItemDataBound="rgInvoices_ItemDataBound"
12.      OnItemCommand="rgInvoices_ItemCommand"
13.      OnSortCommand="rgInvoices_SortCommand">
14. 
15.      <GroupingSettings CaseSensitive="false"></GroupingSettings>
16.      <ClientSettings EnableRowHoverStyle="true"></ClientSettings>
17. 
18.      <MasterTableView AutoGenerateColumns="false" AllowFilteringByColumn="false" ShowFooter="false" DataKeyNames="EmployeeID,HiredDate,Employee">
19. 
20.          <Columns>
21.              <telerik:GridBoundColumn UniqueName="Employee" DataField="Employee" HeaderText="Employee" ShowFilterIcon="false" AllowFiltering="false" AutoPostBackOnFilter="true" DataFormatString="{0:@}">
22. 
23.              </telerik:GridBoundColumn>
24.              <telerik:GridBoundColumn UniqueName="HiredDate" DataField="HiredDate" HeaderText="Hired Date"
25.                  DataFormatString="{0:dd/MM/yyyy}" ShowFilterIcon="false" AllowFiltering="false" AutoPostBackOnFilter="true">
26.              </telerik:GridBoundColumn
27.          </Columns>
28. 
29.          <HeaderStyle CssClass="RadGrid-HeaderStyle" Font-Bold="true" />
30.          <ItemStyle CssClass="RadGrid-ItemStyle" />
31.          <AlternatingItemStyle CssClass="RadGrid-AlternatingItemStyle" />
32.      </MasterTableView>
33.  </telerik:RadGrid>

 

And Default.aspx.vb

01.Public Class _Default
02.    Inherits System.Web.UI.Page
03.    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
04. 
05.    End Sub
06. 
07.    Protected Sub rgInvoices_NeedDataSource(sender As Object, e As Telerik.Web.UI.GridNeedDataSourceEventArgs)
08.        rgInvoices.DataSource = GetGridSource()
09.    End Sub
10. 
11.    Protected Sub rgInvoices_ItemDataBound(sender As Object, e As Telerik.Web.UI.GridItemEventArgs)
12. 
13.    End Sub
14. 
15.    Protected Sub rgInvoices_ItemCommand(sender As Object, e As Telerik.Web.UI.GridCommandEventArgs)
16. 
17.    End Sub
18. 
19.    Protected Sub rgInvoices_SortCommand(sender As Object, e As Telerik.Web.UI.GridSortCommandEventArgs)
20. 
21.    End Sub
22. 
23.    Protected Sub linkBtnExportToExcel_Click(sender As Object, e As EventArgs)
24.        Me.rgInvoices.ExportSettings.Excel.Format = GridExcelExportFormat.Biff
25.        Me.rgInvoices.ExportSettings.IgnorePaging = True
26.        Me.rgInvoices.ExportSettings.ExportOnlyData = True
27.        Me.rgInvoices.ExportSettings.OpenInNewWindow = True
28.        Me.rgInvoices.ExportSettings.FileName = "ExportExcelDemo"
29.        Me.rgInvoices.MasterTableView.ExportToExcel()
30.    End Sub
31. 
32.    Private Function GetGridSource() As DataTable
33.        Dim dataTable As DataTable = New DataTable()
34. 
35.        Dim column As DataColumn = New DataColumn()
36.        column.DataType = Type.[GetType]("System.Int32")
37.        column.ColumnName = "EmployeeID"
38.        dataTable.Columns.Add(column)
39. 
40.        column = New DataColumn()
41.        column.DataType = Type.[GetType]("System.DateTime")
42.        column.ColumnName = "HiredDate"
43.        dataTable.Columns.Add(column)
44. 
45.        column = New DataColumn()
46.        column.DataType = Type.[GetType]("System.String")
47.        column.ColumnName = "Employee"
48.        dataTable.Columns.Add(column)
49. 
50.        Dim PrimaryKeyColumns As DataColumn() = New DataColumn(0) {}
51.        PrimaryKeyColumns(0) = dataTable.Columns("EmployeeID")
52.        dataTable.PrimaryKey = PrimaryKeyColumns
53. 
54. 
55.        Dim row As DataRow = dataTable.NewRow()
56.        row("EmployeeID") = 2
57.        row("HiredDate") = New Date(2019, 7, 1)
58.        row("Employee") = "Tina Bush"
59.        dataTable.Rows.Add(row)
60. 
61.        Return dataTable
62.    End Function
63. 
64.End Class

 

Thanks for your support!

Eyup
Telerik team
 answered on 30 Jul 2019
2 answers
173 views

Hello,

We have this issue in our developpement on WebForms ASP.NET 4.5.2 (VS2015 Update 3) with last version 2019.2 with this configuration  :

In master.page :

        <script> 
            function RadPan_ItemClicking(sender, eventArgs)
            {
                var oItem = eventArgs.get_item();
                if (oItem.get_expanded()) {
                    oItem.collapse();
                }
                else
                    oItem.expand();
                var sUrl = "";
                var aAttributes = oItem._attributes;
                if (aAttributes.get_count())
                    sUrl = aAttributes.getAttribute("URL");
                if (IsDefined(sUrl)) 
                {
                    if (sUrl!="")
                    {
                        var oPanelBar = oItem.get_panelBar();
                        oPanelBar._postback();
                        eventArgs.set_cancel(false);
                        return;
                    }
                }
                eventArgs.set_cancel(true);
            }
        </script>

<telerik:RadPanelBar runat="server" ID="RadPan" ExpandMode="SingleExpandedItem" PersistStateInCookie="True"
                                    onclientitemclicking="RadPan_ItemClicking"
                                    ViewStateMode="Enabled"> 
                                    <CollapseAnimation Duration="100" Type="None" />
                                    <ExpandAnimation Duration="100" Type="None" />
</telerik:RadPanelBar>

--------------------------

It's a manual binding with 3 level of RadPanelItem, 

We don't use NavigateUrl property but we use OnItemClick event to check data in session before redirect

All RadPanelItems have URL Attribute that is read from OnItemClick  event

The behind Code IS NOT in master page BUT in child Page named BasePage (it's inherit WebPage for all pages of project)

Sample of BasePage.aspx.cs

protected override void OnLoad(EventArgs e)
{

_masterPage = Master as MyMaster;

RadPanelBar oRadPan = _masterPage.FindControl("RadPan") as RadPanelBar;

..... (Manual Binding without datasource)

}

To solve this issue temporarely, we use this Javascript code below BUT it's not clean :

$(function () {

       if (Telerik.Web.Browser.edge) {
            with (window)
                if (!location.href.contains("#") && !location.href.contains("?")) {
                    open(location.href + "?", "_blank");
                    close();
                }
        }
        else {
            if (sPathname.contains("index.aspx"))
                with (window.location)
                    if (!href.contains("#")) {
                        replace(href + "#");
                        reload();
                    }
        }
 });

 

Peter Milchev
Telerik team
 answered on 29 Jul 2019
4 answers
540 views
How to align a filter control centrally?
stephane
Top achievements
Rank 1
 answered on 29 Jul 2019
3 answers
118 views

Hello

We have a requirement to do the following.  Can you please tell me whether it is doable (or how much of it is doable) at the moment using Telerik Diagram.  If it is, can you please point me to a starting point?

So we need to --

- allow user to drag and drop blocks into a canvas

- be able to relate blocks

- have a popup appear when relating two blocks to allow input of one or more attributes

- allow editing of relationship by may be double clicking on the relational lines

- save diagram on a web page

- export diagram to excel

- have an auto-layout button option or allow user to manually move boxes around

- allow user to color code blocks based on some attribute

 

I did find a page

https://demos.telerik.com/aspnet-ajax/diagram/examples/interactions/defaultcs.aspx

 

that does some of what we want but not everything.

 

Any help will be appreciated.

Thank you

Sandhia

Vessy
Telerik team
 answered on 29 Jul 2019
1 answer
108 views

Hi,

Is there a way to chose chart culture depending on session value.

Something in Jquery, such as:

<script type="text/javascript" src="cul/kendo.culture.sv-SE.min.js"></script>
    <script type="text/javascript" src="cul/kendo.culture.en-US.js"></script>
  <script>
     function getit() {
         var lang =$('#<%=hfv.ClientID%>').html();
          if (lang = "sv-SE") {
               kendo.culture("sv-SE");
              alert("sv");
           }
           else {
               kendo.culture("en-US");
              alert("en");
          }
     }
    onload=getit;
    </script>

 

The problem with the above, is that it dos not work.

Any idea how to do that.

Regards,

Omar

 

Omar
Top achievements
Rank 1
 answered on 27 Jul 2019
4 answers
309 views
Hi, 
I would like to know how can we set Culture of RadHtmlChart in backend. Since based on the location the cultureinfo varies dynamically, I want to assign the cultureinfo in backend. And more over I wanted to know how can we set a customized culture to RadHtmlChart? 
Omar
Top achievements
Rank 1
 answered on 27 Jul 2019
1 answer
252 views

Good morning,

I am using radScheduler to schedule appointments for employees. Employees have different work schedules each day so I am highlighting their available slots using TimeSlotCreated. Everything works perfectly except for when I try to edit an appointment, all the highlighting disappears. Attached are some images of the process. You can see Jim Bergland is available from 9:00AM to 5:00PM and the light blue background is displaying for him but as soon as I try to edit any of the two existing appointments the background color in the slots is removed.

I know this fact about TimeSlotCreated: "The TimeSlotCreated event is not fired after the advanced edit form is opened (it fires before that, and rendering the advanced form renders the scheduler anew). Thus, customizations for the time slots made in the handler are not rendered while the advanced edit form is visible."

Is there any other way to achieve the time slot shading during the appointment edits?

 

 

Peter Milchev
Telerik team
 answered on 26 Jul 2019
1 answer
139 views

Not sure if this is a RadWindow or RagGrid issue, but issue is affecting the RagGrid, however this issue is limited to viewing the page in Internet Explorer only (Chrome and Edge work). 

When I open a URL with a RadGrid in a RadWindow, the embedded icons (add, refresh, edit, delete, etc.) are not visible.  If I open the exact URL directly in the browser I see the icons.  I understand these images are actually fonts and there may be issues with these fonts in IE, but this only happens when the URL is displayed in a RadWindow.

Is there a solution or work-around?

Rumen
Telerik team
 answered on 26 Jul 2019
1 answer
128 views

When I enable lightweight render globally within my app, it appears my page CSS which controls layout seems to be ignored.

How do I force the controls to use the CssClass settings I have set? 

Rumen
Telerik team
 answered on 26 Jul 2019
Narrow your results
Selected tags
Tags
+? more
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?