We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Problem with insert row

Thread ID:





100670 Aug 24,2011 04:12 AM UTC Sep 6,2011 09:26 AM UTC WinForms 5
Tags: XlsIO
Nguyen Duy Hung
Asked On August 24, 2011 04:12 AM UTC

I have used XLSIO create report.
But When I insert row in Activate Sheet Then Validate in file Excel of row begin with row index = row activate + n row insert is delete.
Help me

Manikandan M [Syncfusion]
Replied On August 24, 2011 09:35 AM UTC

Hi Nguyen Duy Hung,

Thanks for your interest in Syncfusion Product.

I have opened one sample excel file. In sample file, in active sheet, Active row index is 6. I tried to insert the row at index 1. Row is inserted at index 1 correctly and no deletion of rows occurs.I have attached the sample file. Please try this at your side and let us know whether this helps you.



Nguyen Duy Hung
Replied On August 25, 2011 03:03 PM UTC

Example: I have file Excel with 20 rows

Name Range with name = "DanhMuc" contains data with Ranged: A1:C10

column B contains validation

When I insert with statement

IWorksheet sheet = workbook.ActiveSheet;

Then validate of row from 5 to 12 is delete.
Help me

And I have question
I have write Function in Excel to insert row and copy formula
Sub InsertRow()
Dim Rng, n As Long, k As Long
Application.ScreenUpdating = False
Rng = InputBox("Enter number of rows required.")
If Rng = "" Then Exit Sub
Range(ActiveCell, ActiveCell.Offset(Val(Rng) - 1, 0)).EntireRow.Insert
'need To know how many formulas To copy down.
'Assumesfrom A over To last entry In row.
k = ActiveCell.Offset(-1, 0).Row
n = Cells(k, 256).End(xlToLeft).Column
Range(Cells(k, 1), Cells(k + Val(Rng), n)).FillDown
End Sub

I want convert to XLSIO

Help me
Because I can't find Properties ActiveCell and method Offset of Range

Manikandan M [Syncfusion]
Replied On August 30, 2011 06:23 AM UTC

Hi Nguyen Duy Hung,

Thank you for your patience.

We are not able to see the reported issue from our side. We have created one sample for inserting row and for copying formula to newly inserted row. And we have attached the sample below . Please try this at your side and let us know if this helps you.



Nguyen Duy Hung
Replied On September 2, 2011 12:34 PM UTC

I have using sample with template you -> ok but when I using template of me -> not ok

When I insert row with statement sheet.InsertRow(22,5) then Insert OK But validate row is delete with row between 29 and 60.

Help me
I have attach template


Sridhar [Syncfusion]
Replied On September 6, 2011 09:26 AM UTC

Hi Nguyen,

Thank you so much for the udpate.

We are able to reproduce the reported issue at our side and suspect this could be a defect.

So we request you to open a new direct-trac incident with a simple issue reproducing sample for further follow up on this issue.

Direct-Trac Link:

Please let us know if you require any further clarifications.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon