The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
Hi If I want a column to use the same formula for all rows, adjusted by row number, what is the most efficient way to do this? For example B1 =A1 * 10 B2 =A2 * 10 ...
I am using the following code at present but wondered whether there is a better way? Maybe using relative refs?
With Me.GridControl1 .ColStyles(2).CellType = "FormulaCell"
Dim engine As GridFormulaEngine = CType(.CellModels("FormulaCell"), GridFormulaCellModel).Engine
For rowIndex As Integer = .Rows.HeaderCount To .RowCount - 1 Me.GridControl1(rowIndex + 1, 2).CellValue = engine.AdjustReferences("=A1 * 10", rowIndex, 0) Next