Bug 147357

Summary:	Crash in: unsigned __int64 std::_Tree<std::_Tset_traits<ScFormulaCell ,std::less<ScFormulaCell >,std::allocator<ScFormulaCell >,0> >::erase(class ScFormulaCell & const)
Product:	LibreOffice	Reporter:	Colin <that.man.colin>
Component:	Writer	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	dgp-mail
Priority:	medium
Version:	7.2.5.2 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=146497
Whiteboard:
Crash report or crash signature:	["unsigned __int64 std::_Tree<std::_Tset_traits<ScFormulaCell ,std::less<ScFormulaCell >,std::allocator<ScFormulaCell >,0> >::erase(class ScFormulaCell & const)"]	Regression By:
Attachments:	The recovered file that crashed The odt containing the anticipated solution

Description Colin 2022-02-10 19:55:30 UTC

Created attachment 178200 [details]
The recovered file that crashed

This bug was filed from the crash reporting server and is br-0aa71643-cdc5-4364-9797-881bb6d4f93d.
=========================================
I had copied the original query from this forum 
https://www.excelforum.com/excel-formulas-and-functions/946108-frequency-with-subtotal-counting-only-filtered-numbers.html
 into a Writer document
and then copied haseeb's solution at #8
into the same document.
This was saved to disk.
I then opened a new calc document with the intention of copying a selection of numbers from an existing document to use as reference data.
I double-clicked my own source document and it "inserted" itself into the newly opened blank document so I simply opened another blank.
I then cut and pasted special, a column of 400 reference numbers into the defined source cell location in the originator's question and deleted the surplus values exceeding the originator's cell count.
I then moved the resulting array up to M2
As I was only interested in 3 SUBTOTAL(FREQUENCY()) interpolations I simply inserted 9 empty rows at the beginning of the sheet to provide me with some "working space" and then put a header and autofilter into the cell directly above the reference data - now M10.
I formulated my own particular three required FREQUENCY() cells above and to the right of the autofilter array.
I then went into the writer document and selected the proposed formula with the intention of copying it into the first formula cell and modifying it to suit my own anticipated range variation.
The moment I selected the source text AND HERE I'M NOT SURE IF I HAD ACTUALLY PRESSED [CTRL+C] to copy the source - it crashed.
At this point TASK MANAGER confirms Libre is running and it's the currently open crash report window.
Upon closing that pane I am now presented with the document recovery pane for the two files.
It claims to have succeeded and I'm now selecting Finish
Both documents are intact and will be attached.
My intention was to paste the "solution" to R3, hopefully modify it, and apply it as an array function to Q3:Q5

Comment 1 Colin 2022-02-10 19:57:51 UTC

Created attachment 178201 [details]
The odt containing the anticipated solution

The crash occurred during the copy process from this odt - I had not focused the ods which is the implied crash document

Comment 2 Dieter 2022-02-24 14:02:05 UTC

Colin, thank you for reporting the bug. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version. Please also copy and paste informations from Help -> About LibreOffice. Please change to RESOLVED WORKSFORME, if the problem went away.

Comment 3 Colin 2022-02-24 14:22:04 UTC

(In reply to Dieter from comment #2)
> Colin, thank you for reporting the bug. Could you please try to reproduce it
> with the latest version of LibreOffice from
> https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the
> bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the
> bug is still present in the latest version. Please also copy and paste
> informations from Help -> About LibreOffice. Please change to RESOLVED
> WORKSFORME, if the problem went away.

I abandoned the effort.
I realise now that the Excel delimiters in the example I found on the net are not compatible with my local delimiters and there's a good chance that was a contributor to the issue.
What is of concern - possibly even sinister - is that LO crashes but still claims to be active in task manager. That's a recurrent theme through all the crashes that have been processed by the crash reporting module. That's probably impossible to specify/repeat as it's unknown whether LO would properly unload if I didn't allow the crash report. Proverbial rock and a hard place - would it have unloaded if I had opted for a different course of action.

I shall change the status as I no longer propose to adapt the solution to my environment.