I think this bug only affects Mac OS 10.8.x using any Java version compatible with that Mac OS X version. Theoretically, it might affect Mac 10.7 using the latest Java SE downloaded from Oracle. Create a new spreadsheet document. Type "1" in a cell. Select the cell below it and enter a formula to take the cell above and add "1" to it. You should now have a cell with "1" followed by "2." Select the cell with "2" in it and copy it down until you have a list of calculated numbers. Ten or more should be enough. Now, select that entire range of cells. Then either do: 1) Edit -> Cut; 2) Drag and drop the selection to somewhere else in that spreadsheet or 3) Hit the Mac delete key. In every LO spreadsheet I have (I have a lot), it immediately crashes LO. I haven't been able to recreate the crash using just text and numbers in cells. I need to have formulas. Also, it won't crash with just one cell involved. It must be formulas in multiple cells. I had just updated to the latest version of Java released by Apple (via Oracle)--2012-005--when I first noticed this problem. Unfortunately, I hadn't been doing any editing of my spreadsheets since my update to Mac 10.8 from 10.7 in July. This morning I downgraded my Java to Apple 2012-004 (1.6.0_33). It didn't make any difference--same crashes. I have no way to go back to Mac 10.7.x, so I don't know if this problem is based on the Mac 10.8 update or else based in Java. Now about Java on the Mac. When a Mac user downloads and installs Java downloaded from Apple (even thought Apple gets it from Oracle), it's a full Java install. Later, if a Mac user downloads the latest JRE from Oracle, that version will only affect what is used by Web browsers. LO will will use the full version obtained from Apple. If a Mac user gets a full Java SE version from Oracle and installs it, then LO will use that version. The reason I'm still leaning towards Java is because I seem to remember the same problem quite a while ago in OpenOffice when I tried to completely disable Java. If any Mac users read this, please try and recreate this bug using the process descibed above. Then report your results along with the version of Mac OS and LibreOffice you are using as well as the version of Java reported in the LibreOffice Java preference. Right now, this is killing my productivity. I'm a college prof who teaches Accounting and Finance. I do all of my class handouts and exams using LibreOffice Spreadsheet and I'm always cutting/pasting, dragging/dropping or delete large numbers of cells. I hate having to go back to Excel until this gets fixed, but that's what I'm facing. I hate Excel since "the Ribbon." Thanks for any help.
Update: I deleted all of my LO preferences to make sure that bad preferences (especially carried over from earlier versions) weren't causing this. It didn't help. However, this bug is not present under LibreOffice v3.5.6. Using the same original LO preferences (from 3.6.2) and the same Java version as before, I can't reproduce this bug. Frankly, the fact that I can continue to use LO is huge for me. The bug is also not present under the most recent version of Apache's OpenOffice.
Thank you very much for your bug report! (In reply to comment #0) > I think this bug only affects Mac OS 10.8.x using any Java version compatible > with that Mac OS X version. Theoretically, it might affect Mac 10.7 using the > latest Java SE downloaded from Oracle. A good idea, but no -- I can reproduce it also (with LibO 3.6.1.2) on Mac OS X 10.6.8 (Intel), which runs Java 1.6.0_35. -> Adapted summary. > Create a new spreadsheet document. Type "1" in a cell. Select the cell below > it and enter a formula to take the cell above and add "1" to it. You should > now have a cell with "1" followed by "2." Select the cell with "2" in it and > copy it down until you have a list of calculated numbers. Ten or more should > be enough. > > Now, select that entire range of cells. Then either do: 1) Edit -> Cut; 2) > Drag and drop the selection to somewhere else in that spreadsheet or > 3) Hit the Mac delete key. In every LO spreadsheet I have (I have a lot), > it immediately crashes LO. REPRODUCIBLE with LibO 3.6.1.2, German langpack installed, on Mac OS X 10.6.8 (Intel) -- see above. NOT reproducible, at least not that easily, with LibreOffice 3.5.6.2 on the same machine. -> Added keyword ‘regression’. -> Set Status to ‘NEW’. But, good news: IIRC a very similar bug was reported some time ago and is already fixed (the fix should appear in LibreOffice 3.6.2). Now searching for that bug ...
Yes, this is obviously the same issue as in bug 53364. So the good news are: the problem should be fixed in LibreOffice 3.6.2, which will be released soon*). Until then, we are sorry for all inconveniences this bug causes for you, and thank you for your patience. *) At least a first pre-release should be available end of next week; you can download it then from http://www.libreoffice.org/download/pre-releases/ and use it to confirm if this issue is really fixed. Maybe you can even use it for your real work -- this is not recommended, of course, but at least I myself use pre-releases most times for my work, and in 90% of the time they work better than the last official release, so you could give it a try. Just my 2 cents ;-) *** This bug has been marked as a duplicate of bug 53364 ***
Sorry, I forgot to mention: Feel free to reopen this bug report, if you can still reproduce this problem with LibreOffice 3.6.2.1 (the next pre-release mentioned in comment #3) or a current Master build. Thank you!