[Issue] Linked spreadsheets

Discuss the spreadsheet application
Post Reply
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

[Issue] Linked spreadsheets

Post by RusselB »

I have a few spreadsheets that are linked so that I can effectively maintain a budget.
This has worked great for years, so I see no reason to change.
I recently opened one the files to make some entries, and noticed that I was asked if I wanted to update the links twice, not the one time that I'm used to.
The first time I was asked, was after I selected the file to be opened, but before the file actually showed on the screen, and the second time after the file showed on the screen.
It is the second request that I'm used to seeing.
Can anyone else duplicate these results and/or explain what is happening?
This just started since upgrading to OpenOffice 4.1.4
Last edited by Hagar Delest on Wed Jun 19, 2024 11:42 am, edited 1 time in total.
Reason: tagged Issue.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
Villeroy
Volunteer
Posts: 31363
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Linked spreadsheets

Post by Villeroy »

Yes. Same issue with file:url-links, with DDE-links, with sheet-from-file-links and with links to external data (named range within ods).
When you set Tools>Options>Calc>Update links to "never" (don't ask), it prompts "Update all links?" anyway.
When you set Tools>Options>Calc>Update links to "always" (don't ask), it prompts "Update all links?" and "This file contains links. Should they be updated?". Same with "ask" option.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
Posts: 31363
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Linked spreadsheets

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply