Re: Autofit does not size properly for printing

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: cradovsky (cradovsky.1dpo3z_at_excelforum-nospam.com)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 10:28:16 -0500

Three thoughts:

- One, you can manually push line-breaks into your cells at the wrap
points that make sense to you. Problem with this is you'd have to come
up with some arbitrary criteria for when to wrap (e.g., number of
characters, backing up to the beginning of a word, etc.). You'd likely
be conservative and break "early" on the line, therefore you'd have
extra whitespace between columns.

- Two, come up with a "fudge factor" that allows you to assess the
difference between the normal view and the print-preview view and apply
this to a row-height adjustment. Still not ideal, as things such as
font, bolding, word-length, etc. effect the wrapping in ways beyond the
straight factor adjustment.

- Three, find some VB environment object that lets you "peek" at the
print-preview version and adjust accordingly.

One and two are overly complex, and will always be an approximation
that will fail at the edge conditions. This could be minimized by
joining the two approaches, but that solution is too complex for easy
implementation/maintenance and will still fail occasionally.

I have yet to find the object in the VB environment that lets you
"decode", predict, or otherwise directly calculate the print-preview
version of a sheet. In the MS-Access environment, you can alter
appearences during run-time, but I haven't heard of that in Excel.

Without a resolution to this, Excel is a flawed tool for automated
reporting.

Regards,

Carlo 

-- 
cradovsky
------------------------------------------------------------------------
cradovsky's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15063
View this thread: http://www.excelforum.com/showthread.php?threadid=266626

Relevant Pages

  • Re: Environment containing ams align
    ... Peter Mendham wrote: ... I need to wrap up the ams align environment in another environment of my own for convenience to automatically do some preparation and cleaning up ... It just doesn't want to play ball with align or alignat, ...
    (comp.text.tex)
  • net send message alternatives?
    ... I wanted to wrap ... in our environment. ... Other than a 3rd party tool, ... Troy ...
    (microsoft.public.scripting.vbscript)
  • newenvironment combining theorems and glossaries
    ... What I want is a new definition environment that will take a word and a ... would wrap the word in a \gls. ... theorem environment, just the header stuff. ... environment, and then to output it twice, it'd help a great deal. ...
    (comp.text.tex)