https://bugs.freedesktop.org/show_bug.cgi?id=81757
--- Comment #10 from Ryszard <ry...@iname.com> ---
In one point LO must change the trigger for recalculating sheet, and now
recalculations are also triggered by change made from custom macros.
In this case I have found out the problem is that cell J12 is changed from
macro function. It looks like this is causing auto recalculation, of course
this leads to infinite loop so "Iterations" option must be set, and values of
depending cells might be incorrect since macro functions are never finished. If
I go to macro editor I'm getting error variable not optional with highlighted
line " If ((insRadius/thickness) <= 1 ) Then". This error is only shown in
BASIC editor.
To force calculation you may use hard recalculate, or enter same data or set
same option again.
commenting lines oSheet.getCellRangeByName("J12").value = kFactor(selItem
in macro functions and making value of cell
J12=BENDFACTOR(radius,angle,thickness) will make everything back to normal,
also "Iterations" option may be unset.
I do not know if this LO behavior was intentional, but for me it is quite
critical bug. Many people may not realize about values not being updated
correctly in their spreadsheets, OO 4.1.1 is working as expected.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
