Created attachment 11984 [details]
test case

Please, find attached a test case to reproduce the steps

Hi, thanks reporting this.

Using Mageia 7 GNOME and Libreoffice. All updates applied.
Version : 6.4.6.2
Build ID : 6.4.6.2-1.mga7
Threads CPU : 4; OS : Linux 5.7; UI Render : par défaut; VCL: gtk3; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded
Opening Attached 11984 file here in Libreoffice Calc.
Right-click to enter Edit mode on diagram.
Click to switch to second sheet.

No crash.


Can you provide journalctl -f output while doing this?
Can you tell me about your Desktop Environment? KDE Plasma, GNOME, XFCE?
Can you copy/paste here Libreoffice version in Help => About menu?

CC: (none) => ouaurelien

Can you also provide here output of command:
$ rpm -qa | grep libreoffice

Testing under Mageia 7 Plasma:
Libreoffice Calc is:
Version : 6.4.6.2
Build ID : 6.4.6.2-1.mga7
Threads CPU : 4; OS : Linux 5.7; UI Render : par défaut; VCL: gtk3_kde5; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

Opening same test file.
Right-click to enter Edit mode on diagram. Changed even a value.
Making sure I am in Edit mode for diagram.
Click to switch to second sheet.

No crash. Libreoffice runs well. UI correctly switches to Normal state.
Values can be added in sheet 2.
Going back to sheet 1: All seems OK.

Leaving this in Bugsquad until further answer from reporter.

Ever confirmed: 1 => 0
Status: NEW => UNCONFIRMED
Keywords: (none) => NEEDINFO

using KDE Plasma

Libreoffice
Version : 6.4.6.2
Build ID : 6.4.6.2-1.mga7
Threads CPU : 4; OS : Linux 5.7; UI Render : par défaut; VCL: gtk3; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

# rpm -qa | grep libreoffice
libreoffice-pyuno-6.4.6.2-1.mga7
libreoffice-help-fr-6.4.6.2-1.mga7
libreoffice-x11-6.4.6.2-1.mga7
libreoffice-data-6.4.6.2-1.mga7
libreoffice-calc-6.4.6.2-1.mga7
libreoffice-impress-6.4.6.2-1.mga7
libreoffice-ogltrans-6.4.6.2-1.mga7
libreoffice-writer-6.4.6.2-1.mga7
libreoffice-langpack-fr-6.4.6.2-1.mga7
libreoffice-ure-6.4.6.2-1.mga7
libreoffice-math-6.4.6.2-1.mga7
libreoffice-opensymbol-fonts-6.4.6.2-1.mga7
libreoffice-wiki-publisher-6.4.6.2-1.mga7
libreoffice-draw-6.4.6.2-1.mga7
libreoffice-graphicfilter-6.4.6.2-1.mga7
libreoffice-xsltfilter-6.4.6.2-1.mga7
libreoffice-emailmerge-6.4.6.2-1.mga7
libreoffice-langpack-en-6.4.6.2-1.mga7
libreoffice-help-en-6.4.6.2-1.mga7
libreoffice-pdfimport-6.4.6.2-1.mga7
libreoffice-core-6.4.6.2-1.mga7
libreoffice-gtk3-6.4.6.2-1.mga7
libreoffice-ure-common-6.4.6.2-1.mga7

