Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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 <>
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. 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
the formula.

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.