N
nano2k
Hi
The code that generates this error is the following:
public void SetBuffer2(object[,] buf, int firstRow, int firstColumn,
int upperBound0, int upperBound1, int wSheetIndex)
{
Excel.Worksheet wSheet = this.GetWorkSheet(wSheetIndex);
if (wSheet!=null)
{
Excel.Range range = (Excel.Range)wSheet.Cells[firstRow,
firstColumn];
range = range.get_Resize(upperBound0, upperBound1);
range.Value2 = buf; // <<<--- THIS LINE GENERATES THE ERROR
}
}
The bounds of the arrays are ok.
It seems that the error is raised because of some value that is
"longer" than accepted by the cell ( ? )
I'm trying to insert an approx 13KB -length text into some cell. I
mean, the value corresponding to some cell is a 13KB sized string.
If I truncate the string for that particular cell, to under 1KB,
everything goes with no problems at all.
I also found this problem discussed here:
http://groups.google.ro/group/micro...580a6fca825/98a77ec8cd6ad468#98a77ec8cd6ad468
But no solution
Any help?
Thanks in advance.
The code that generates this error is the following:
public void SetBuffer2(object[,] buf, int firstRow, int firstColumn,
int upperBound0, int upperBound1, int wSheetIndex)
{
Excel.Worksheet wSheet = this.GetWorkSheet(wSheetIndex);
if (wSheet!=null)
{
Excel.Range range = (Excel.Range)wSheet.Cells[firstRow,
firstColumn];
range = range.get_Resize(upperBound0, upperBound1);
range.Value2 = buf; // <<<--- THIS LINE GENERATES THE ERROR
}
}
The bounds of the arrays are ok.
It seems that the error is raised because of some value that is
"longer" than accepted by the cell ( ? )
I'm trying to insert an approx 13KB -length text into some cell. I
mean, the value corresponding to some cell is a 13KB sized string.
If I truncate the string for that particular cell, to under 1KB,
everything goes with no problems at all.
I also found this problem discussed here:
http://groups.google.ro/group/micro...580a6fca825/98a77ec8cd6ad468#98a77ec8cd6ad468
But no solution
Any help?
Thanks in advance.