https://bugs.freedesktop.org/show_bug.cgi?id=67489
--- Comment #2 from Markus Hoenicka <[email protected]> --- (In reply to comment #1) > Hi Markus, > > I can confirm the behaviour. > But also can tell that the problem is result of a new stetting. > > Pls go to Tools > Options > Calc > Formula ... > Recalculate on file load > Set this to ODF spreadsheet 'always recalculate' and the problem is gone. > > > But now the question: is this effect expected with that function, or not.. > Or should we write a comprehensive blog with information about new Calc > stuff... > Kohei, can you pls give your advise? > thanks! > Cor Thanks for the clarification. My humble opinion is: 1. Pasting a formula and have it display the wrong result does not make any sense. There is no point in having this as a default behaviour. 2. The result of pasting a formula must not depend on how many cells you copy. Either you never recalculate, or you always recalculate. Anything else is confusing at best and makes the spreadsheet inconsistent at worst. 3. As an end user, I prefer consistent behaviour to blog entries that explain inconsistent behaviour. 4. The bug (or misfeature) is not related to file loading whatsoever. Before reporting the bug, I checked if there is any option that might affect cell recalculation after copy/paste. I did not find anything appropriate. A setting labelled "Recalculation on file load" must not affect the behaviour of pasting cells. just my 2cc Markus -- 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
