https://bugs.documentfoundation.org/show_bug.cgi?id=91345
stragu <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |107810 Summary|Save not active after links |Updating data from a DDE |updated |link is not considered a | |file change (even if it | |affects formula results) CC| |[email protected] | |.org --- Comment #27 from stragu <[email protected]> --- Still reproducible in this version: Version: 7.3.0.2 / LibreOffice Community Build ID: f1c9017ac60ecca268da7b1cf147b10e244b9b21 CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded I do agree that this is a problem. Here are my steps, which hopefully make the issue more obvious: 0. Download both attachment 130400 and attachment 130401 1. Open the ODT file 2. Make sure DDE links point to the right spreadsheet in "Edit > Edit Links to External Files..." 3. Add a table or a field that uses values in the linked tables, e.g. a sum of the first table's column "a" 4. Save and close Writer 5. Open the ODS file and change a value in that "a" column 6. Save and close the ODS file 7. Open the ODT file, click "Yes" when given the opportunity to update the data from the linked files 8. Observe that the values have changed in the linked table as well as in the result of the formula that was added in step 3 9. Close Writer Actual results: No prompt to save the changes. If the source spreadsheet is modified again in that column, this actually is a case of data loss: opening the ODT will either show the old data (if linked files are not updated) or different, new data (if linked files are updated). Expected results: User is prompted to save the changes. I'd say this should be considered as a dataloss bug, not an enhancement. Not 100% sure about the meta bug, as I could not find one specific to DDE. Also tried to make bug description more precise. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107810 [Bug 107810] [META] OLE/Embedded object bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
