Results 1 to 11 of 11
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report writing? (Excel97-SR2)

    Excel appears to be really strong in holding long memo-length strings without truncating the contents.
    Unfortunately, those collapsed cells do nothing for print-outs and proofing of the contents.

    Is there a report plug-in or some way to format the printout via VBA that will serve as a report making tool?
    I have a feeling the answer is no, Excel is made to do math not word processing but the mere fact that it can hold indefinite string lengths makes me wonder.
    I mean, how high can we really count?
    I just thought I'd ask.
    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report writing? (Excel97-SR2)

    VBA can format things almost any way you want it formatted. However, I am not sure what you are trying to do. If you have a long string in a cell, all you have to do is make the cell big enough (tall enough if you have it formatted to wrap text), or combine adjacent cells so that all of the text fits, and it will all print.
    Legare Coleman

  3. #3
    Lounger
    Join Date
    Aug 2001
    Location
    Shropshire, UK
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report writing? (Excel97-SR2)

    Are you refering to the way Excel will not appear to display more than 256 characters in cell if it is formatted as TEXT?
    The contents appear in the formula bar ok, but you get a single row of # characters displayed in the cell, regardless of column/ width and wrapping settings. The only way around it is to set the formatting to GENERAL.
    Ewan

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Report writing? (Excel97-SR2)

    I don't know if this relevant, but you can restrict the width of the columns containing text and set the formatting to include word wrapping, which means long lines can be wrapped to fit on the width a page or part of a page.

    Andrew C

  5. #5
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report writing? (Just a suggestion)

    Just a thought, and this will only work if your Excel spreadsheet is layed out in a table format, you could use Access as your report generator. I've got several spreadsheets linked to an Access file. The only "tables" in the Access file are the spreadsheets, but Access can run queries and create reports off the linked data.

    FWIW
    Again, this only works if your spreadsheet is setup like a table.

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Report writing? (Excel97-SR2)

    It sounds like you are more into cells which contain very long strings of data, in which case Wrap Text and Autosize may help. But if you are really looking for a better way to display static text in printouts, use a text box. (I do this when I'm quoting legislation in support of a calculation.) Unfortunately textboxes have limited formatting capabilities, but they -are- very easy to size and print.
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report writing? (Excel97-SR2)

    Where is this Autosize feature you speak of?

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report writing? (Excel97-SR2)

    In the Format menu select Column or Row depending on which you want to autofit. In the pop up menu select "AutoFit Selection."
    Legare Coleman

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Report writing? (Excel97-SR2)

    Pardon me, I meant Autofit. Format, Column, Autofit and Format, Row, Autofit. Also available by selecting the column or row, moving to the right edge of the column header if a column, upper edge of the row header if a row, until the "cross with arrows" pointer appears, and double clicking. The VBA method is Rows("range").EntireRow.AutoFit and Columns("range").EntireColumn.AutoFit and variations
    -John ... I float in liquid gardens
    UTC -7ąDS

  10. #10
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report writing? (Excel97-SR2)

    Ahhh Autofit... I knew about that one.

  11. #11
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report writing? (Excel97-SR2)

    Thanks one and all... <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Through your advice I was able to whip up a quasi report in Excel.
    Even locking the column heads and repeat printing of them on each page.
    I appreciate the assistance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •