https://bugs.freedesktop.org/show_bug.cgi?id=83461
--- Comment #3 from Andy <[email protected]> --- After some further fiddling, I can state the situation more precisely: - in LO 4.2 or 4.3 when you input a "frequency" function in a formula, the visible result is correct but the cells occupied by the formula are not clearly defined, it depends on what you need to do: - if you move the active cell around and each time look at what is shown in the formula bar, you see the "frequency" formula only in the correct cells where frequency values are shown. E.g. if you inserted a 5 interval frequency count into d3:d7, only when you have one of these cell active you see the formula in the formula bar; - if you need to copy or move by mouse dragging the counts and the formula behind them, you cannot do that with d3:d7, which is what usually (and correctly) happens when a matrix formula covering many cells is only partially selected. The problem is that here the selection is correct (and in fact in previous releases it worked). After some trials you can see that the minimum range of cells you have to select to be able to copy/drag is actually C3:E8 in our example, or in general you must add two columns one on each side of the one REALLY containing the formula, AND a row below. In reality, other contents could be in the additional cells, possibly having nothing to do with the "frequency" formula, and thus you are forced to copy/drag them as well. - if you want to edit and modify the formula, I still have not found a cell range allowing me to do that: any range will tell you that "you cannot modify a part of a matrix formula". So at the moment I fint it IMPOSSIBLE. Normally you would just select the range D3:D7, click on the formula bar and edit it. This all happens in a single session, in which you have created the formula with "frequency" function and interact with it without saving closing and reopening the file. In fact, if you proceed to do that, everything changes!! When you reopen the file the situation is strongly different. This is it itself a significant bug: there is inconsistency between what you think you are saving and what is really saved. - To be precise, after reopening the calc file the frequency formula appears to have extended itself one cell further down, i.e. to D3:D8 now, instead of D3:D7, and in D8 there is in fact an additional value (which is the count of possible values in the data column higher that the high upper limit you gave as second argument to the function - normally it is zero as you would like to include all values in your frequency count). - Now the consistency between the cells where values are shown and those actually occupied by the formula is OK, and you can edit the formula in the usual way; however the unwanted final value in D8 cannot be eliminated because is part of a matrix function! and of course if you recreate the formula without it, then erratic behaviour described starts again. I am really surprised that nobody has run into this problem else than me. Please note that all of this is being experienced on the Italian locale with the "FREQUENZA" function actually; if this is not the case in other locales please let me know. Thanks for your attention -- 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
