LibreCalc will not load spreadsheet from file.

**bearymore** · 16-Jan-2020, 20:56

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.

**Knurpht** · 16-Jan-2020, 21:13

Please show us your repos

Code:

zypper lr -d

**tsu2** · 17-Jan-2020, 07:48

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

**bearymore** · 17-Jan-2020, 08:25

Originally Posted by Knurpht

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/                                       |

**bearymore** · 17-Jan-2020, 08:33

Originally Posted by tsu2

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.

**tannington** · 17-Jan-2020, 09:58

I believe you may have been hit by this bug:

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

**bearymore** · 17-Jan-2020, 10:10

Originally Posted by tannington

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?

**tannington** · 17-Jan-2020, 10:25

Originally Posted by bearymore

... 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.

**bearymore** · 17-Jan-2020, 12:01

Originally Posted by tannington

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.