Issue 103811 - Data > Text to Columns ignores selection after paste > transpose
Summary: Data > Text to Columns ignores selection after paste > transpose
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1 RC2
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-07-25 19:38 UTC by Joe Smith
Modified: 2013-01-29 21:54 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
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 Joe Smith 2009-07-25 19:38:13 UTC 
To reproduce:

1) File > New > Spreadsheet

2) Enter three text values:
A1: a,b
B1: c,d
C1: e,f

3) Select A1:C1; Edit > Copy
4) Click in a new cell, e.g. A4
5) Edit > Paste Special > All, Options: Transpose; OK

The data are pasted into A4:A6, and Calc shows them highlighted & selected.

6) Data > Text to Columns, Separated by: comma

Note that only one row appears in the preview.

7) Click OK: Only the first row of the selection is processed.

Expected result: All rows of the selection should be processed by Text to Columns.
Comment 1 Regina Henschel 2009-07-26 00:00:37 UTC 
As described. "Text to Column" works as expected, if you first unmark the cells
after pasting them and then select them again.