Bug 178172 - Text to columns is not working
Summary: Text to columns is not working
Status: RESOLVED FIXED
Alias: None
Product: calligrasheets
Classification: Applications
Component: general (show other bugs)
Version: 2.4.1
Platform: unspecified Linux
: NOR normal
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-12-19 14:28 UTC by Johan Erlands
Modified: 2013-11-22 10:56 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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