Author Topic: Libre Office  (Read 446 times)

0 Members and 1 Guest are viewing this topic.

Offline Osmond

  • Jr. Member
  • **
  • Posts: 91
  • Karma: 0
  • I've just joined!
    • View Profile
    • Awards
Libre Office
« on: August 04, 2017, 11:07:37 am »
I have a Libre Calc spreadsheet. The default font appears to be Liberation Sans but I have changed the font for my spreadsheet to Ubuntu Light. However if I move a row of cells the vacant space left reverts back to Liberation Sans. I choose Tools - Options - Fonts and follow the instructions to replace Liberation with Ubuntu. Nothing happens after several goes. Any suggestions?

Osmond

Offline Mark Greaves (PCNetSpec)

  • Administrator
  • Hero Member
  • *****
  • Posts: 17083
  • Karma: 432
  • Gender: Male
  • "-rw-rw-rw-" .. The Number Of The Beast
    • View Profile
    • PCNetSpec
    • Awards
Re: Libre Office
« Reply #1 on: August 04, 2017, 05:21:53 pm »
run:
Code: [Select]
sudo fc-cache -fv
REBOOT

then try again
WARNING: You are logged into reality as 'root'
logging in as 'insane' is the only safe option.
pcnetspec.co.uk

Offline Osmond

  • Jr. Member
  • **
  • Posts: 91
  • Karma: 0
  • I've just joined!
    • View Profile
    • Awards
Re: Libre Office
« Reply #2 on: August 05, 2017, 08:28:50 am »
No effect I'm afraid

Offline Rich J

  • Sr. Member
  • ****
  • Posts: 361
  • Karma: 2
  • Gender: Male
  • A Linux Luvvie!
    • View Profile
    • Awards
Re: Libre Office
« Reply #3 on: August 05, 2017, 08:54:29 am »
Have you tried this?

Open the spreadsheet
Click in the first (blank) cell (top left corner to the left of the 'A' and above the '1')
This selects the whole spreadsheet.
Make the changes to font and size etc then save in the normal way.
Click anywhere within the spreadsheet to de-select.
Test.

Sometimes, if adding extra columns/rows etc, the formatting can revert also but that's an easy one to rectify - just select the affected area and change the parameters.  If you set the format you want before you start entering cell data, (font, borders, column/row size, cell size and so on) using the above 'should' retain the instructions throughout the spreadsheet when alterations are made afterwards.

HTH

Rich


« Last Edit: August 05, 2017, 08:56:52 am by Rich J »

Offline Osmond

  • Jr. Member
  • **
  • Posts: 91
  • Karma: 0
  • I've just joined!
    • View Profile
    • Awards
Re: Libre Office
« Reply #4 on: August 08, 2017, 10:53:51 am »
Thanks for that Rich J but still get reversion to Liberation sans. The Libre office default font change procedure does not work and I have been unable to find any help from the Libre web site. It's a nuisance but I can live with it. Thanks for your help.

Osmond

Offline Mark Greaves (PCNetSpec)

  • Administrator
  • Hero Member
  • *****
  • Posts: 17083
  • Karma: 432
  • Gender: Male
  • "-rw-rw-rw-" .. The Number Of The Beast
    • View Profile
    • PCNetSpec
    • Awards
Re: Libre Office
« Reply #5 on: August 08, 2017, 11:49:20 am »
I wonder what would happen if you removed the liberation font from your system just as a test (you can always reinstate it).
WARNING: You are logged into reality as 'root'
logging in as 'insane' is the only safe option.
pcnetspec.co.uk

 


SimplePortal 2.3.3 © 2008-2010, SimplePortal