https://bugs.freedesktop.org/show_bug.cgi?id=83461
--- Comment #5 from Andy <[email protected]> --- Hello and thanks for your suggestions. What you write is true, but it is different from the behaviour of the function in previous versions (and from that of present OO release 4.1.1). >>>>> BEFORE: - if you inserted the function preselecting one cell (as you say) or k+1 (with a k array of limit values) you got the k+1 counts, k BELOW you limit values and the last ABOVE the last limit value. - if you inserted the function preselecting ANY other number of cells (2, 3, ... k) you got results only in the corresponding cells, the function was present only in those cells, and could be moved, copied and edited just selecting the same cells, no more no less. This happened in particular if you pre-selected k cell, non wanting the count above your last limit value because you designed the limit values so as to include all case. >>>>>> NOW: - in the first case nothing has changed; - in the second case above you get the partial results in the pre-selected cells, but the inconsistency between what results you see and what cells are part of the matrix that I described in previous comments is there. I think that in this situation, with no apparent error of which the user is alerted, the behaviour is - and looks - very amazing and irrational. When you save close and reopen, results are forced to be shown in full, regardless of your pre-selected range, so what has happened is that it is actually NO MORE POSSIBLE to obtain and show partial results of a matrix function. Prompted by your comment I extended the analysis to other matrix functions, noticing that is holds for many (probably all) of them: so there is SOMETHING THAT HAS BEEN CHANGED IN THE BEHAVIOUR OF MATRIX FUNCTIONS IN GENERAL. I was not aware of this change and the help documentation does not make it clear. IMHO the previous situation was much preferable: - now you have lost a functionality (the ability to produce only partial results from a matrix function), that you may consider not so relevant, but maybe relevant to some; - the behaviour of the sheet when you pre-selct a partial range of cells to insert a matrix function appears to be strange and inconsistent, since the ever-present link between what you insert in cells and what you see in the formula bar is lost, even if you get no error message. And in fact, when you save and reopen things are different. It would have been better, then, that in this case you got the "forced full results" immediately, not only after closing and reopening the file. Any further comments of hints are welcome. -- 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
