[Libreoffice-bugs] [Bug 133536] Links to external files in a Calc table integrated in a Writer document can no longer be updated.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #11 from Lothar Viel <lothar.viel at arcor.de> ---
Created attachment 168459
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168459&action=edit
Example Writer document with integrated Calc spreadsheet

I have uploaded the example Writer document with the integrated Calc
spreadsheet again and not marked it as 'patch'.

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!

Just now I found out something very interesting:

If a new calc spreadsheet is created in a Writer as described above, updating
the link to the external calc spreadsheet works absolutely perfectly if the
update is carried out as described above ('Edit', Link to External Files...').
However, if the Writer document with the integrated calc spreadsheet is saved
and closed and then opened again, the updating of the link no longer works!

-- 
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/20201223/3639057d/attachment.htm>