• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Linked excel table flip columns order after updating

New Here ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

I'm linking an excel sheet to a report that I'm working on on InDesign and everytime I update it the order of the columns change, like reading them in arabic. 
The text is readable, only issue is the shifting of the columns. 

Maria_FS_0-1730277636458.png

 

Views

226

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

@Maria265558995dcg 

 

I've moved your post from Creative Cloud desktop to the InDesign forum.

 

Can you show us what the table looks like before you update and also what it looks like in Excel?

 

Jane

 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

Thank you Jane. 

Table in Excel looks like this:

Maria_FS_0-1730279166641.png

 

And here the moment I linked it to InDesign: 

Maria_FS_1-1730279236104.png

 

And after updating the link: 
Maria_FS_2-1730286206197.png

 

  

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

Thank you for the screenshots, @Maria265558995dcg , as that makes it clear. You need to use a Table style that you can reapply when you update.

 

  • The Table style includes cell shading, borders, and Cell styles
  • Cell styles include Paragraph styles
  • Paragraph styles include Character styles

 

If you don't have these styles already, then create them when you first place the Excel file

  • Character styles: may not be needed here, as they are for words and phrases
  • Paragraph styles: you'll need at least two: Table Head and Table Body (names are up to you)
  • Cell styles: you'll need at least three for the shading. Be sure to include the appropriate Paragraph style
  • Table style: White borders, Cell styles for header, footer, left & right columns. You only need to assign a style for the Header Row. Make it a Header Row if it isn't already.
    You can't include a "second row" in the Table Style, but it can be applied manually to this row.

 

To start:

  • Save
  • Create the styles
  • Save
  • Important: select the entire table and clear the local formatting for all four styles, as local formatting overrides styles
  • Apply the Table style, then manually apply the Cell style for the "A/I Design" row

 

 

Test

  • Make a change in Excel
  • Update the table in InDesign
  • Apply the Table style plus the Cell style for the second row

 

Jane

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

@Maria265558995dcg

 

Can you check if you somehow have set Right-To-Left option for your tables? 

 

To the Table or maybe Paragraph / Paragraph Style table is in? 

 

Can you share INDD document with one affected table and linked Excel file? 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

@Maria265558995dcg

 

Was the table created in Excel - or exported from some other application as an Excel file?

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

It was created in excel, I created cell style to be equal to my InDesign presentation. 
I realized that if I give format in InDesign and I have to update later, I have to re-do all the formatting work. 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

@Maria265558995dcg

 

Does it happens in a new, fresh document?

 

Resetting formatting of the table is normal. 

 

You can mitigate it a bit by using Table Styles. 

 

If Table Style isn't not enough - I would suggest my ID-Tasker tool, not free, but extremely versatile - the only drawback - it's PC only. 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

The excel was new, the document no... I will try to use the table styles first, thank you. 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

quote

The excel was new, the document no... I will try to use the table styles first, thank you. 


By @Maria265558995dcg

 

Table Styles are like Paragraph and Character Styles for text - they are essential. 

 

Applying Table Style rather won't fix your problem. 

 

If your Excel file will update OK in the new document - please try IDMLing to fix your old document: 

 

Export your old document as IDML, open, save with a new name - do not overwrite your original file. 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

Can you post the Excel file here for us to look at?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 30, 2024 Oct 30, 2024

Copy link to clipboard

Copied

LATEST

Hi @Maria265558995dcg ,

to resolve the issue, the reading order of columns in the placed table, do the following:

[ 1 ] Select all cells in the table ( select one cell and then do the keyboard shortcut for Select All )

[ 2 ] Run a script on the selected table. The code below is written in ExtendScript (JavaScript) and should be copied to a text-only-file you will save and later rename the suffix to ".jsx" so that InDesign can execute the code in the User panel of the Scripts panel.

// A table selected
// Change the table direction to LTR:
app.selection[0].tableDirection =
TableDirectionOptions.LEFT_TO_RIGHT_DIRECTION;
alert( app.selection[0].tableDirection );

 

In case the table direction is alread left to right and nothing changes after running the script, go with this code:

// A table selected
// Change the table direction to RTL:
app.selection[0].tableDirection =
TableDirectionOptions.RIGHT_TO_LEFT_DIRECTION;
alert( app.selection[0].tableDirection );

How to install ExtendScript (JavaScript) files and execute them, see:

https://indiscripts.com/pages/help#hd0sb2

https://www.danrodney.com/scripts/directions-installingscripts.html

 

Hm. All that said, I would suggest to open the text frame holding the table in the Story Editor Window to see if the columns are reversed in a table with direction left-to-right or if your table has the wrong table direction after updating the table:

Bildschirmfoto 2024-10-30 um 13.32.09.png

 

If your columns show the wrong order, but the Story Editor is showing the right order from top to bottom, your table has the wrong table direction. To correct this see the script code above for LTR.

 

What could be wrong with your InDesign document or your table's text frame, I have no idea.

To test this one needs the Excel file and your sample InDesign document…

 

Regards,
Uwe Laubender
( Adobe Community Expert )

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines