I generally see this as a development problem. Without going into formula details problems the situation is like this: Let's say A and B represent chainsaws to chop a tree, then A or B will iterate up to 32,767 times until tree falls over to one side falling into next best house. Other cells calculating statical necessities will be ignored by iteration so whole spreadsheet is never recalculated. On 04.07.2016 12:11, Eike Rathke wrote:
Hi Horst, Note that you wrote your mail to the developer mailing list that is about coding and developing things, not general "I have a problem" discussions. Please see https://www.libreoffice.org/get-help/feedback/ and https://www.libreoffice.org/get-help/community-support/ for better channels. However.. On Thursday, 2016-06-30 17:02:56 +0200, Horst Reinhard Umlauf wrote:With the first spreadsheets I remember the main idea behind iterations and change limit was consistency within spreadsheets. It seems this has changed. When cells were changed within the set limit the iteration marker was set. For iterations it was compared and when the number of iterations was not reached the whole sheet was reprocessed. Why has this changed to a cell iteration value where the number of iterations is processed on a cell basis? Can it be expected that this will be changed again in the future?I really don't know what exactly you're talking about. Eike
Attachment:
signature.asc
Description: OpenPGP digital signature