Bug 156215 - drag cell expansion copy will result in a crash often
Summary: drag cell expansion copy will result in a crash often
Status: RESOLVED DUPLICATE of bug 149527
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Skia
  Show dependency treegraph
Reported: 2023-07-09 23:19 UTC by goofyseeker3
Modified: 2023-07-22 04:32 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description goofyseeker3 2023-07-09 23:19:43 UTC
at least half of the a few times using the drag copy expansion crashed the software

Steps to Reproduce:
1. make a formula
2. drag down

Actual Results:
cursor jams to cross, then crash to nothing

Expected Results:
no crash

Reproducible: Sometimes

User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All Win11)
OS is 64bit: no (yes)
Comment 1 m_a_riosv 2023-07-09 23:24:37 UTC
Please test with a clean profile, Menu/Help/Restart in Safe Mode

And paste here the information on Menu/Help/About LibreOffce (There is an icon to copy)
Comment 2 goofyseeker3 2023-07-09 23:25:36 UTC
this mostly happens when dragging thousands of cells, like 2000-4000 cells drag copy expand formula.
Comment 3 goofyseeker3 2023-07-09 23:38:49 UTC
it crashes even after the drag copy formula expansion has finished, during scroll window
Comment 4 goofyseeker3 2023-07-10 00:10:46 UTC
it even crashes not related to the formula expansion drag, it even crashes when drag window scroll selecting a large number of rows to a chart image.
Comment 5 QA Administrators 2023-07-10 03:14:15 UTC Comment hidden (obsolete)
Comment 6 Stéphane Guillou (stragu) 2023-07-11 12:46:04 UTC
I think this is likely a duplicate of bug 149527.

goofyseeker3, can you please:
- share with us the contents of your Skia log
- as m.a.riosv askes, share the version info copied from Help > About LibreOffice
- test if it still crashes with "Force Skia software rendering" turned on in Tools ▸ Options ▸ LibreOffice ▸ View

