Bug 106346 - Crash in: ScPoolHelper::GetFormTable()
Summary: Crash in: ScPoolHelper::GetFormTable()
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.5.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Crash
  Show dependency treegraph
 
Reported: 2017-03-05 22:30 UTC by Fred
Modified: 2020-05-17 09:28 UTC (History)
3 users (show)

See Also:
Crash report or crash signature: ["ScPoolHelper::GetFormTable()"]


Attachments
Trying to change the background by value (19.07 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-03-06 02:11 UTC, Fred
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Fred 2017-03-05 22:30:38 UTC
This bug was filed from the crash reporting server and is br-768d2797-306c-4816-a048-69e9eff6f7af.
=========================================
EDITING

Version: 5.2.5.1
Build ID: 0312e1a284a7d50ca85a365c316c7abbf20a4d22
CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; 
Locale: en-US (en_US); Calc: group

I was "practicing" conditional formatting, using paste special to copy conditionally formatted from one column to another (with values entered) when the crash occurred. An example of what I was doing:   
Column B
Row 6:  3.25

Row 8:  4.50

Row 10: 3.00
Row 11: 4.00
Row 12: 5.00

The conditional formatting for B10:B25 is:
C 1: Cell Value is equal to "" Apply Style Default.
C 2: Cell Value greater than $Sheet3.$B$8 Apply Style "HighBG" (red background).
C 3: Cell Value less than $Sheet3.$B$6 Apply Style "LowBG" (yellow background).

I copied (Paste special - format only) B10 to D10, then used manage to edit (the "high" and "low" value cell reference and verify /change the range. I did this several times (different target ranges) before the crash.

I hope this helps you
-- Fred
Comment 1 Xisco Faulí 2017-03-05 22:37:35 UTC Comment hidden (obsolete)
Comment 2 Fred 2017-03-06 02:11:37 UTC
Created attachment 131664 [details]
Trying to change the background by value
Comment 3 Xisco Faulí 2017-03-06 09:05:50 UTC
Hello Fred,
So, once I open the attached document, which are the steps I have to follow in order to reproduce the crash?
On the other hand, have you tried with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
Comment 4 Fred 2017-03-06 16:25:59 UTC
Hi,
I hoped the what I wrote when the crash reporter was clear. I guess not. 
It only failed once, and I sent the "dump" as requested.
My testing went something like this:

With cell B10 selected:
[Format][Conditional Formatting][Conditions]
make condition 1 say
~~~ Cell value is equal to "" Apply Style Default
[Add]
Make Condition 2 say 
~~~ Cell value is less than $Sheet3.$B$6 Apply Style LowBG
[Add]
Make Condition 3 say
~~~ Cell value is greater than $Sheet3.$B$8 Apply Style HighBG 

then change Cell Range (on the bottom) to B10:B25
click [OK]

Now [Ctrl][C] to copy
select cell D10
then [Edit][Paste Special]
 ~~~ verify that Only Formats is checked ~~~
[OK]
Now fix the formatting for Column D so everything refers to column D:
With cell D10 selected:
[Format][Conditional Formatting][Manage]
Select D10 from the list
[Edit]
change conditions 2 and 3 from $Sheet3.$B$? to $Sheet3.$D$?
Change the range to D10:D25

   Repeat for other columns
I hope that this helps.
-- Fred
Comment 5 Xisco Faulí 2017-03-08 09:41:43 UTC
Hello,

I can't reproduce it in

Versión: 5.3.1.1
Id. de compilación: 72fee18f394a980128dc111963f2eefb05998eeb
Subpr. de CPU: 1; SO: Windows 6.1; Repr. de IU: predet.; Motor de trazado: HarfBuzz; 
Configuración regional: es-ES (es_ES); Calc: group

following the steps provided.

were you be able to reproduce it again?
Comment 6 QA Administrators 2017-09-29 08:58:18 UTC Comment hidden (obsolete)
Comment 7 Xisco Faulí 2017-10-30 10:52:15 UTC Comment hidden (obsolete)
Comment 8 m_a_riosv 2018-11-08 12:08:39 UTC
crashreport.libreoffice.org/stats/crash_details/06cf8af2-b76a-464d-914f-efc77c89af9a

Accessing Menu/Format/Print ranges/Define
Comment 9 Xisco Faulí 2018-11-08 12:20:36 UTC
(In reply to m.a.riosv from comment #8)
> crashreport.libreoffice.org/stats/crash_details/06cf8af2-b76a-464d-914f-
> efc77c89af9a
> 
> Accessing Menu/Format/Print ranges/Define

No crash here.
Could you please give more info? do you reproduce it with the file attached? do you reproduce it with another document? where is the cursor placed when you go to Menu - Format- etc ?
Comment 10 Fred 2018-11-08 16:33:44 UTC
This is old enough that it may be ignored. My reporting was because of 
the automatic prompt asking to report the failure.

-- Fred
Comment 11 m_a_riosv 2018-11-08 18:47:47 UTC
It's hard because it is not always reproducible.

With 6.1 I have has several crash without any notice and without report, even a lost of the whole profile. But it's in an environment with several files opened and a lot of links between files.

Always with calc.
Version: 6.1.3.2 (x64)
Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: es-ES (es_ES); Calc: CL
Comment 12 Xisco Faulí 2018-11-09 15:12:10 UTC
Hi m.a.riosv,
it would be nice if you could find a reliable way to reproduce it...
Comment 13 m_a_riosv 2018-11-09 15:41:17 UTC
Sure if was possible, but can't be.

I have renable OpenGL and let's see, I'm not absolutely sure it's only a LO issue, specially with an Intel graphics card.

It's specially annoying the program quit's with any notice, or the other they awaiting to finish what should be a save the files with the crash, but never ended.
Comment 14 Xisco Faulí 2018-12-21 16:09:42 UTC
(In reply to m.a.riosv from comment #8)
> crashreport.libreoffice.org/stats/crash_details/06cf8af2-b76a-464d-914f-
> efc77c89af9a
> 
> Accessing Menu/Format/Print ranges/Define

Hello, Miguel Angel,
Since your problem is realted to print ranges, I think it's the same as bug 121439
Comment 15 Julien Nabet 2020-05-16 21:38:46 UTC
Any update with 6.4.3?
Indeed, when going to summary tab of https://crashreport.libreoffice.org/stats/signature/ScPoolHelper::GetFormTable(), there are very few crashes referenced with 6.4.X in comparison with versions from 6.2.X for example.
Comment 16 m_a_riosv 2020-05-16 22:23:19 UTC
i think I didn't see it time ago, but what is there some times, is a crash without report or with a blank crash report.
Comment 17 Julien Nabet 2020-05-17 09:28:07 UTC
Thank you Miguel for your feedback.
About blank report, we don't know if it's related.

Let's put this one to WFM then.

If someone reproduces this with recent LO version (6.4.3), don't hesitate to reopen this tracker.