Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Single cell owning 1024 chars caused exception
I found that if a single cell includes greater than 1024 chars, using
property Range.FormulaR1C1to read content from the cell must cause an exception, say System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT : 0x800A03EC at System.RuntimeType.ForwardCallToInvokeMember(Strin g memberName, BindingFla gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData) at Microsoft.Office.Interop.Excel.Range.get_FormulaR1 C1() However, same code, just after keeping chars less than 1024 in a single cell, everything is ok. Is it a Microsoft.Office.Interop.Excel implemenation error? I used MS Excel 11.0 Object Library. Thx in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Single cell owning 1024 chars caused exception
Cell's formula property cannot handle more than 1024. However a cell can
contain, but not display, up to 32k characters. Maybe you can read the ..Value property. Regards, Peter T "dotNeter" wrote in message ups.com... I found that if a single cell includes greater than 1024 chars, using property Range.FormulaR1C1to read content from the cell must cause an exception, say System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT : 0x800A03EC at System.RuntimeType.ForwardCallToInvokeMember(Strin g memberName, BindingFla gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData) at Microsoft.Office.Interop.Excel.Range.get_FormulaR1 C1() However, same code, just after keeping chars less than 1024 in a single cell, everything is ok. Is it a Microsoft.Office.Interop.Excel implemenation error? I used MS Excel 11.0 Object Library. Thx in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Single cell owning 1024 chars caused exception
Thx Peter.
I want the return type is Object, that is more easier for future processing. So I can't use Cells property to retreive the data. I'll have a try. BTW, I can't find any documentation describing Formula property cannot handle more than 1024 chars. Where is it? Undocumented? Peter T wrote: Cell's formula property cannot handle more than 1024. However a cell can contain, but not display, up to 32k characters. Maybe you can read the .Value property. Regards, Peter T "dotNeter" wrote in message ups.com... I found that if a single cell includes greater than 1024 chars, using property Range.FormulaR1C1to read content from the cell must cause an exception, say System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT : 0x800A03EC at System.RuntimeType.ForwardCallToInvokeMember(Strin g memberName, BindingFla gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData) at Microsoft.Office.Interop.Excel.Range.get_FormulaR1 C1() However, same code, just after keeping chars less than 1024 in a single cell, everything is ok. Is it a Microsoft.Office.Interop.Excel implemenation error? I used MS Excel 11.0 Object Library. Thx in advance! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Single cell owning 1024 chars caused exception
BTW, I can't find any documentation describing Formula property cannot
handle more than 1024 chars. Where is it? Undocumented? In 100's of threads in this ng and officially elsewhere, see for yourself in VBA Sub test() Dim rng As Range, s$ Set rng = ActiveCell s = "X" For i = 1 To 10 s = s & s Next Stop ' step through with F8 rng = s MsgBox Len(rng.FormulaR1C1) ' len 1024 no error rng = s & "a" MsgBox Len(rng.FormulaR1C1) ' ERROR cos len 1025 'drag cursor down to next line & continue with F8 rng = s & s & s & s & s & s & s & s MsgBox Len(rng.Value) ' 8192 End Sub Regards, Peter T "dotNeter" wrote in message oups.com... Thx Peter. I want the return type is Object, that is more easier for future processing. So I can't use Cells property to retreive the data. I'll have a try. BTW, I can't find any documentation describing Formula property cannot handle more than 1024 chars. Where is it? Undocumented? Peter T wrote: Cell's formula property cannot handle more than 1024. However a cell can contain, but not display, up to 32k characters. Maybe you can read the .Value property. Regards, Peter T "dotNeter" wrote in message ups.com... I found that if a single cell includes greater than 1024 chars, using property Range.FormulaR1C1to read content from the cell must cause an exception, say System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT : 0x800A03EC at System.RuntimeType.ForwardCallToInvokeMember(Strin g memberName, BindingFla gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData) at Microsoft.Office.Interop.Excel.Range.get_FormulaR1 C1() However, same code, just after keeping chars less than 1024 in a single cell, everything is ok. Is it a Microsoft.Office.Interop.Excel implemenation error? I used MS Excel 11.0 Object Library. Thx in advance! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Single cell owning 1024 chars caused exception
Thx again.
Another question. Which Office versions does this 1024 limitation apply to? All? And all languages? thx. Peter T wrote: BTW, I can't find any documentation describing Formula property cannot handle more than 1024 chars. Where is it? Undocumented? In 100's of threads in this ng and officially elsewhere, see for yourself in VBA Sub test() Dim rng As Range, s$ Set rng = ActiveCell s = "X" For i = 1 To 10 s = s & s Next Stop ' step through with F8 rng = s MsgBox Len(rng.FormulaR1C1) ' len 1024 no error rng = s & "a" MsgBox Len(rng.FormulaR1C1) ' ERROR cos len 1025 'drag cursor down to next line & continue with F8 rng = s & s & s & s & s & s & s & s MsgBox Len(rng.Value) ' 8192 End Sub Regards, Peter T "dotNeter" wrote in message oups.com... Thx Peter. I want the return type is Object, that is more easier for future processing. So I can't use Cells property to retreive the data. I'll have a try. BTW, I can't find any documentation describing Formula property cannot handle more than 1024 chars. Where is it? Undocumented? Peter T wrote: Cell's formula property cannot handle more than 1024. However a cell can contain, but not display, up to 32k characters. Maybe you can read the .Value property. Regards, Peter T "dotNeter" wrote in message ups.com... I found that if a single cell includes greater than 1024 chars, using property Range.FormulaR1C1to read content from the cell must cause an exception, say System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT : 0x800A03EC at System.RuntimeType.ForwardCallToInvokeMember(Strin g memberName, BindingFla gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData) at Microsoft.Office.Interop.Excel.Range.get_FormulaR1 C1() However, same code, just after keeping chars less than 1024 in a single cell, everything is ok. Is it a Microsoft.Office.Interop.Excel implemenation error? I used MS Excel 11.0 Object Library. Thx in advance! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Single cell owning 1024 chars caused exception
Which Office versions does this 1024 limitation apply to? All?
Excel 97 - 2003. Not sure about the new beta, earlier versions might be less, I forget. Even manually you cannot enter or edit a formula starting with an "=" over 1024. FWIW a formula can contain over 1024, but you cannot read or write it. Regards, Peter T "dotNeter" wrote in message oups.com... Thx again. Another question. Which Office versions does this 1024 limitation apply to? All? And all languages? thx. Peter T wrote: BTW, I can't find any documentation describing Formula property cannot handle more than 1024 chars. Where is it? Undocumented? In 100's of threads in this ng and officially elsewhere, see for yourself in VBA Sub test() Dim rng As Range, s$ Set rng = ActiveCell s = "X" For i = 1 To 10 s = s & s Next Stop ' step through with F8 rng = s MsgBox Len(rng.FormulaR1C1) ' len 1024 no error rng = s & "a" MsgBox Len(rng.FormulaR1C1) ' ERROR cos len 1025 'drag cursor down to next line & continue with F8 rng = s & s & s & s & s & s & s & s MsgBox Len(rng.Value) ' 8192 End Sub Regards, Peter T "dotNeter" wrote in message oups.com... Thx Peter. I want the return type is Object, that is more easier for future processing. So I can't use Cells property to retreive the data. I'll have a try. BTW, I can't find any documentation describing Formula property cannot handle more than 1024 chars. Where is it? Undocumented? Peter T wrote: Cell's formula property cannot handle more than 1024. However a cell can contain, but not display, up to 32k characters. Maybe you can read the .Value property. Regards, Peter T "dotNeter" wrote in message ups.com... I found that if a single cell includes greater than 1024 chars, using property Range.FormulaR1C1to read content from the cell must cause an exception, say System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT : 0x800A03EC at System.RuntimeType.ForwardCallToInvokeMember(Strin g memberName, BindingFla gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData) at Microsoft.Office.Interop.Excel.Range.get_FormulaR1 C1() However, same code, just after keeping chars less than 1024 in a single cell, everything is ok. Is it a Microsoft.Office.Interop.Excel implemenation error? I used MS Excel 11.0 Object Library. Thx in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get a cell in a sheet to show the last 1024 characters? | Excel Worksheet Functions | |||
Anyone notice excel search within cell limited to first 1024 chars | Excel Discussion (Misc queries) | |||
Beyond 1024 cell content limit | Excel Programming | |||
Display text 1024 characters in a cell | Excel Worksheet Functions | |||
extracting a single char from a string of chars | Excel Programming |