Calc - links - editing

[abcd]

Hello,
is there any way to edit in Calc the path of the links, i.e. the “formulas” enclosed in
{=[…]}, which are in turn the result of copy&paste/special/links. I noticed, they get frequently corrupted, pointing to inexistent files. In my case subdirectories is “added” or either removed to/from the original path when the worksheet is saved and subsequently reopened. I noticed also that changing the location (on the disk) of such Calc worksheets and reopening them result in the link path automatically changed by libreoffice. Using LO 6.4.2 on Linux.

Thanks

[anon73440385]

i.e. the “formulas” enclosed in {=[…]},

These are not links but array formulas and to edit them, you need to select the whole result array. For more details see LibreOffice Help - Array Functions

[abcd]

I’ll try. Thank you.