Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: OpenOffice Calc is garbage

  1. #11
    Moderator
    Good Guru
    Compunuts's Avatar
    Join Date
    May 2001
    Location
    California
    Posts
    3,935
    Quote Originally Posted by Schotty
    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.
    LinuxVillage - The truely community run Linux/Floss forum !

    No IT BS !!

  2. #12
    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...
    Asus A8V Deluxe Mobo
    AMD Athlon64 X2 4400 -939
    2GB Crucial DDR3200 Dual-Channel
    ATi AiW 9800 Pro 128DDR
    Audigy2 ZS
    Sony DRU-810 DVD+RW DL
    3 x Maxtor MaxLine SATA 160Gb 16Mb Cache
    1 x Maxtor MaxLine SATA 300Gb 16Mb Cache
    1 x Maxtor MaxLine SATA 120Gb 16Mb Cache

  3. #13
    Moderator
    Good Guru
    Compunuts's Avatar
    Join Date
    May 2001
    Location
    California
    Posts
    3,935
    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.
    LinuxVillage - The truely community run Linux/Floss forum !

    No IT BS !!

  4. #14
    Achtung!!

  5. #15

    ??

    Attention?! Attention, what?
    Asus A8V Deluxe Mobo
    AMD Athlon64 X2 4400 -939
    2GB Crucial DDR3200 Dual-Channel
    ATi AiW 9800 Pro 128DDR
    Audigy2 ZS
    Sony DRU-810 DVD+RW DL
    3 x Maxtor MaxLine SATA 160Gb 16Mb Cache
    1 x Maxtor MaxLine SATA 300Gb 16Mb Cache
    1 x Maxtor MaxLine SATA 120Gb 16Mb Cache

  6. #16
    Moderator
    Good Guru
    Compunuts's Avatar
    Join Date
    May 2001
    Location
    California
    Posts
    3,935
    Bravo to base, bravo to base, can you repeat, over !
    LinuxVillage - The truely community run Linux/Floss forum !

    No IT BS !!

  7. #17
    Associate fossy's Avatar
    Join Date
    Aug 2007
    Location
    The Antipodes
    Posts
    39
    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?

Similar Threads

  1. Cannot Copy Multiple Unsorted Row or Coloumn at OOo Calc for Windows
    By Ivan W Setiadi in forum Windows - General Topics
    Replies: 1
    Last Post: 09-14-2006, 11:59 PM
  2. openoffice.org calc question
    By S_D_Willie in forum Linux - Software, Applications & Programming
    Replies: 1
    Last Post: 01-23-2004, 08:41 AM
  3. SCO Garbage
    By vwgtiturbo in forum Linux - General Topics
    Replies: 8
    Last Post: 12-06-2003, 09:03 PM
  4. OpenOffice.org Calc question
    By SwampDonkey in forum Linux - Software, Applications & Programming
    Replies: 6
    Last Post: 11-24-2002, 09:23 PM
  5. Programming on a Casio CFX-9850Ga Plus (calc)
    By Feztaa in forum Programming
    Replies: 1
    Last Post: 03-29-2002, 07:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •