I’m having trouble with array formula, it shouldn’t duplicate but it does. Is this not a bug?
array_form.ods (11.8 KB)
Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 2; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
25.2.3-2
Calc: threaded
sort of feature 
with a single value return, it gets iterated over the output array, which is not dynamiccaly adjusted.
e.g. {=MAX(A2:A5)} or {=1}
not fully documented though
→ Array Functions # Adjusting an Array Range
Is there any way to not happen without manually adjusting?
plenties 
would depend of your actual use case :
This looks even better in combination with SORT().
See tdf#163592, tdf#166042
Bug #163592 is marked RESOLVED FIXED (for 24.8.6 and higher.
The other bug seems to be the one bothering you. It is still marlked UNCONFIRMED.
=== ===
The result, imo, isn’t a dupliocation, but an output to every position in the previously locked output range.
Users seem to expect a solution by implementation of “Dynamic Arrays” as Excel is told to support. I can’t check because I have no access to Excel.
See tdf#127808
For my personal use I have a solution based on a package of Basic routines (BSM). There are unavoidable disadvantages, of course.
Ahh, I’m drawing a blank on this one. I was using FILTER() because it can ignore columns, fetch N of first/last rows and handle multi-dimensional criteria, but I didn’t know it handles single value differently. 
OnlyOffice handles it the same as LO
