Issue 117819

Summary: Copy from table paste ordered fields
Product: Base Reporter: dtinazzi <dtinazzi>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: frank.schoenheit, issues, marc.neumann, r4zoli
Version: OOo 3.3 RC10   
Target Milestone: ---   
Hardware: PC   
OS: Windows Vista   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Zipped Access 2000 test.mdb file none

Description dtinazzi 2011-04-12 14:36:34 UTC

the problem is:

if I copy a table from Base and then paste it to Calc, the fields list in Calc is ordered alphabetically ascending and has not the original order.

Steps to reproduce the problem:

1. Attach an odb (ver. 3.30) to Access 2000 file "test.mdb" (see attachment)

2. test.mdb contains a table (Table1) with 2 fields ('B', 'A') containing 1 record ('B', 'A'), so if I open Table1 (double click) in Base I see:
'B'  'A'
'B'  'A'

3. Table1 opened, I click once on the top left corner to select all the table, then I right click and select "Copy"

4. I open a new Calc spreadsheet and I paste, I see:
'A'  'B'
'B'  'A'
So the fields are ordered alphabetically ascending, and have not the expected order.

Comment 1 dtinazzi 2011-04-12 14:40:01 UTC
Created attachment 76360 [details]
Zipped Access 2000 test.mdb file
Comment 2 r4zoli 2011-04-12 15:30:47 UTC
If you use your example file as registered database / data source, you can add your data without any problem, from table you can insert data into spreadsheet.
Comment 3 dtinazzi 2011-04-12 16:52:55 UTC
Hi r4zoli,

I think that if I have the option to copy and paste data from base to calc, it should be done correctly, even if I have a workaround to do it...

Comment 4 marc.neumann 2011-04-14 08:38:11 UTC
confirm, set target and send to the right developer
Comment 5 marc.neumann 2011-04-14 08:38:42 UTC
correct component
Comment 6 Frank Schönheit 2011-04-18 08:35:59 UTC
correcting owner
Comment 7 Oliver-Rainer Wittmann 2012-06-13 12:18:16 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.