https://bugs.documentfoundation.org/show_bug.cgi?id=165255

--- Comment #11 from Colin <[email protected]> ---
@BogdanB

A Eureka moment: Perhaps you can help define whether it is a bug or just an
exception that will never be addressed.

The short version, I conducted numerous experiments and generated the following
auto-reports:-

https://crashreport.libreoffice.org/stats/crash_details/6337dd57-02fb-420a-9779-47f2263f5ec3

https://crashreport.libreoffice.org/stats/crash_details/320d446d-6376-4476-b86b-bf4bc00ef8e5

https://crashreport.libreoffice.org/stats/crash_details/276e3a63-2890-46c9-9561-1f7683149ed1

https://crashreport.libreoffice.org/stats/crash_details/5905d7d6-fb30-42f7-b4d1-5b96df9c7748

I have just realised that one of my actions on the day the fault manifested was
to insert a cell in 1 column of a 4 column filtered array on another less
frequently utilised sheet in the workbook. I immediately realised it would
"unsync" that array - so I inserted three more cells in their appropriate
locations to re-balance the array. I don't recall whether this was an immediate
remediation or whether I realised a few moments later and went back to rectify
it.

Today's experiments prompted me to remember that event so I have simply used
the filter to sort the array and the problem has been expunged.

Had I added the entry to the bottom and re-sorted the array it would probably
never have manifested itself.

That does indicate that there is a problem when a user inserts elements into
the middle of an array rather than adding them to the bottom of the array and
using the "sort" in the filter context pane to correctly place them. It's also
uncertain whether the act of inserting one cell first rather than all cells on
that row as opposed to inserting an entire row instead of appending and sorting
is the culprit.

This is where you earn your money and make the appropriate assessment :)

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to