# journalctl -f
-- Logs begin at Mon 2020-11-02 14:16:24 CET. --
nov. 10 18:51:17 cftw.ddns.info plasmashell[15754]: qt.qpa.xcb: QXcbConnection: XCB error: 2 (BadValue), sequence: 25879, resource id: 121634819, major code: 141 (Unknown), minor code: 3
nov. 10 18:52:47 cftw.ddns.info mandi[4324]: skipping loopback interface
nov. 10 18:52:52 cftw.ddns.info dbus-daemon[913]: [system] Activating via systemd: service name='org.freedesktop.hostname1' unit='dbus-org.freedesktop.hostname1.service' requested by ':1.1105' (uid=1001 pid=11616 comm="/usr/lib64/libreoffice/program/soffice.bin --calc")
nov. 10 18:52:52 cftw.ddns.info systemd[1]: Starting Hostname Service...
nov. 10 18:52:52 cftw.ddns.info dbus-daemon[913]: [system] Successfully activated service 'org.freedesktop.hostname1'
nov. 10 18:52:52 cftw.ddns.info systemd[1]: Started Hostname Service.
nov. 10 18:53:22 cftw.ddns.info systemd[1]: systemd-hostnamed.service: Succeeded.
nov. 10 18:53:52 cftw.ddns.info rtkit-daemon[901]: Supervising 6 threads of 3 processes of 1 users.
nov. 10 18:53:52 cftw.ddns.info rtkit-daemon[901]: Supervising 6 threads of 3 processes of 1 users.
nov. 10 18:53:52 cftw.ddns.info mandi[4324]: skipping loopback interface
nov. 10 18:53:55 cftw.ddns.info mandi[4324]: skipping loopback interface
nov. 10 18:53:55 cftw.ddns.info mandi[4324]: skipping loopback interface
nov. 10 18:53:56 cftw.ddns.info mandi[4324]: skipping loopback interface

Thanks answering.

It seems there is this missing package:
libreoffice-kf5-6.4.6.2-1.mga7

Please run:
# urpmi --auto-update libreoffice-kf5

This package helps libreoffice to be better intgrated with Plasma.
But, I really don't think it is mandatory.

Meanwhile, in your "journalctl -f" output, I don't see any error.

Please at last provide the file:
/home/[your user name]/.local/share/sddm/xorg-session.log

This log file can contain info don't catched by system journal.

Ever confirmed: 0 => 1
Status: UNCONFIRMED => NEW

# urpmi --auto-update libreoffice-kf5
Erreur : options --auto-select et la liste de paquetages incompatibles.
# urpmi libreoffice-kf5              
    http://mirrors.mageia.org/api/mageia.7.x86_64.list: media/core/updates/libreoffice-kf5-6.4.6.2-1.mga7.x86_64.rpm
installation de libreoffice-kf5-6.4.6.2-1.mga7.x86_64.rpm depuis /var/cache/urpmi/rpms                                                                                              
Préparation...                   ##################################################################################################################################################
      1/1: libreoffice-kf5       ##################################################################################################################################################


$ tail -f ~/.local/share/sddm/xorg-session.log 
(process:15523): GLib-GObject-CRITICAL **: 21:42:47.427: g_object_unref: assertion 'G_IS_OBJECT (object)' failed
(process:15523): GLib-GObject-CRITICAL **: 21:42:47.427: g_object_unref: assertion 'G_IS_OBJECT (object)' failed
(process:15523): GLib-GObject-CRITICAL **: 21:43:48.558: g_object_unref: assertion 'G_IS_OBJECT (object)' failed
(process:15523): GLib-GObject-CRITICAL **: 21:43:48.558: g_object_unref: assertion 'G_IS_OBJECT (object)' failed
(process:15523): GLib-GObject-CRITICAL **: 21:43:48.558: g_object_unref: assertion 'G_IS_OBJECT (object)' failed
(process:15523): GLib-GObject-CRITICAL **: 21:43:48.588: g_object_unref: assertion 'G_IS_OBJECT (object)' failed


$ soffice
** (soffice:6838): WARNING **: 21:43:02.180: Exception in getAccessibleName()

That last warning is probably inoffensive.

Trying the sample on M7/Mate, with all packages as per comment 5
+ kf5, libreofficekit
- emailmerge, wiki-publisher
but not FR locale. I suspect Aurelien has that.

> 1. Enter edit mode on first sheat diagram
> 2. Click to switch to second sheat 
> 3. Everything is frozen, then crashes "nicely"
 1. Already in (Edit menu) Edit Mode.
 2. Feuille2.
 3. Continues OK, can do things in Feuille2.
