Bug 178172

Summary:	Text to columns is not working
Product:	[Applications] calligrasheets	Reporter:	Johan Erlands <johan.erlands>
Component:	general	Assignee:	Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal	CC:	dainisp, deri
Priority:	NOR
Version:	2.4.1
Target Milestone:	---
Platform:	unspecified
OS:	Linux
Latest Commit:	http://commits.kde.org/calligra/dbcb43f804f81c958a5f206a9d5fe42df72d1ccd	Version Fixed In:
Sentry Crash Report:

Description Johan Erlands 2008-12-19 14:28:09 UTC

Version:           2.0 beta-3 (using 4.1.85 (KDE 4.1.85 (KDE 4.2 Beta2)), Kubuntu packages)
Compiler:          cc
OS:                Linux (i686) release 2.6.27-9-generic

When Text to columns is invoked data, no columns is added. The result for doing text to columns on 1,1 is 1 with the separator ,. The result should have been two columns with 1.

Comment 1 Johan Erlands 2009-04-05 14:47:42 UTC

I've tried this with 2.0 rc1 and it does not work.

Comment 2 Johan Erlands 2009-05-30 17:47:22 UTC

just tried it on 2.0.0 and its is still there.

Comment 3 Johan Erlands 2009-06-15 22:54:54 UTC

I think that the culprit is m_selection->lastRange() that doesn't change in CSVDialog.
 
    m_selection->().setRight( m_selection->lastRange().left() + numCols - 1 );

lastRange is the same as it was before after this line. I'm not god enough to figure out why this line does not change lastRange.

I have tried file imports as well. They only work if i select a wide enough area. They also truncate to the number of selected columns...

Comment 4 Dainis 2009-07-26 08:08:39 UTC

This bug is in my system too:
Linux bigarch 2.6.30-ARCH #1 SMP PREEMPT Mon Jul 20 07:46:03 CEST 2009 x86_64 AMD Athlon(tm) 64 Processor 3800+ AuthenticAMD GNU/Linux
KSpread
Version 2.0.1
Using KDE 4.2.4 (KDE 4.2.4) (KDEmod)

Comment 5 Deri James 2011-05-25 16:18:33 UTC

Still present in 2.3.3, no workaround found.

Comment 6 Deri James 2012-07-31 17:54:27 UTC

Still present in Calligra Sheets 2.4.1

Comment 7 Tomas Mecir 2013-11-10 18:59:19 UTC

Git commit e037aad7e0a26b8c3e719b94533ebea74c4eb7c1 by Tomas Mecir.
Committed on 10/11/2013 at 18:57.
Pushed by mecir into branch 'master'.

fix text to columns
Related: bug 181576

M  +12   -14   sheets/dialogs/CSVDialog.cpp

http://commits.kde.org/calligra/e037aad7e0a26b8c3e719b94533ebea74c4eb7c1

Comment 8 Halla Rempt 2013-11-22 10:56:03 UTC

Git commit dbcb43f804f81c958a5f206a9d5fe42df72d1ccd by Boudewijn Rempt, on behalf of Tomas Mecir.
Committed on 10/11/2013 at 18:57.
Pushed by rempt into branch 'calligra/2.7'.

fix text to columns
Related: bug 181576

M  +12   -14   sheets/dialogs/CSVDialog.cpp

http://commits.kde.org/calligra/dbcb43f804f81c958a5f206a9d5fe42df72d1ccd