In libreoffice CalcWhen copying a sheet from one worksheet to other the reference links within the sheets changes to temporary. How to avoid this?

[MonicaK]

Thanks in advance

[PYS]

Hi

Create or rename the “targets” sheets in the destination spreadsheet before copying (move). For example, if you copy Sheet2 containing a formula =test.A1 in a new spreadsheet, creates or renames a “test” sheet in this new spreadsheet before copying.

Regards