Tables in LO 2017
-
Thought we could go ahead and test the new Tables feature of layout which can supposedly reference a Microsoft Excel or google shreadsheet. I'm pretty excited about this feature as it will save alot of time with window schedules etc...
However, I am already having trouble with it. I am trying to import a large spreadsheet into LO 2017 and keep getting the following message:
I am a Passive House designer and would find this particularly usful for inserting the PHPP spreadsheet into layout. However, every time I try, same error message, even after unprotecting the file.
-
Any advice on this?
-
-
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 -
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
-
Yes, I would appreciate any and all files that are causing issues.
-
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.
-
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?
-
Please see video below:
-
@marcdurant said:
Yes, I would appreciate any and all files that are causing issues.
Marc I sent you a PM
-
@brettsichellodesign said:
Please see video below:
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?
-
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
-
@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...
Advertisement