Tables in LO 2017

ntxdave

Any advice on this?

It worked for me.

marcdurant

Any chance you could share that excel file with the LayOut team for debugging purposes? There may be something specific about your file that's breaking our importer, and we'd love to check it out.

Thanks,
Marc

nickchun

Marc, I have had the same issue trialling Layout. I have downloaded the Make version for now. I am trying to insert a table from an Excel 2007 Workbook that has 25 sheets. If you want a copy of the workbook I can PM it to you.

Nick

marcdurant

Yes, I would appreciate any and all files that are causing issues.

brettsichellodesign

Unfortunately I am unable to share this excel file. However I can confirm that is a 6218KB file with many workbooks most of which are protected. I did try un-protecting them but still have the same issue.

I have got round this problem by referencing the cells I needed into a new excel file with just 1 workbook and referencing that into LO. Just means I have to have another file.

juju

This is probably a noob Excel question, but how do you manage to reference cells in a separate protected Excel file? How do you enter the password to the referenced file from the referring file?

brettsichellodesign

Please see video below:

https://youtu.be/jkDa0-Fy0D0

brettsichellodesign

@marcdurant said:

Yes, I would appreciate any and all files that are causing issues.

Marc I sent you a PM

juju

@brettsichellodesign said:

Please see video below:

https://youtu.be/jkDa0-Fy0D0

thanks for the vid, that is how you reference cells between documents

I'm interested to know if it still works (automatically) if you have the source Excel file password protected and, if so, how you manage that the target file opens/reads the source (password protected) file?

marcdurant

Among other minutia, looks like the library we're using to import .XLS files doesn't properly handle some aspects of locked cells. Thanks for your help identifying the issue, and keep an eye out for maintenance releases.

-m

juju

@marcdurant said:

Among other minutia, looks like the library we're using to import .XLS files doesn't properly handle some aspects of locked cells. Thanks for your help identifying the issue, and keep an eye out for maintenance releases.

-m

Hi Marc,

When will we be able to reference a password locked Excel file into Layout? I tried again after the SU2017proM2 release but no luck...