Duplicated
Last Updated: 12 Jul 2024 14:19 by ADMIN
Created by: Jeremy
Comments: 0
Category: Spreadsheet
Type: Feature Request
0

I'm attempting to create a custom spreadsheet tool that updates the values of the cells the user has selected. The problem is that I can't get the current cell selection from the TelerikSpreadsheet control.

I attempted to get it by exporting it from the control and importing it into an XlsxFormatProvider. I thought what I needed might be in the 'Worksheet.ViewState.SelectionState.ActiveCellIndex' object but it always seems to be set to Cell[0,0]. Is there somewhere else I can find the selection?

The following code works but always updates A1.

byte[] excelFileContent = await SpreadsheetRef.ExportToExcelAsync();
XlsxFormatProvider formatProvider = new();

Workbook workbook = formatProvider.Import(excelFileContent);
Worksheet worksheet = workbook.ActiveWorksheet;

CellIndex cellRange = worksheet.ViewState.SelectionState.ActiveCellIndex;
worksheet.Cells.GetCellSelection(cellRange).SetValue("Selected!!");

 byte[] newExcelFileContent;
 using (MemoryStream ms = new())
 {
   formatProvider.Export(workbook, ms);
   newExcelFileContent = ms.ToArray();
 }

 FileData = newExcelFileContent; 
 await InvokeAsync(StateHasChanged);

Unplanned
Last Updated: 11 Jul 2024 08:58 by ADMIN
Created by: Jeremy
Comments: 2
Category: Spreadsheet
Type: Feature Request
1

I'm having the same issue that was fixed in the Telerik UI for WinForms RadSpreadsheet. When loading the workbook into a Blazor UI TelerikSpreadsheet control, the validation dropdown shows fine when exported to Excel but the Telerik control doesn't show the dropdown. However, it only allows you to type values in the supplied validation list as expected.

RadSpreadsheet: ListDataValidation not working, dropdown does not appear in control (telerik.com)

ListDataValidationRuleContext context = new(worksheet, ri, ci)
{
  InputMessageTitle = "Restricted input",
  InputMessageContent = "The input is restricted to the week days.",
  ErrorStyle = ErrorStyle.Stop,
  ErrorAlertTitle = "Wrong value",
  ErrorAlertContent = "The entered value is not valid. Allowed values are the week days!",
  InCellDropdown = true,
  Argument1 = "Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday"
};

cell.SetDataValidationRule(new ListDataValidationRule(context));
Unplanned
Last Updated: 24 Jun 2024 11:22 by ADMIN
I MUST use Strict CSP with Telerik.UI for Blazor. Please provide a path forward for me to be able to use versions 6+. Maybe offer a reduced distro without the Spreadsheet component?
Unplanned
Last Updated: 12 Jun 2024 10:09 by Roy
Created by: Roy
Comments: 0
Category: Spreadsheet
Type: Feature Request
2

Please add support for protected worksheets and protected workbooks.

Unplanned
Last Updated: 07 Jun 2024 07:46 by Federico
Created by: Federico
Comments: 0
Category: Spreadsheet
Type: Feature Request
4
Expose a way to know which cells are selected, or even better, read the values of the selected cells.
Unplanned
Last Updated: 05 Jun 2024 07:20 by ADMIN
Created by: Diana
Comments: 0
Category: Spreadsheet
Type: Feature Request
4
I would like to be able to save the data in the spreadsheet on an OnChange event when the data in a cell is changed. I don't see any event like this on the control and am wondering if this is something planned for the future.
Unplanned
Last Updated: 22 May 2024 08:23 by Markus
Created by: Markus
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
In Excel, you can add a dropdown to edit the value of a cell. I want the same behavior in the Spreadsheet component.