Adding Spreadsheets or Tables to layout page

pbacot · 28 Apr 2015, 16:23

I think I would just print Excel to pdf and insert the pdf.

Dave R · 28 Apr 2015, 16:27

Peter, that works well if you're using a Mac. On PC, not so much.

pbacot · 28 Apr 2015, 16:40

What happens on a PC?

Dave R · 28 Apr 2015, 17:10

No PDF import option.

seasdes · 28 Apr 2015, 23:47

FastStone Capture allows screen clips to be saved at whatever resolution that you want. I use it every day.

caronte01 · 6 Jun 2015, 00:00

I generate PDF from libre office, and then open it in inkscape, where I can save as PNG. At 200-300 DPI. Yes, layout PC needs PDF import badly!!!

Garyvn · 9 Jun 2015, 15:06

I just did a quick check then with Excel and Layout

not sure if this is a capability new to Layout 2015 but

Copy and paste from excel to LO worked fine - editable table in a text box

Also trying a way I always use via powerpoint to keep the formatting and colours of Excel

1] select range in excel
2] paste as image in powerpoint
3] copy that image from powerpoint
4] pasting into layout - quick and pretty spreadsheet

hope that helps

Chailas · 16 Jun 2015, 19:41

In a PC you can use the snipping tool and save the image as a .jpg

ashscott · 9 Jul 2015, 16:52

Have just been doing some tables from excel to Layout - they copied and pasted quite nicely so long as I didn't try and edit them in Layout - it seems Layout reads them better than it did a few versions back when I tried this and consistently got tabs jumping all over the place.

TL;DR: Try copy pasting from your spreadsheet to Layout first - could save you some time.

shawb · 7 Sept 2015, 14:46

Hi,

I have been looking at the Excel table into LO thing (or lack of in the PC version). Here is my offering:

Create your table in Excel with cell widths, heights, font size and formulas. Make sure that any editable data can be copied and pasted as a block (for convenience).
Format a matching area in the spreadsheet as a swap area.
Select the entire table, copy and paste into LO. The table comes in as an editable text block with cells bordered in black lines.
Make any changes to data in individual cells. Note, no formulas are copied just the numbers.
Double click in the text box which will select all cell data.
Copy and then paste back into the Excel sheet but in the formatted swap area.
Select the data to be changed and paste into the original table position.
The formula results will update.
Start back at the beginning! Re-copy the updated table and double click in the LO text box, paste.

Not perfect but seems to work. Basically it is a way of re-calculating a table using Excel and not having to do it manually.

Brian