https://bugs.documentfoundation.org/show_bug.cgi?id=92749
--- Comment #8 from Laurie <[email protected]> --- This will probably be my last comments on this. 1) I can live with the hard recalc. 2) I have found that file size is not important. A 270K file still behaves this way. 3) As a relative newbie to Libre Office Calc I was rather put off when the Workbook which worked fine in version 4.1 gave garbage in 4.5 4) (for Joel) Does a change in the index column of a table referenced by VLOOKUPs trigger re-evaluation of those VLOOKUPs? I suspect the core of the problem is that the values in the index column of the underlying table Summary.A118:M363 are among those which change and that changes to an index column do not flag for re-evaluation of the lookups dependant on them. But this is remedied by changing the number of steps of calculation or by the Ctrl+Shift+F9 combination. If this is a programming choice to speed re-calculation of the most commonly encountered Workbooks I agree with it. Somebody who is sufficiently technically literate to design a Workbook complex enough to need it is literate enough to apply the simple workaround. 5) Similar wrong results appear when a different month of data is selected by changing Print.V3 Again, the index column of the underlying table in the Summary Sheet is changing. 6) Thanks for the help. -- 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
