https://bugs.freedesktop.org/show_bug.cgi?id=79770
--- Comment #6 from Miguel <[email protected]> --- Thanks, I now understand about the range names and database names. But replacing the database name by the range name does not improve anything (but deleting a database range makes the software crash reproducibly if this range is still used in formulae). Setting the GUI in English does not change anything either. I am using the same build as you are, what else can I do to confirm the bug? May it be platform-specific? I have Linux 32 bits: Linux ....... 3.13.0-30-generic #54-Ubuntu SMP Mon Jun 9 22:47:59 UTC 2014 i686 i686 i686 GNU/Linux Let me explain in which conditions the problem appears: it is written in a complex way, in order to recalculate the macros just when it is needed (and it used to work well). There are 2 ranges, filled manually: $Plan.$E$7:$G$526, $Plan.$I$7:$K$526 The references to these ranges are set in two cells: cfg.C33, cfg.C34 The text address of these ranges are in two next cells: cfg.D33, cfg.D34 The locations (sheet, sheet number, row, row number, column, and column number) of these ranges are in two blocks of 6 cells: cfg.E33:J33, cfg.E34:J34 The 2 cells Plan.B7:C7 are a matrix, computed by a macro using the locations of these ranges. They are always good. The 2 cells below Plan.B8:C8 are exactly the same matrix, computed in exactly the same way, except that one parameter is "1" instead of "2". Depending on where is the cursor when I recalculate, these cells (and all the cells below) will contain "Err:522" (circular reference) instead of the correct result. Although this is complex, I can see no circular reference in this process. At some date, probably in 2011 or 2012, the recalculate behavior evolved: it became must slower (systematic complete recalculate?) and less reliable (this kind of problems). Miguel -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
