https://bugs.documentfoundation.org/show_bug.cgi?id=92749
--- Comment #2 from Laurie <[email protected]> --- Response to the question from Timur. On the file I uploaded, Worksheet “Translation” in Column “AB” the first line above the “#N/A” reports the number of user charges which ought to be listed above that line. When first opened, the count corresponds with the number of lines of user charges and they are looked up correctly. If I change the selection criteria in cell “AI5” from “1” to “0” the new count appears but the lines above do not report correctly. All of the lines still appear and the cells within some lines are selecting data from different lines in the source table. That is the problem. With “AI5” = “0” these lines should report a subset of the data which was displayed when “AI5” = “1”. Now alter the number of steps in “Tools – Options – Libre Office – Calculate. Any alteration; even downward. >From then on until the Workbook is closed it recalculates correctly. That will demonstrate what this set of lookups is supposed to do. I doubt that it is the number of iterations that is relevant because a downward change works too. I suspect that something else gets “set” as the change is recorded and that window is closed. Maybe some other change would have the same effect but this one works for me. This was not noticed while the file was smaller; I don’t remember how much smaller. The file grows as new data is added each month. I have only one L.O. Calc file of anywhere near this size. I have been using MS_EXCEL extensively but am trying to make the switch. In L.O. 4.0 this file opens and re-calculates correctly. The file was created in L.O. 4.0 In 4.4.4.1 and 4.4.4.3 we have the problem. Where can I get 4.4.5 and/or 5.0? (Assuming that these are versions for Windows systems.) -- 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
