When I open my document, many cells are in 522 error. In this formula, I have just condition "If". This condition is on cell with custom function. This custom function go in an other document, search a sheet and execute a RECHERCHEV on this sheet. i have the same problem with custom function in ThisComponent. I want to refresh this Cell -> F9 (recalculate) -> nothing Steps to reproduce: 1. A1 : A custom function 2. A2 : Formula : If Then Else. 3. Save and Close 4. Open the document 5. See in A2, an 522 error 6. I try to recalculate with F9 -> nothing 7. I try with macro to recalculate -> nothing 8. I change a caracter and I validate -> OK A video for illustrate this problem : http://www.dailymotion.com/video/x2ahpsa_problem-calc-libreoffice_tech thanks
Try hard re-calc (Ctrl+Shift+F9). May be a duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=85431
It's the same problem. Si vous êtes francais, on peut paler french. :-)
According to comment 2 closing as duplicate. *** This bug has been marked as a duplicate of bug 85431 ***