Error columnindex after copy a row

[Gert]

Hi,

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:

ControlCenter2.radSpreadsheet.Workbook.ActiveWorksheet.Columns.Remove(200, columns.Count-200);

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.

 

BR Gert

 

 

[Dimitar]

Hello Gert,

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. 

Regards,
Dimitar
Progress Telerik

[Gert]

Hi Dimitar,

with an new file without formatting it is working. Can you pls try with my file? (rename smal.jpg to smal.xlsx)

 

Tanks for your help!!!!!!!

 

[Dimitar]

Hi Gert,

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.

Regards,
Dimitar
Progress Telerik

[Gert]

Hi Dimitar,

thanks a lot for your good aswer, the workaround is working perfect for me.

Have a nice day,
Gert

[Dimitar]

Hi Gert,

I am glad that this wors for you. Do not hesitate to contact us if you have other questions.

Regards,
Dimitar
Progress Telerik