Issue 12424 - sorting sheets containing matrix equations
Summary: sorting sheets containing matrix equations
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability
Depends on:
Reported: 2003-03-17 20:03 UTC by Unknown
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-03-17 20:03:15 UTC
When sorting rows, the sort function does not move cells containing matrix
equations along with their corresponding row.  

This can be seen in a very simple sheet having a first row of empty cells and
the first cell of the second row containing the letter "z" and the second cell
in the second row containing the matriz equation "{sum()}" 

After sorting the data the cell with "z" moves, of course, up into the first
row, but the cell containing the matrix equation remains in the second row.

Earlier versions of Star Office keep matrix equations attached to their
corresponding rows and as such are quite usefull.
Comment 1 peter.junge 2003-04-10 19:02:04 UTC
Priority too high.
Comment 2 frank 2003-08-26 15:07:55 UTC
Hi Eike,

I've checked this with OOo1.0.1 and SO6, they work as described and
therefore different from SO 5.2.

Please have a look at this Issue.

Comment 3 ooo 2003-08-29 11:39:35 UTC
We don't sort matrix formulas at all anymore. Doing so was a bug in
SO5.2 and broke references. Otherwise imagine a simple 2D matrix like
{=A1:A2} with A1:=1 and A2:=2 sorted descending, you don't want that
to display 2,1 suddenly, or to be torn apart if other values lie in

In the special case of a one-dimensional matrix in a single cell it
might be possible to move it around, but this is not a bug, I flag it
as enhancement.
Comment 4 Unknown 2003-08-29 19:30:06 UTC
Decoupling matrix formulas from their respective rows during a sort
operation may seem like an enhancement to some; however, please
consider that this rather major change puts OpenOffice at variance
with the other 95% of the world's spreadsheet users, i.e. EXEL.  Such
incompatibility can be forced upon people by large user groups and
corporations like Microsoft, but smaller groups and concerns usually
find their strength in compatibility and cooperation.
Comment 5 ooo 2003-09-12 12:20:22 UTC

Please note that Excel behaves the same, array formulas are not sorted
at all except if they are one-dimensional. This exception is exactly
what I proposed to implement, so we will be even more "compatible" to
the competitor.
Comment 6 frank 2004-05-05 11:30:11 UTC
Due to time problems this is re-targeted to OOo later
Comment 7 Marcus 2017-05-20 11:13:53 UTC
Reset assigne to the default "".