To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109178 Issue #|109178 Summary|formulae comparison Component|Spreadsheet Version|current Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|ooecsslc8356
------- Additional comments from [email protected] Fri Feb 12 00:28:04 +0000 2010 ------- 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 : --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
