Having finally fallen out of love with Microsoft apps I’m quickly making the transition Linux and especially to OnlyOffice. Being a bit of a data monkey I love that OnlyOffice is keeping up with the array formulas, and I suspect the LET function in Calc is likely to arrive shortly.
Anyway, my suggestion is for Calc formulas. I like to use multiple rows when writing longer, more complex formulas, treating the formula more like a traditional programming language. However, on finishing the formula, Calc strips away all carriage returns and space characters. Might Calc be able to retain a formula formatted like this?
=SUMIFS(
Sheet1!$E$1:$E$100,
Sheet1!$A$1:$A$100,“Country”,
Sheet1!$B$1:$B$100,“Latest”,
Sheet1!$C$1:$C$100,“Sales”
)-
SUMIFS(
Sheet1!$E$1:$E$100,
Sheet1!$A$1:$A$100,“Country”,
Sheet1!$B$1:$B$100,“Year Ago”,
Sheet1!$C$1:$C$100,“Sales”
)
Instead of reverting to this:
=SUMIFS(Sheet1!$E$1:$E$100,Sheet1!$A$1:$A$100,“Country”,Sheet1!$B$1:$B$100,“Latest”,Sheet1!$C$1:$C$100,“Sales”)-SUMIFS(Sheet1!$E$1:$E$100,Sheet1!$A$1:$A$100,“Country”,Sheet1!$B$1:$B$100,“Year Ago”,Sheet1!$C$1:$C$100,“Sales”)
I think it’s clear which is the easiest to read and edit.
Now, if you want to throw in some some color coding formats too, i.e. make all function names blue, etc., I’d be delighted 