Issue 101154 - Calc- Insert - Link to external Data with tab delimited text file: unable to import any data.
Summary: Calc- Insert - Link to external Data with tab delimited text file: unable to ...
Status: CLOSED DUPLICATE of issue 97793
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.1 RC1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-04-17 10:01 UTC by jim_meech2
Modified: 2017-05-20 09:52 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Screenshot test import (139.32 KB, image/png)
2009-04-17 10:03 UTC, jim_meech2
no flags Details
Screnshot External Data (107.61 KB, image/png)
2009-04-17 10:04 UTC, jim_meech2
no flags Details
Tab delimitted text file for data source (37 bytes, text/plain)
2009-04-17 10:05 UTC, jim_meech2
no flags Details
Excel spreadsheet (1.31 MB, application/
2009-04-17 11:54 UTC, jim_meech2
no flags Details
Text file to import into Excel (108.15 KB, text/plain)
2009-04-17 11:55 UTC, jim_meech2
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jim_meech2 2009-04-17 10:01:17 UTC
This issue is present on all 2.x & 3.x release versions of calc on PC platform.
The issue is present on both Linux (Ubuntu) & Windows XP.

When trying to insert a link to external data which is a delimited text file, I
am unable to import any data as there are no defined ranges.
The text import window functions as one would expect.
The External Data window does not display any Available tables/ Ranges. The Ok
button remains greyed out.

It would be extremely useful to be able to periodically import data from a text
file. Many data RS232 based data loggers produce data in tab or comma delimited
Unfortunately I have to return to excel to perform this routine task.

Many thanks & best regards

Comment 1 jim_meech2 2009-04-17 10:03:21 UTC
Created attachment 61623 [details]
Screenshot test import
Comment 2 jim_meech2 2009-04-17 10:04:05 UTC
Created attachment 61624 [details]
Screnshot External Data
Comment 3 jim_meech2 2009-04-17 10:05:49 UTC
Created attachment 61625 [details]
Tab delimitted text file for data source
Comment 4 frank 2009-04-17 10:24:27 UTC
double to Issue 1834

Use Menu Insert-Sheet from File and tag the Link option if you need it.


*** This issue has been marked as a duplicate of 1834 ***
Comment 5 frank 2009-04-17 10:24:51 UTC
closed double
Comment 6 jim_meech2 2009-04-17 11:51:06 UTC
Thanks for your quick response, however I do not believe that this issue should
be closed as resolved as a duplicate of issue 1834.
I have scanned the numerous postings on this issue, perhaps my report is better
suited as a new feature request, as it appears the Link to external data route
is functioning as intended.

The suggested method of importing text files works fine if you wish to create a
new sheet for the imported data. If however you wish to repeatedly import &
refresh data from a text file, so that it always imports to the same sheet,
starting at the same cell, this method does not work easily.
You would have to write additional macros to cut and paste the data from the new
sheet to the sheet you wish to work on.

The equivalent functionality in Excel makes it very easy to import text data
into a template spreadsheet for rapid processing.
As an engineer dealing with large numbers of text based machine logs, this
functionality is invaluable.
I will upload an example excel spreadsheet & real data to demonstrate the
utility of this approach to data import.
This spread sheet will not open in OO due to incompatible macros.

on opening the spreadsheet in excel (office XP) follow these steps:

Don't update on  the request to update linked data.
Press the macro button Refresh Data.
Select the text file Autopilot.txt
Ignore the Export results Macro Button

Statistical analysis & graph plotting have now been completed.

If you are willing to reconsider the status of this report I would be very
willing to clarify any points by phone. I may be contacted on +44 (0)1386 768050
Working hours 09:00  to 17:00  GMT+1 BST should this prove useful.

Many thanks & best regards
Jim Meech

Comment 7 jim_meech2 2009-04-17 11:54:05 UTC
Created attachment 61630 [details]
Excel spreadsheet
Comment 8 jim_meech2 2009-04-17 11:55:12 UTC
Created attachment 61631 [details]
Text file to import into Excel
Comment 9 frank 2009-04-17 12:26:27 UTC

it's definitely a double to Issue 1834.

If you have to import such text files into the same document and the same sheet,
just use the Link optionn in the Insert-Sheet from file dialog. This will ask
you everytime you open the document to update the links in it. So all you need
is there but works a little different compared to Excel. OOo isn't a MSOffice
clone and will not be one. So you have to expect some differences.

Nevertheless I re-assign this Issue to the User Experience group for clarifying.

Comment 10 Edwin Sharp 2014-01-02 11:55:07 UTC
Duplicate bug.

*** This issue has been marked as a duplicate of issue 97793 ***