Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo over 6 columns in excel - expand vertically
Message
From
22/12/2005 02:44:14
 
 
To
21/12/2005 14:36:09
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
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:
01080103
Views:
22
This message has been marked as a message which has helped to the initial question of the thread.
Hi Dragan,
I am doing something very simillar right now.
I folowed soemwhat different aproach. I first find out where IS page break
and then I start writing sufficient number of rows up from that point.
Actually I first merge sufficient area, and then simply write memo text
to it. Word wrap should be easy to fix.
(I can send you entire automation class with this very sample if you are interested)

Pozdrav :)



>>I'm using Excel automation for all the reports. Now I got an interesting problem - I have a memo which needs to print at the bottom of the page (position not fixed, just below everything else), and needs to expand over six columns. The length of the memo is, of course, variable.
>>
>>I need to autosize this merged range vertically. Which I can't do in Excel (2003). Autosize doesn't work on merged cells, or if it does, I don't know how to get it to work. And help is of no help, of course.
>>
>>Any ideas?
>
>And, worse than that, I can't even make text to wrap at all if it's longer than 255 characters. It just shows as a line of ######################.
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform