Telerik Forums
UI for WPF Forum
1 answer
252 views

Hello, I am filling my spreadsheet programmatically.

I need the cell "name" to use it in a formula.. For example:

 

string formula = "=SUM(" + worksheet.Cells[row, column].GETNAME() + ";" + worksheet.Cells[row, column + 1].GETNAME() + ")";

 * This GETNAME method should return "A1", "B1", "C1", etc...

 

 And then, set the formula value to another cell: 

worksheet.Cells[row + 3, column].SetValue(formula);

 

 Is this the best way of doing this? Remember that the variables 'row' and 'column' are set before in a logic that I have to use. So it can change.

Deyan
Telerik team
 answered on 16 Feb 2016
1 answer
62 views

Hi,

i'm trying to adjust the multi selection behavior of the RadGridView to fit our customers needs.

In a short: A single click should behave like control-click.

The grid is read-only and only used for selection & filtering purposes.
It has a couple of columns, including a GridSelectColumn on the left side.

A "mouse"-user needs to hit the small check box on the left side, otherwise the selection is lost.
Or needs to press "Control" all the time which is neither intuitive nor convenient.

Is there a possibility to change the default selection behavior of the GridView in such a way ?

Thanks in advance,

Thorsten Klingert

 

 

   - The Single

 

Thorsten
Top achievements
Rank 1
 answered on 16 Feb 2016
1 answer
69 views

We presently have a .NET application which displays a diagram from an Oracle data source and a .NET program. Attached is a screenshot of the user interface with the diagram.

The goal is to provide the users the ability to dynamically resize the various 'rectangles' in the diagram, by dragging the horizontal and vertical lines. As an example, in the attached diagram page 2, we'd like to expand the TIG area from 33.33% to 50% by dragging the vertical line that separates it from General Reinsurance Corp.

As an example we would draw a vertical splitter line/object at the border and constrain the drag horizontally. When the splitter is dragged in either direction it sends a message to the adjacent object to resize and change value.

Question is are there any controls currently offered by Telerik out of the box that we could use to accomplish this?

Martin Ivanov
Telerik team
 answered on 15 Feb 2016
1 answer
103 views

HI, 

 

I am using telerik gridview. And to render 8000+ records  its take 3-4 sec.

Its has 25+ columns and many columns having hyperlink to perform some action.

Please let us know is there any way improve the performance. With keeping all existing functionality.

 

Regards

Prashant

 

 

Dilyan Traykov
Telerik team
 answered on 15 Feb 2016
2 answers
1.1K+ views

Hello,

 i try to use the MapItemsRequest with the MapPolyline and i have this issue: The calling thread must be STA, because many UI components require this.

