Libre Calc.

Lbre Calc has been modified beyond description. I can no longer change font, number style, position in cell to name but a few. I can save which is rather academic since
I cannot make any changes to my spreadsheet. Calc used to be easy to use with options offering all the commonly used operations. What is going on?


Which version of Calc are you talking about ?

And in which distro/version ?


I can still do all the things you mentioned in Version:

Are you saying the option for changing font,etc. are missing … or just not working ?

Don’t know the version but I have recently downloaded a full set of updates including from Libre Office so should be up to date.
I cannot find the options mentioned.


Where/how did you “download” the updates ?

And you can get the version by opening Calc, and going to Help > About LibreOffice

This is Peppermint7. Recommended updates -small icon bottom right on screen. Generally update about once a month.

Version number 6.1 so far as I can see.
The option for changing “default font” is present but does not work. Have tried it many times. I cannot find the option for changing font on an open spreadsheet.

Hang on! Have just discovered “side bar” under “View” at the top of the spreadsheet window. This provides the operations I was missing. Libre Office is a very difficult system for the uninitiated to manage. Its “help” pages are not much help and it seems impossible to address a direct question.

Sorry to have troubled you. Thanks anyway.


Hmm, you seem to have a more recent version than the default version in the Peppermint repos (more recent even than the version in Peppermint 9) … maybe they’ve changed some stuff I’m not aware of yet.

Anyway, glad you figured it out :slight_smile:

Unfortunately not to my satisfaction. Is it possible to get back to the earlier and much more usable version? I am spending a great deal of time grappling with cmplexities of this version and not getting any real work done. Grateful for any advice.

What’s the output from:

ls -a /etc/apt/sources.list.d


for APT in `find /etc/apt/ -name \*.list`; do grep -o "^deb[a-z0-9\-]\+/[a-z0-9\-]\+" $APT | while read ENTRY ; do USER=`echo $ENTRY | cut -d/ -f4` PPA=`echo $ENTRY | cut -d/ -f5` ; echo ppa:$USER/$PPA ; done ; done


dpkg -l | grep libre
google-earth.list peppermint.list peppermint.

I cannot get a response from your second sring. I continally get: bash: syntax error near unexpected token ‘do’

The third response is: -l: command not found

You’re copying and pasting these commands right ?

No. Just reading them and printing them manually.


This is what came up when copied and pasted your 2nd string

ii  libdjvulibre-text                                              all          Linguistic support files for libdjvulibre
ii  libdjvulibre21:amd64                                           amd64        Runtime support for the DjVu image format
ii  libreadline5:amd64                    5.2+dfsg-3build1                             amd64        GNU readline and history libraries, run-time libraries
ii  libreadline6:amd64                    6.3-8ubuntu2                                 amd64        GNU readline and history libraries, run-time libraries
ii  libreoffice-base-core                 1:5.1.6~rc2-0ubuntu1~xenial4                 amd64        office productivity suite -- shared library
ii  libreoffice-calc                      1:5.1.6~rc2-0ubuntu1~xenial4                 amd64        office productivity suite -- spreadsheet
ii  libreoffice-common                    1:5.1.6~rc2-0ubuntu1~xenial4                 all          office productivity suite -- arch-independent files
ii  libreoffice-core                      1:5.1.6~rc2-0ubuntu1~xenial4                 amd64        office productivity suite -- arch-dependent files
ii  libreoffice-math                      1:5.1.6~rc2-0ubuntu1~xenial4                 amd64        office productivity suite -- equation editor
ii  libreoffice-style-elementary          1:5.1.6~rc2-0ubuntu1~xenial4                 all          office productivity suite -- Elementary symbol style
ii  libreoffice-style-galaxy              1:5.1.6~rc2-0ubuntu1~xenial4                 all          office productivity suite -- Galaxy (Default) symbol style
ii  libreoffice-writer                    1:5.1.6~rc2-0ubuntu1~xenial4                 amd64        office productivity suite -- word processor
ii  libresid-builder0c2a                  2.1.1-14ubuntu2                              amd64        SID chip emulation class based on resid
ii  librest-0.7-0:amd64                   0.7.93-1                                     amd64        REST service access library
ii  librevenge-0.0-0:amd64                0.0.4-4ubuntu1                               amd64        Base Library for writing document interface filters    

And this from the 3rd.

What’s the output from:

soffice --version

LibreOffice 10m0(Build:2)

Would you like to try LibreOffice 6 ?

It might fix whatever is broken in your LO 5.

If so, follow the instructions below…

Open a terminal and run the following commands in sequence

sudo apt-get remove --purge libreoffice*


mv ~/.config/libreoffice ~/.config/libreoffice-old


sudo add-apt-repository ppa:libreoffice/ppa


sudo apt-get update


sudo apt-get install libreoffice

Before dealing with Libre Office as you suggest I have been considering going from existing Peppermint 7 to 9 in which case I could defer Libre business until 9 is in. However, if I simply download 9 does it overwrite 7 or do I end up with both?

Your advice on this would be most welcome.


The installer should give you the option to REPLACE Peppermint 8, or ALONGSIDE Peppermint 8

Choosing REPLACE will completely wipe the drive, then install Peppermint 9

Choosing ALONGSIDE will shrink the Peppermint 8 partition, and create a new one for Peppermint 9 … so you choose which to boot into.

On another note, Peppermint 9 already has LibreOffice 6 out of the box.

DIRECT istallation would not come up so I used the recmmended TORRENT. Was not offered a choice of REPLACE or ALONGSIDE. I have ended up with a window which refers to a 128 GB disc and instruction to “Restore disc image”. Not sure what’s going on here.

Have you burned the ISO image you downloaded to a USB stick ?

If not, what OS are you going to use whilst creating the USB stick … Peppermint 7 ?