We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Link to cell in another Calc sheet yields Err:540.

asked 2020-08-27 20:54:47 +0200

wagnerr gravatar image

I am attempting to link to data in another spreadsheet by entering "=" in the refering cell and then left-clicking the referred cell in the other spreadsheet. It gives Err:540 in the referring cell. It appears not to depend on the content of the referred cell (text or numeric or link to another cell in the referred spreadsheet.) LO V6.4.4.2 on kubuntu.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-08-27 21:19:13 +0200

LeroyG gravatar image

Save the new file, and reload it (choose menu File - Reload), or just close and reopen it. You will see an Enable Content button; press it.

See: https://ask.libreoffice.org/en/questi...

Add Answer is reserved for solutions.

Press edit below your question if you want to add more information; also can comment an answer.

Check the mark (Correct answer mark) to the left of the answer that solves your question.

edit flag offensive delete link more

answered 2020-11-01 19:13:31 +0200

erAck gravatar image

Fwiw, sounds like bug tdf#135108 but I never could reproduce it with a new document, only with a loaded document that so far had no linked externals.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-08-27 20:54:47 +0200

Seen: 107 times

Last updated: Nov 01 '20