Excel table comes in different size

[brucey26764276]

I have an Excel file that will be placed in Indesign in two sections because file will be crossing the gutter that will being three-hole punched.

When I place two sections of the same Excel file into Indesign, They are they come in at different sizes see sample below.

Same file should mean same size. What am I miss as I'm placing? Below is the table place as a whole and everything lines up.

Thanks in advance,

Bruce

[Mike Witherell]

When you place it, do you place it inline to run with text, or do you place it as a stand-alone frame? Are you placing it into a paragraph style? What are the space-before and space-afters of the paragraph style? Are any objects on the spread that are pushing their text-wrap on your frame?

[brucey26764276]

I placed it as stand-alone frame with no styles applied. I wanted to keep content as true to Excel as possible so when the Excel file gets updated, the link can be updated easily with no movement.

I'm not using any text wraps in the design.

Is this a known issue or am I just missing something?

Thanks.

[Mike Witherell]

Then that would suggest the "Basic Paragraph Style" is applied. What are its attributes including space before and afters, and line indents, etc? Is snap to baseline grid turned on or off?

[brucey26764276]

Basic paragraph style has no space before or after. Indents are 0. Snap to baseline grid is off. However, even if it was on, wouldn't this affect both imported file the same and not just one?

OK, here was my work around since I couldn't get it to work.

I imported the whole Excel table in Indesign instead of section it off during the input. Cut the table and place into new text frame. The new text frame gave me the ability to crop the excel file and section them off by duplicating the new frame. Not sure if this is the best solution, but it seemed to work.

[Diane Burns]

If you are designing your document in spreads, you can use one table and insert and "empty" column that jumps the spread, leaving room for your 3-hole punch. I have a book-publishing client that uses this approach frequently.

[brucey26764276]

Thanks Diane. That is an idea for another work around but doesn't address the issue.

Is this it a know bug in Indesign that placing sections of an Excel file can result into different sizes tables? Bringing in the same file, but different sections, shouldn't cause a size shift as seen in the examples i provided above.

[Diane Burns]

Just to clarify, when you say bringing in "different sections," are you using the Import Options dialog to change the range of rows and columns each time you import? Thnx.

[brucey26764276]

Hi Diane,

Yes, I'm using the Import Options to change the range and place the file.

For example:

first frame will hold: A1:L33

second frame will hold: M1:T33

They both start and stops at the same place.

[Diane Burns]

I tried but have not been able to reproduce the problem. It looks like from your screen cap you are bringing it in as a "Formatted Table." I wonder if the problem persists if you bring it in as an "Unformatted Table"? (Chosen in the Import Options dialog).

Also, again from your screen cap, it doesn't look like they are different sizes. It looks more like they simply don't line up. I had this occur in one of my tests and I needed to widen a column in InDesign so it didn't wrap.

[brucey26764276]

Diane, you are correct referring to type size and line weight. Those remain the same. But there was a couple cell rows that changed cell height and affected the overall table size and makes it so it does not line up.

I tried bring in file unformatted and it was just a mess. I don't want to do a lot of formatting with the tables in Indesigns because the files will be updated often and I want a clean update so there isn't a lot of fuss on my end to format styles.

I've tried bring this Excel file into new clean Indesign file and still have same results.

Looks like I can adjust the row height and it will stick even after the Excel file has been updated. So that might be the right way to go.