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.
Cut & Paste Problem: Excel to Calc
Re: Cut & Paste Problem: Excel to Calc
Just tried it in OOo 2.3 (Dutch build)Chris wrote:Any help is muchly appreciated !
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
____________
DiGro
AOO 4.1.15 (Dutch) on Windows 11. Scanned with Ziggo Safe Online (F-Secure)
DiGro
AOO 4.1.15 (Dutch) on Windows 11. Scanned with Ziggo Safe Online (F-Secure)