Problem
How to auto-resize linked .ods file as OLE object in .odt file to .odt page or .ods content dimensions?
It should resize like a regular table does.
Partial (repetitive) solution
Per
- double-clicking (to update) the OLE object, and then
- clicking Original Size in its Properties window
allows the spreadsheet to ascertain and resize to its correct size, but this must be redone after every modification to the linked file, and causes it to display over subsequent text:
…unless wrap is disabled:
Untitled 1.ods (9.0 KB)
Untitled 1.odt (10.7 KB)