Steps to reproduce:
1. Select a range of cells downwards in same column
2. Right click->Format->Numbers. Change to format required (either currency or date).
3. Range of cells still selected.
4. Data->Text to columns. Then Ok.
Current behavior: Only first cell is converted.
Expected behavior: All selected cells should be converted.
Work around: reselect the cell range. Data->Text to columns. Then Ok. Now it works. Irritating that I have to re select the cell range.
Operating System: Ubuntu
Version: 188.8.131.52 release
Reproduced with 184.108.40.206, 220.127.116.11, 18.104.22.168 - Ubuntu 12.04 x86
Not reproduced with LO 22.214.171.124
Waiting confirmation from dev if fix will backported to 4.2.7
Still reproduced in 126.96.36.199.0+ Time: 2014-07-30_13:16:10
I am closing this as WFM - it would take some effort from multiple people to find the patch, review the patch, and backport the patch. While the OP says it's "quite annoying" the workaround is quite straightforward. 4.3 is available and the problem is resolved.
Thanks fine. I added the LibreOffice apt repos and am using 4.3, and can confirm the issue does not exist in this release. Shame the ubuntu versions are out of date. Thanks for looking into it.
FWIW - Ubuntu release is pretty much always "out of date" (or it is as soon as a new "fresh" release comes out) and this is by design - they have a pretty strict regression policy so if you want "latest and greatest" you have to get the ppa.
Zdeněk Crhonek committed a patch related to this issue.
It has been pushed to "master":
uitest forbug tdf#82398
It will be available in 6.1.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.