Issue 16793 - OOO should import the existing Excel Data Range as a Spreadsheet Database Range. Then there should be a way to reconnect the range to an existing query in the DSB.
Summary: OOO should import the existing Excel Data Range as a Spreadsheet Database Ran...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.1 RC
Hardware: All All
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability, rfe_eval_ok
Depends on:
Blocks:
 
Reported: 2003-07-13 22:30 UTC by jhansonxi
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

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

Attachments
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 jhansonxi 2003-07-13 22:30:02 UTC 
Source:  Excel 2003 XLS spreadsheet with Data Range/query defined.

What should happen:  OOO should import the existing Excel Data Range as a
Spreadsheet Database Range.  Then there should be a way to reconnect the range
to an existing query in the DSB.

What does happen:  The data is imported but the range definition is lost.

Workaround:
1.  Connect the queried database as a Data Source.  If the source was a query,
recreate it if necessary.

2.  Open the XLS file in OOO Spreadsheet.

3.  Open the Data Source Browser (View > Data Sources, F4) and browse to the
table or query.  Click on the table/query and drag it to the start of the
original data range in the spreadsheet.  You must drag-n-drop in order to create
the database range since a copy & past approach doesn't work as expected:
http://www.openoffice.org/issues/show_bug.cgi?id=16792

4.  Fix the overwritten columns, etc. when the new Database Range lands in the
wrong cell:
http://www.openoffice.org/issues/show_bug.cgi?id=16790

Note:  You are stuck with the column headings since OOO doesn't have a way to
suppress them like Excel (External Data Range Properties > Include field names):
http://www.openoffice.org/issues/show_bug.cgi?id=12523

5.  Reset any existing cell formatting that was trashed by the import:
http://www.openoffice.org/issues/show_bug.cgi?id=16791

6.  To learn how to update a database range in an OOO spreadsheet, refer to the
online help index for the "Refresh Data" feature.  This should lead you to the
"Comparing Microsoft Office and OpenOffice.org Terms" equivalent commands
summary.  It indicates that the OOO command "Reload" in the File menu is the
equivalent to the M$ Office XP command "Refresh Data".  Do it now.

7.  Repeat steps 1-5 then save your work this time.  Skip step 6.  Instead, use
the correct command from the Data menu, "Refresh Range":
http://www.openoffice.org/issues/show_bug.cgi?id=16789
Comment 1 jhansonxi 2003-07-13 22:41:31 UTC 
8.  Reset any cell formatting that existed in the Database Range
before the refesh:
http://www.openoffice.org/issues/show_bug.cgi?id=16794
Comment 2 jhansonxi 2003-07-17 21:06:51 UTC 
Problem still exists in 1.1 RC
Comment 3 utomo99 2003-09-15 04:22:07 UTC 
Please try using the latest OOo 1.1 Rc4,
Comment 4 utomo99 2003-09-16 09:05:31 UTC 
Can you please attach the documents, so we can test it .
Comment 5 ingenstans 2003-09-28 21:13:31 UTC 
Thank you for a clear bug report. But it would be a great help if you 
could submit the sheet that is giving you problems (or, if it has 
confidential infomartion, another Excel 2003 sheet with a defined 
range so we can reproduce it.
Comment 6 utomo99 2003-10-01 07:53:17 UTC 
utomo> jeff:
Please Attach the documents which make this problem, so we can test
it/faster to confirm.  
(Without the documents, we cannot confirm the problem easily/need more
time)
Don't forget to cut other part of the documents, so the file size is
small, but we still able to see the problem.
Comment 7 frank 2003-10-01 08:37:51 UTC 
Hi,

this is not possible for now. So this is a request for enhancement and
I change the flags.

@utomo
I've talked to DR (the developer for the Excel filter) and he is aware
of this.

@Bettina
1 4 u

Frank
Comment 8 bettina.haberer 2003-12-04 17:42:11 UTC 
Summary: What should happen:  OOO should import the existing Excel
Data Range as a Spreadsheet Database Range.  Then there should be a
way to reconnect the range to an existing query in the DSB.
What does happen:  The data is imported but the range definition is lost.
This one is considered for OO.o later (area ms-interoperability), is
will take time because it means a big rebuilding work.
Comment 9 bettina.haberer 2003-12-04 17:43:55 UTC 
Summary: What should happen:  OOO should import the existing Excel
Data Range as a Spreadsheet Database Range.  Then there should be a
way to reconnect the range to an existing query in the DSB.
What does happen:  The data is imported but the range definition is lost.
This one is considered for OO.o later (area ms-interoperability), is
will take time because it means a big rebuilding work.
Comment 10 bettina.haberer 2003-12-04 17:45:48 UTC 
Oj, setting flags...
Comment 11 bettina.haberer 2003-12-04 17:46:24 UTC 
reopening for setting it on started again.
Comment 12 bettina.haberer 2003-12-04 17:46:58 UTC 
started again!
Comment 13 bettina.haberer 2003-12-04 17:48:25 UTC 
Summary was meant just one time.
Comment 14 bettina.haberer 2003-12-04 17:49:09 UTC 
And set Daniel on copy.
Comment 15 erwin.tenhumberg 2004-10-27 17:10:14 UTC 
enhanced summary, set keywords and reassigned issue according to RFE process
Comment 16 ace_dent 2008-05-16 00:38:19 UTC 
OpenOffice.org Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 3 years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
http://download.openoffice.org/index.html
or consider trying the new OOo 3 BETA (still in testing):
http://download.openoffice.org/3.0beta/
 
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
http://www.openoffice.org/issues/query.cgi
 
Many thanks,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html