Ask Your Question

Changed entries to #REF!

asked 2020-11-19 17:01:08 +0200

wedeeg gravatar image

How do I get my figures back from #REF! ?

edit retag flag offensive close merge delete


This question is related to calc and not to math (which is the formula editor of LibreOffice). Please retag

Opaque gravatar imageOpaque ( 2020-11-19 17:19:01 +0200 )edit

Edit your question to explain why you consider it related to the mathematics formula editor, a companion application of Writer.

In case, your question is about an error in a spreadsheet, retag to replace math by calc. Press Enter twice to exit retag mode.

Anyway, edit your question to explain your context (in which circumstances #REF! appeared) and mention your OS and LO version. Otherwise your chances to get an answer are quite low. Read these guidelines and follow them.

ajlittoz gravatar imageajlittoz ( 2020-11-19 17:22:59 +0200 )edit

And maybe file format used to save it's relevant.

m.a.riosv gravatar imagem.a.riosv ( 2020-11-20 23:54:00 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-11-19 17:23:46 +0200

Opaque gravatar image

updated 2020-11-20 10:15:09 +0200


no one can answer that since #REF! means you referenced to some unknown/incorrect address (probably by copying a formula containing a relative address to a new cell and the re-calculation of the new address would result in an address outside of calc's address space). Example: Type =A1 into cell B1 and delete column A => you get #REF! in new cell A1 - nobody can determine what has been in B1 before you deleted column A

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-11-19 17:01:08 +0200

Seen: 48 times

Last updated: Nov 20 '20