Calc doesn't recalculate formulas correctly. I should force to recalculate all by pressing Ctrl+Shift+F9 several times. And when I sort rows then calculated values again becomes wrong. Seems Calc taking them from old cache. And then again I should recalculate them forcely with hotkeys. When I recalculating all formulas and saving document and opening it again - formula values again is wrong. Calc not saving recalculated correct values.
Could you to attach a short sample document that exhibits the behavior with step by step instructions how to reproduce?
@Eldar: ping?
Insufficient data.