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.
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
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?
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
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);
}
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.
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
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
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();
}
}`
<
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
>
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.