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.
Most of the patches applied there will be in the upcoming 4.2.2 posting.
From: Tom Cloyd <firstname.lastname@example.org>
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. 220.127.116.11 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
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
c. Immediately and I get this error message:
/...closing the error message modal window immediate crashes the whole
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.
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy