Issue 81047

Summary: copy-paste base to calc gives errors in pasted fields
Product: Calc Reporter: gercokees <gercokees>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, mats_ogren
Version: OOo 2.2.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
81047-testfile none

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.