I have an .ods file of ~1MB, ~50 sheets. Recently with LO6.2 I noticed that two different sheets containing array functions that reference a same third sheet were showing incorrect values.
I upgraded to LO6.3 and the same problem was present.
I figured out that the curly braces were missing from the formulas in both sheets, i.e. the array formulas had reverted to standard formulas. There were other array formulas in the doc that where still correct but they didn’t reference the same sheet as the ones that had broken.
^^ “Scores” sheet. (Contains date sorted list of Players and Tags; where Tags my be reassigned on subsequent dates)
Formula in Sheet1 to get most recent “Tag” number given Player in B2
Formula in Sheet2 to get most recent “Player” given Tag number in M2
I had been editing the Scores sheet to move a bunch of rows around by inserting blank rows, then cutting/pasting rows to move them. All this was within the range of rows 1:437. I’m 99% sure that’s what broke the array formulas and reverted them back to standard formulas.
I say “99%” because I fixed the array formulas, did some more moving rows editing in Scores and the Sheet1 formulas broke again. Interestingly, this time the Sheet2 formulas did not break.
The problem is that I can’t seem to make a reproducible test case for this.
I’ve been using this doc in OpenOffice and LibreOffice for going on six years now and never noticed this problem until this week.
First question: am I doing something wrong?
Second question: any suggestions on how to get a reproducible test case to submit a bug?