Suggested Formula comparison feature for OpenOffice Calc:

Some spreadsheets require formulae in adjacent cells to be structured nearly 
identically but with subtle differences. In checking those formulae, 
especially when they are long and complex, it would really be handy to list 
them one above the other so their structure differences could be easily 
spotted. The only way I know to do this now is to copy/paste each formula into 
a separate text editor and make the comparison there. Then go back to Calc to 
edit them individually. 

What I propose is a Calc command that would display all the formulae in a 
selected row of cells or column of cells in a single separate window. They 
would be listed one above the other, whether from a row or from a column, in 
the same order they existed in the selected cells. And, each row in the window 
would identify that formula's cell address. I further propose that any formula 
could be edited right in this window without losing sight of the other 
formulae. Calc would also need a command to close the window and return to 
normal after any editing was completed.

Calc is especially good at preventing one from seeing two formulae at the same 
time for comparison purposes. I have even opened a second Calc on a copy of 
the file I am editing with the hope that a formula in that copy of Calc would 
be displayed so that I could compare it to a formula in an adjacent cell 
address in the first Calc. But, to no avail. Between these two copies of Calc, 
only one formula is shown because only the active Calc shows a formula in the 
edit window.  

I know you can have Calc show all the formulas, but if those formulas are long 
and in a row (as opposed to a column), you soon run out of screen width when 
you go through the laborious task of expanding the column widths to show the 
formulas entirely. 

Can you spot the inconsistency in these two examples?

=IF(F215>$Tx.$C5;IF(F215<$Tx.$C6;ROUND((F215-$Tx.$C5)*$Tx.$B6;2);$Tx.$D7-
$Tx.$D6))
=IF(F215>$Tx.$C6;IF(F215<$Tx,$C7;ROUND((F215-$Tx.$C6)*$Tx.$B7;2);$Tx.$D8-
$Tx.$D7))
=IF(F215>$Tx.$C7;IF(F215<$Tx.$C8;ROUND((F215-$Tx.$C7)*$Tx.$B8;2);$Tx.$D9-
$Tx.$D8))

=IF(E215>$Tx.$C7;IF(E215<$Tx.$C8;ROUND((E215-$Tx.$C7)*$Tx.$B8;2);$Tx.$D9-
$Tx.$D8))
=IF(F215>$Tx.$C7;IF(F215<$Tx.$C8;ROUND((E215-$Tx.$C7)*$Tx.$B8:2);$Tx.$D9-
$Tx.$D8))
=IF(G215>$Tx.$C7;IF(G215<$Tx.$C8;ROUND((G215-$Tx.$C7)*$Tx.$B8;2);$Tx.$D9-
$Tx.$D8))

Errors are in the middle line of each set. 

In the first set check the punctuation after the 2nd $Tx where a  ,  appears 
that should be a  period.

In the second set, note that E215 appears near the middle of line, it should 
be F215. And the punctuation after $B8 should be  ;  not  :