Tables in LO 2017

Found a bug in LayOut? Report it here

Tables in LO 2017

Postby brettsichellodesign » Tue Nov 08, 2016 12:21 am

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.
0
User avatar
brettsichellodesign 
 

Re: Tables in LO 2017

Postby brettsichellodesign » Wed Nov 09, 2016 6:13 pm

Any advice on this?
0
User avatar
brettsichellodesign 
 

Re: Tables in LO 2017

Postby ntxdave » Wed Nov 09, 2016 7:11 pm

brettsichellodesign wrote:Any advice on this?

It worked for me.
0
User avatar
ntxdave 
 

Re: Tables in LO 2017

Postby marcdurant » Fri Nov 11, 2016 12:10 am

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
0

marcdurant 
SketchUp Team
SketchUp Team
 

Re: Tables in LO 2017

Postby nickchun » Fri Nov 11, 2016 10:19 am

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
0

nickchun 
 

Re: Tables in LO 2017

Postby marcdurant » Fri Nov 11, 2016 6:49 pm

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

marcdurant 
SketchUp Team
SketchUp Team
 

Re: Tables in LO 2017

Postby brettsichellodesign » Wed Nov 23, 2016 1:13 am

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.
0
User avatar
brettsichellodesign 
 

Re: Tables in LO 2017

Postby juju » Wed Nov 23, 2016 10:38 am

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?
0
Save the Earth, it's the only planet with chocolate.
User avatar
juju 
Premium Member
Premium Member
 

Re: Tables in LO 2017

Postby brettsichellodesign » Wed Nov 23, 2016 6:10 pm

Please see video below:

0
User avatar
brettsichellodesign 
 

Re: Tables in LO 2017

Postby brettsichellodesign » Thu Nov 24, 2016 12:41 am

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



Marc I sent you a PM
0
User avatar
brettsichellodesign 
 

Re: Tables in LO 2017

Postby juju » Thu Dec 01, 2016 3:45 pm

brettsichellodesign wrote: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?
0
Save the Earth, it's the only planet with chocolate.
User avatar
juju 
Premium Member
Premium Member
 

Re: Tables in LO 2017

Postby marcdurant » Fri Dec 02, 2016 11:14 pm

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
1

marcdurant 
SketchUp Team
SketchUp Team
 

Re: Tables in LO 2017

Postby juju » Wed Feb 22, 2017 2:01 pm

marcdurant wrote: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...
0
Save the Earth, it's the only planet with chocolate.
User avatar
juju 
Premium Member
Premium Member
 

SketchUcation One-Liner Adverts

by Ad Machine » 5 minutes ago



Ad Machine 
Robot
 



 

Return to LayOut Bug Reporting

Who is online

Users browsing this forum: No registered users and 1 guest

Visit our sponsors: