Could well be that those files are not 100% compatible with the XLS file
Yes, we tried saving as .xls and .xlsx, no joy.
We just upgraded our Macs from 10.4 to 10.8 machines and our Office versions [v2004] are not compatable with 10.8 so were hoping to avoid buying new versions by using Libre Office.
Libre Office seems to do 95% of the tasks Microsoft version does, but not this critical link with InDesign.
Have you tried OpenOffice?
Will do and let you know Bob, thanks C
Long way around.
Copy the table in LO, paste into a text frame. Use convert text to table, do any merged cells, etc. Apply table style formatting.
Retain one computer with the older OS as Excel can open the LO XLS files, save out and import into ID.
Use a PDF of the tables and place them.
Take care, Mike
Sorry, should have said:
We are working with timetables that get updated on regular basis.
We link the XLS into ID and then format the cells/contents.
When the service changes (updates) happen, we recieve a new .xls file and then just update in ID which keeps the formatting in place.
We are doing option 2 at the moment so we can continue to work but ideally would think the ID would import open source office solutions.
Honestly, if your workflow is that dependent on Excel files, I think
you're being penny-wise here.
There's no telling if/when this could blow up in your face.
That said, do let us know if OO is any better.
Always 'penny-wise' here
OO v3 export to .xls. No joy, not even the cells coming in.
Ideally Adobe would support the ODS format going forward. I wouldn't hold my breath but at the current pace of individuals and business switching to LO, it would be a good move on Adobe's part.
Altering Bob's statement to perhaps his intent, it would be that by using OpenSource applications that do not evidently properly support the XLS format (and there are issues with Adobe's XLXS placing), the statement would be:
LO may be penny wise, but pound foolish in mission critical environments.
Best regards, Mike
"LO may be penny wise, but pound foolish in mission critical environments."
Totally agree, but having just spent £20k+ on hardware, CS6, Quark 9 etc I didn't really want to go back to the board just for Office.
Looks like will be going down the route of an old 10.4 machine / office 2004 with VNC access for the operators.
I understand--even at my small scale of operation this gets too expensive fast.
We had the same problem. LibreOffice seems to maintain data types per cell when saving files which InDesign can't handle. If you explicitely mark all cells as text, InDesign will read everything correctly and you can work with Indesign as you're used to.
I hope this helps