[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 #7 from Lothar Viel <lothar.viel at arcor.de> ---
(In reply to Martin Srdoš from comment #4)
> Please, write step by step how did you make the tables.
> 
> I did Calc tables and then I copied to writer by ctrl+shift+V. Then I am
> editing the original calc document and after save documents it works good
> also in writer. However I made my own files.
> 
> Also check that on actual version.
> 
> Version: 7.2.0.0.alpha0+ (x64)
> Build ID: 4e63ec27b69fa01ff610c894c9fbf05c377a6179
> CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL:
> win
> Locale: cs-CZ (cs_CZ); UI: en-US
> Calc: CL

Dear Martin.
First of all, I would like to apologise for responding so late. But
unfortunately I have had so much to do in the last few weeks that I haven't
found the time.

My example involves two different Calc spreadsheets. One is integrated in a
Writer document and should display the corresponding value of an external Calc
spreadsheet file after entering a row number. The second, external spreadsheet
file thus serves as a database that is to be accessed from the integrated Calc
spreadsheet with the help of an INDEX command.


Error description:
If a Calc Spreadsheet is included in a Writer document and there is a link to
another, external Calc Spreadsheet with data, this link can no longer be
updated.

Preparations:
Please save the again simplified two documents 'Writer Document with integrated
Calc Spreadsheet.odt' and 'Calc Spreadsheet with external data.ods' somewhere
on your WINDOWS PC.

Steps to reproduce the error:
Open the Writer document and then also the integrated Calc spreadsheet.
In field B1 of this small spreadsheet, a number (here in the example 2, 3, 4 or
5) can be entered that refers to a corresponding row number of the external
Calc spreadsheet ('Calc Spreadsheet with external data.ods'). 
In the field B2 of the integrated Calc spreadsheet, the values of the external
Calc spreadsheet are accessed and displayed with the function INDEX.
Accordingly, the field B2 shows the value of the row number of column A of the
external Calc spreadsheet, which is entered in B1.

I.e. if, for example, the number 2 is entered in field B1 of the integrated
Calc spreadsheet, the value 200 must be displayed in field B2 as it is stored
in row 2, column A of the external Calc spreadsheet. If, for example, the
number 3 is entered in B1 of the integrated spreadsheet, the value 300 must
appear in field B2 and so on.

If one or more values of column A in the external Calc spreadsheet are
modified, the integrated Calc spreadsheet in the Writer document still shows
the previous values because the link to the external spreadsheet is not updated
automatically. Even if the Writer document including integrated Calc
spreadsheet is saved, closed and reopened, field B2 of the integrated Calc
spreadsheet still shows the old values from the external spreadsheet.
To update the link of the integrated Calc spreadsheet with the now changed
external Calc spreadsheet, one has to click on 'Edit' with the integrated Calc
Spreadsheet open, then on 'Links to External Files...', then on 'Modify...' and
now select the external Calc Spreadsheet 'Calc Spreadsheet with external Data'
and click on 'Open'. Finally click on 'Update' and now the selected file
including path should be displayed in the line 'Source file'. Close the window
by clicking on 'Close'.
Now the modified values of the external Calc spreadsheet should be displayed in
the integrated Calc spreadsheet. 

This update of the link to the external Calc spreadsheet still worked properly
up to LibreOffice version 6.2.5, but from version 6.2.8 up to the latest
version 7.1.0.0 beta1(x64) this no longer works! The previous values are still
displayed and there is no possibility to display the modified, current values
of the external Calc spreadsheet. I do not have the LibreOffice versions
between version 6.2.5 and 6.2.8, so I cannot determine exactly from which
version onwards the updating of the link to the external Calc spreadsheet no
longer works.

If you want to test updating the link again with the old LibreOffice version
6.2.5 but no longer have access to it, I can send you a link to download from
my cloud (64 bit version).

-- 
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/20201222/de0b0da4/attachment.htm>