Essentially, I have two sequences of numbers in Row 2 and Row 3, and I want to produce a sequence of numbers in Row 4 such that:
A4 = A2A3
B4 = A2B3 + B2A3
C4 = A2C3 + B2B3 + C2A3
D4 = A2D3 + B2C3 + C2B3 + D2A3
(This is the Cauchy product for the mathematically minded)
I want to use the function SUMPRODUCT which will greatly simplify the formulas, but I need some way to get the reverse of Row 2 or Row 3 as an array. Is there some function or extension that I am missing? Or is this simply not possible in LibreOffice Calc?