Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Hi folks

Let me embelish a little further as to why it's useful to cut/copy and paste from the spreadsheet input line. I caught myself doing this last night and I now know why I want this feature back. I also tested against this using my wife's laptop running MSO 2010.

When one right clicks on a cell and copies it, the pasting also collects the cell format (it's borders and layout) along with the text/data, and this is not the action one wants (or what I am looking for), only the text is wanted. So it involves more steps than necessary to cut/copy, then using the "paste special" or "paste only - text" in another document. Or as I said highlighting the info wanted in Calc's input line, and then using Ctrl c.

With the feature of cut/copy from the input line offered by other mentioned spreadsheet apps input line, the default action is to "right click - copy", which only copies the text, and paste. So this is a straight forward process, only two actions involved.

Hope this helps explain what I am about with this problem now, in LO Calc.


Andrew Brown

On 25/07/2013 08:43 PM, Steve Edmonds wrote:
It is not suficient. If I copy the input line and past to the input line of a new cell the cell references stay the same. Not so if I copy a cell. CMD-C works on the mac. On linux highlighting the line copies it to clipboard and middle click pastes it.

On 25/07/13 7:50 PM, Tim Lloyd wrote:
Hi Andrew,

I agree regarding the calc issue. I tried this on under Fedora and portable under Windows. Neither allow you to right click on the input line. As you noted, CTRL-C works. So, I cranked up LO3.6.2.2 under XP. Same.

The only thing I noticed is that you can right click on the cell itself. No need to go up to the input line. I wonder if this is deemed to be sufficient.


On 07/24/2013 06:26 PM, Andrew Brown wrote:
Hi Everyone

Well this is now my turn to ask for some help, and to see if any of you have or are experiencing these issues. This applies to both my Windows version, and Ubuntu Raring versions of LO, so a common occurrence. And it has persisted since I migrated over to LO. Your responses will assist me before I send this as a bug report, missing feature.

In Calc, I cannot copy and paste any data content out of the input line at the top i.e. right click the mouse and copy using the now non existent drop down menu. This goes for an existing spreadsheet or creating a new one. In the past, not sure if it was early versions of LO Calc, or OOo Calc, but I could do this, no problems. I copy from a lot of pricelists and other similiar type spreadsheets, and paste into order sheets or directly into emails for my business, and I find now the only workaround is to highlight the content and Ctrl c to copy it, or using the menu "Edit". This needs to be looked at and added as a feature, or returned as a feature. MS Office Excel has always allowed this as well.

This next one is in Writer, and many of my clients have this issue as well, and I feel this is a major failure or feature exclusion. Writer cannot handle the copy and paste of multiple image files, such as photos etc, and then automatically space them one below the other. Many of my clients are in the field as motor vehicle assessors and take multiple pictures of vehicle repairs (up to about twenty per vehicle), process them to reduce their physical size, then paste them into a word processor and compile into a PDF before emailing to the insurance houses. MS Office can do this and has always done this with no issues whatsoever, but LO Writer simply dumps the images one on top of the other, with a lot of unnecessary work to have to drag and place each image in order below the previous one. And this is not consistent, sometimes Writer fails with a lot of photos (noticeably more than five). This lack of feature is now forcing many of my customers to return to MSO, and I feel it needs to be addressed and fixed.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.