LibreOffice CALC help needed please

Discussion in 'PC and I.T support/Advice posts' started by Stratman, Mar 22, 2014.

  1. Stratman

    Stratman Hardcore MB Enthusiast

    Messages:
    4,096
    Joined:
    Jun 15, 2003
    Location:
    Sunbury
    Car:
    W203 C200 CDI '04Estate
    Mrs. Stratman gets her work rota as an Excel spreadsheet, withh lots of coloured cells and so on. Our printer is monochrome, so when it's printed the output can be black text on a dark grey background. Not very readable.

    I've tried and failed to find a way to print just the data without the colours, just black on white. The printer driver (Samsung ML-2525W) doesn't have the option, neither does LibreOffice have the equivalent of Excel's Page Setup, which offers a Black and White option, or if it does I can't find it.

    Is there a way to print a colourful Excel spreadsheet from LibreOffice in just black and white?
     
  2. balge

    balge Hardcore MB Enthusiast

    Messages:
    827
    Joined:
    Jul 28, 2010
    Location:
    Central England
    Car:
    Mercedes-Benz W124
  3. OP
    OP
    Stratman

    Stratman Hardcore MB Enthusiast

    Messages:
    4,096
    Joined:
    Jun 15, 2003
    Location:
    Sunbury
    Car:
    W203 C200 CDI '04Estate
    Thanks, I suspect you're right. It 's a feature. The printer driver surprisingly doesn't offer the option either. Even the 'save toner' mode shades the cells.

    I'll try to write a macro that removes cell backgrounds. Then comes the hard bit, Mrs. Stratman and computers.

    Edit:- The online help states I should select printer properties and choose black and white from there. It looks like LibreOffice has passed the buck.
     
    Last edited: Mar 22, 2014
  4. Rayny

    Rayny Hardcore MB Enthusiast

    Messages:
    505
    Joined:
    Jan 4, 2009
    Location:
    Hastings
    Car:
    Skoda Roomster
    Not ideal, but could you just select all the cells, and change the background colour to white before you print?
     
  5. OP
    OP
    Stratman

    Stratman Hardcore MB Enthusiast

    Messages:
    4,096
    Joined:
    Jun 15, 2003
    Location:
    Sunbury
    Car:
    W203 C200 CDI '04Estate
    That's indeed what I would do, but Mrs. Stratman has rather limited IT skills ;)
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.