[Libreoffice-bugs] [Bug 133536] Links to external files in a Calc table integrated in a Writer document can no longer be updated (steps in comment 11)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133536

Buovjaga <ilmari.lauhakangas at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|Windows (All)               |All
           Keywords|                            |bibisectRequest, regression
            Summary|Links to external files in  |Links to external files in
                   |a Calc table integrated in  |a Calc table integrated in
                   |a Writer document can no    |a Writer document can no
                   |longer be updated.          |longer be updated (steps in
                   |                            |comment 11)
             Status|UNCONFIRMED                 |NEW
             Blocks|                            |107810, 112071
     Ever confirmed|0                           |1

--- Comment #14 from Buovjaga <ilmari.lauhakangas at libreoffice.org> ---
(In reply to Lothar Viel from comment #11)
> I created the Calc spreadsheet integrated in the Writer document as follows:
> Click on 'Insert' in the open Writer document, then on 'Object', on 'OLE
> Object...' and on 'LibreOfficeDev 7.1 Spreadsheet'.
> In the Calc Spreadsheet thus created, enter a number between 2 and 5 in cell
> B1 and the following function in cell B2:
> 
> =INDEX('file:///D:/Calc Spreadsheet with external
> Data.ods'#$Tabelle1.$A$1:$A$10;B1)
> 
> This should cause the corresponding value from the external Calc spreadsheet
> to appear in cell B2: 200, 300, 400 or 500, depending on the number in cell
> B1. The prerequisite is, of course, that the Calc spreadsheet with the
> external values is located in the path specified in the INDEX function.
> 
> Afterwards, please save the Writer document with the integrated Calc
> spreadsheet under any name and close it. 
> 
> Now open the Calc spreadsheet with the external values and change one or
> more values in column A (e.g. in cell A3 the number 300 to 333). Then save
> and close the spreadsheet and open the Writer document and the integrated
> Calc spreadsheet again and enter the number 3 in cell B1 (confirm with
> Enter, of course), then the previous value 300 is still displayed in cell
> B2, as the link to the external calc spreadsheet is not automatically
> updated. 
> 
> To update this link, you have to click on 'Edit', 'Link to External
> Files...' and 'Update', as I already described yesterday. If the path
> displayed under 'Sourcefile' does not correspond to the actual path of the
> Calc spreadsheet, the correct path must be selected with the button
> 'Modify...' before clicking on 'Update'. Finally, click on 'Close'. 
> 
> Now the modified value, namely 333, should actually be displayed in cell B2,
> but this is not the case! The previous value 300 is still displayed!

Thanks, I reproduce with the steps.

The link updating must be attempted while still editing the OLE object.

Arch Linux 64-bit
Version: 7.2.0.0.alpha0+
Build ID: b36a40a809206a57160108b3361f42420f619c2e
CPU threads: 8; OS: Linux 5.9; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 23 December 2020


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107810
[Bug 107810] [META] OLE/Embedded object bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=112071
[Bug 112071] [META] Linked external data issues
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201224/6b65ae76/attachment.htm>