https://bugs.documentfoundation.org/show_bug.cgi?id=92749
--- Comment #14 from Laurie <a...@wycliffe.org> --- Workbook reduced to Calculation of Photocopy/Print charges. This is where the problem was most obvious. Could probably reduce the file size further but this is probably minimal complexity. The flow is;- a) by lookups from the PCopy sheet to the Summary Sheet. b) Calculations of charges on the Summary Sheet. The results of these calculations including Column A are affected by the Value in I3 (formerly AI3) of the Translation worksheet. c) Lookups to the Translation Worksheet eliminate the lines with charge = 0. These Lookups reference column A of the Summary sheet to locate the next line with a non-zero charge. If one of these lookups references from a value (say 10) in this column and that value (10) subsequently changes (say to a 9) without triggering a re-evaluation of that lookup that could explain what we are seeing. So the calculations operate on the results of lookups and other lookups operate on the results from the calculations. -- 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