Tom, Issue with Calc were one of the reasons that the ESC is moving directly to a 4.2.2 release.
Grab the current TinderBox build of LODev 4.2.3 and install that to see if it has corrected behavior with your corrupted formulas. http://dev-builds.libreoffice.org/daily/libreoffice-4-2/Win-x86@42/current/ Most of the patches applied there will be in the upcoming 4.2.2 posting. Stuart ________________________________________ From: Tom Cloyd <[email protected]> Sent: Monday, February 24, 2014 12:16 PM To: LibreOffice User's Help Forum Subject: [libreoffice-users] ver. 4.2 copy/paste bug - update On Feb. 17, I posted about this problem. I got several potentially useful responses. With the limited time available to me, I've explored them all, and here's the present status of this problem: 1. I'm running ver. 4.2.1.1 now. 2. The problem reported earlier is still very much with me. I typically begin my day by running a macro that opens 8 Calc spreadsheets, including several that are rather large. I use these to organize my day and track certain complex tasks. I've been doing since 2005, and using LO/Calc to do it since 2008. I've tried deleting my user profile. I can reproduce the error _immediately_, with the only profile change in place being a lowering of the macro security level to the lowest level to allow me to actually USE my spreadsheets. So, this doesn't appear to be a user-profile corruption issue. 3. Here's the problem: a. I move some cells from one sheet in a Calc document to a higher location in the same sheet. b. This messes up some linked formulas, so I copy two cells that are correct down through all the others (normally this works OK). to relink the formula. c. Immediately and I get this error message: /vector::_M_range_check /...closing the error message modal window immediate crashes the whole problem. I'd attempt a bug report, but every time I've tried that I've gotten lost in the sheer strangeness of the process. I just can't take the time to try to wrestle through the process, which is certainly not set up for average users, I'd say. I can offer to share the spreadsheet in which the crash occurs, for what that's worth. It has maybe 30 sheets and is about a meg. in size. I did find that removing about 15 of the sheets appeared to stop the problem, for unknown reasons. I'll continue to use ver. 4.2x, as I seem to have a workaround figured out, and hope that this gets fixed in future releases. Tom -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
