Created attachment 183160 [details] picture shows the faulty display / error There is an error, which I still not found a way to reproduce, but come across very often (either after opening a file or while switching between different sheets). I created a spreadsheet calculating a list of all Champions League winners, and sort them regarding their amount of appearance. I made two screenshots which show my problem: 1) error appears 2) “one solution” to correct the error by unhiding some cells In 1) you can see the error. In 2) you can see the correct display. And between them, I just unhid some cells. But this is only one way. Another way to correct the display is by edit something - most times (not always!) the display changes to show the correct values. I have a feeling that this could be connected to the INDIRECT and ADDRESS functions which I use in this spreadsheet. The error also occurs in other spreadsheets I created and used INDIRECT and ADDRESS. In my opinion Err:522 is misleading, because it simply doesn't fit in this case. P.S. unfortunately, I can only add one screenshot, so I decided to add the error appearance
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 183161 [details] example ods-file which shows the error every now and then the newly added ods-file sometimes shows the reported error, but I still didn't find a way to reproduce. Edit: I searched for weeks to find a solution in the internet and wasn't able to find something. Today I changed my search engine and found a post in stackoverlow which exactly describes my problem (and is more than 6 years old! - marked as unsolved)
(In reply to Martin from comment #2) > Created attachment 183161 [details] > example ods-file which shows the error every now and then > > the newly added ods-file sometimes shows the reported error, but I still > didn't find a way to reproduce. > > Edit: I searched for weeks to find a solution in the internet and wasn't > able to find something. Today I changed my search engine and found a post in > stackoverlow which exactly describes my problem (and is more than 6 years > old! - marked as unsolved) Can you share the link to the StackOverflow post?
Here is the stackoverflow post I found, which describes my problem quite well and also the ideas to overcome the error once - but not forever: https://stackoverflow.com/questions/36224524/false-error-522-circular-reference
While I don't currently see Err:522 in attachment 183161 [details] (so, this is a guess ATM), the problem might be related to the fact that a formula in a certain cell uses its own cell address within the formula. For example, part of the formula in F3 is "...COUNTA(F$3:F3)...". I am just mentioning this as a potential example, as I have not checked this in detail (since I don't see the reported Err:522 ATM). Certain functions can accept this, but others can't. Think about it: you are asking for a formula to evaluate the resulting content of itself, in order to calculate the result. I would suggest either trying to find an alternative, or check whether someone in https://ask.libreoffice.org has some idea. If you find exact steps to replicate the problem and there is really a bug, you could come back to report it in order to solve it.