Word wrap in OWC Spreadsheet

[Dan A.]

I know that this feature is not supported in OWC 10, but
it's still unsolved in OWC 11 ???!!!
It's like Achilles heel. Many of our clients are simply
reconsindering buying our app.
It's a pity, after such a long wait for a viable Excel
control...

 

[Alvin Bruney [MVP]]

What exactly are you trying to do? Maybe there is a work around. Usually,
one feature shouldn't be a showstopper but if it is, i'm sure there is a
workaround.

 

[Dan A.]

It's all about descriptions, i.e. what if in A2 cell I had this looong description "This is our market share for 2004"
I'd like the text to wrap so it doesn't "spill over" the next cells

One cumbersome workaround is to allocate more rows and behind the scenes we would "spread evenly" the description, i.e. A2, A3, A4.
But then, the whole Excel cell referencing will be out of sync once the description gets longer or shorter.

Another idea is to "trap GDI-wise" the cell's DeviceContext and do the drawing by ourselves
I couldn't find any support for this...

 

[Alvin Bruney [MVP]]

how about a mouse over toolip? you can use javascript to get the
coordinates of the mouse and figure out which cell you are over, then get
the discription and display it as a tip. it's not going to be a walk in the
park but in theory, it should work well with the added advantage that if the
user isn't bothered about the long description then it doesn't pop out
because they won't mouse over it.


--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/3he3b

It's all about descriptions, i.e. what if in A2 cell I had this looong

description "This is our market share for 2004"?

I'd like the text to wrap so it doesn't "spill over" the next cells.

One cumbersome workaround is to allocate more rows and behind the scenes

we would "spread evenly" the description, i.e. A2, A3, A4.

But then, the whole Excel cell referencing will be out of sync once the

description gets longer or shorter.