Changed entries to #REF!
How do I get my figures back from #REF! ?
First time here? Check out the FAQ!
How do I get my figures back from #REF! ?
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
Asked: 2020-11-19 17:01:08 +0100
Seen: 44 times
Last updated: Nov 20 '20
arabic language support [closed]
Libreoffice math. no IME. Cannot edit formulas. [closed]
How can I get better quality in Math GIF images for HTML exports? [closed]
Can I export a document to LaTeX? [closed]
What could prevent the small formula window from working in LibO 3.5? [closed]
MATH The application does not appear below the edit window. [closed]
Del Operator in Libreoffice Math [closed]
is there something like quickbooks in libre office? [closed]
This question is related to calc and not to math (which is the formula editor of LibreOffice). Please retag
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
bycalc
. PressEnter
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.
And maybe file format used to save it's relevant.