Bug 161752 - EDITING comment in "####" cell freezes LibreOffice at all
Summary: EDITING comment in "####" cell freezes LibreOffice at all
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.4.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-23 22:05 UTC by nick222
Modified: 2024-10-24 19:42 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample (51.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-06-24 14:00 UTC, nick222
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nick222 2024-06-23 22:05:43 UTC
Xubuntu 24.04

LibreOffice Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ru-RU (ru_RU.UTF-8); UI: ru-RU Ubuntu package version: 4:24.2.4~rc2-0ubuntu0.24.04.1~lo1 Calc: threaded

There are several cells one below the other. A comment has been added to each.
In the top cell, the value goes beyond its boundaries and it begins to look like "#####".
When I try to edit a comment in this cell, LibreOffice freezes completely.
In other cells below this one, the same thing is observed.
If, after restarting LibreOffice, you correct the display of the number in the first cell so that it is displayed normally, then the effect disappears in all cells and the program starts working normally.
Comment 1 HTK300 2024-06-24 09:59:33 UTC
not reproducible in Windows 10_64, LO 24.8 dev
Comment 2 nick222 2024-06-24 14:00:31 UTC
Created attachment 194928 [details]
Sample
Comment 3 ady 2024-06-24 16:32:11 UTC
(In reply to Nick222 from comment #0)
> When I try to edit a comment in this cell, LibreOffice freezes completely.

Could you please describe with steps (1, 2, 3...) how exactly you edit the comment?

For example:
1. Right-click on cell D33.
2. In the context menu, select Edit Comment.
3...
4. Press...

Again, that is just one generic example.

At which step Calc hangs/freezes?

Please also go to Calc menu Help > About; click on the icon within the dialog in order to copy the version info to the clipboard; then paste the info in your next comment.

FWIW, I do not reproduce the problem on Windows. Maybe knowing specific steps, the problem could be reproduced by someone else.
Comment 4 nick222 2024-06-24 17:35:28 UTC
Steps:
1. Yes - Right-click on cell D33.
2. Yes - In the context menu, select Edit Comment.
3. LibreOffice freeze at all.
Restart LibreOffice by Task Manager.

Version information - see my first post, please.
Comment 5 Rafael Lima 2024-06-24 21:02:58 UTC
The comment opens as expected for me in:

Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Ubuntu package version: 4:24.2.3-0ubuntu0.24.04.2
Calc: threaded

It also works in:

Version: 24.8.0.0.beta1+ (X86_64) / LibreOffice Community
Build ID: d681c57ba51b635ba7c85b21e062732110e8293f
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Calc: CL threaded
Comment 6 Stéphane Guillou (stragu) 2024-07-09 02:28:31 UTC
No crash for me on Ubuntu 22.04 + GNOME 42.9 with:

Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

I tested with cell contents visible and formula made smaller to display "###".

Do you reproduce the same crash if you change your UI language to a different one, e.g. English?

Maybe something to report to Ubuntu on Launchpad, given that you are using the version packaged by the distribution.
Comment 7 Buovjaga 2024-07-09 06:54:09 UTC
(In reply to Rafael Lima from comment #5)
> The comment opens as expected for me in:
> 
> Version: 24.2.3.2 (X86_64) / LibreOffice Community
> Build ID: 420(Build:2)
> CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb)
> Locale: pt-BR (pt_BR.UTF-8); UI: en-US
> Ubuntu package version: 4:24.2.3-0ubuntu0.24.04.2
> Calc: threaded
> 
> It also works in:
> 
> Version: 24.8.0.0.beta1+ (X86_64) / LibreOffice Community
> Build ID: d681c57ba51b635ba7c85b21e062732110e8293f
> CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb)
> Locale: pt-BR (pt_BR.UTF-8); UI: en-US
> Calc: CL threaded

Can you also check with SAL_USE_VCLPLUGIN=gtk3 ?
Comment 8 Rafael Lima 2024-07-09 12:28:13 UTC
(In reply to Buovjaga from comment #7)
> Can you also check with SAL_USE_VCLPLUGIN=gtk3 ?

Still, it works for me.

Tested with the gtk vcl (beware that I'm on Plasma 5.27)

Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Ubuntu package version: 4:24.2.4-0ubuntu0.24.04.2
Calc: threaded

Version: 24.8.0.0.beta1+ (X86_64) / LibreOffice Community
Build ID: d681c57ba51b635ba7c85b21e062732110e8293f
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Calc: CL threaded

Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c5132c74be9311eed4857635aecbfe9df77cf8ac
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Calc: CL threaded
Comment 9 Robert Großkopf 2024-10-24 19:42:28 UTC Comment hidden (obsolete)