Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / General / February 2006

Tip: Looking for answers? Try searching our database.

Actuate to Excel

Thread view: 
Anne - 06 Feb 2006 04:30 GMT
When Actuate downloads a report to Excel, some large text fields show
up as just a row of # signs.  Then the user has to change the format of
the row to general.  They are getting irritated at having to do that so
many times.

Any idea how to stop that, or how to direct Excel to see it
differently, or a resource to find those answers?
Rhino - 06 Feb 2006 16:27 GMT
> When Actuate downloads a report to Excel, some large text fields show
> up as just a row of # signs.  Then the user has to change the format of
[quoted text clipped - 3 lines]
> Any idea how to stop that, or how to direct Excel to see it
> differently, or a resource to find those answers?

You could probably get Excel to handle that for you quite easily with an
Excel macro that gets launched automatically every time Excel is started.

I don't know what statements you'd put in that macro myself - I only just
learned to write Word macros the other day and haven't tried Excel macros
yet - but it shouldn't be too hard to do what you want.

The language used for Word and Excel macros is VBA (Visual Basic for
Applications) and there are many resources for this language online; just
search on VBA in Google. There are also some public Microsoft newsgroups for
discussing VBA that I found very useful, particularly
microsoft.public.word.vba.general. (You'll need to add the Microsoft news
server, msnews.microsoft.com, to your newsreader, then simply subscribe to
microsoft.public.word.vba.general. Or you can read and post via Google
Groups if you don't have a newsreader program and don't want to bother with
one. Mind you, Outlook Express has a built-in newsreader so you shouldn't
need to install anything new unless you really hate Outlook Express.)

--
Rhino


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.