Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 he http://groups.google.ro/group/micros...a77ec8cd6ad468 But no solution :( Any help? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Exception from HRESULT: 0x800AC472 | Excel Discussion (Misc queries) | |||
SUMIF with Exception of multiple Item | Excel Discussion (Misc queries) | |||
Error 0x800A03EC trying to set range value | New Users to Excel | |||
Exception Occurred excel form vba | Excel Discussion (Misc queries) | |||
Excel.Range.Name gives error an exception | Excel Discussion (Misc queries) |