https://bugs.documentfoundation.org/show_bug.cgi?id=92407
--- Comment #23 from gmarco <[email protected]> --- As you like ... but a lot of time has passed, the Guide has remained almost the same as in 1917 and the gaps reported then have remained. • The use of "dragging" is not addressed, but, beeing commonly used to copy selected data, requires a warning: dragging a selected area from the sheet in CALC to the document in WRITER the spreadsheet area is embedded into the text document with a moving (cut) and not a copying (copy). So, to avoid losing data, you should restore the area in the CALC spreadsheet before saving it. To avoid this you should do, as indicated in the Guide at Creating a DDE link in Writer: from the EDIT menu "Copy (Ctrl+C) a selected area from the sheet in CALC, then Paste Special (Ctrl+Shift+V) in WRITER and then selecting LibreOffice n.n - Spreadsheet". (see also *note*) • Good the documentation in "Inserting a file as an OLE object" selecting the "Link to file" option (see also *note), but, if you want to insert only an area of the file, you can only insert and link it as DDE, as previously said, but without synchronization). • The Writer Guide (EN only too) may be usefull but many people don't know it (it is not recalled in help menu (L.O.guide F1 or User guide). (*note*): In the Guide ("Introduction: OLE and DDE objects") is said: "The difference between a DDE object and a linked OLE object is that a linked OLE object can be edited from the document in which it is added as a link, but a DDE object cannot. For example, if a Calc spreadsheet is pasted into a Writer document as a DDE object, then the spreadsheet cannot be edited in the Writer document.". It seems to me that this is not exactly so: both objects can be edited in WRITE same way, but the difference is that changes made in WRITE to the object pasted as DDE are not reflected in the original CALC file and vice versa, i.e. both documents are not in sync with each other. Summing up and concluding: the problem of automatic and synchronized updating of a single area of a spreadsheet seems still unmanageable, while I believe that the most common use is the incorporation of an area (rather than an entire sheet) in a text document and that this object can be kept synchronized and updated respecting the changes made to the original source. I no longer have the possibility to verify how it is now managed in MS, but this is what I obtained in the past in Word-Excel. -- You are receiving this mail because: You are the assignee for the bug.
