The Linux Community Forum

The Forums => General Discussion => Topic started by: Osmond on September 10, 2018, 03:15:50 pm

Title: Libre Calc.
Post by: Osmond on September 10, 2018, 03:15:50 pm
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?

Osmond
Title: Re: Libre Calc.
Post by: Mark Greaves (PCNetSpec) on September 10, 2018, 03:30:10 pm
Which version of Calc are you talking about ?

And in which distro/version ?

[EDIT]

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

Are you saying the option for changing font,etc. are missing .. or just not working ?
Title: Re: Libre Calc.
Post by: Osmond on September 10, 2018, 04:32:44 pm
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.

Osmond
Title: Re: Libre Calc.
Post by: Mark Greaves (PCNetSpec) on September 11, 2018, 12:08:26 am
Where/how did you "download" the updates ?

And you can get the version by opening Calc, and going to Help > About LibreOffice
Title: Re: Libre Calc.
Post by: Osmond on September 11, 2018, 09:15:16 am
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.

Osmond
Title: Re: Libre Calc.
Post by: Mark Greaves (PCNetSpec) on September 11, 2018, 01:00:00 pm
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 :)
Title: Re: Libre Calc.
Post by: Osmond on September 11, 2018, 01:59:48 pm
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.
Title: Re: Libre Calc.
Post by: Mark Greaves (PCNetSpec) on September 11, 2018, 02:33:33 pm
What's the output from:
Code: [Select]
ls -a /etc/apt/sources.list.d
and
Code: [Select]
for APT in `find /etc/apt/ -name \*.list`; do grep -o "^deb http://ppa.launchpad.net/[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
and
Code: [Select]
dpkg -l | grep libre
Title: Re: Libre Calc.
Post by: Osmond on September 15, 2018, 12:51:20 pm
Code: [Select]
google-earth.list peppermint.list peppermint. list.save

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

Title: Re: Libre Calc.
Post by: Mark Greaves (PCNetSpec) on September 16, 2018, 01:29:41 am
You're copying and pasting these commands right ?
Title: Re: Libre Calc.
Post by: Osmond on September 16, 2018, 11:25:08 am
No. Just reading them and printing them manually.
Title: Re: Libre Calc.
Post by: Osmond on September 17, 2018, 10:51:50 am
Code: [Select]
ppa:peppermintos/p7-release

This is what came up when copied and pasted your 2nd string
Title: Re: Libre Calc.
Post by: Osmond on September 17, 2018, 10:55:30 am
Code: [Select]
ii  libdjvulibre-text                     3.5.27.1-5                                   all          Linguistic support files for libdjvulibre
ii  libdjvulibre21:amd64                  3.5.27.1-5                                   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.
Title: Re: Libre Calc.
Post by: Mark Greaves (PCNetSpec) on September 18, 2018, 11:16:23 am
What's the output from:
Code: [Select]
soffice --version
Title: Re: Libre Calc.
Post by: Osmond on September 19, 2018, 08:41:46 am
LibreOffice 5.1.6.2 10m0(Build:2)
Title: Re: Libre Calc.
Post by: Mark Greaves (PCNetSpec) on September 19, 2018, 11:26:57 am
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
Code: [Select]
sudo apt-get remove --purge libreoffice*
then
Code: [Select]
mv ~/.config/libreoffice ~/.config/libreoffice-old
then
Code: [Select]
sudo add-apt-repository ppa:libreoffice/ppa
then
Code: [Select]
sudo apt-get update
then
Code: [Select]
sudo apt-get install libreoffice
Title: Re: Libre Calc.
Post by: Osmond on September 23, 2018, 02:29:47 pm
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.

Osmond
Title: Re: Libre Calc.
Post by: Mark Greaves (PCNetSpec) on September 23, 2018, 08:23:15 pm
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.
Title: Re: Libre Calc.
Post by: Osmond on September 26, 2018, 05:00:11 pm
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.
Title: Re: Libre Calc.
Post by: Mark Greaves (PCNetSpec) on September 26, 2018, 10:48:22 pm
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 ?
Title: Re: Libre Calc.
Post by: Osmond on September 28, 2018, 12:34:27 pm
Not yet.  Peppermint 7 is all I have.

I notice that DIRECT download works from the Users Guide. Can I abort the TORRENT process and use DIRECT as originally intended?
Title: Re: Libre Calc.
Post by: Mark Greaves (PCNetSpec) on September 28, 2018, 07:25:23 pm
Of course you can.

here are the direct links.

Peppermint 9 64bit
https://peppermintos.com/iso/Peppermint-9-20180621-amd64.iso

Peppermint 9 32bit
https://peppermintos.com/iso/Peppermint-9-20180621-i386.iso
SimplePortal 2.3.3 © 2008-2010, SimplePortal