Bug 147357 - Crash in: unsigned __int64 std::_Tree<std::_Tset_traits<ScFormulaCell *,std::less<ScFormulaCell *>,std::allocator<ScFormulaCell *>,0> >::erase(class ScFormulaCell * & const)
Summary: Crash in: unsigned __int64 std::_Tree<std::_Tset_traits<ScFormulaCell *,std::...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
7.2.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-10 19:55 UTC by Colin
Modified: 2023-11-23 22:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature: ["unsigned __int64 std::_Tree<std::_Tset_traits<ScFormulaCell *,std::less<ScFormulaCell *>,std::allocator<ScFormulaCell *>,0> >::erase(class ScFormulaCell * & const)"]

Attachments
The recovered file that crashed (11.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-02-10 19:55 UTC, Colin 		Details
The odt containing the anticipated solution (12.85 KB, application/vnd.oasis.opendocument.text)
2022-02-10 19:57 UTC, Colin 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.