Issue 105923

Summary: Text Import wizard skips empty cells
Product: Calc Reporter: yurikhan <yurivkhan>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, jkieffab
Version: OOO310m11   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.0.1
Developer Difficulty: ---

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