Issue 81047 - copy-paste base to calc gives errors in pasted fields
Summary: copy-paste base to calc gives errors in pasted fields
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
81047-testfile (325.89 KB, text/plain)
2007-08-27 08:43 UTC, gercokees 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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 
Hi,
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
bug...
Greetz...
Comment 1 gercokees 2007-08-27 08:43:02 UTC 
Created attachment 47793 [details]
81047-testfile
Comment 2 gercokees 2007-08-27 08:45:27 UTC 
hummm,
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 
Hi,

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

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.