Issue 117819 - Copy from table paste ordered fields
Summary: Copy from table paste ordered fields
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.3 RC10
Hardware: PC Windows Vista
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-04-12 14:36 UTC by dtinazzi
Modified: 2013-08-07 15:45 UTC (History)
4 users (show)

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

Zipped Access 2000 test.mdb file (11.27 KB, application/zip)
2011-04-12 14:40 UTC, dtinazzi
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.