[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=56958

raal  changed:

   What|Removed |Added

 Status|VERIFIED|CLOSED

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=56958

--- Comment #16 from billchecker...@gmail.com ---
It sounds like you're having trouble sorting your spreadsheet data after using
and removing subtotals. Sorting data can sometimes cause issues, especially if
there are formulas or functions involved.

If you're working with an electricity bill spreadsheet and you've used
subtotals to summarize the data, there are a few things you can try to sort the
data without crashing the spreadsheet. One thing you might want to check is
whether there are any hidden rows or columns that were created by the subtotal
function. These hidden rows or columns can sometimes cause sorting issues.

Another thing to try is adjusting your sorting options. For example, you might
want to try sorting the data by a different column or using a different sort
order. Sometimes, changing the sorting options can help resolve any issues
you're experiencing.

I hope this helps! Let me know if you have any other questions or if there's
anything else I can do to assist you.

https://billchecker.pk/fesco-online-bill/

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=56958

raal  changed:

   What|Removed |Added

 CC||r...@post.cz
 Status|RESOLVED|VERIFIED

--- Comment #15 from raal  ---
The test exist, set status to Verified.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=56958

--- Comment #14 from Commit Notification 
 ---
Zdeněk Crhonek committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=a790ee54319583897d82d4372243df870d4452a6

uitest - calc subtotals; tdf#114720 tdf#88792 tdf#88735 tdf#56958 tdf#55734

It will be available in 6.1.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=56958

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:3.7.0 target:3.6.4   |target:3.7.0 target:3.6.4
   ||target:6.1.0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=56958

--- Comment #6 from Bill Bruckner bill@gmail.com ---
I updated to 3.6.3.2 from 3.6.2.2, but it still crashes the same way.

Regards,
Bill

On 11/10/2012 11:28 PM, bugzilla-dae...@freedesktop.org wrote:
 Markus Mohrhard mailto:markus.mohrh...@googlemail.com changed bug 
 56958 https://bugs.freedesktop.org/show_bug.cgi?id=56958
 What  Removed Added
 CCmarkus.mohrh...@googlemail.com

 *Comment # 5 https://bugs.freedesktop.org/show_bug.cgi?id=56958#c5 
 on bug 56958 https://bugs.freedesktop.org/show_bug.cgi?id=56958 from 
 Markus Mohrhard mailto:markus.mohrh...@googlemail.com *
 Looks like a duplicate ofBug 55734  show_bug.cgi?id=55734. Could you please 
 update to 3.6.2 and check
 if this fixes your problem.

 If so please mark this bug as duplicate of the other one.
 
 You are receiving this mail because:

   * You reported the bug.


-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=56958

billh...@y7mail.com changed:

   What|Removed |Added

   Hardware|x86-64 (AMD64)  |All
 OS|Linux (All) |All
 Status|UNCONFIRMED |NEW
Version|3.6.2.2 release |3.6.0.1 rc
 Ever confirmed|0   |1

--- Comment #7 from billh...@y7mail.com ---
Confirmed on LO 3.6.3.1 Windows Vista 32bit.

To reproduce the crash

1. Open the test file
2. Data-Subtotals
3. Group by-Trans date
4. Tick 'Calculate subtotals for' - Amount
5. Click OK
6. Data-Subtotals
7. Group by--none-
8. Untick 'Calculate subtotals for' - Amount
9. Click OK
10. Data-Sort
11. Sort key 1-Post Date.
12. Sort key 2--undefined-
13. Click OK

LibreOffice crashes.

Note: There was one time when I did not reproduce the crash after doing
something else first (e.g. calculating slightly different subtotals, sorting
slightly differently). However, if I follow the above steps it crashes every
time.

I could also reproduce on Win XP LO 3.6.0.1

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=56958

--- Comment #8 from billh...@y7mail.com ---
I just noticed that the suspected duplicate, bug 55734, was fixed in 3.6.3.2.

So I upgraded to 3.6.3.2 and retested.

The bug still occurs exactly as in 3.6.3.1

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=56958

Markus Mohrhard markus.mohrh...@googlemail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #9 from Markus Mohrhard markus.mohrh...@googlemail.com ---
(In reply to comment #8)
 I just noticed that the suspected duplicate, bug 55734, was fixed in 3.6.3.2.
 
 So I upgraded to 3.6.3.2 and retested.
 
 The bug still occurs exactly as in 3.6.3.1

Thanks fixed the problem now. There were all in all two problems that crashed
this document. The first one seems to be gracefully ignored in a non dbgutil
build.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=56958

--- Comment #1 from Markus Mohrhard markus.mohrh...@googlemail.com ---
Can you at least try to generate a test document that shows this behavior?

Without a test document we are not able to fix this bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=56958

--- Comment #2 from Bill Bruckner bill@gmail.com ---
I can duplicate the problem consistently with the attached file.

 1. I sub-total by Trans Date and sum on Amount.
 2. I remove the Sub-totals by clicking on Subtotals  under the Data
menu, selecting -none- under Group by and unchecking Amount
under Calculate subotals for
 3. I try to sort on Post Date and LibreOffice Calc crashes.

Regards,
Bill

On 11/10/2012 11:45 AM, bugzilla-dae...@freedesktop.org wrote:

 *Comment # 1 https://bugs.freedesktop.org/show_bug.cgi?id=56958#c1 
 on bug 56958 https://bugs.freedesktop.org/show_bug.cgi?id=56958 from 
 Markus Mohrhard mailto:markus.mohrh...@googlemail.com *
 Can you at least try to generate a test document that shows this behavior?

 Without a test document we are not able to fix this bug.
 
 You are receiving this mail because:

   * You reported the bug.


-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 56958] Spreadsheet Crashes trying to SORT after using and removing SUBTOTALs

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=56958

Markus Mohrhard markus.mohrh...@googlemail.com changed:

   What|Removed |Added

 CC||markus.mohrhard@googlemail.
   ||com

--- Comment #5 from Markus Mohrhard markus.mohrh...@googlemail.com ---
Looks like a duplicate of Bug 55734. Could you please update to 3.6.2 and check
if this fixes your problem.

If so please mark this bug as duplicate of the other one.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs