XLS import problem

Learn / Forums / General InDesign Topics / XLS import problem

Viewing 2 reply threads
  • Author
    Posts
    • #89327
      Simon Duckworth
      Participant

      Hi Gang,

      Pulling my hair out over this one! I’m trying to import an XLS spreadsheet into ID as a link, and apply formatting automatically at the same time. My problem is an odd one – the XLS that I’m importing contains linked cells which are imported as values (ie. the content shows up correctly) when I import the XLS as unformatted. When I try to import the XLS as formatted, ID decides to ignore the cell values of the XLS (return a zero) in each linked cell.

      Can anyone advise please? It’s driving me mad!

      Best, Simon

    • #89342
      David Blatner
      Keymaster

      I don’t know, but I generally use XLSX instead of XLS. Does that make a difference?

    • #89343
      Simon Duckworth
      Participant

      Thanks David – turns out I was using an .xlsx file! I’ve tried using a .xls file and it imports correctly… My problem now is whether the formulae in the .xlsx can handle being converted to .xls, but that’s beyond the scope of this forum :o/

      Thanks again, I’m going to raise this as a bug to Adobe (unless itsafeaturenotabug)

      Simon

Viewing 2 reply threads
  • You must be logged in to reply to this topic.
>