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

On 2013-10-06 1:55 PM, Brian Barker <> wrote:
At 13:04 06/10/2013 -0400, Charles Marcus wrote:
This is really starting to infuriate me... Why, when working in an
.ods spreadsheet, if I copy a number from a cell, and go to
paste>special it into another cell, does it often (not every time,
still can't pin it down) sometimes come up with the only option as
'Unformatted text' from 'Unknown source'?

One obvious possibility is that the copy action did not take place
properly and that you are pasting previous clipboard contents,
apparently from a different source.  That would be easy, as the copy
action gives no obvious feedback.  Do you use a keyboard shortcut to

I've tried all the variations (select cells, right-click, copy or cut, select cells, CTRL-C or CTRL-V, and select cells, and select cells, Edit > Copy or Cut...

Does your keyboard need attention or replacement?  Or do your
fingers, er, ... ?

No, and no... happens on many different systems, and many different users - and as I said, this has not always been a problem, so no, this is not operator error.

I have had this problem off and on when copy/pasting numbers between
.csv files and .ods spreadsheets, but even then it isn't every time.

Do you have your .csv file open in LibreOffice - in which case it will
have (default) formatting - or in a plain text editor - in which case it

When it happens between .csv and .ods, I have both open in Libreoffice.

But as I said, this also happens when copy/pasting things ON THE SAME WORKSHEET IN THE SAME WORKBOOK.

I trust this helps.

Not yet... ;)

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.