Page 1 of 1

Cut & Paste Problem: Excel to Calc

Posted: Wed Dec 19, 2007 2:27 am
by Freelance
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 !

Chris.

Re: Cut & Paste Problem: Excel to Calc

Posted: Wed Dec 19, 2007 6:26 pm
by DiGro
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