Issue 109178 - Add a Dialog (or similar) for Formulae display, comparison and editing of selected formulae
Summary: Add a Dialog (or similar) for Formulae display, comparison and editing of sel...
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: recent-trunk
Hardware: All All
: P5 (lowest) Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-02-12 00:28 UTC by ooecsslc8356
Modified: 2017-05-20 09:56 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description ooecsslc8356 2010-02-12 00:28:04 UTC
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?



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  :
Comment 1 Rainer Bielefeld 2013-06-06 05:05:52 UTC
I think I understand what reporter wants. He needs a dialog containing several Input Lines anchored to user selected cells so that he can observe, compare, edit the formulas 

But that would be some really difficult and expensive work. And the workaround to compare formulas using '=Formula(sheet.cell)', what shows a formula as a string, is not so bad, only the possibility to edit directly in the shown Formula string is missing. 

So I think a cost-benefit calculation might lead to the decision not to proceed this one, P5 for now
Comment 2 Edwin Sharp 2014-01-13 17:21:12 UTC
Moved to: