Changed entries to #REF!
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
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
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
mathbycalc. PressEntertwice 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.