Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo over 6 columns in excel - expand vertically
Message
From
23/12/2005 09:41:21
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
23/12/2005 03:10:54
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Miscellaneous
Thread ID:
01079925
Message ID:
01080493
Views:
16
>It is all well that ends well :)

Wasn't it "when ends well" ("kad se dobro svrši")? Sounds mucho better in Serbian :).

>But I think what you did is more dificult.
>Even if it is one page, knowing row where pagebreak occur
>alows you to position/size your memo area accrdingly. Nice & easy.
>No streaching no calculating size etc.

This is a sticker, about 15cm wide, and 25cm tall. No second page ever. Excel's limit of 1024 displayable characters is quite enough for me.

Once I needed a multipage report that needs to print nice... I'll start taking stuff from your class. I'll keep it at hand for sure.

>BTW I don't like to much idea of excel doing auto-streach,
>because outcome could be unpredictable when different data come into play.

I know, it's the same as printing free text in any other environment - be it a memo in a frx, or when generating a .ps, .pdf or any other type of output. The text may overflow. Since I already got a limit here, I could have put a replicate(replicate("W",15)+" "), 64) for a sample, measured how much space that takes, and stretched my block accordingly. But I was stubborn. Outsmarting Excel's shotrcomings was a matter of... what's proper English for "inat"? Spite?

>Even WodWrap is problematic in this respect.
>I prefer to see text appear exactly as entered in source memo field.

It does, for me. The width is different, of course, but then the content of this isn't lyrics, it's instructions on a manufacturing order.

>If you hv limit of six columns horisontaly (other text on right side or above) maybe is not bad idea to decrease font by one rather then doing sizing streaching etc.

Beyond sixth columns there be dragons... i.e. nothing.

>I send you automation class with real life usage sample, because you said that you are using excel automation extensively. It is set of very usefull wrappers, basically automated automation so I just tought you might make good use out of it.

I've read it and, as I said, it has already helped me with this problem. You got the details in the mail, anyway.

>uuups I hv to go for our little office party
>(will be back after xmass)
>
>Merry Christmass everyone :)

If you want something for everyone, I'd go with the New Year.

a) it's sure to come
b) it comes to everyone

How am I sure it will come? Simply, it relies on the calendar. And there can't be any failure with the calendar, because it has no moving parts (except the Solar system), and because it's essential for the existence of the Olympic games. Now there's absolutely no power on Earth that can prevent these games' regular repeating. They are the protector of the calendar, and indestructible.

Still too early to wish everyone a HNY... so, later.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform