Cut & Paste Problem: Excel to Calc

Discuss the spreadsheet application

Cut & Paste Problem: Excel to Calc

Postby Freelance » Wed Dec 19, 2007 2:27 am

I am having an "issue" with cut and paste between Excel and Calc.

I can easily select multiple cells and columns in excel, copy them and then paste them into Calc. The issue I have is that any cells containing more than 255 characters are cropped. Firstly I though it may be because I had a couple of [CR]'s in the cells, yet it cropped like half way through a line. I then counted the characters within the newly pasted cell. 255 in each of the cropped.

I couldn't find any limitation settings within Calc. ANY IDEAS?

At the moment I am individually cutting and pasting the contents of each cell. - ANNOYING!

Any help is muchly appreciated !

Posts: 1
Joined: Wed Dec 19, 2007 1:57 am

Re: Cut & Paste Problem: Excel to Calc

Postby DiGro » Wed Dec 19, 2007 6:26 pm

Chris wrote:Any help is muchly appreciated !

Just tried it in OOo 2.3 (Dutch build)

Pasted a cutted text from 1610 characters in one Calc-cell. No problem.

Pasted the same text in one cell in Excel - no problem

Noticed that any [CR] will cause Calc to paste on a new row though

AOO 4.1.7 on Windows 10. Scanned with ZIGGO Safe Online (F-Secure)
User avatar
Posts: 103
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands

Return to Calc

Who is online

Users browsing this forum: No registered users and 25 guests