Bug 125048 - Saved file has wrong group if calc file contains a chart. (Truly bizarre ...)
Summary: Saved file has wrong group if calc file contains a chart. (Truly bizarre ...)
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.5.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Network
  Show dependency treegraph
 
Reported: 2019-04-30 15:15 UTC by Nigel Arnot
Modified: 2019-11-26 09:44 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
The spreadsheet "nobug.ods" which is used at the start of the bug report description (8.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-04-30 15:15 UTC, Nigel Arnot
Details
The file "bug.ods", in case you want to look at its internals (14.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-04-30 15:18 UTC, Nigel Arnot
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nigel Arnot 2019-04-30 15:15:27 UTC
Created attachment 151094 [details]
The spreadsheet "nobug.ods" which is used at the start of the bug report description

This is a truly bizarre bug that I've spent a lot of time diagnosing and reducing to a simple case. This description is quite long. Please bear with me.

You need an unusual folder on an NFS share. Here, we have a group called "silson". My username is "nigel". The folder has the group sticky bit set, so that files are created with group silson and everybody in  that group shares write access. Here is the set-up for folder "test". I don't think the acls are relevant, but included just in case. 

[root@hermes Silson Library]# ls -ld test
drwxrwsr-x+ 2 nigel silson 4096 Apr 30 15:29 test
[root@hermes Silson Library]# getfacl test
# file: test
# owner: nigel
# group: silson
user::rwx
group::rwx
mask::rwx
other::r-x
default:user::rwx
default:group::rwx
default:mask::rwx
default:other::r-x

Now, open the attached file and save it into this folder with libreoffice calc, as "nobug"

Now, insert a chart. Select A1:B8. Insert|Chart. X-Y scatter, Points & Lines, Finish. Save as "bug"

Click on the chart and press backspace to delete it. Save as "fixedbug"

The file protections are:

ls test/* -l
-rw-rw-r--+ 1 nigel nigel  14994 Apr 30 15:37 test/bug.ods
-rw-rw-r--+ 1 nigel silson  9050 Apr 30 15:38 test/fixedbug.ods
-rw-rw-r--+ 1 nigel silson  9056 Apr 30 15:34 test/nobug.ods

It's the presence of a chart that makes the file get saved with group=nigel instead of group=silson. It can be a chart hidden away on a different work-sheet that nobody ever looks at ....

The bug was not present in the libreoffice shipped with Fedora 27: 5.4.7.2-3.fc27.x86_64. It appeared after upgrading to Fedora 29, 6.1.5.2-5.fc29.x86_64
Comment 1 Nigel Arnot 2019-04-30 15:18:05 UTC
Created attachment 151095 [details]
The file "bug.ods", in case you want to look at its internals
Comment 2 Nigel Arnot 2019-04-30 15:53:54 UTC
Just confirmed that this bug is also present in 6.2.3.2 as downloaded from https://www.libreoffice.org/download/download/
Comment 3 Xisco Faulí 2019-11-25 15:53:21 UTC
Thank you for reporting the bug.
it seems you're using an old version of LibreOffice.
Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 4 Nigel Arnot 2019-11-26 09:36:17 UTC
Appears fixed in 6.3.3.2-5.fc31 (fedora 31)

In passing - I couldn't find an easy way to delete a chart. Click/Backspace no longer works. Is Highlighting the block of sells around it and then clearing all contents the right/only way to do it?
Comment 5 Xisco Faulí 2019-11-26 09:44:16 UTC
(In reply to Nigel Arnot from comment #4)
> Appears fixed in 6.3.3.2-5.fc31 (fedora 31)
> 
> In passing - I couldn't find an easy way to delete a chart. Click/Backspace
> no longer works. Is Highlighting the block of sells around it and then
> clearing all contents the right/only way to do it?

Thanks for retesting with the latest version.
Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.