Issue 105923 - Text Import wizard skips empty cells
Summary: Text Import wizard skips empty cells
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO310m11
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-15 13:02 UTC by yurikhan
Modified: 2013-12-12 10:34 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.1
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 yurikhan 2009-10-15 13:02:08 UTC 
When pasting tab-separated text from clipboard into Calc, cells that would
become empty retain their previous values instead.

To reproduce:
1. Start Windows Notepad.
2. Type: (replace [tab] with actual tab keypresses)
foo[tab][tab]baz
quux[tab]plugh[tab]xyzzy
3. Select all.
4. Copy.
5. Start OpenOffice.org Calc.
6. Navigate to cell B1.
7. Type:
bar
8. Navigate to cell A1.
9. Paste.
10. In the Text Import wizard, select:
 * Character set: Unicode
 * From row: 1
 * Separated by: [x] Tab (and nothing else).
 * OK

Expected:
 * The B1 cell is empty.

Observed:
 * The B1 cell contains its previous value, "bar".
Comment 1 Jenny Kieffaber 2013-11-09 22:30:21 UTC 
I have tested this bug on the environment listed below and was also able to confirm that this bug still exists.  I also verified that this is a reasonable software feature by testing this functionality in Microsoft Excel.  Excel's observed behavior matches the expected behavior listed from yurikhan.

Hardware: MAC OSX Version 10.8.5 Build 12F45 
Version: AOO401m5(Build:9714)  -  Rev. 1524958
TextEdit: 1.8 (301)
Comment 2 Edwin Sharp 2013-12-12 10:34:19 UTC 
As given in description.

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