[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [libreoffice-users] copying a ODS file and setting some cells to value in old file
- Subject: Re: [libreoffice-users] copying a ODS file and setting some cells to value in old file
- From: Fred James <firstname.lastname@example.org>
- Date: Wed, 11 Dec 2019 15:11:07 -0500
- To: Johnny Rosenberg <email@example.com>, libreoffice <firstname.lastname@example.org>
Johnny Rosenberg wrote:
Den ons 11 dec. 2019 kl 19:55 skrev Fred James <email@example.com>:Thank you for the URL. I found the definition of Err:540 ... "External content disabled". From there I looked at LibreOffice help and found the instructions for inserting the reference/link to the cell in the other ODS file "To Reference a Cell in Another Document", which I followed right up to "Confirm the formula by clicking the green check mark.", but I don't have a green check mark to click.
(Please forgive me if this is a duplicate ... thank you)https://help.libreoffice.org/6.3/ar/text/scalc/05/02140000.html?DbPAR=CALC
I do this every year, but this year I am experiencing problems
OS Mageia 7, Plasma
The original file is an 18 sheet ODS file used for budget purposes
I can successfully copy the original file (in original location) to the
new file (in new location), either by ...
open the old file and save-as (File -> Save As)
open Dolphin file manager, copy the old file, paste the file into a
new location, and rename it to the new file
open a terminal and perform the copy operation there (cp
Then in the new file, I delete unwanted sheets and data to start the
year fresh. Next I set the values of some cells in the new file, to the
values of some cells in the old file. (Example:
This has always worked well in the past, but this year, I am getting an
error in the destination cell ... at first that was ErrL514, and now it
Can you advise, please?
Then I tried looking for where the external content might be disabled/enabled ... no luck so far.
Answers to the question(s) at Google seem to be written for other versions of Libreoffice, because they don't match too well to anything in this version (184.108.40.206)
Can you advise, please?
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
|[libreoffice-users] copying a ODS file and setting some cells to value in old file||Fred James <email@example.com>|
|Re: [libreoffice-users] copying a ODS file and setting some cells to value in old file||Johnny Rosenberg <firstname.lastname@example.org>|
- Prev by Date: Re: [libreoffice-users] copying a ODS file and setting some cells to value in old file
- Next by Date: Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
- Previous by thread: Re: [libreoffice-users] copying a ODS file and setting some cells to value in old file