<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:ilmari.lauhakangas@libreoffice.org" title="Buovjaga <ilmari.lauhakangas@libreoffice.org>"> <span class="fn">Buovjaga</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Links to external files in a Calc table integrated in a Writer document can no longer be updated (steps in comment 11)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133536">bug 133536</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">OS</td>
<td>Windows (All)
</td>
<td>All
</td>
</tr>
<tr>
<td style="text-align:right;">Keywords</td>
<td>
</td>
<td>bibisectRequest, regression
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>Links to external files in a Calc table integrated in a Writer document can no longer be updated.
</td>
<td>Links to external files in a Calc table integrated in a Writer document can no longer be updated (steps in comment 11)
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Blocks</td>
<td>
</td>
<td>107810, 112071
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Links to external files in a Calc table integrated in a Writer document can no longer be updated (steps in comment 11)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133536#c14">Comment # 14</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Links to external files in a Calc table integrated in a Writer document can no longer be updated (steps in comment 11)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133536">bug 133536</a>
from <span class="vcard"><a class="email" href="mailto:ilmari.lauhakangas@libreoffice.org" title="Buovjaga <ilmari.lauhakangas@libreoffice.org>"> <span class="fn">Buovjaga</span></a>
</span></b>
<pre>(In reply to Lothar Viel from <a href="show_bug.cgi?id=133536#c11">comment #11</a>)
<span class="quote">> 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!</span >
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</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] OLE/Embedded object bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107810">Bug 107810</a>] [META] OLE/Embedded object bugs and enhancements
</li>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Linked external data issues"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112071">Bug 112071</a>] [META] Linked external data issues
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>