Confirms Aurelien's test.

@Antonin
> Everything is frozen, then crashes "nicely"
When you say 'everything', do you mean just Calc, or the whole system?
Please elaborate on crashes "nicely". An error dialogue? A screenshot of that?

Try doing from a terminal:
 $ oocalc <path-to-the problem-spreadsheet>
to see what errors are reported there. (There was no terminal output at all in my test; nor when doing just $ soffice).

Does the fault only happen with the given spreadsheet, or with any?
If you have a different desktop, please try that.

CC: (none) => lewyssmith

I noticed the bug on a heavier spreadsheet. I manage to avoid the crash, selecting a cell before clicking the sheet I wanted to get to. But it's hard to change behaviour, so after about 10 crashes, upset, I build this sample to submit the bug.

'everything' because all the desktop is heavily slowed, while a libreoffice window 'error dialog' is poping up (I may be more accurate to say pooooooooowowowowowowooooping up... (about 40s long)). Opened it's telling me "Récupération de document". I could never feel the validate button to be clicked, or wait enough for that. I everytime had to move to tty2 to kill soffice (SIGTERM 15). Until now ! After validating this popup window, I eventually get a Fatal exception :

$ oocalc ~/Bureau/soffice_calc_bug.ods 

** (soffice:20722): WARNING **: 22:21:53.893: Exception in getAccessibleName()


Fatal exception: Signal 11
Stack:
/usr/lib64/libreoffice/program/libuno_sal.so.3(+0x3c1b0)[0x7fe08a7ec1b0]
/usr/lib64/libreoffice/program/libuno_sal.so.3(+0x3c378)[0x7fe08a7ec378]
/lib64/libc.so.6(+0x3caf0)[0x7fe08a510af0]

I'll tell you later if I get to another desktop environment, or restarted session.

Reboot

I see now libreoffice is now using VCL: gtk3-kde5; 
The bug is still there

Installed Xfce desktop environment
# urpmi task-xfce-minimal

In this environment: VCL: gtk3;
No bug.

My original bug report was under Plasma with VCL: gtk3;


One noticeable difference between both environments is Compiz. 
Plasma + Compiz  -vs-  Xfce

Actually Compiz is on both desktop environments. By default Xfce has no 3D cube.
So I have no more clue to provide. 
The remaining question is: What's wrong with my Kde5 Plasma session ?

I forgot to tell my test under Xfce was with another brand new user.
The bug is coming from my initial user session, both with Plasma or Xfce ; the new user has no problem with both envrironments.

Maybe worth to know, my linux mga7 is an update from mageia 6.

Just to say I have tried this now under Plasma, same (OK) as in comment 8.
 $ oocalc Desktop/soffice_calc_bug.ods 
 $
---------
Thank you for all your experiments. If I understand them correctly:
* Original user, the fault happens under both Plasma AND Xfce.
* It is NOT specific to the example spreadsheet.
* New user, the fault does NOT happen under either Plasma OR Xfce.

This suggests something in $HOME, some configuration parameter perhaps.
Since the fault seems to be LibreOffice rather than desktop (Plasma)
.config/libreoffice/ seems a good place to look - comparing old & new user.

What do you think, Aurelien ?

Yes Lewis Smith, you've got it.
For me, digging into .config/libreoffice/4/user/ is too labyrinthine.

I just renamed my user folder for backup : .config/libreoffice/4/user0/

When launching oocalc, a brand new .config/libreoffice/4/user/ folder is created. But the bug is still there :

$ oocalc ~/Bureau/soffice_calc_bug.ods 

** (soffice:31121): WARNING **: 15:44:14.757: Exception in getAccessibleName()


Fatal exception: Signal 11
Stack:
/usr/lib64/libreoffice/program/libuno_sal.so.3(+0x3c1b0)[0x7f8ff0e871b0]
/usr/lib64/libreoffice/program/libuno_sal.so.3(+0x3c378)[0x7f8ff0e87378]
/lib64/libc.so.6(+0x3caf0)[0x7f8ff0babaf0]

