To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92490 Issue #|92490 Summary|In formulas, cells that are referenced more than once |will be assigned more than one colour Component|Spreadsheet Version|OOo 3.0 Beta 2 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|vrrp
------- Additional comments from [EMAIL PROTECTED] Tue Aug 5 16:39:19 +0000 2008 ------- In Calc, whenever you use a formula that references a given cell more than once, the cell colour is not remembered. Steps: Write the value "1" in cells A1 and A2. Create a formula in cell A3 that reads "=A1+A2+A2". Select cell A3, then click on the box where you normally input the text. The formula will expand on the cell, showing each cell reference, e.g. A1, in a different colour, that is accompanied by a rectangle highlighting that cell in the same colour. You will notice that A1 will be highlighted blue, A2 in magenta, but the cell references on the A3 cell will be in blue, red and magenta respectively. Calc should check whether a given cell has already been highlighted in the current formula, before using a new colour to highlight it (thus causing the red highlight to be overwritten by the magenta one). This issue has been around since I can remember (at least since 2.0). This makes it extremely difficult to debug complicated formulas, as you have tons of colours that are not used and that do not correspond to any highlighted cell, and conversely you can't "see" how many times and where a given cell of a given colour is referenced in the formula (since every time it appears it's in a different colour). I can attach (can't figure out how) a very simple .ods file with the steps above, and a small png picture with a much more complicated formula, which makes the problem very clear, in case people consider it worthy. Thank you. --------------------------------------------------------------------- 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]
