We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Pasting spreadsheet cell as dde link in word doc makes huge ugly box around it [closed]

asked 2016-11-22 08:08:15 +0200

juntjoo gravatar image

Is there a way to manage the box size? I'm pasting as "dde links" because it looks like the only advanced pasting option that makes the contents dynamic which is what I want but not these huge boxes that rearrange the page layout. Also I'm pasting into table cells I've created if that makes a difference, but these boxes are rearranging the table dimensions. Help could you? Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-15 21:48:34.156199

1 Answer

Sort by » oldest newest most voted

answered 2016-11-22 10:28:06 +0200

Lupp gravatar image

updated 2016-11-22 10:34:12 +0200

(Always use the native ODF-format for your documents. In case of Writer this is '.odt' for ordinary documents.)

Inserting a cell range (may be a single cell) as a DDE link into a Writer document always creates a text-table. This table is formatted first with default settings using the full width of respective page style ( /frame /surrounding table cell ... where applicable), and also defines a standard border for the cells.

Subsequently you may edit the table properties in your preferred way, 'Context menu' (RightClick) > 'Table Properties...' e.g.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-11-22 08:08:15 +0200

Seen: 111 times

Last updated: Nov 22 '16