I have a calc file with a separate sheet for each month of the year, and an averages sheet which gives weekly average values for the whole year. At the start of the year, these are in the order averages/January/February/...../December. At the end of each month I move that months sheet to the end so that the order becomes averages/this month/next month/..../last month. This worked fine in Open Office before the fork, I can't remember whether it first occurred in LibreOffice 3.3, but it's certainly been there in every subversion of 3.4. I can save the file OK, then if I move a sheet to the end position, it appears to work OK, but if I now try to save the file again the green progress bar reaches c.25%, then stops and after about 10 seconds LibreOffice calc crashes. I can submit the file if it helps.
I tried with an empty calc sheet in which I input very little data in each sheets. Afterward I reordered the sheets as you said and tried saving each time. There was not crash. Obviously, this is far from your situation, and there may be other factors at work, so it would be nice if you could provide your document to be experimented with (given that it is not confidential information). So for now, I will say failed to reproduce on LibreOffice 3.4 340m1(Build:103) for OpenSuse Linux. (Clearly not sure about this, though).
we have a similar bug report and I got a test document in private, this seems to be a windows only issue bug 39085
Created attachment 50232 [details] A sanitised version of the failing calc file - which fails in exactly the same way This is a sanitised version of the failing ods. It fails in exactly the same way as the full sheet. Incidentally, yhe only way to move the sheet in 3.4.2 in Windows seems to be by drag and drop. The copy/move sheet dialogue won't move it because it says the name is already in use. The copy/move dialogue did work in 3.4.1, but then calc crashed on saving.
Still occurs in 3.4.3 under Windows 7
This also happens if I copy a sheet. I have another sheet which I maintain daily for a year, which has many formulae in it. To save having to reinput all the formulae, towards the end of the year, I copy it, rename it for next year and remove all the input figures. This way I have figures for all years in the same file. This bug is marked as medium/major, but in my view is major as it makes LibreOffice almost unuseable for me. I prefer the ethos of TDF to that of Oracle, but suspect I will soon have to revert to OpenOffice.
I also found this severe problem that I reported as bug 43148 on 2011-11-21. I hope a response.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
I have run the same tests on the same sheets using LO 3.5 beta 2 and everything seems to work OK in the beta.
For me also (bug 43148), this problem seems to be solved in the LOdev3.5 beta 2, but not in the LO3.4-501.
I rejoiced too soon. Further testing (performed on other files made with LO 3.3.4 or previous versions) have shown that despite improvements, the problem is still present in the LOdev3.5 beta 2.