Ask Your Question
0

Changed entries to #REF!

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

wedeeg gravatar image

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

edit retag flag offensive close merge delete

Comments

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 +0100 )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 +0100 )edit

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

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

1 Answer

Sort by » oldest newest most voted
3

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

Opaque gravatar image

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

Hello,

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

Stats

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

Seen: 44 times

Last updated: Nov 20 '20