https://bugs.documentfoundation.org/show_bug.cgi?id=98546
Bug ID: 98546
Summary: EDITING sheet links using a macro
Product: LibreOffice
Version: 5.0.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Hi,
when setting a link to an external spreadsheet with a macro, the values
returned aren't immediately taken into account. This causes any attempt to
VLOOKUP() the linked values to fail. The linked values are only taken into
account after saving and reopening the spreadsheet.
Tested under LO Version: 5.0.1.2
Build ID: 81898c9f5c0d43f3473ba111d7b351050be20261
Locale : fr-FR (fr_FR.UTF-8)
This was functioning correctly until v.4.3.7 and is buggy from the next version
onwards, as some have reported on the FR libreoffice users mailing list.
I attach 2 files that help understand the problem: the user creates daily
documents with data carried forward from day1 to day2 and so on. This is done
using a macro, called from a button click.
day1.ods is the original data. The data to be carried forward is in the 'to
carry' sheet.
day2.ods has the same structure + the macro that demonstrates the problem.
Clicking the 'Carry forward' button on the 'work' sheet causes a link to be
established with the day1.ods document, 'to carry' sheet. This feeds the
day2.ods 'carried' sheet. This is obtained with the ChargerReports() sub.
A workaround is to create a supplemental dummy sheet in the target (say
'carried2') where cells get their values from the 'carried' sheet. These
'carried2' values can be searched or used immediately. This adds complexity to
the spreadsheet, though, and causes a noticeable overhead when the source data
is big.
Note that deleting the link or not has no influence on the faulty behaviour.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
