Bug 86487 - Err 522 in formula cell when I open my document.
Summary: Err 522 in formula cell when I open my document.
Status: RESOLVED DUPLICATE of bug 85431
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.6.2 release
Hardware: x86 (IA32) Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-11-20 11:53 UTC by madvic
Modified: 2014-11-20 13:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description madvic 2014-11-20 11:53:12 UTC
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
Comment 1 GerardF 2014-11-20 12:43:38 UTC
Try hard re-calc (Ctrl+Shift+F9).

May be a duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=85431
Comment 2 madvic 2014-11-20 12:50:36 UTC
It's the same problem.
Si vous êtes francais, on peut paler french. :-)
Comment 3 raal 2014-11-20 13:53:43 UTC
According to comment 2 closing as duplicate.

*** This bug has been marked as a duplicate of bug 85431 ***