More info: https://wiki.documentfoundation.org/QA/FirstSteps#Graphics-related_issues_(_Skia_)
Comment 7 goofyseeker3 2023-07-11 14:34:18 UTC
can you get a duplicate of the bug, by your own testing?
Comment 8 QA Administrators 2023-07-12 03:14:44 UTC Comment hidden (obsolete)
Comment 9 Stéphane Guillou (stragu) 2023-07-12 08:29:32 UTC
Please reply to the questions in comment 1 and comment 6 so we can help out.
Thank you!
Comment 10 goofyseeker3 2023-07-12 08:37:31 UTC
I'm trying to help you to fix the bug. I'm fine thanks.
Comment 11 QA Administrators 2023-07-13 03:14:13 UTC Comment hidden (obsolete)
Comment 12 Stéphane Guillou (stragu) 2023-07-13 15:08:57 UTC
Hm I think I'll have a to close as "insufficient data" given it doesn't look like we'll get more data, unfortunately.
Comment 13 goofyseeker3 2023-07-13 15:17:18 UTC
There is still a bug mind you.
Comment 14 goofyseeker3 2023-07-13 15:18:30 UTC
sounds like you could not replicate the bug, to get more information.
Comment 15 goofyseeker3 2023-07-13 15:23:32 UTC
Sorry I did not bother to test if the bug is still there in the newest version.
Comment 16 goofyseeker3 2023-07-13 15:35:27 UTC
yes its still present in the newest version. log files follow later.
Comment 17 goofyseeker3 2023-07-13 15:37:08 UTC
VulkanDeviceName=NVIDIA GeForce RTX 3060
CPUModelName=AMD Ryzen 5 5600G with Radeon Graphics         
CPUFlags=sse3 pclmulqdq monitor ssse3 fma cpmxch16b sse41 sse42 movbe popcnt aes xsave osxsave avx f16c rdrand msr cx8 sep cmov clfsh mmx fxsr sse sse2 ht fsgsbase bmi1 avx2 bmi2 erms invpcid rdseed adx sha lahf abm sse4a syscall mmxext rdtscp
MemoryTotal=16119872 kB
Comment 18 goofyseeker3 2023-07-13 15:40:13 UTC
skia mode was(is currently on without even forcing.
Comment 19 goofyseeker3 2023-07-13 15:48:13 UTC
if you wonder how its not replicable, then currently is less than 1/20 chance it will hang-crash while dragging cell ranges down.
Comment 20 goofyseeker3 2023-07-13 15:48:56 UTC
to be exact, when scroll dragging cell ranges down.
Comment 21 goofyseeker3 2023-07-13 15:50:08 UTC
the scroll dragging cell ranges includes selecting datasets for graphs, not only scroll dragging expanding cell formulas.
Comment 22 goofyseeker3 2023-07-13 15:53:33 UTC
where is the logs (skia) located? not clear or easy to find by fast scrolling around (the bug).
Comment 23 goofyseeker3 2023-07-13 15:54:50 UTC

Graphics Backend used: skia
Passed Tests: 53
Quirky Tests: 51
Failed Tests: 0
Skipped Tests: 5
Comment 24 goofyseeker3 2023-07-13 15:59:31 UTC
current skia.log after restart in force skia (why does it wipe it):

RenderMethod: raster
Compiler: Clang
Comment 25 goofyseeker3 2023-07-13 16:11:31 UTC
seems like is more stable to this bug than, in which it occurred frequently, now it happens only infrequently (once every very long time).
Comment 26 goofyseeker3 2023-07-13 16:36:49 UTC
safe mode in the 4096 row 10 column formulate table is very slow
Comment 27 goofyseeker3 2023-07-13 16:40:39 UTC
safe mode is useless
Comment 28 goofyseeker3 2023-07-13 17:10:02 UTC
side scroll bar jams crashes the program app in version, not even when the drag cell expansion is happening.
Comment 29 goofyseeker3 2023-07-13 17:31:21 UTC
skia.log after the scroll crash:

RenderMethod: vulkan
Vendor: 0x10de
Device: 0x2503
API: 1.3.242
Driver: 536.160.0
DeviceType: discrete
DeviceName: NVIDIA GeForce RTX 3060
Denylisted: no
Comment 30 Stéphane Guillou (stragu) 2023-07-13 23:23:50 UTC
Thank you for the info.
I added some other reports using the same graphics card in "see also".

You being able to crash it using only the scrollbar confirms you are experiencing bug 149527, so I am marking as a duplicate.

Can you please confirm that LO does not crash when you have "Force Skia software rendering" on?

Julien, is it worth blacklisting this graphics card?

*** This bug has been marked as a duplicate of bug 149527 ***
Comment 31 goofyseeker3 2023-07-13 23:29:43 UTC
how about fixing the bug instead of black listing the most popular graphics card on steam? and I could not get it to crash with the forced software skia, but I cant confirm it, it might still crash with it, did not extensively repeat the test. and only tested the force software skia with not with, which crashes more often.
Comment 32 goofyseeker3 2023-07-13 23:52:06 UTC
it might be a separate bug, so that both the scroll and the cell expansion both separately trigger a crash
Comment 33 goofyseeker3 2023-07-14 00:17:52 UTC
I cant get the frequent crash in drag mode to replicate on after reinstall. does the reset of settings have some contribution of the operation?
Comment 34 Julien Nabet 2023-07-14 06:55:59 UTC
(In reply to Stéphane Guillou (stragu) from comment #30)
> ...
> Julien, is it worth blacklisting this graphics card?
Since the default will soon be the raster mode instead of Vulkan mode, I don't think it worths it.

Roman: put you in cc just in case.
Comment 35 Julien Nabet 2023-07-14 06:57:14 UTC
(In reply to goofyseeker3 from comment #31)
> how about fixing the bug instead of black listing the most popular graphics
> card on steam? and I could not get it to crash with the forced software
> skia, but I cant confirm it, it might still crash with it, did not
> extensively repeat the test. and only tested the force software skia with
> not with, which crashes more often.

Because there was only 1 person in LO devs who knew well Skia and we've got no info from him since more than 1 year.
Yes it's a pity and I had warned about this potential situation a long time ago.
Comment 36 goofyseeker3 2023-07-21 04:01:54 UTC
just a side note, dont know if its related, but chart graph crashed when trying to edit, nothing to do with scrolling or range dragging
Comment 37 goofyseeker3 2023-07-22 04:32:40 UTC
omg mouse wheel scrolling triggers also the scroll crash unresponsiveness, yep it goes into a deth spiral loop doing the scroll bug