Currently when we open spreadsheet with circular reference, we are not notified in any way, until we click in circular reference cell, when we see "Error: Circular reference". https://helponline.libreoffice.org/5.4/en-US/text/scalc/05/02140000.html?&DbPAR=CALC There could be 2 ways to raise awareness, similar to some other software: - warning in the beginning that there are circular references in the document, with OK to proceed and Help to explain - permanent notification in Status Bar "Circular references found" which, when those cells are selected, changes to current "Error: Circular reference" Note: seems Calc doesn't have function to show circular reference cells, which should be another bug. Once this one is confirmed.
On one side circular circular references are not an error when Menu/Tools/Options/LibreOffice Calc/Calculate/Iterations it's enable. And it's posible find cells with the 'Err:522' with Find&Replace, searching for the error with 'Formatting display' enable and searching for values.
Thank you, but I still remain with the proposal. Alternative for point 2: permanent notification in Status Bar "Circular references: B2, D6, H8" i.e. which immediately shows where they are. If this is feasible, point 1: warning in the beginning may not be necessary. Or may be another enhancement bug.
Eike, what do you think ?
To be able to display such status information we'd have to recalculate the entire document after load. We certainly don't want this unless the user has explicitly chosen to do so.
Thank you. So what's possible then without recalculation? - Warning at the beginning with "OK to proceed", "Recalculate" and "Help to explain"? - first suggestion: permanent notification in Status Bar "Circular references found" which, when those cells are selected, changes to current "Error: Circular reference" and maybe: - permanent notification in Status Bar "Circular references: B2, D6, H8" only if Recalculate pressed? What do you think of minimal solution now, now just this: - permanent notification in Status Bar "Circular references found" which, when those cells are selected, changes to current "Error: Circular reference" It's also acceptable because it gives some clue and show cells could be another bug. Maybe Warning could then also be another bug.
(In reply to Timur from comment #5) > What do you think of minimal solution now, now just this: > - permanent notification in Status Bar "Circular references found" which, > when those cells are selected, changes to current "Error: Circular reference" > It's also acceptable because it gives some clue and show cells could be > another bug. Maybe Warning could then also be another bug. I checked with moggi as well and this is not possible without recalculating. So let's close.