Ask Your Question

Calc keeps crashing every time I copy and paste a range. [closed]

asked 2014-10-10 12:18:42 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am copying and pasting a range of data from a .xlsx file to another .xlsx file. The original file was .csv ; I tried Save As to a .xlsx file but it still crashes when I copy from it and paste. The data is just normal figures, currency, dates etc, not even any formulas. What could be causing this? It's driving me crazy! Using Libre Office version English language. Operating system Windows 8.1.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 23:52:13.283462


Please try resetting the user profile:

m.a.riosv gravatar imagem.a.riosv ( 2014-10-10 22:40:01 +0200 )edit

Thanks, I've tried resetting my user profile. I'm not sure yet if it has fixed the problem, as it was intermittent. Will provide more feedback later.

Dave Oz gravatar imageDave Oz ( 2014-10-13 11:10:46 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-10-15 11:43:05 +0200

Lupp gravatar image

updated 2014-10-15 11:49:10 +0200

Concerning the additional complaint regarding dates:

Your "dates" are text. You can convert them to numeric values and then format them for display as you like in situ using 'Data' > 'Text to Columns...'.. You can achieve the same effect already when importing from csv setting the column type for the dates column appropriately.

[PS (unsolicited): Better use genuine banking sofware.]

edit flag offensive delete link more

answered 2014-10-15 04:44:08 +0200

Dave Oz gravatar image

Still had the problem this morning, so resetting my user profile didn't work. Couldn't paste ANYTHING into the file, not even a single cell copied from the same file, whether I used CTRL C and V or right clicking / copy / paste. In desperation I deleted all the worksheets (about 9 of them) except the main one to reduce the size of the file (it was only 23MB, not huge?) - and it seemed to cure the problem! Even stranger, I then went back to the original file with all 10 worksheets in it, and it seems to work OK too...

So problem solved, but I'd be much happier if I knew what caused it in the first place. My only suspicion is a problem with date formats. I downloaded the original CSV file (that I was copying from) from my bank, and although the dates looked like dates, Calc didn't seem to be recognising them as dates when I tried to sort on that column - it only sorted on the day dates, which ended up with months being mixed up. Changing the format to date format made no difference; I had to format a new column and copy all the dates in by hand - not something I want to do every month!

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-10-10 12:18:42 +0200

Seen: 1,310 times

Last updated: Oct 15 '14