We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

ImportTwoDimensionArray seems to invalidate some cells

Hello,

I'm not sure whether I'm doing something wrong, but this looks like a bug to me. After doing some particular manipulations on the grid, there are some cells which I can no longer update. Attempts to update the value or formula using Formula, R1C1Formula, PutValue() all give a Null Reference Exception.

I have narrowed down the manipulations to the following example. I realize I could make this function work by doing things differently, but this is just to illustrate the problem - it is greatly simplified from what my real code does. I see no reason why these steps should cause an error. I'm using version 5.0.0.10 of Aspose.Cells.

public void Test()

{

var data = new object[1, 1];

data[0, 0] = 1;

var workbook = new Workbook();

var grid = workbook.Worksheets[0];

//first set up a formula referencing cell above this one

grid.Cells[36, 16].R1C1Formula = "=R[-1]C";

grid.Workbook.CalculateFormula(false);

//then overwrite with data

grid.Cells.ImportTwoDimensionArray(data, 36, 16);

grid.Workbook.CalculateFormula(false);

//now the referenced cell is messed up

grid.Cells[35, 16].PutValue("3"); //gives a null ref exception

}

Hi,

We have found the issue after initial test. We will fix it soon.

Hi,

Please try the attached version, we have fixed the issue.

Thanks.

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


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