Hi,
A simple example in C# using Aspose.Cells.GridDesktop.dll 8.6.2.0 generates an exception. I run under VS2008 net2.0 windows 7 pro 64bits. On a new doc or an imported one of any format.
The same occurs using the right click popup menu with “Insert Column”.
no problem with InsertRow()
namespace AsposeEvalNet
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void openExcelFileButton_Click(object sender, EventArgs e)
{
String strImportFileName;
DialogResult result = openFileDialog1.ShowDialog();
if (result == DialogResult.OK)
{
strImportFileName = openFileDialog1.FileName;
String extn = Path.GetExtension(strImportFileName);
if (extn == “.xml” || extn == “.xls” || extn == “.xlsx”)
{
textBox1.Text = strImportFileName;
gridDesktop1.ImportExcelFile(strImportFileName);
}
else
textBox1.Text = “MS-Excel file extension not supported (use .xml(2003) .xls .xlsx)”;
}
}
private void toolStripInsertCol_Click(object sender, EventArgs e)
{
gridDesktop1.Worksheets[0].InsertColumn(0);
}
}
}
As a related addition, I just discovered that RemoveRow(index) seems to remove the last row, no matter the value of index
Thanks
Daniel