This is a migrated thread and some comments may be shown as answers.

Error columnindex after copy a row

5 Answers 23 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Gert
Top achievements
Rank 1
Gert asked on 30 Jan 2020, 10:27 AM

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

 

 

5 Answers, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 04 Feb 2020, 06:35 AM

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

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Gert
Top achievements
Rank 1
answered on 04 Feb 2020, 07:03 AM

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!!!!!!!

 

0
Accepted
Dimitar
Telerik team
answered on 04 Feb 2020, 12:45 PM

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

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Gert
Top achievements
Rank 1
answered on 05 Feb 2020, 03:28 PM

Hi Dimitar,

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

Have a nice day,
Gert

0
Dimitar
Telerik team
answered on 06 Feb 2020, 05:47 AM

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

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Spreadsheet
Asked by
Gert
Top achievements
Rank 1
Answers by
Dimitar
Telerik team
Gert
Top achievements
Rank 1
Share this question
or