Date: prev next · Thread: first prev next last
2019 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.