Why??? 'Unkown source' when copy/pasting numbers SAME SHEET SAME WORKBOOK

users
#1

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?

#2

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?

What version of LO are you using and what is your OS?

#3

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

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 copy? Does your keyboard need attention or replacement? Or do your fingers, er, ... ?

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 won't?

I trust this helps.

Brian Barker

#4

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.

Mark.

#5

sorry...

XP (32bit) or Win7 (64bit), fully patched

Currently on 4.0.5, but this has been happening for a long time over many different versions, starting somewhere in the 3.x series...

And it seems to be getting worse.

#6

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
>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
copy?

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
won't?

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... :wink:

#7

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".

Yes, I've known about this one... but even this one didn't always happen even before the problem started occurring within the same sheet..

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

I agree this is what should (and what used to) happen, but no longer...

Could this be what's happening?

Nope...