[libreoffice-users] Spurious Circular reference errors

2014-09-10 Thread david_lynch
I have a quite complex spreadsheet. About half the time, when I change a cell, I get several hundred Err: 522 cells. This will happen even when the cell I change is referenced by no other cell. I can get rid of all the Err:522 entries by CNTL:SHIFT:F9 or by double clicking on the column

Re: [libreoffice-users] Spurious Circular reference errors

2014-09-10 Thread Tom Davies
Hi :) If it's not hugely heavy and doesn't have confidential stuff such as names and addresses or super-secret financial info then how about just uploading it to Nabble and let us have a look? It sounds to me like there is a circular reference buried somewhere in the sheet but somehow you are