Results 1 to 4 of 4

Thread: Showing formula in Calc (Open Office)

  1. #1
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts

    Showing formula in Calc (Open Office)

    Is there any way I can show the formula instead of the results using Calc in Open Office?

    I know how to do it in M$ Excel, in Calc I've been going to Format > Page > Sheet tab, and clicking formula.

    It doesn't change anything in the viewing screen, but if you look in print preview it shows a few things been shown as the formula.. but the rest as "#" symbols.

    Anybody know why it's doing this?

    Screenshot:


    Cheers

  2. #2
    radix lecti dave87's Avatar
    Join Date
    Sep 2005
    Location
    England
    Posts
    12,806
    Thanks
    657
    Thanked
    931 times in 634 posts
    • dave87's system
      • Motherboard:
      • Asus
      • CPU:
      • i5 3470k under Corsair H80 WC
      • Memory:
      • 8gb DDR3
      • Storage:
      • 240gb SSD + 120gb SSD
      • Graphics card(s):
      • Asus HD7950
      • PSU:
      • XFX 600w Modular
      • Case:
      • Lian Li PC-A05FNB + Acoustipack
      • Operating System:
      • Windows 10 Pro
      • Monitor(s):
      • 2x Dell S2309W (1920x1080)
      • Internet:
      • BT Infinity Option 2
    ### symbols means the text is too long to fit in the box - widen the box and it'll show up

  3. #3
    Ah, Mrs. Peel! mike_w's Avatar
    Join Date
    Oct 2003
    Location
    Hertfordshire, England
    Posts
    3,326
    Thanks
    3
    Thanked
    9 times in 7 posts
    Yeah, Calc doesn't like to print long formulas, which is a bit of PITA (there's probably some obscure option to change it, but I've never found it)

    Personally, I prefer Gnumeric.
    "Well, there was your Uncle Tiberius who died wrapped in cabbage leaves but we assumed that was a freak accident."

  4. #4
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    Ah, that is a bit of a PITA isn't it?

    Thank yee

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. is open office the best free office clone?
    By joshwa in forum Software
    Replies: 9
    Last Post: 23-01-2005, 01:45 PM
  2. Open source office?
    By ajbrun in forum Software
    Replies: 14
    Last Post: 24-11-2004, 11:19 AM
  3. Open Source Articles
    By r1zeek in forum General Discussion
    Replies: 6
    Last Post: 13-08-2004, 09:14 AM
  4. Replies: 3
    Last Post: 26-03-2004, 07:06 PM
  5. Open Office - anyone using it?
    By sparky191 in forum Software
    Replies: 2
    Last Post: 24-10-2003, 03:38 PM

Posting Permissions

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