Problem with insert row

[Nguyen Duy Hung]

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]

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.

Thanks,
Manikandan.M




Sample_c984e17f.rar

[Nguyen Duy Hung]

Thanks.
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;
sheet.InsertRow(3,2);

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]

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.

Thanks,
Manikandan.M



Sample_InsertRow_92cca3e.zip

[Nguyen Duy Hung]

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





Sample_336b3079.rar

[Sridhar]

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:
https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents


Please let us know if you require any further clarifications.

Thanks,
Sridhar.S