https://bugs.freedesktop.org/show_bug.cgi?id=83461
Priority: medium
Bug ID: 83461
Assignee: [email protected]
Summary: EDITING: The “frequency” matrix function is assigned
to the wrong number of cells and becomes unusable
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.3.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 105707
--> https://bugs.freedesktop.org/attachment.cgi?id=105707&action=edit
A calc sheet with the anomalies of the "frequency" function shown and described
Problem description: The frequency matrix function has changed its behaviour
and it is not sensibly usable anymore.
The old function could be inserted into an arbitrary number of cells and it
ended up occupying just in the cells you selected before writing it.
The most common situation was that:
- you had a data column of arbitrary size,
- defined a column vector of upper limit for intervals of value (or specific
single values for discrete data) for which you wanted to obtain the frequency
counts in the data column (occupying, for example, k cells in all).
- Then you selected the column range of k cells just to the right of the cells
containing upper limits, typed the “frequency” function with the two inputs
(data column and upper limits column) and inserted it with CTRL+SHIFT+enter
- Afterwards, in old versions of LO the matrix function could be edited, moved
around or copied and pasted simply re-selecting the k cells where you did
input it.
- Now in 4.3.1 the function can be inserted pre-selecting any number of cells
(even only one), but the problem is that, after entering it, it occupies a
number of cells which is not clear, but is bigger than the column of k cells
where you see frequency counts!! In other words there are some cells occupied
by the function but that when made the active cell clicking on them with the
mouse do not show the formula in the formula bar, which is absurd.
In fact, if you select the range where you inserted the formula (the k cell
column right of the upper limits), you cannot modify the formula now (it says
that the selection is only “a part” of the matrix), you cannot copy the cell
range, nor you can drag it around.
It is impossible to edit the function inserted, as by trial and error I
discovered that you need to select both the column before (left) and after
(right) the one where you put the formula, and in doing so you will not have
the formula text in the formula editing bar as was the case before.
It is clear that something is wrong also because if you save your calc file and
open it with Openoffice or LO old releases (I tried the first), then you'll see
another frequency value in the lower k+1 cell which looks like it is part of
the matrix formula... but it cannot be seen on LO!!
If you re-save the file without any user induced change there and re-open it
with 4.3.1, everything is changed: now the "frequency" formula occupies the k
desired cell plus the k+1 below them, and it's only there, differently from how
it was before! This shows an inherently unstable behaviour, and can easily lead
to data corruption, impossibility to modify and edit our files.
The problem is critical for people like me who rely on the "frequency" function
very often: it is a showstopper in itself, enough to go back to older releases
Expected behavior:
the one that the "frequency" function exhibited in older releases, similar to
all other matrix functions
Operating System: Windows 7
Version: 4.3.1.2 release
--
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
