Re: [libreoffice-users] copying a ODS file and setting some cells to value in old file

Den ons 11 dec. 2019 kl 19:55 skrev Fred James <fredjame@fredjame.net>:

> (Please forgive me if this is a duplicate ... thank you)
>
> I do this every year, but this year I am experiencing problems
>
> OS Mageia 7, Plasma
> LibreOffice 6.2.8.2
>
> 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)
>          or
>      open Dolphin file manager, copy the old file, paste the file into a
> new location, and rename it to the new file
>          or
>      open a terminal and perform the copy operation there (cp
> oldlocation/oldfilename newlocation/newfilename
>
> 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:
> ='file:///home/fredjame/mystuff/budget/2019/budget_2019.ods'#$'TD
> December 2019'.F114)
>
> 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
> is Err:540.
>
> Can you advise, please?

https://help.libreoffice.org/6.3/ar/text/scalc/05/02140000.html?DbPAR=CALC


> Thank you
> Regards
> Fred James
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy