OpenOffice Calc is garbage

[Compunuts]

Out of curiousity do other Linux office apps work correctly here? Perhaps Gnumeric or KCalc (or whatever the KDE version would be) may work better for that type of thing.

Gnumeric also doesn't support multiple colums (or rows) for that matter. Only one whole column or row at a time.

[vwgtiturbo]

I tried this in Excel, just to make sure I wasn't crazy (remember the window freeze from my previous post) and in Excel, it works. I can select multiple inconsecutive rows or columns, and have the option to cut or copy them. Oh well, I guess this will just be chalked up as one of those annoying things that I can do nothing about. Back to Excel for me, for now anyway...

[Compunuts]

I've said that in Excel works. Also freezing thing, the same with Excel. You have to select the cell behind the pane that you want to freeze.

[Roczid]

Achtung!!

[vwgtiturbo]

Attention?! Attention, what?

[Compunuts]

Bravo to base, bravo to base, can you repeat, over !

[fossy]

There's no problem with freezing, as I believe the OP has discovered. The software blocks cutting, copying or pasting cells which are not a single range, i.e. adjacent. The matter has been discussed on a forum dedicated to OpenOffice and, IIRC, an issue has been filed, although it seems I am not watching it because I have no emails about it.

Searching the other forum, I find there is a tool on ooomacros called CellMover which evidently moves multiple ranges. (I have not used it and that is not its primary purpose).

Recent versions of Calc evidently allow moving of multiple ranges if the intervening ones are filtered out but I imagine that's as much trouble as moving each range independently. What about copying and pasting a single range and deleting the parts you do not want in the new location?