Issue 106668 - unable to open data file in spreadsheet via url load bar
Summary: unable to open data file in spreadsheet via url load bar
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-11-06 09:52 UTC by oorene
Modified: 2013-12-20 11:04 UTC (History)
3 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description oorene 2009-11-06 09:52:38 UTC
scenario: a data file consists of tab separated values with file suffix .dat.

in url load bar, the file name path is typed, e.g. /path/to/filename/file.dat

The file is opened as corrupted characters in the writer application!

The correct behaviour is that an import dialogue window should appear to
configure calc to open the file.
Comment 1 raal 2009-11-17 15:27:20 UTC
I can confirm with version OOO320m4.
It´s not easy to import tabular data into calc when suffix is another then .csv
or .txt because of autodetecting of filetype.
As a workaround you can drag&drop .dat file into calc. this action open text
import dialog.
Comment 2 Edwin Sharp 2013-12-20 11:04:41 UTC
A .dat file opens in Writer instead of Calc.

AOO410m1(Build:9750)  -  Rev. 1551017
Win 7