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

Tanstaafl 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
op[tion as 'Unformatted text' from 'Unknown source'???

This is insane!

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

What is going on here?

If you're in edit mode (e.g. by pressing F2, double clicking a cell, or copying from the input bar above the spreadsheet), the text is copied as plain text, and you get the option to paste as "Unformatted text" from "Unknown source".

If you click a cell or select a range of cells, you then get the options to paste formulas, values etc.

Could this be what's happening?

Hope that helps.


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.