Dear Dev Team and Kai, I used OpenOffice.org.calc extensively for the first time yesterday. In the process of entering several hundred numbers (coordinate pairs) I missed two features that I find in Microsoft Excel (2002 10 SP3 and previous releases):
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. 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. I am using version 1.1.2 from a Debian Linux distribution. I appreciate the work that you are doing and think that OpenOffice is a fine product. Feel free to contact me at cbc0111 at earthlink.net or this reply address if you have questions or suggestions. Thanks, Christopher --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