public void MapItemsRequest(object sender, MapItemsRequestEventArgs eventArgs)
        {
             
            double minZoom = eventArgs.MinZoom;
            Location upperLeft = eventArgs.UpperLeft;
            Location lowerRight = eventArgs.LowerRight;
 
            if(minZoom == 10){
                //GET INFORMATION FROM URL (DownloadString - JSON and parse information)
                var points = new LocationCollection();
                foreach (var coord in feature["geometry"]["coordinates"])
                {
                  points.Add(new Location((double) coord[1], (double) coord[0]));
                }
 
                var _polyline = new MapPolyline
                {
                   Points = points,
                   Stroke = new SolidColorBrush(Colors.Brown),
                   Name = "id" + feature["_id"],
                   StrokeThickness = 3
                };
 
                FeaturesList.Add(_polyline);
                eventArgs.CompleteItemsRequest(_trackList);
            }

Petar Mladenov
Telerik team
 answered on 15 Feb 2016
4 answers
210 views

Hi:

I've pretty much gathered that this isn't supported natively, but surely there's a way to make it work with expressions or event handling. Or something.

Each row in my grid has a Credit column and a Debit column. It needs to have a Balance column that takes the net of the Credit and Debit columns in a row and then adds that value to the balance of all the rows before it. I suppose the quintessential example of this functionality would be a checkbook register. (

Credit - Debit - Balance

0 - 100 - -100

50 - 0 - -50

200 - 0 - 150

 

Thanks for the help.

Mark
Top achievements
Rank 1
 answered on 12 Feb 2016
5 answers
113 views

Hi, i have test the sample on the sdk and have the same problem in my test project:

If the grid does not have the vertical scrollbar, all rows are visible and selected properly when I press the check box select all or deselect all.

But if the vertical scroll bar is present, not all rows are selected or deselected, casually are sometimes not select or deselect all lines

The Image Cattura1 is Ok all row is visible and check all or uncheck all work OK.

In the Image cattura 2 i show only 2 row and i uncheck all row, but the row not visible (Image Cattura3) are checked.

 I test the version trial 2016.1.112

 

Thanks

Aurelio

 

Stefan
Telerik team
 answered on 12 Feb 2016
3 answers
54 views

Hi guys, i have big problem with SplineSeries on RadCartesianChart.

I have DateTimeContinuousAxis on my X axis and LinearAxis on my Y axis.

I want to make average line using SplineSeries but i have problem with drawing it properly.

In attach i created 2 series of data:
LineSeries (BlackLine) and SplineSeries (RedLine)

Both of them are binded to the same collection of data.

And now, i don't know why, SplineSeries go back and then forward, how i can archive line like LineSeries but more rounded? (I Want to SplineSeries go only forward).

I founded this link on Google but it's doesnt work:
http://marketplace.telerik.com/forums/spline-series---only-go-forward

Dinko | Tech Support Engineer
Telerik team
 answered on 12 Feb 2016
1 answer
228 views
`TelerikControls` has a bug and sometimes the `GridView` displays  empty `ComboBoxCells`. In order to fix this I followed their steps here http://docs.telerik.com/devtools/wpf/controls/radgridview/troubleshooting/blank-cells.html and I have to point the `ItemsSource` to a static resource. 

That method works perfectly if the resource never changes, but mine can change depending on a `ComboBoxSelection` within the `DataGrid`. I'm wondering how do I update my `StaticResource` collection in the UI.

I've tried this method http://stackoverflow.com/questions/4438876/wpf-refresh-staticresource but it never changed the collection in the UI. 

**RelationshipEditor.xaml.cs**

private void OnSelectionChanged(object sender, SelectionChangedEventArgs e)
{
    var radcomboBox = e.OriginalSource as RadComboBox;
    if (radcomboBox != null)
    {
        RadComboBox comboBox = (RadComboBox)e.OriginalSource;
        (FindResource("MyChannelDataProvider") as ObjectDataProvider).Refresh();
    }
}`


**RelationshipEditor.xaml**

<ObjectDataProvider x:Key="MyChannelDataProvider" ObjectType="{x:Type Loans:LoanViewModel}">
 </ObjectDataProvider>
 
<Telerik:GridViewComboBoxColumn Header="Relationship"
                                ItemsSource="{Binding SelectedRelationship.GridRelationshipTypes, Source={StaticResource MyChannelDataProvider}}" 
                                DataMemberBinding="{Binding RelationshipType}"
                                SelectedValueMemberPath="Id"
                                DisplayMemberPath="Name">
</Telerik:GridViewComboBoxColumn>


I've set break points for `GridRelationshipTypes` and I can see it is getting the correct collection. If I remove static resource, the code works perfectly but it may still exhibit the telerik bug. 
Stefan
Telerik team
 answered on 12 Feb 2016
5 answers
168 views

Hello,

I'm binding on a GridViewDataColumn a custom type using the DataMemberBinding attribute. Having the "Search as you type" feature enabled, the search is not performed on the column.

Which is the correct method to enable the "Search as you type" filter on a Data Column bound to a custom type?

Is there any mehtod to implement a custom logic?

 

Regards.

Maya
Telerik team
 answered on 12 Feb 2016
Narrow your results
Selected tags
Tags
+? more
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?