Bug 157219 - Cells cannot be merged after unsharing
Summary: Cells cannot be merged after unsharing
Status: RESOLVED DUPLICATE of bug 100433
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.0.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2023-09-13 03:04 UTC by 1009323081
Modified: 2023-09-27 14:42 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
This is an xlsx format file that I undid and still can't merge cells. (6.07 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-09-13 03:04 UTC, 1009323081
Details

Note You need to log in before you can comment on or make changes to this bug.
Description 1009323081 2023-09-13 03:04:48 UTC
Created attachment 189540 [details]
This is an xlsx format file that I undid and still can't merge cells.

In the form of xlsx format, the shared table cannot merge cells, but the merge cell button is still gray after canceling the share. Temporary solution Save the package table as ods restart operation to cancel the sharing can be solved.
Comment 1 m_a_riosv 2023-09-14 00:36:21 UTC
Sample file seems protected, not shared.
Comment 2 1009323081 2023-09-14 02:23:58 UTC
(In reply to m.a.riosv from comment #1)
> 示例文件似乎受到保护,而不是共享。

 我就设置了共享,再取消共享,表格就这样了,你可以试试看,能不能自己操作复现此bug。如果是受到保护,那么在哪里可以取消保护呢
Comment 3 QA Administrators 2023-09-16 03:22:17 UTC Comment hidden (obsolete)
Comment 4 Stéphane Guillou (stragu) 2023-09-27 14:42:33 UTC
Comment 2 automatically translated:

> I set up sharing, then canceled sharing, and the table looked like this.
> You can try it and see if you can reproduce this bug by yourself.
> If it is protected, where can I cancel the protection?

I tested from a new file, and it's true that unsharing an XLSX results in a file that still behaves like a shared file: not able to merge cells, and changes are tracked for some reason (when that functionality is not available in a shared ODS). But no "(shared)" in the title bar.

Ultimately I think this is the same as bug 100433, in which saving a shared XLSX results in the user being told it is not shared anymore, 

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

Version: 6.0.0.3
Build ID: 64a0f66915f38c6217de274f0aa8e15618924765
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk2; 
Locale: en-AU (en_AU.UTF-8); Calc: group

*** This bug has been marked as a duplicate of bug 100433 ***