Issue 81047 - copy-paste base to calc gives errors in pasted fields
Summary: copy-paste base to calc gives errors in pasted fields
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-08-27 08:40 UTC by gercokees
Modified: 2013-02-07 22:38 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

81047-testfile (325.89 KB, text/plain)
2007-08-27 08:43 UTC, gercokees
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description gercokees 2007-08-27 08:40:04 UTC
Try to open the attached document with Base.
goto queries and open "test" query.
notice the first postcodefield, being: "9051 PM"
close the query.
right-click on the query and choose: copy.
open a new calc-sheet and paste.
notice the first postcode-field, being: "9063:00:00"

this occurs rarely in my documents say 3 or 4 times...
Because user data is corrupted in an easy-to-encounter way i mark this as a p2
Comment 1 gercokees 2007-08-27 08:43:02 UTC
Created attachment 47793 [details]
Comment 2 gercokees 2007-08-27 08:45:27 UTC
suddenly i see the "pm" in the field. so i think calc sees it as a date or
time... however, in the base-file the field is a text, so calc should see it as
a text also... i think i mark it as a p3 again...
Comment 3 marc.neumann 2007-08-28 10:25:17 UTC

I can reproduce this also by pasting a text from writer to spreadsheet. So this
is not a database error. 

The problem that it worked as designed. Spreadsheet try to choose the right
format and because of the PM the time format is used. 

However I send this issue to the requirements team for evaluating a possible

Bye Marc
Comment 4 mats_ogren 2011-08-23 18:34:21 UTC
A similar problem appears for text strings consisting of more than 15 digits.
They will apparently be interpreted as numbers no matter what and the final
digits will irrevocably be replaced by zeros. It would be nice to have an
option to copy without loss of information, e.g. by pasting everything as text,
if it is not feasible to preserve the original data types in the database or 
to enable the user to choose the data type of each pasted column, like when
one pastes a text table from the clipboard.