Help! Single cell owning > 1024 chars caused exception

dotNeter · 07-10-2006, 03:39 AM

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(String memberName,
BindingFla
gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.get_FormulaR1C1()

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!

Peter T · 07-10-2006, 04:54 AM

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" <Buddhist.CHinA@gmail.com> wrote in message
news:1152516763.399795.30680@s13g2000cwa.googlegroups.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(String memberName,
> BindingFla
> gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
> at Microsoft.Office.Interop.Excel.Range.get_FormulaR1C1()
>
> 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!
>

dotNeter · 07-10-2006, 09:44 AM

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" <Buddhist.CHinA@gmail.com> wrote in message
> news:1152516763.399795.30680@s13g2000cwa.googlegroups.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(String memberName,
> > BindingFla
> > gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
> > at Microsoft.Office.Interop.Excel.Range.get_FormulaR1C1()
> >
> > 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!
> >

Peter T · 07-10-2006, 10:34 AM

> 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" <Buddhist.CHinA@gmail.com> wrote in message
news:1152539113.956831.318140@b28g2000cwb.googlegroups.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" <Buddhist.CHinA@gmail.com> wrote in message
> > news:1152516763.399795.30680@s13g2000cwa.googlegroups.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(String memberName,
> > > BindingFla
> > > gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
> > > at Microsoft.Office.Interop.Excel.Range.get_FormulaR1C1()
> > >
> > > 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!
> > >
>

dotNeter · 07-11-2006, 10:20 PM

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" <Buddhist.CHinA@gmail.com> wrote in message
> news:1152539113.956831.318140@b28g2000cwb.googlegroups.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" <Buddhist.CHinA@gmail.com> wrote in message
> > > news:1152516763.399795.30680@s13g2000cwa.googlegroups.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(String memberName,
> > > > BindingFla
> > > > gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
> > > > at Microsoft.Office.Interop.Excel.Range.get_FormulaR1C1()
> > > >
> > > > 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!
> > > >
> >

Peter T · 07-12-2006, 04:05 AM

> 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" <Buddhist.CHinA@gmail.com> wrote in message
news:1152670420.307254.217900@i42g2000cwa.googlegroups.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" <Buddhist.CHinA@gmail.com> wrote in message
> > news:1152539113.956831.318140@b28g2000cwb.googlegroups.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" <Buddhist.CHinA@gmail.com> wrote in message
> > > > news:1152516763.399795.30680@s13g2000cwa.googlegroups.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(String
memberName,
> > > > > BindingFla
> > > > > gs flags, Object target, Int32[] aWrapperTypes, MessageData&
msgData)
> > > > > at Microsoft.Office.Interop.Excel.Range.get_FormulaR1C1()
> > > > >
> > > > > 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!
> > > > >
> > >
>

Peter T · 07-12-2006, 04:10 AM

> 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" <Buddhist.CHinA@gmail.com> wrote in message
news:1152670420.307254.217900@i42g2000cwa.googlegroups.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" <Buddhist.CHinA@gmail.com> wrote in message
> > news:1152539113.956831.318140@b28g2000cwb.googlegroups.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" <Buddhist.CHinA@gmail.com> wrote in message
> > > > news:1152516763.399795.30680@s13g2000cwa.googlegroups.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(String
memberName,
> > > > > BindingFla
> > > > > gs flags, Object target, Int32[] aWrapperTypes, MessageData&
msgData)
> > > > > at Microsoft.Office.Interop.Excel.Range.get_FormulaR1C1()
> > > > >
> > > > > 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!
> > > > >
> > >
>

Peter T · 07-12-2006, 04:25 AM

> 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" <Buddhist.CHinA@gmail.com> wrote in message
news:1152670420.307254.217900@i42g2000cwa.googlegroups.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" <Buddhist.CHinA@gmail.com> wrote in message
> > news:1152539113.956831.318140@b28g2000cwb.googlegroups.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" <Buddhist.CHinA@gmail.com> wrote in message
> > > > news:1152516763.399795.30680@s13g2000cwa.googlegroups.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(String
memberName,
> > > > > BindingFla
> > > > > gs flags, Object target, Int32[] aWrapperTypes, MessageData&
msgData)
> > > > > at Microsoft.Office.Interop.Excel.Range.get_FormulaR1C1()
> > > > >
> > > > > 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!
> > > > >
> > >
>