| Summary: | text to columns puts result into first line if whole column is selected | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | almos <aaalmosss> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | jorendc |
| Priority: | medium | ||
| Version: | 4.0.4.2 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
|
Description
almos
2013-08-03 17:55:18 UTC
Mmh, I partially can confirm your behavior. (In reply to comment #0) > If you have a column of data that you want to process with "text to > columns", and you select the whole column by clicking the column header, the > result will be created starting on line 1 irregardless of where the original > data column started (e.g. your data is in B4:B5000, and it's split into 3 > columns, it will end up in B1:D4997). I totally can confirm this. Also I have to mention, if you have data from B4:B5000 it'll shift everything to the first row, but it also _DOES NOT_ touch the last 3 rows of it (if your data is in B10:B5000 it'll skip the last 9 rows). > > If there is some data in the area it would overwrite with this (e.g. in the > above example you have something else in C1), it asks if it's OK to > overwrite it, but in this case it pastes the result in the correct place > (B4:D5000 in the example, and C1 is not overwritten). I fail to confirm that. Although I fail to reproduce the last part, this is definitely a bug. So marking it as such. Kind regards, Joren |