1. Cut Column or Row ( or Range) followed by Insert Cut Cells. This has the affect of quickly moving rows or columns. Range can be used but unless the cut and insert take place in the same column or row, the results can be messy. In either case, references are updated to follow the move. The functionality may be there but is was not obvious to me.
In Calc you have to do it in several steps: Insert an empty row, cut&paste (or drag&drop) the row you want to move, delete the original row. Formula references are then updated, too.
2. A functionality called Text-to-columns. While this can be accomplished by saving a sheet as CVS, opening it and making it into a spread sheet, copying and pasting the cells back to the original sheet, Text-to-columns performs the parse in place and distributes the discovered fields to the right. It could also be called Split-Cell or Split-Cell-on-Separator. I also noticed that CSV is very particular, that is looking for comma-space instead of just comma. While this avoids splitting at thousands-separators in the US and at decimal-divider elsewhere, it was a different behavior than I was expecting.
At the moment, loading a CSV file is the only way. That should work with a single comma as separator, not only comma-space.
Thanks for your suggestions. Both a direct text-to-column feature and a quicker way to exchange columns/rows have been suggested before. They won't be in version 2.0, but we're keeping them in mind for later versions.
Niklas
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
