Bug 94256 - Calc Crashes on sorting, copying sheets
Summary: Calc Crashes on sorting, copying sheets
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-09-16 05:29 UTC by Bruce Martin
Modified: 2020-10-30 10:54 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Bruce Martin 2015-09-16 05:29:52 UTC

    
Comment 1 Bruce Martin 2015-09-16 05:42:38 UTC
This problem has been around for a long time, but is intermittent.

When sorting a sheet, especially if a preset range involving first line as field names is involved,Calc will crash,

On reloading, any other workbooks that were open will likely have to be restored as well.

I have seen this most commonly i=when a larger workbook of as many as 30 sheets is involved.

My typical spreadsheets are notably more complex than many users, and involve inter-sheet hyperlinks, and boolean triggered analytics. Cloning of whole sheets and other formatting (usually for cosmetics and readability.)

When cloning a sheet, the formulas get modified automatically, making an entire mess! This is apt to happen if there are hyperlinks and/or formulae that link outside the workbook.

The spreadsheet may also hacve been working when backed up using Filzilla and a NAS box, then subsequently restored via Filezilla.

If the sheet is then sorted, a crash results until all the errors in the formulas have been purged.

Sometoimes it helps to copy the sheet out to a separeate workbook created as a temporary sport of repository for the parts, then renamed as needed and subsequently re-exported from the latter workbook back into the original workbook. This tends to avoid rthe paorlem of crashing when a sheet is cloned within tthe single workbook.

Note: At times the data may contain multilingual content or handle multiple currencies etc.
Comment 2 tommy27 2015-09-18 12:00:46 UTC
please provide a test file with steps to reproduce the issue
Comment 3 Timur 2015-11-12 17:47:22 UTC
If you provide what's requested, feel free to reopen and set to Unconfirmed.
Comment 4 George Coppleson 2020-10-30 10:54:34 UTC
Wonderful! In this time of the pandemic, it is the best solution that a student could get. I can visit the site https://uk.bestessays.com/essay_service.html to solve my problem and I wish to admit my daughter to it next year. Thanks for sharing.