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

Imported Excel unformatted table text-based formulas import as "-1"

Community Expert ,
Sep 25, 2022 Sep 25, 2022

Copy link to clipboard

Copied

Hi all, I'm experiencing a bug where any formulas that reference a text value in my excel files import into Indesign as "-1". Can anyone confirm this bug on their system? If so, please vote for this bug report.

 

Steps to reproduce:

1. In Microsoft Excel, in cell A1 add "Some text"

2. In cell B1 add formula "=A1"
3. Save excel document .xlsx
4. Import into indesign as Unformatted Table (note: formatted table works fine)

typing the formulatyping the formula

formula is workingformula is working

Indesign import options I usedIndesign import options I used

this is what I gotthis is what I got

 

I'm using Indesign 17.4 and Excel for Mac 16.63.1, on MacOS 12.6.

 

If you are also experiencing this bug, please vote for this bug report.

- Mark

TOPICS
Bug , Import and export

Views

58

Likes

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

correct answers 1 Correct answer

Community Expert , Sep 26, 2022 Sep 26, 2022

Apparently, it is just with text-based formulas. Number formulas work OK; limited testing with dates seem to work too.

 

Likes

Translate

Translate
Community Expert ,
Sep 26, 2022 Sep 26, 2022

Copy link to clipboard

Copied

Apparently, it is just with text-based formulas. Number formulas work OK; limited testing with dates seem to work too.

 

David Creamer: Community Expert, Adobe Certified Instructor, and Adobe Certified Expert (since 1995)

Likes

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 ,
Sep 26, 2022 Sep 26, 2022

Copy link to clipboard

Copied

Thanks so much. I can confirm what you say. I have updated the bug report.

- Mark

Likes

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 ,
Sep 26, 2022 Sep 26, 2022

Copy link to clipboard

Copied

Now that I think about it, Dates should work fine since they are really just numbers to Excel (days since 01/01/1900)

 

David Creamer: Community Expert, Adobe Certified Instructor, and Adobe Certified Expert (since 1995)

Likes

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 ,
Sep 26, 2022 Sep 26, 2022

Copy link to clipboard

Copied

LATEST

You are right.

Screen Shot 2022-09-27 at 07.42.55.png

Likes

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