Announcement

Collapse
No announcement yet.

Wanted: Libre Office Calc With Help that Works

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Wanted: Libre Office Calc With Help that Works

    I installed Kubuntu 25.10 on February 2nd.

    I've done a lot of things to the system since, adding software, removing software, etc. I did not keep a log of all I did, but of course it should be possible to query the system to tell me what it has.

    I have LibreCalc Office installed - I think it came with the system.

    Attempting to use its help button generally gives me messages like

    Firefox can’t find the file at /usr/share/libreoffice/help/index.html?Target=scalc/.uno:HelpIndex&Language=en-US&System=UNIX&Version=25.8.
    My first thought was that debian derivatives often package documentation separately so I looked for possibly relevant packages, and would have installed any I found. This is where libreoffice-help-common may have come from.

    Here's what I can tell you about relevant packages:

    $ sudo apt list --installed \*office\*
    libreoffice-base-core/questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 amd64 [installed,automatic]
    libreoffice-calc/questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 amd64 [installed,automatic]
    libreoffice-common/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed,automatic]
    libreoffice-core/questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 amd64 [installed,automatic]
    libreoffice-draw/questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 amd64 [installed,automatic]
    libreoffice-help-common/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed,automatic]
    libreoffice-help-en-us/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed]
    libreoffice-impress/questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 amd64 [installed,automatic]
    libreoffice-kf6/questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 amd64 [installed,automatic]
    libreoffice-math/questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 amd64 [installed,automatic]
    libreoffice-plasma/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed,automatic]
    libreoffice-qt6/questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 amd64 [installed,automatic]
    libreoffice-style-breeze/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed,automati>
    libreoffice-style-colibre/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed,automat>
    libreoffice-uiconfig-calc/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed,automat>
    libreoffice-uiconfig-common/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed,autom>
    libreoffice-uiconfig-draw/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed,automat>
    libreoffice-uiconfig-impress/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed,auto>
    libreoffice-uiconfig-math/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed,automat>
    libreoffice-uiconfig-writer/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed,autom>
    libreoffice-writer/questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 amd64 [installed,automatic]
    openoffice.org-hyphenation/questing,questing,now 0.10ubuntu2 all [installed]



    The offending file exists and is world readable:

    ls -l /usr/share/libreoffice/help/index.html
    -rw-r--r-- 1 root root 4123 Dec 10 12:59 /usr/share/libreoffice/help/index.html

    I don't see a relevant snap, and I have not installed flatpack

    $ snap list
    Name Version Rev Tracking Publisher Notes
    bare 1.0 5 latest/stable canonical base
    core22 20260113 2292 latest/stable canonical base
    firefox 147.0.4-1 7836 latest/stable/… mozilla -
    gnome-42-2204 0+git.c1d3d69-sdk0+git.015db9a 247 latest/stable/… canonical -
    gtk-common-themes 0.1-81-g442e511 1535 latest/stable/… canonical -
    gtk-theme-breeze 1.3 5 latest/stable/… kde -
    icon-theme-breeze 1.3 5 latest/stable/… kde -
    snapd 2.73 25935 latest/stable canonical snapd



    I really need the help to be working, because at my level of knowledge the spreadsheet is pretty close to unusable without documentation, and getting docs from the web is very much hit or miss, not to mention usually producing the wrong version.

    Can anyone please tell me how to fix this?
    Last edited by DinoNerd; Yesterday, 04:55 PM. Reason: fix giant mess resulting from (a) firefox inability to paste-and-match-style and (b) kde inability to reliably copy text from shell windows.

    #2
    I just checked, and found similar errors from LibreOffice Writer, so presumably the whole LibreOffice suite has the same problem.

    I'm posting about this here, rather than on the LibreOffice site, because this smells to me like a build or packaging problem.

    Comment


      #3
      You do not have LO's help files, which are just local copies of the official online web documents.

      You need to install libreoffice-help-<language>.

      A list of options available can be seen here, or searching with Synaptic Package Manager.
      Last edited by claydoh; Yesterday, 06:19 PM.
      Self-built: Asus PRIME B550M-K/Ryzen 5600GT/32Gb/Intel ARC B580 12Gb/KDE neon
      HP Elitedesk 800 G3 Mini: i5-7500T(35w)/32Gb/KDE Linux/Kubuntu LTS
      HP Chromebook 14: i5-1135G7/8Gb/512Gb SSD/KDE neon

      Comment


        #4
        Originally posted by claydoh View Post
        You do not have LO's help files, which are just local copies of the official online web documents.

        You need to install libreoffice-help-<language>.

        A list of options available can be seen here, or searching with Synaptic Package Manager.
        Apt list says I have

        libreoffice-help-en-us/questing-updates,questing-updates,now 4:25.8.4-0ubuntu0.25.10.1 all [installed]

        Comment


          #5
          oops, I somehow didn't scan it. I was even wearing my glasses

          Plus, it wasn't installed by default on my 25.10 system.

          It is working for me here: it opens Firefox to the local help pages after I installed the package. I didn't even have to restart the program.


          You may need to try running LO from the terminal and see what errors it shows when trying to open the help pages from the menu.

          Code:
          libreoffice --calc
          (or --writer, etc)
          Self-built: Asus PRIME B550M-K/Ryzen 5600GT/32Gb/Intel ARC B580 12Gb/KDE neon
          HP Elitedesk 800 G3 Mini: i5-7500T(35w)/32Gb/KDE Linux/Kubuntu LTS
          HP Chromebook 14: i5-1135G7/8Gb/512Gb SSD/KDE neon

          Comment


            #6
            Originally posted by claydoh View Post
            oops, I somehow didn't scan it. I was even wearing my glasses

            Plus, it wasn't installed by default on my 25.10 system.

            It is working for me here: it opens Firefox to the local help pages after I installed the package. I didn't even have to restart the program.


            You may need to try running LO from the terminal and see what errors it shows when trying to open the help pages from the menu.

            Code:
            libreoffice --calc
            (or --writer, etc)

            I don't think it was installed by default on my system either, but don't remember for sure.

            No errors appearing in the terminal window when I tried this.

            --

            On the good side, I downloaded the latest LibreOffice from their own website to a different, non-Kubuntu system (the Mac I'm trying to move away from). The help works there. So I have a workaround of sorts.

            Worst case, I'll do the same thing with the Kubuntu system, after uninstalling the one from the Kubuntu repository, and get things working that way, assuming of course their linux version doesn't have a similar problem.

            Actually, uninstall plus reinstall might be a good idea, even getting the packages from ubuntu. Sometimes that works.



            Comment


              #7
              Uninstalling/reinstalling rarely fixes things in linux, but it does not hurt to do so.

              Dumb question, but have you checked your browser (if open), to see if it is opening the help page when trying this? What is your default browser, if different from the stock Snap version of Firefox?

              It does NOT come into focus when I do this, but I usually have it on a different screen. I would assume this would be noticed at some point anyway, the next time you switched to your web browser.

              Self-built: Asus PRIME B550M-K/Ryzen 5600GT/32Gb/Intel ARC B580 12Gb/KDE neon
              HP Elitedesk 800 G3 Mini: i5-7500T(35w)/32Gb/KDE Linux/Kubuntu LTS
              HP Chromebook 14: i5-1135G7/8Gb/512Gb SSD/KDE neon

              Comment


                #8
                Originally posted by claydoh View Post
                Uninstalling/reinstalling rarely fixes things in linux, but it does not hurt to do so.

                Dumb question, but have you checked your browser (if open), to see if it is opening the help page when trying this? What is your default browser, if different from the stock Snap version of Firefox?

                It does NOT come into focus when I do this, but I usually have it on a different screen. I would assume this would be noticed at some point anyway, the next time you switched to your web browser.
                It is the stock snap version of firefox.

                The error message I reported is showing up in Firefox, with a URL of file:///usr/share/libreoffice/help/index.html?Target=scalc/.uno%3AHelpIndex&Language=en-US&System=UNIX&Version=25.8

                I.e. a normal file URL, but with material after the .html

                I know that sort of thing works for actual web pages, if the web page/server is set up appropriately, but I'm not sure whether the suffixes are interpreted and/or ignored by the web server (none in this case), or the web browser, presumably based on the page contents.

                The message I'm getting is consistent with firefox believing that the full path name is

                /usr/share/libreoffice/help/index.html?Target=scalc/.uno%3AHelpIndex&Language=en-US&System=UNIX&Version=25.8

                rather than

                /usr/share/libreoffice/help/index.html

                This version of firefox doesn't seem to want to tell me its version number, but
                Code:
                snap list
                says it's 147.0.4-1

                What does the URL line look like on your browser when you try this?

                The url used by libreoffice 26.2's mac installation is

                https://help.libreoffice.org/26.2/en...x#bm_id3806162

                This is not a file::: URL

                So we're still left with the question of whether file URLs can in fact include ?foo=bar suffixes.

                Last edited by DinoNerd; Yesterday, 09:50 PM. Reason: add more info

                Comment


                  #9
                  Originally posted by DinoNerd View Post
                  What does the URL line look like on your browser when you try this?
                  Accessing from Writer:
                  Code:
                  file:///usr/share/libreoffice/help/en-US/text/shared/05/new_help.html?System=UNIX&DbPAR=WRITER&HID=.uno:HelpIndex#bm_id3806162
                  From Calc:
                  Code:
                  file:///usr/share/libreoffice/help/en-US/text/shared/05/new_help.html?System=UNIX&DbPAR=CALC&HID=.uno:HelpIndex#bm_id3806162

                  This is the stock LO from Ubuntu
                  The most current from LOS's PPA's is this same version.
                  Last edited by claydoh; Today, 12:17 AM.
                  Self-built: Asus PRIME B550M-K/Ryzen 5600GT/32Gb/Intel ARC B580 12Gb/KDE neon
                  HP Elitedesk 800 G3 Mini: i5-7500T(35w)/32Gb/KDE Linux/Kubuntu LTS
                  HP Chromebook 14: i5-1135G7/8Gb/512Gb SSD/KDE neon

                  Comment


                    #10
                    So the Mac release is not accessing local offline help files, just going to the web.

                    The file location on my main PC (KDE neon) using the current from LO's PPAs is the same url here.
                    LO's own packaging may have variations in the file names/location, I will assume.
                    Self-built: Asus PRIME B550M-K/Ryzen 5600GT/32Gb/Intel ARC B580 12Gb/KDE neon
                    HP Elitedesk 800 G3 Mini: i5-7500T(35w)/32Gb/KDE Linux/Kubuntu LTS
                    HP Chromebook 14: i5-1135G7/8Gb/512Gb SSD/KDE neon

                    Comment

                    Users Viewing This Topic

                    Collapse

                    There are 0 users viewing this topic.

                    Working...
                    X