Hi, I am getting the following error:
"Aspose.Excel cannot shift nonblank cell off the worksheet."
Could someone explain what exactly this refers to. How does one go about fixing/avoiding it?
Thanks, Ilia
Hi Ilia,
Do you call InsertRow or InsertColumn method in your program?
In the following case you may meet this error:
You have put some data, say “hello world”, in column IV. And then you call InsertColumn method. The error will occur.
You can also test it in MS Excel:
* Put “hello world” in cell IV1
* Insert column at Colum IU
Then you will get a prompt error.