Thank Martin for your witty reply.

are undecided whether to laugh about this issue or start cursing against
those cowboys... I will choose the first solution, I guess.

in case of any other ideas by anyone, please let me know

bye

mark


"Martin Brown" wrote:

perf wrote:
Hi, I write because I'm experiencing a quite strange problem with Excel 2007
and
.xls file.
Time ago I created an add-in in vba that creates a toolbar that allows
depending on the chosen button to insert custom designs by me (hysteresis,
thresholds etc etc), and then connects these blocks together with normal
excel connectors. In Office 2003 everything was fine. Now I'm having problems
in 2007: to maintain compatibility with other PCs that have Office 2003
installed on and must to work on files, I decided to keep the format. xls as
the default for all.
But there is a strange thing: when I open, in 2007, the xls files created in
office 2003 many blocks are 'moved' graphically (unpredictably), while
connectors are in place and go properly where it should be the blocks.
Moreover, as I try to
move the block, connectors move immediately.
If I move correctly the blocks and save the .xls file and reopen it, it
re-happens equal. in 2003 it's all perfect.
I hope I explained ...

Furthermore, if in 2007 I save the file as. xlsx after postioning correctly
the blocks,
the problem does not happen, and everything is perfect. I then tried to open
the .xlsx with a patched Office 2003, but then the problem is in 2003.

do you think that there is a solution to this problem? it seems that's it's
only a display mismatch.

The only solution to this problem involves the liquidation of the cowboy
development team responsible for the abortion that is XL2007.

Just about every aspect of shapes is made incompatible with all previous
versions. Top, Left, Bottom, Right changed to Top, Left, Width, Height.

Some objects will not draw correctly in XL2007 if they are closer to the
zero axes of the coordinate system. Charts are glacially slow.

You have to fork the code. It is possible to make an application using
graphical objects that will work in both the radically different choices
of parameterisation. However, forking the code is easier.

Regards,
Martin Brown
.