Paul

My feedback

  1. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  Adobe InDesign: Bugs » Text/Story/Table  ·  Flag idea as inappropriate…  ·  Admin →
    Paul commented  · 

    I have looked further into tableFormattingOptions via javascript.

    I in fact can successfully set the following:

    TableFormattingOptions.EXCEL_UNFORMATTED_TABBED_TEXT

    TableFormattingOptions.EXCEL_UNFORMATTED_TABLE

    but I cannot set

    TableFormattingOptions.EXCEL_FORMATTED_TABLE

    TableFormattingOptions.EXCEL_FORMAT_ONLY_ONCE

    When attempting to set these last two, the result is EXCEL_UNFORMATTED_TABLE.

    So, there's a bug. I'm using a Mac and CC2019. I hope this helps. Thanks!

    Paul commented  · 

    I also cannot set the excel import options table formatting options via script. I use the following line:

    app.excelImportPreferences.tableFormatting = TableFormattingOptions.EXCEL_FORMATTED_TABLE;

    If the UI import option panel says Unformatted before I run the script, the placed excel xlsx document remains unformatted after I run the script. If I check after running the previous line with:

    alert (app.excelImportPreferences.tableFormatting)

    I am alerted the the setting is the one I wanted, e.g. formatted, yet the resulting placed content is unformatted.

    I hope you can set me straight on this one. Thanks!

Feedback and Knowledge Base