Desktop grid - Deleting a row programatically

Aspose.Cells Product Family
1

Hi Amjad

How can we delete/remove a row programatically from aspose grid?
e.g. grdDataEntry.worksheets(0).rows(0).remove or something like that

2

Hi,

Please use Worksheet.RemoveRow method for your task.

e.g

'To delete a row

grdDataEntry.Worksheets(0).RemoveRow(0)

'To delete a column

grdDataEntry.Worksheets(0).RemoveColumn(0)

Thank you.

3

Hi Amjad

Thanks for the quick response.

4

Hi Amjad



I am facing some issues with Formulas, while deleting rows. Find the attached sample code and screen shots.



Kindly look into it.



Thanks and Regards

Sukhminder Singh

5

Hi Sukhminder,

Thanks for providing us the template project.

Well, I have checked your project with the screenshot doc. For scenario1 (deleting the third row), I think it works fine as it should give #Ref error in M2 cell. If you could implement this in MS Excel manually, it will also produce this error.

However, for scenario 2 (deleting the 4th row), I can find the issue, here it should also give the #Ref error as MS Excel does this.

We will look into your issue to figure it out and get back to you soon.

Thank you.

6

Hi Sukhminder,

Please try the attached fix v<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" />2.0.0.32. We have fixed your issues according to MS Excel standards.

For scenario 1, the correct updated formula of M2 should be “=#REF+M3” when clicking “Delete M3” button. Now it works as expected.

For scenario 2, the correct updated formula of M2 should be “=M3 + #REF!” when clicking “Delete M4” button. Now it works fine same as MS Excel.

Thank you.

7

The issues you have found earlier (filed as 8085) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.