Results 1 to 10 of 10

Thread: LibreCalc will not load spreadsheet from file.

  1. #1

    Angry LibreCalc will not load spreadsheet from file.

    After a recent update, LibreCalc will no longer allow me to load a spreadsheet from a file.When I issue the insert sheet from file command, I receive the error message
    Code:
    Error loading document file:///home/charlie/Diag_Q19.xlsx:Object not accessible.
    The object cannot be accessed
    due to insufficient user rights.
    Both the spreadsheet I am using and the file holding the existing spreadsheet have the same owner, in this case user/charlie. It is possible to open the file from which I am trying to load a spreadsheet and use the move/copy spreadsheet command to copy the spreadsheet to the file into which I am trying to insert it. It is simply that the insert from file doesn't work. This is new and happens with every file I've tried. I've never had this problem before. I have a plain vanilla installation. The LibreOffice is Version: 6.3.3.2.0+Build ID: 30(Build:2) CPU threads: 4; OS: Linux 4.12; UI render: default; VCL: kde5, supplied by SUSE.

    Any help would be greatly appreciated.
    Last edited by bearymore; 16-Jan-2020 at 20:58. Reason: clarification

  2. #2
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    20,317
    Blog Entries
    14

    Default Re: LibreCalc will not load spreadsheet from file.

    Please show us your repos
    Code:
    zypper lr -d
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  3. #3
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,866
    Blog Entries
    2

    Default Re: LibreCalc will not load spreadsheet from file.

    If this was working very recently and your problem only just started happening,
    Recommend

    1. Open an elevated console running the following command which will display system logs in real time... Then try the operation again. Maybe something additional will be written to your log file.
    2. Again, only if it was working very recently and something changed, you can submit a bug to https://bugzilla.opensuse.org.

    And generally,
    When you post a problem or submit a bug, try to provide the actual commands and results, don't just describe verbally... For instance when you say that your file has your logged in User permissions (although I agree it's pretty hard to misunderstand or do this check incorrectly).

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  4. #4

    Default Re: LibreCalc will not load spreadsheet from file.

    Quote Originally Posted by Knurpht View Post
    Please show us your repos
    Code:
    zypper lr -d
    Here are the repositories. Note that the home: repositories have not been enabled.
    Code:
    #  | Alias                               | Name                               | Enabled | GPG Check | Refresh | Priority | Type     | URI                                                                                          | Service---+-------------------------------------+------------------------------------+---------+-----------+---------+----------+----------+----------------------------------------------------------------------------------------------+--------
     1 | Dickens_-_Ubuntu_Fonts              | Dickens - Ubuntu Fonts             | No      | ----      | ----    |   99     | NONE     | http://download.opensuse.org/repositories/home:/gldickens3/openSUSE_Leap_15.1/               |        
     2 | Local                               | Local                              | Yes     | ( p) Yes  | Yes     |   99     | plaindir | dir:/home/charlie/RPMS                                                                       |        
     3 | Mono                                | Mono                               | No      | ----      | ----    |   99     | NONE     | http://download.opensuse.org/repositories/Mono/openSUSE_Leap_15.1/                           |        
     4 | Mozilla                             | Mozilla                            | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/repositories/mozilla/openSUSE_Leap_15.1/                        |        
     5 | Perl_Language                       | Perl Language                      | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/repositories/devel:/languages:/perl/openSUSE_Leap_15.1/         |        
     6 | PlexRepo                            | PlexRepo                           | Yes     | (r ) Yes  | No      |   99     | rpm-md   | https://downloads.plex.tv/repo/rpm/x86_64/                                                   |        
     7 | Subpixel_-_namtrac                  | Subpixel - namtrac                 | No      | ----      | ----    |   99     | NONE     | http://download.opensuse.org/repositories/home:/namtrac:/subpixel/openSUSE_Leap_15.1/        |        
     8 | Utilities                           | Utilities                          | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/repositories/utilities/openSUSE_Leap_15.1/                      |        
     9 | download.nvidia.com-leap_1          | nVidia Graphics Drivers            | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | https://download.nvidia.com/opensuse/leap/15.1                                               |        
    10 | google-chrome                       | google-chrome                      | Yes     | ( p) Yes  | Yes     |   99     | rpm-md   | http://dl.google.com/linux/chrome/rpm/stable/x86_64                                          |        
    11 | http-download.opensuse.org-67f86a4a | home:dnh                           | No      | ----      | ----    |   99     | NONE     | http://download.opensuse.org/repositories/home:/dnh/openSUSE_Leap_15.1_standard/             |        
    12 | http-download.opensuse.org-807de918 | Ximi1970 - Pipelight               | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/repositories/home:/Ximi1970:/openSUSE:/Extra/openSUSE_Leap_15.1 |        
    13 | http-download.opensuse.org-8d637abc | GNOME:Apps                         | No      | ----      | ----    |   99     | NONE     | http://download.opensuse.org/repositories/GNOME:/Apps/openSUSE_Leap_15.1/                    |        
    14 | openSUSE-Leap-15.1-1                | openSUSE-Leap-15.1-1               | No      | ----      | ----    |   99     | rpm-md   | cd:/?devices=/dev/disk/by-id/ata-ASUS_DRW-24B1ST_i_E5D0CL057665                              |        
    15 | openSUSE_Leap_15.0_1                | Network Telephony                  | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | https://download.opensuse.org/repositories/network:/telephony/openSUSE_Leap_15.1/            |        
    16 | openSUSE_Leap_15.0_2                | Games                              | No      | ----      | ----    |   99     | NONE     | http://download.opensuse.org/repositories/games/openSUSE_Leap_15.1/                          |        
    17 | opensuse-guide.org-repo             | Libdvdcss Repository               | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://opensuse-guide.org/repo/openSUSE_Leap_15.1/                                           |        
    18 | packman.inode.at-suse               | Packman                            | Yes     | (r ) Yes  | Yes     |   98     | rpm-md   | http://packman.inode.at/suse/openSUSE_Leap_15.1/                                             |        
    19 | repo-debug                          | Debug Repository                   | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/debug/distribution/leap/15.1/repo/oss/                          |        
    20 | repo-debug-non-oss                  | Debug Repository (Non-OSS)         | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/debug/distribution/leap/15.1/repo/non-oss/                      |        
    21 | repo-debug-update                   | Update Repository (Debug)          | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/debug/update/leap/15.1/oss/                                     |        
    22 | repo-debug-update-non-oss           | Update Repository (Debug, Non-OSS) | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/debug/update/leap/15.1/non-oss/                                 |        
    23 | repo-non-oss                        | Non-OSS Repository                 | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/distribution/leap/15.1/repo/non-oss/                            |        
    24 | repo-oss                            | Main Repository                    | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/distribution/leap/15.1/repo/oss/                                |        
    25 | repo-source                         | Source Repository                  | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/source/distribution/leap/15.1/repo/oss/                         |        
    26 | repo-source-non-oss                 | Source Repository (Non-OSS)        | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/source/distribution/leap/15.1/repo/non-oss/                     |        
    27 | repo-update                         | Main Update Repository             | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/update/leap/15.1/oss                                            |        
    28 | repo-update-non-oss                 | Update Repository (Non-Oss)        | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/update/leap/15.1/non-oss/                                       |

  5. #5

    Default Re: LibreCalc will not load spreadsheet from file.

    Quote Originally Posted by tsu2 View Post
    If this was working very recently and your problem only just started happening,
    Recommend

    1. Open an elevated console running the following command which will display system logs in real time... Then try the operation again. Maybe something additional will be written to your log file.
    2. Again, only if it was working very recently and something changed, you can submit a bug to https://bugzilla.opensuse.org.

    And generally,
    When you post a problem or submit a bug, try to provide the actual commands and results, don't just describe verbally... For instance when you say that your file has your logged in User permissions (although I agree it's pretty hard to misunderstand or do this check incorrectly).

    TSU
    What is the log command you are referencing? The actual command I entered was Sheet; Insert Sheet From File; Insert [file chosen from list]. This immediately elicits the error message in the first post. User permissions are Owner can view or modify, group and others can only view for all files. All files are owned by user/charlie and LibreCalc is launched by user/charlie. This is a recent problem. This has always worked for me for years actually.

  6. #6
    Join Date
    Sep 2013
    Location
    Norfolk, UK
    Posts
    1,395

    Default Re: LibreCalc will not load spreadsheet from file.

    I believe you may have been hit by this bug:

    https://bugs.documentfoundation.org/....cgi?id=129082
    Regards, Paul

    2x Tumbleweed (Snapshot: 20200224) KDE Plasma 5
    2x Leap 15.1 KDE Plasma 5

  7. #7

    Default Re: LibreCalc will not load spreadsheet from file.

    Quote Originally Posted by tannington View Post
    I believe you may have been hit by this bug:

    https://bugs.documentfoundation.org/....cgi?id=129082
    It does sound similar. Will the patch be available soon in the OpenSuse version?

  8. #8
    Join Date
    Sep 2013
    Location
    Norfolk, UK
    Posts
    1,395

    Default Re: LibreCalc will not load spreadsheet from file.

    Quote Originally Posted by bearymore View Post
    ... Will the patch be available soon in the OpenSuse version?
    For Leap 15.1 I'm afraid I don't know.

    You could consider using 6.4.x although that's still a release candidate

    https://download.opensuse.org/reposi...USE_Leap_15.1/

    or file a bug on the openSUSE bugzilla https://bugzilla.opensuse.org to see if the patches can be backported.
    Regards, Paul

    2x Tumbleweed (Snapshot: 20200224) KDE Plasma 5
    2x Leap 15.1 KDE Plasma 5

  9. #9

    Default Re: LibreCalc will not load spreadsheet from file.

    Quote Originally Posted by tannington View Post
    For Leap 15.1 I'm afraid I don't know.

    You could consider using 6.4.x although that's still a release candidate

    https://download.opensuse.org/reposi...USE_Leap_15.1/

    or file a bug on the openSUSE bugzilla https://bugzilla.opensuse.org to see if the patches can be backported.
    It did turn out to be the bug. I added the repository https://download.opensuse.org/reposi...SUSE_Leap_15.1 and loaded 6.3.4.2. The bug is gone.

  10. #10
    Join Date
    Sep 2013
    Location
    Norfolk, UK
    Posts
    1,395

    Default Re: LibreCalc will not load spreadsheet from file.

    Quote Originally Posted by bearymore View Post
    It did turn out to be the bug. I added the repository https://download.opensuse.org/reposi...SUSE_Leap_15.1 and loaded 6.3.4.2. The bug is gone.
    OK. Good to hear. Yes, that repository is probably a "safer" choice.
    Regards, Paul

    2x Tumbleweed (Snapshot: 20200224) KDE Plasma 5
    2x Leap 15.1 KDE Plasma 5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •