Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

From LO help NO help, unfortunately. Nevertheless, trying and trying again, I've found the solution!

Link to http://1drv.ms/1FfdhJh for samples; I used a XLS sheet but all is ok with an ODS too. Warning: in OneDrive LO W-C xlssample seems .XLSX but if you download renaming .XLS is OK. Here how to do: From Calc: select cell or cells-area -> Copy in Writer: point to where to apply, Copy-paste -> link DDE. After pasting you can adjust boards and characters of the linked data. From Edit -> Links you can display all linked objects and manage them; if "automatic update" is checked (I think as default) every update to Calc sheet is reflected into the Writer document, elsewhere you can click on "Update" to do that. Reopening the Writer file you'll be asked if you wish updating YES|NOT: every change applied to the Calc sheet shall be or not reflected into the Writer document.

The only thing I am not able to do is the aligning of linked data with my test: e.g., in my sample I'd like to align the date getting "This is my document dated 2015-05-15". (why ???)

And why don't put a similar illustratiion in LO help?

From LO help NO help, unfortunately. Nevertheless, trying and trying again, I've found the solution!

Link to http://1drv.ms/1FfdhJh for samples; I used a XLS sheet but all is ok with an ODS too. Warning: in OneDrive LO W-C xlssample seems .XLSX but if you download renaming .XLS is OK. Here how to do: From Calc: select cell or cells-area -> Copy in Writer: point to where to apply, Copy-paste -> link DDE. After pasting you can adjust boards and characters of the linked data. From Edit -> Links you can display all linked objects and manage them; if "automatic update" is checked (I think as default) every update to Calc sheet is reflected into the Writer document, elsewhere you can click on "Update" to do that. Reopening the Writer file you'll be asked if you wish updating YES|NOT: every change applied to the Calc sheet shall be or not reflected into the Writer document.

The only thing I am not able to do is the aligning of linked data with my test: e.g., in my sample I'd like to align the date getting "This is my document dated 2015-05-15". (why ???)

And why don't put a similar illustratiion in LO help?

Post scriptum Errata corrige, I apologize: I've updated the samples (link to http://1drv.ms/1Prcw7M ) also substituting the xls file with an ods.

Warning 1: in the ODT, about the comment, I wrote "← double-click to display comments": it is not always so. If you create a new comment from LO Writer you can display it only by View->Comments. In my sample (it is an ODT migrated from a WinWord DOC) that is true, but I don't know why (may be some developer could explain ...???).

Warning 2: opening the ODT doc you are asked if you wish updating YES|NOT. Replying YES every change applied to the Calc sheet willl be reflected into the Writer doc ... but if now you want to save the file, the "SAVE" menu option is inhibited and clicking on "X" also the file will not saved; you have to exit by "Save As", I think this is a bug.

From LO help NO help, unfortunately. Nevertheless, trying and trying again, I've found the solution!

Link to http://1drv.ms/1FfdhJh for samples; I used a XLS sheet but all is ok with an ODS too. Warning: in OneDrive LO W-C xlssample seems .XLSX but if you download renaming .XLS is OK. Here how to do: From Calc: select cell or cells-area -> Copy in Writer: point to where to apply, Copy-paste -> link DDE. After pasting you can adjust boards and characters of the linked data. From Edit -> Links you can display all linked objects and manage them; if "automatic update" is checked (I think as default) every update to Calc sheet is reflected into the Writer document, elsewhere you can click on "Update" to do that. Reopening the Writer file you'll be asked if you wish updating YES|NOT: every change applied to the Calc sheet shall be or not reflected into the Writer document.

The only thing I am not able to do is the aligning of linked data with my test: e.g., in my sample I'd like to align the date getting "This is my document dated 2015-05-15". (why ???)

And why don't put a similar illustratiion in LO help?

Post scriptum Errata corrige, I apologize: I've updated the samples (link to http://1drv.ms/1Prcw7M ) also substituting the xls file with an ods.

Warning 1: in the ODT, about the comment, I wrote "← double-click to display comments": it is not always so. If you create a new comment from LO Writer you can display it only by View->Comments. In my sample (it is an ODT migrated from a WinWord DOC) that is true, but I don't know why (may be some developer could explain ...???).

Warning 2: opening the ODT doc you are asked if you wish updating YES|NOT. Replying YES every change applied to the Calc sheet willl be reflected into the Writer doc ... but if now you want to save the file, the "SAVE" menu option is inhibited and clicking on "X" also the file will not saved; you have to exit by "Save As", I think this is a bug.

Warning 3: linked objects are drive dependent. In "LO W-C odtsample.odt" objects are linked to "D:......", so if you have only C: drive, I've added the modified version "LO W-C odtsample(C).odt" with links to C:....." (http://1drv.ms/1Prcw7M).