Issue 13671 - Pasting text containing numbers seperated by dots is impossible
Summary: Pasting text containing numbers seperated by dots is impossible
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on: 33723
  Show dependency tree
Reported: 2003-04-21 11:30 UTC by fhimpe
Modified: 2013-02-07 22:38 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description fhimpe 2003-04-21 11:30:23 UTC
I have a table in an OOo writer document, which I want to paste in an OOo
spreadsheet document. The first columnn of the table contains text in the form
of "1.1.1.", "1.1.2", and so on. When the table is pasted in the spreadsheet,
OOo interprets this text as a date, so it becomes "01/01/01", "01/01/02" and so
on. I tried first changing the formatting of the cells to "Text", but when
pasting this is ignored and the formatting is automatically set to date. I could
not find a way to disable this automatic guessing, neither could I paste it
correctly with one of the formats of "Paste Special". So there does not seem to
be any way to correctly paste this text in the spreadsheet.
Comment 1 frank 2003-04-24 11:50:00 UTC
Hi Frederik,

sorry to tell you that this is working now as expected. Nevertheless
we are aware of such problems and are thinking about a better
solution. Depending on this I reflaged this Issue as Enhancement.

A work around would be to format the cells you want the clipboard
content  in as Text and paste it as unformatted text. Unfortunately
you can't get the table structure from the original in that way, so
you have to put the blocks of cells you want to reside side by side
into the clipboard and Paste Special them using the transpose checkbox
in the dialog.

It's a bit tricky and unsatisfactory but for now the only way to solve
your problem if you will not enter the Values by hand.

Aaahhh, another way. Just insert an ' (apostrophe) in front of all
values in the text file. Copy them into the clipboard and paste them
into calc. Now you should have them as text in your spreadsheet.

Best regards


Hi Bettina,

1 4 u

Comment 2 ace_dent 2008-05-16 02:42:15 UTC Issue Tracker - Feedback Request.

The Issue you raised has the status 'New' pending further action, but has not
been updated within the last 4 years. Please consider re-testing with one of the
latest versions of OOo, as the problem(s) may have already been addressed.
Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 3 Rainer Bielefeld 2009-07-05 08:17:38 UTC
May be this will be fixed with Issue 33723?
Comment 4 bettina.haberer 2010-05-21 14:44:25 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".