Created attachment 104339 [details]
The whole spreadsheet.
Here is the spreadsheet.
Try to sort on column B then A.
Columns on the right (mostly empty) should also be sorted.
On pc Debian x86-64 with 4.2.6 LO Debian package, I don't reproduce this.
Could you give a try to brand new 4.2.6 and tell us if you still reproduce this?
I tried to reproduce this bug although there were no exact steps to execute.
First I selected Column B and than clicked the 'increasing sort' icon. I got a question whether to extend the scope of sorting to A1:D300, which I excepted. I got a sorted A1:D300 table, while columns on the right G1:AJ300 were not touched. I think the values in column D were the ones which seemed to be problematic.
I feel so, that here is the root of the problem. The values in column D are defined as the sum of I:AJ fields of the same line but the lines of the left part of table are moved to another place because of sorting while the originally referred values on the right remained on their original place. This means that now these sums are not calculating the intended values. (It can be interpreted that the columns on the right are not sorted.)
I also tried to verify my theory by the following test. Select the entire table: click first A4 than shift click AJ300. On Data → Sorting dialogue for 'sorting key 1' choose 'column B'. Leave sorting key 2 and 3 empty. Click OK. I expected this will solve the original problem but unfortunately LO crashed (and always crashes)!
I am not an expert of Calc but may be this helps.
My test system:
Windows XP SP2
LO 22.214.171.124 Build id.: 185f2ce4dcc34af9bd97dec29e6d42c39557298f
J'ai installé 4.2.6. mais j'ai le même problème.
Merci pour la rapidité de votre réponse
Le 09.08.2014 15:06, email@example.com a écrit :
> Julien Nabet  changed bug 82386 
> Ever confirmed
> COMMENT # 1  ON BUG 82386  FROM JULIEN NABET 
> On pc Debian x86-64 with 4.2.6 LO Debian package, I don't reproduce this.
> Could you give a try to brand new 4.2.6 and tell us if you still reproduce
> You are receiving this mail because:
> * You reported the bug.
(translation from previous comment: same problem on 4.2.6)
I put it at NEW since confirmed by penttila.
(In reply to comment #2)
> I also tried to verify my theory by the following test. Select the entire
> table: click first A4 than shift click AJ300. On Data → Sorting dialogue for
> 'sorting key 1' choose 'column B'. Leave sorting key 2 and 3 empty. Click
> OK. I expected this will solve the original problem but unfortunately LO
> crashed (and always crashes)!
May be due to Conditional formatting.
Within same steps and uncheck "Include formats" in sort dialog (2nd tab), data are sorted without crash.
(In reply to comment #4)
> (translation from previous comment: same problem on 4.2.6)
> I put it at NEW since confirmed by penttila.
Sorry, but I have NOT confirmed this bug! I only tried to clerify it as the problem description was not clear. So I change it's status to NEEDINFO as long as we donn't get exact, reproducible problem description what can be confirmed.
It is another thing that I was able to crash LO. If it is reproducable by someone else - I think - we should rise another bug for it. What is your opinion?
bfoman: would you have some time to give it a try and, if you've got a crash, retrieve a bt?
I have made a segfault in the attached .ods in master commit f74a633,
fetched 2014-08-23, configured:
--enable-option-checking=fatal --enable-dbgutil --enable-crashdump
built and running of debian-wheezy 64-bit.
(1) Open the .ods from the list of recently used files in the Start
(2) Click in the intersection of the column headings row and the row
headings column to select the whole worksheet.
(3) Take menu options Data > "Sort...".
(4) Select Sort Key 1 = "Column B" Ascending, Sort Key 2 = "Column A" Ascending.
(5) Click <OK>. Program sends the progress bar across the bottom of
the screen and then segfaults.
The backtrace from the segfault has the same function names in frames
0 through 19 as frames 1 through 20 of the backtrace attached to bug
81696 "CRASH while sorting cells with conditional formatting". I am
tentatively closing this as a dup of that bug.
When you see that a build newer than 2014-08-24 sorts your spreadsheet
without crashing, please set status VERIFIED. If crash persists,
please set status REOPENED.
*** This bug has been marked as a duplicate of bug 81696 ***
Created attachment 105443 [details]
gdb on the core file