@PleaseGIveMeBackMyKDE -- Here's the link to file a bug.
Please post a link to any bugs you file in a comment below using the format "fdo#123456".
qubit ( 2013-02-25 07:03:05 +0200 )edit
Hello,
The default function of paste seems to have changed and I find this change to be for the worse. I have noted the following changes:
The default funtion of copy and paste has been consistent since I started using OpenOffice back at version 1. Why it has changed with the implementation of LibreOffice is beyond me. Pasting is a primary function of a spreadsheet and this change does not seem to improve functionality. With that said, I suppose the question is simple: Why has the default function of copy and paste been altered and when will it be restored to the standard function?
If there is reason for this change and I am simply not up to scratch with how to now use copy paste, where is this documented? I have found no note of this change to the default behaviour anywhere in the help files or on this website.
[Update] As stated in my belated reply to the comment, these issues are noted within a spreadsheet without any external sources or destinations. I am also curious if these problems are being encountered by anyone else. I ask because these issues are making my use of Calc very difficult and previously simple tasks now take much longer. If no one else is having the same problems then I must conclude it is something to do with my system or install of the suite. In which case I have alternate steps I can take to try and resolve these issues.
Thanks in advance to anyone who can clear these issues up. I am certain I can not be the only user finding these changes problematic.
Sincerely,
Zorba.
Looks like the problem may be fixed...
@Zorba writes (May 1 '12):
I run on Win7 64. I tried repairing the install and it began to work but not consistently, Have just reinstalled and it appears to be working correctly now. Will confirm after a few days testing before updating officially. Hopefully it was simply a weird install error!
If you're still experiencing issues:
If installing the latest release doesn't seem to fix this problem, please file a bug and provide a list of steps that can reproduce it. The QA team will be happy to help you track down this issue!
Please post a link to any bugs you file in a comment below using the format "fdo#123456".
Thanks!
As a reference I was googling "libreoffice copy to column with different format" and I found this post.
Context: OpenSuse in German Programs: LibreOffice 3.5:build-403 Kwrite Version 4.8.5 (4.8.5) "release 2"
What: Trying to copy from kwrite a column of dates into a date type pre-formatted column of librecalc.
Problem: Using default options caused Librecalc to insert cells in string format, instead of the date format I had set up previously to pasting.
Solution: In the dialog of paste, go to Fields (or "Felden" in German) and select the "US-Englisch" option instead of "Standard". Then the cells are input and formatted accordingly.
Ej. input "raw" date: 2012-12-16 Librecalc's pre-Formatted cells now recognize this input as: "12/16/12"
Previously it only pasted "2012-12-16" and I was unable to change that format until I performed the afore mentioned procedure.
HTH
As a reference I was googling "libreoffice copy to column with different format" and I found this post.
Context: OpenSuse in German Programs: LibreOffice 3.5:build-403 Kwrite Version 4.8.5 (4.8.5) "release 2"
What: Trying to copy from kwrite a column of dates into a date type pre-formatted column of librecalc.
Problem: Using default options caused Librecalc to insert cells in string format, instead of the date format I had set up previously to pasting.
Solution: In the dialog of paste, go to Fields (or "Felden" in German) and select the "US-Englisch" option instead of "Standard". Then the cells are input and formatted accordingly.
Ej. input "raw" date: 2012-12-16 Librecalc's pre-Formatted cells now recognize this input as: "12/16/12"
Previously it only pasted "2012-12-16" and I was unable to change that format until I performed the afore mentioned procedure.
HTH
Yes, I agree with original post. It is broken and exhibits random behaviour. Most (if not all) of the problem with Paste and Paste Special happen when you try to Paste into multiple cells. Sometimes you get the Text Import dialogue, sometimes you get the Paste Special dialogue with source "unknown source".
The very basic spreadsheet operation of copying the contents of a single cell and pasting it into multiple cells seems to be impossible! Try this:
Copy a single cell; select a range of cells and try to Paste;
Up pops a dialogue called Text Import (why?!), you press OK and nothing happens.
It is braindead and practically unusable as a spreadsheet.
Experience the same problem: sheet copy small vertical range of cell with formula to paste on the same sheet in the same column and its reports "Unknown Source" and offers "Unformatted Text." However, the pasting occasionally does work as expected. But there's clearly a random bug at work.
Maybe your profile is corrupted. See more about profile: http://wiki.documentfoundation.org/UserProfile
I am also having an issue with pasting in LibreOffice on MAC OSX 10.7 with LO 3.5.2.2. It seems that whenever I copy from within a cell in CALC, it adds a carriage return to the end of the string. I.E. Click on cell containing asdfghjk, highlight cell contents "asdf", command + C, then in TextEdit, Command + V, Command + V...it doesn't paste as asdfasdf it pastes as:
asdf
asdf
(except together with no extra line in between...formatting on this forum is funky) For the issue you are having, I am able to use regular paste within a spreadsheet document and it retains its cell properties. I did notice however, that when I opened an excel file in LibreOffice and copied from it into a new ods sheet that it lost its formatting.
If I used "Paste Special.." and checked Paste ALL it seemed to resolve the issue. It's still a little frustrating and tedious when you are copying a bunch of individual cells.
As far as all the issues you are having, I am not able to replicate any of them. Are you using protected documents or files loaded from a different file format, or did you try this on a brand new sheet?
You can also try installing the 32 bit version instead, maybe the 64bit build is off...
BlipBertMon, you should try Ctrl+Shift+V, Paste Special and uncheck "Formatting".
Hell yes!! How to get paste to 'LOSE' baroque/unusual individual-clipboard item formatting and instead adhere/demurr/submit to formatting set for the target spreadsheet?? I'll happily trade places with you. I spend half my time trying to 'undo' paste-buffer formatting and restore consistent fonts, sizes, colors across the cells of _my_ spreadsheet. I don't care whether some web page used white bold text on a pink background!! If anyone can clue me in here... e-mail BlipBertMon at GMail.. >>off soapbox<<
Confirmed to be a problem on Win7 64bit v 3.6.4.3.
All cut-and-paste looses formatting, including from within the same Writer document. Ctrl+Shift+V only shows unformatted text as option.
Anyone know where the bug tracker is? Anyone have troubleshooting instructions or fixes
@PleaseGIveMeBackMyKDE -- Here's the link to file a bug.
Please post a link to any bugs you file in a comment below using the format "fdo#123456".
qubit ( 2013-02-25 07:03:05 +0200 )editLibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-04-13 07:31:17 +0200
Seen: 2,426 times
Last updated: Feb 25
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
What is the source and destination of the copy / paste operation(s) of which you speak? It would appear you are talking about copying from a HTML source (e.g., web page) and pasting into Calc. Quite different from copy/paste between documents e.g., Calc / Writer.
oweng ( 2012-04-13 13:40:17 +0200 )editSorry about late reply. The issue occurs with copy paste of cells in the same spreadsheet. No external sources or destinations. Considering the loss of function I have observed, I am surprised this does not appear to be a more common problem.
Zorba ( 2012-05-01 06:01:56 +0200 )editSorry, but I run LO 3.4.6 on mac OSX 10.7 and LO 3.5.2 on Ubuntu Linux 10.4 and everything works fine. I cannot reproduce any of the behaviours you are describing.
mikebibo ( 2012-05-01 12:40:51 +0200 )editThanks, that's good to know. I run on Win7 64. I tried repairing the install and it began to work but not consistently, Have just reinstalled and it appears to be working correctly now. Will confirm after a few days testing before updating officially. Hopefully it was simply a weird install error!
Zorba ( 2012-05-01 14:29:37 +0200 )edit