in my radSpreadsheet I do this actions:
- insert an empty row (insertEmptyRow.jpg)
- than copy the hole row (copyRow.jpg)
- than paste it in the first cell of the before inserted row (pasteRow.jpg)
- and than I insert an empty row again --> An Error comes up (errorColumnIndex.jpg)
From this point on my Worksheet has this 16383 columns and I can not get rid of it.
What I tried so far wars:
but this had no effect, all the columns are still visible and scrollable.
When I try to delete this columns in GUI the next error occures: (delCol.jpg, errorNullRef.jpg)
Sorry for the german in pics.
Can you help?
Using telerik 2018 R2.
5 Answers, 1 is accepted
I was unable to reproduce this. I have recorded a small video that shows what I am doing. Could you please check it and let me know what I am missing?
In addtion, I checked our feedback portal for similar issues but I have not found any. This may be connected to a specific document. Can you check if this is reproducible with a blank document on your side?
Thank you in advance for your patience and cooperation.
Thanks for the sample document. I was able to reproduce the observed behavior. This happens because the column styles are defined by a range (see attached). This is considered an issue and I have logged it on our feedback portal. You can track its progress, subscribe to status changes and add your comment to it here. I have updated your Telerik points as well.
As a workaround I can suggest clearing the styles of the unused columns:
private void RadSpreadsheet_WorkbookChanged(object sender, EventArgs e)
var range = this.radSpreadsheet.Workbook.ActiveWorksheet.UsedCellRange;
this.radSpreadsheet.ActiveWorksheet.Columns[range.ColumnCount + 1, SpreadsheetDefaultValues.ColumnCount - 1].Clear(ClearType.All);
Should you have any other questions do not hesitate to ask.
thanks a lot for your good aswer, the workaround is working perfect for me.
Have a nice day,
I am glad that this wors for you. Do not hesitate to contact us if you have other questions.