Looks like MS Office Word "tables" don't post

Kenneth L. Anthony Jun 8, 2007

  1. Kenneth L. Anthony

    Kenneth L. Anthony TrainBoard Member

    2,745
    472
    50
    This is a test of posting data organized in Microsoft Office table format.

    Car type On roster Commodity Industry spot
    Boxcar XM 70 Grain Elevator
    Boxcar XM 70 Cotton Compress
    Boxcar XM 70 Coffee beans Cargo dock
    Boxcar XM 70 Jute/ gunny sacks Cargo dock
    Boxcar XM 70 Wool Cargo dock
    Boxcar XM 70 Beer Brewery/ team
    Boxcar XM 70 Liquor Team
    Boxcar XM 70 Pallets Cargo dock
    Boxcar XM 70 Cooperage Cargo dock/team
    Boxcar XM “reefer standards” 0 (Desireable) Reefer salt ATSF icing platform
    Boxcar XI Insulated “Maine” 1 Special car Potatoes Team
    Boxcar XT Boxtank Linde/ NCG 2 Industrial gases Eastend
    Boxcar XA Autobox 10 Automobiles Auto dock

    NO. It doesn't maintain items in columns as set up.
     
  2. ppuinn

    ppuinn Staff Member

    2,242
    752
    47
    Ken:
    Trainboard's features don't support posting the contents of Word tables directly in a post; but, you can attach the table to your post if it is in a Word document (or entered in the cells of an Excel workbook). You wouldn't necessarily have the table visible in the body of your post, but someone would be able to open the attachment to see what you're post is referring to.

    Often when I am discussing someone's track plan, I'll insert a Railimages picture of the track plan directly into the body of the post instead of attaching the plan at the bottom of the post. That way, a reader can see both text and track plan in the same window instead of having to constantly switch back and forth between the text in the post and the track plan in the attachment.

    Although the mechanics of it may be cumbersome, a scanned image of the table might be uploaded to Railimages, and then inserted in your post just like your track plans and pictures.
     
  3. Kenneth L. Anthony

    Kenneth L. Anthony TrainBoard Member

    2,745
    472
    50
    Thanks, Dave H., for the suggestion: "Trainboard's features don't support posting the contents of Word tables directly in a post; but, you can attach the table to your post if it is in a Word document (or entered in the cells of an Excel workbook)."
    Let's see if it works. Here goes.

    Fairly small table in Microsoft Office .doc file takes larger size than allowable. Trainboard won't take it!

    Okay, I will try an Excel spreadshead file. Maybe I can import a Word table directly into Excel and make.... nope, doesn't work. Have to re-key it all. I may still try it. But later....
     
  4. ppuinn

    ppuinn Staff Member

    2,242
    752
    47
    Ken:
    Sorry about misleading you on the Word table. The size limit for Word docs and Text files is 19Kb, but PM Charlie...that might be a negotiable/changeable setting.

    The first attachment is an Excel table with 2 dozen items (rows) across 4 columns on a single page. List of text items only...no formulas or conditional formating. The Uploading info said it was about 14Kb.

    The second Excel sheet has text data that is 11 columns wide (about 1.3 TB screens wide--so viewers will have to scroll side to side to see all columns) and 1000 rows long (not sure how many rows per TB screen). There are no formulas is this particular file.
    The Uploading info said it was about 190Kb. The maximum Excel file size uploadable as an attachment to TB is 200Kb, so we're pretty close to maximum size for text lists attachable to posts in threads.
    If you kept the page to only 7 or 8 columns wide, you could have 1000 items that would print out in about 20 pages that were 8.5x11.

    When either of these attachments are opened, they are "Read Only" files--noone can modify them and then save the changes to be seen by someone else. To make changes in files, a viewer must save the file on his own computer and modify what is on his computer rather than attempting any modification of the attachment in TB. If he wanted to show his changes to other TBers, he'd have to upload his own version of the file as an attachment in his own post in the thread.

    My Spiral Helix Dimension Calculator stickied at the top of the Layout Design Forum is only a single worksheet that is a little wider and longer than the usually viewable area of a post...but I think it is well over 100Kb. It has lots of formulas in the individual cells, and some cells are permanently colored while others have conditional formating that changes as a function of the value in the cell. In addition, some of the cells are locked to prevent unintended changes in the formulas, but others change their values when a viewer enters their own values in certain cells. One version of the Helix Calculator was too large to upload as an attachment...too many formulas on just two 8.5x11 pages. This suggests the complexity of the information in the cells affects how many cells of information can be uploaded at a time.
     

    Attached Files:

    Last edited by a moderator: Jun 9, 2007
  5. Kenneth L. Anthony

    Kenneth L. Anthony TrainBoard Member

    2,745
    472
    50
    Thanks for the help, Dave H. I am trying to make my original post read with tabulated and formatted text-- just as we can post a picture in the middle of a discussion from railimages. I guess I am just awfully long-winded in some of my discussions.
    If I don't think of something semi-wonderful, I may just go play with trains for a while.
    Anyway, thanks for the help.
     

Share This Page