open calc / sorting issues ...

[Jean-Baptiste Faure]

Hi,

Le 03/11/2014 13:36, Michael Meeks a écrit :
> 
> On Mon, 2014-10-27 at 19:56 +0100, Jean-Baptiste Faure wrote:
>> Le 23/10/2014 17:20, Michael Meeks a écrit :
>>> [...]
>>> * Pending Action Items:
>>>     + get a clear use-case & description of what doesn't work vs. master wrt. Calc sorting (JBF)
>>
>> First draft here: https://bugs.freedesktop.org/show_bug.cgi?id=85490
> 
> 	So - I don't grok that bug; I was expecting a tracker bug; are you
> trying to use 'see also' for that ? rather than 'depends on' ? the "see
> also" is a zoo that doesn't solve the problem here I think.

I am trying to summarize the different use-cases I can find related to
sorting range of cells with references. Many things are not clear with
the collection of bugs you can find in bugzilla with the keyword "sort".
For many bugs reported in BZ, it is not clear, for me, if the bug is
really in Calc or between the chair and the keyboard.
We are missing a clear description of all use-cases that Calc is able to
handle and, for each use-case, how Calc should do sorting. In other
words we are missing the specifications of sorting.

So I am working on a spreadsheet gathering the use-cases I am able to
describe. Each use-case has data, description, how to test, what is
expected and how it works in master, 4.3.4.0.0+, 4.2.6.3, 4.1.6.2 and
4.0.6.2. The spreadsheet is not finished yet but, at the moment, I have
at least 2 clear conclusions:

1/ the issue with the use-case "bank account" (bugs 81633 and 85215) is
fixed in 4.3.4.0.0+ and 4.4.0.0.alpha1, except for the fact that in 4.3
the legacy behavior is obtained with the default value of option
UpdateReferenceOnSort, when in 4.4 you have to change it to get back the
legacy behavior.

2/ with 4.3, it is not possible to make all tests of the spreadsheet
working, without changing the option, which implies that you need to
restart LO each time you need to change the value of the option. It is
not a user experience as good as we expect.

I hope to be able to attach the spreadsheet to the metabug shortly.

Best regards.
JBF

-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.