(In reply to Lewis Smith from comment #13)
> Just to say I have tried this now under Plasma, same (OK) as in comment 8.
>  $ oocalc Desktop/soffice_calc_bug.ods 
>  $
> What do you think, Aurelien ?

I would like to say the same. Something is wrong in user $HOME dir.
Please log in as root on CLI.
Remove:
rm -r /home/[youruser name]/.cache
rm -r /home/[youruser name]/.config/libreoffice/

Please double-check what you are typing.

(In reply to Antonin Roussel from comment #14)
> $ oocalc ~/Bureau/soffice_calc_bug.ods 

This is the correct command line I prefer:
$ libreoffice --calc

Libreoffice is a shell script that set environment variables to soffice binary that is later launched. Passing arguments like "--calc" permits the execution of soffice.bin with a "New Calc Document".

> ** (soffice:31121): WARNING **: 15:44:14.757: Exception in
> getAccessibleName()> 
> Fatal exception: Signal 11
> Stack:
> /usr/lib64/libreoffice/program/libuno_sal.so.3(+0x3c1b0)[0x7f8ff0e871b0]
> /usr/lib64/libreoffice/program/libuno_sal.so.3(+0x3c378)[0x7f8ff0e87378]
> /lib64/libc.so.6(+0x3caf0)[0x7f8ff0babaf0]

This seems to be a segfault (Signal 11) in libuno_sal.so.3
I really can't reproduce it.
What quantity of RAM do you have on your computer?

(In reply to Antonin Roussel from comment #14)
> For me, digging into .config/libreoffice/4/user/ is too labyrinthine.
Agree!

> I just renamed my user folder for backup : .config/libreoffice/4/user0/
I thought to do something similar:
* Backup (mv) .config/libreoffice - what you did
* Copy (you would need to be root) that directory (cp -a ) from the user that works to the user that crashes; then chown -R to the normal user that directory. However, your way of doing this was even easier:
> When launching oocalc, a brand new .config/libreoffice/4/user/ folder is
> created. But the bug is still there
Gloom. It must be something else, so Aurelien's suggestion looks good:
> $ rm -r /home/[youruser name]/.cache
Any other possibilities?

(In reply to Antonin Roussel from comment #10)
> 
> One noticeable difference between both environments is Compiz. 
> Plasma + Compiz  -vs-  Xfce

I missed this.
Compiz is not supported on Plasma.

You CAN replace Kwin (KDE own's window manager and compositor) by Compiz but it is not supported by KDE developers anymore.
So does us. That's remind me to carefully read each comment.

All effects Compiz has can be meet in Kwin one in Systemsettings5 => Workspace Behavior => Desktops Effects (Cube, woobly windows, Genius' Lamp effect,...).

And that's why Libreoffice (LO) under XFCE does not seem to be affected.

So, I suggest you to really ditch Compiz under Plasma 5.15.
Try after a restart of Libreoffice.

If it does not succeed, an other clue.
(Note that this is under Cauldron and same in M7 with different versions)

$ urpmf -f libuno_sal.so.3
libreoffice-ure-7.0.2.2-1.mga8.x86_64:/usr/lib64/libreoffice/program/libuno_sal.so.3

So, this C++ lib is responsible to help LO handle hardware.
All online searchs for "libuno_sal.so.3" with "segfault" point to:
"Libreoffice does not launch". Sometimes associated with other lib. This seems generic but I will suspect user system is running out of RAM when the segfault occurs.

I out of ideas.

(In reply to Aurelien Oudelet from comment #15)
There are 8Gio RAM (40% used), 10Gio SWAP, 4 CPUs. BOINC is often running in the background, sometimes it is wise to suspend it.

I use the suggested command line, I then load my test file. Same storytelling.

$ libreoffice --calc

** (soffice:31714): WARNING **: 00:12:34.032: Exception in getAccessibleName()


Fatal exception: Signal 11
Stack:
/usr/lib64/libreoffice/program/libuno_sal.so.3(+0x3c1b0)[0x7f81565521b0]
/usr/lib64/libreoffice/program/libuno_sal.so.3(+0x3c378)[0x7f8156552378]
/lib64/libc.so.6(+0x3caf0)[0x7f8156276af0]


(In reply to Aurelien Oudelet from comment #15)
(In reply to Lewis Smith from comment #16)
.cache
Looks cleaning it has no effect...

(In reply to Aurelien Oudelet from comment #17) Concerning Compiz.
The fact is Plasma+Compiz gives no bug with a brand new user.

(In reply to Lewis Smith from comment #16)
> Any other possibilities?

-1- Back up and renew ~/.config
Disconnect graphic session, and from tty do
$ mv /home/[youruser name]/.config /home/[youruser name]/.config0 
Start new graphic session (auto  creation of a new ~/.config)
No more bug

-2- Restore ~/.config
Disconnect graphic session, and from tty do
$ rm -r /home/[youruser name]/.config
$ mv /home/[youruser name]/.config0 /home/[youruser name]/.config

-3- Refining : Back up and renew ~/.config/compiz
Disconnect graphic session, and from tty do
$ mv /home/[youruser name]/.config/compiz /home/[youruser name]/.config/compiz0
Start new graphic session (auto  creation of a new ~/.config/compiz)
No more bug

So there is a compiz option that allows this bug to happen.

Compiz options allowing the bug.
Looks like this is between
Zoom du bureau amélioré (which relies on) Focus position polling (which relies on) GLIb
Some other plugins are active, but these ones seem to trigger the bug.

From .config/compiz/compizconfig/Default.ini 
[core]
as_active_plugins = glib;focuspoll;ezoom .../... (I'm guessing here)


Notice: When removing ezoom, then focuspoll, compiz is crashing. I can tell that because window decorations are suddenly changed and compiz effects gone.

I understood there is no support for Plasma + Compiz, so I do not expect someone to solve this issue.
Thank you all for your help.

* ezoom: The Enhanced Zoom Desktop plugin allows the whole screen to be zoomed in for improved legibility. It is possible to continue working with other applications while zoomed in. improved zoom functions for disabled
* focuspoll: Updates the focus pointer position from the accessbility library AT-SPI through dbus
* glib: support de la boucle principla GLib

http://wiki.compiz.org/Plugins/Ezoom

(In reply to Antonin Roussel from comment #20)
> Compiz options allowing the bug.
> Looks like this is between
> Zoom du bureau amélioré (which relies on) Focus position polling (which
> relies on) GLIb
> Some other plugins are active, but these ones seem to trigger the bug.
> 
> From .config/compiz/compizconfig/Default.ini 
> [core]
> as_active_plugins = glib;focuspoll;ezoom .../... (I'm guessing here)
> 
> 
> Notice: When removing ezoom, then focuspoll, compiz is crashing. I can tell
> that because window decorations are suddenly changed and compiz effects gone.
> 
> I understood there is no support for Plasma + Compiz, so I do not expect
> someone to solve this issue.
> Thank you all for your help.

Yeah, I accused Compiz as in a quick online search I saw multiple bugs with Libre Office and gtk-window-decorations. So, with a brand-new default Compiz configuration file, the bug does not seems to be reproduced. That's great!

Please test and report back to close the bug.

(In reply to Aurelien Oudelet from comment #22)
> So, with a brand-new default Compiz
> configuration file, the bug does not seems to be reproduced. That's great!
the bug does not reproduce
Until you enable one of the three plugins

The problem is not Plasma specific.

If there is no support for Compiz + gtk-window-decorations
I set this bug as RESOLVED + WONTFIX

Resolution: (none) => WONTFIX
Status: NEW => RESOLVED