https://bugs.documentfoundation.org/show_bug.cgi?id=94256
--- Comment #1 from Bruce Martin <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
