RTD EXCEL

[Ian]

Have completed development of an in-proc free threading model RTD server.
Works quite well and updates in real-time. Problems start to occur when
saving a spreadsheet with =RTD(...) formula in it and an excel add-in that
uses other COM objects. Excel loads back the formulae as =_xlfn.RTD(...),
which is bad as things do not load or initialize.

Any ideas?

 

[Jens Thiel]

Have completed development of an in-proc free threading model RTD server.
Works quite well and updates in real-time. Problems start to occur when
saving a spreadsheet with =RTD(...) formula in it and an excel add-in that
uses other COM objects. Excel loads back the formulae as =_xlfn.RTD(...),
which is bad as things do not load or initialize.

Hi Ian,

_xlfn.RTD is the name used internally, but I have only seen this appear on
Excel versions before 2002/XP which do not support the RTD function. Do you
save and load the document on the same computer with the same Excel version?

Jens.

 

[Ian]

Hi Jens,

Development of the RTD Server has been done on the single machine. All
documents have been created from scratch (no loading old documents).

I am running Excel 2003/Win2000.

If I do not use the other add-in, i.e. I only load and save RTD formula the
problem goes away.

However, I do not see why I should tell my clients that they cannot use
other add-ins or COM objects when using RTD, this will not wash with our
client base as we have a real-time excel contribution mechanism that works
along side the RTD server and this MUST be an add-in and it MUST use COM
objects.

 

[Jens Thiel]

Ian,

I can assure you that the combination of RTD and other add-ins is working. I
guess you have a side-effect in your code, e.g. a pointer or uninitialized
memory. Try something like Purify (and ignore the leaks inside Excel
itself). If this doesn't help, try the following combinations to see if the
problem persists (but make sure that you *thoroughly* remove any unwanted
add-ins before):

- Your RTD with a minimalistic add-in example
- Your add-ins with a minimalistic RTD example

Jens.

 

[ianbeard]

Have completed development of an in-proc free threading model RT
server.
Works quite well and updates in real-time. Problems start to occu
when
saving a spreadsheet with =RTD(...) formula in it and an excel add-i
that
uses other COM objects. Excel loads back the formulae a
=_xlfn.RTD(...),
which is bad as things do not load or initialize.

Any ideas?

I'm having exactly the same trouble. I cut my RTD server to bare-bones
It does nothing at all, simply returns an error code immediately. Wit
no add-ins the formula is saved and restores ok. As soon as I add a
add-in it stops saving, so no, it has nothing to do with memory leak
or other rubbish like that, its simply a bugged RTD interface in Excel
which Microsoft refuses to do anything about