[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

 CC||stephane.guillou@libreoffic
   ||e.org

--- Comment #11 from Stéphane Guillou (stragu) 
 ---
The "share spreadsheet" functionality for XLSX seems very broken:
- as described here, saving a shared XLSX forces the user to "unshare it" by
saving a copy of the file
- with an extremely confusing message that I can't make sense of even after
reading it several times
- ... but even if the "unshared" file is then saved, with "(saved)" absent from
the title bar, the file retains the shared file restrictions (e.g. inability to
merge cells, as reported in duplicate bug 157219)
- ... and tracks edits, even though it's something unavailable in shared
spreadsheets.

Overall, feels very confusing and broken and makes me wonder if this feature
should be restricted to ODF (or entirely removed given how many features are
turned off when in use).

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 19e9fe7c8c89399753ac1730e1c76378b18418bc
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

 CC||1009323...@qq.com

--- Comment #10 from Stéphane Guillou (stragu) 
 ---
*** Bug 157219 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

--- Comment #9 from Gabor Kelemen (allotropia)  ---
Created attachment 182309
  --> https://bugs.documentfoundation.org/attachment.cgi?id=182309=edit
Equivalent feature in Excel

(In reply to Justin L from comment #7)
> Is this really something that MS Formats know about? Is this a Microsoft
> thing, or is it a LibreOffice-only feature?

Yes, there is something similar in Excel. I recall people were using this
feature and place files on Sharepoint servers (maybe it works on simpler
services like smb too) to have collaborative shared editing of spreadsheets.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

--- Comment #8 from Buovjaga  ---
(In reply to Justin L from comment #7)
> Is this really something that MS Formats know about? Is this a Microsoft
> thing, or is it a LibreOffice-only feature?

I only found this, already deprecated, feature:
https://support.microsoft.com/en-us/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534

Replaced by
https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

--- Comment #7 from Justin L  ---
Is this really something that MS Formats know about? Is this a Microsoft thing,
or is it a LibreOffice-only feature?

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

--- Comment #6 from Roman Kuznetsov <79045_79...@mail.ru> ---
Still repro in

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: af64bc49d872d8a040d66387303def98eae5cd51
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

--- Comment #5 from QA Administrators  ---
Dear Dan,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

Aron Budea  changed:

   What|Removed |Added

   Keywords||filter:xlsx
   Severity|minor   |normal
 CC||ba...@caesar.elte.hu
 Blocks||108897
   Hardware|x86-64 (AMD64)  |All


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

Bartosz  changed:

   What|Removed |Added

 Status|ASSIGNED|NEW
   Assignee|gan...@poczta.onet.pl   |libreoffice-b...@lists.free
   ||desktop.org

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

Bartosz  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |gan...@poczta.onet.pl
   |desktop.org |

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

Buovjaga  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW
   Severity|normal  |minor

--- Comment #4 from Buovjaga  ---
Then you can set the XLSX to shared mode and try saving it.

You will get an error dialog:

This spreadsheet is no longer in shared mode.

Save your spreadsheet to a separate file and merge your changes to the shared
spreadsheet manually.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

--- Comment #3 from Buovjaga  ---
Created attachment 127839
  --> https://bugs.documentfoundation.org/attachment.cgi?id=127839=edit
ODS with shared status

Save this as XLSX and observe the title bar drop (shared)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

Bartosz  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #2 from Bartosz  ---
Could you please attach some .xlsx and .odt documents on which it is possible
to reproduce this issue?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100433] Shared document status lost when saved as XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100433

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||todven...@suomi24.fi
 Ever confirmed|0   |1
 OS|Windows (All)   |All

--- Comment #1 from Buovjaga  ---
Repro.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.3.0.0.alpha0+
Build ID: c13f60e7cd18df6b0ab70289f5b91ee01e4ae126
CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Built on June 18th 2016

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs