Hello All.
I am trying to streamline things and have a question about Tables in Layout.
Can a table be created without the cell outlines?
I know it sounds counterproductive, but I want to replace the Lot Coverage calculations that are manually edited with a spreadsheet that includes formulas. I don’t want the Grid, but I like the clean layout and formulas.
Select the table and in Shape Style turn off Stroke. You can turn off Fill, too.
I guess I’d better have my coffee before I go any further today!
Thanks, Dave!
I’ve wanted to fix this forever, but just didn’t take the time to do it.
I tried that on the first table that I copied into LO, but had no luck.
It did work just as you said when I imported a saved .xlsx file.
Does that mean you copied from Excel and pasted into LayOut?
Yes. I grabbed the cells from Excel and pasted them in LayOut the first time vs importing a file.
The next question is, can I save it as a Scrapbook with the edited format and adjusted size, or do I need to import?
The formulas don’t seem to get imported.
Copying and pasting from other applications and into LayOut is not a good workflow. It leaves you without a reference to the original. This applies to copying from SketchUp and any other files.
If you import the XLSX file in the first place, you can save it in a scrapbook and then you can open it and edit it in Excel. If you are going to make the scrapbook, first unlink the reference so the spreadsheet file is embedded in the scrapbook.
No they don’t. If you use the correct workflow and insert the .xlsx file, you would then be able to edit it in Excel after dragging it into a new file.
So, maybe I should re-name for project save the excel file in each job file like I do the models and LayOut files. Treat it just like importing a SketchUp portal and re-link table to the excel doc in the job folder that I placed from the scrapbook.
I would do that. All reference files like .skp, xlsx, rtf, CAD files, and raster images) for a given project are saved along with the LayOut file in the same project folder.
If you are always going to be inserting the same sort of spreadsheet reference into your projects you could set up your template with a proxy .xlsx file and then relink to the one specific to the current project in Document Setup>References. You can do the same for the SketchUp file.
This is the first page in one of my templates. There’s a spreadsheet (I used one from an old project that is about average size for those) along with three viewports.
I wouldn’t bother with the scrapbook thing for the tables at all in this case.
If you ‘Send to LayOut’ - the SKP you send should overwrite the SKP you use in the LO template… super easy to build multiple templates with scenes, layers, etc. all keyed to each other.
For the spreadsheet or the RTF - I keep a folder on my drive called ‘Client Templates’ as well as ‘Templates’ (both not in the LO or SKP location, literally in my documents folder). I keep all referenced PDFs / RTF / Spreadsheets there… so I always know where they live. My SKP is typically what changes and that comes in from SketchUp and is saved in a client folder.
