Comment 0 for bug 262511
Revision history for this message
| John Pye (jdpipe) wrote Formula color-coding fails when multiple identical cell references | #0 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
bbfa235
(Get the code!)
Binary package hint: openoffice.org
In Calc in OpenOffice on Hardy, I have a problem when editing cells with formulae like this:
=IF(D13=
When I press 'F2' to see the color-coded form of this formula (with cells color-coded to indicate where different values are coming from), the first 'D13' in this formula comes up blue and the second 'D13' comes up red, even though they are the same cell. Then, the actual cell D13 is color-coded red as well, so there is no indication about what/where the blue cell should be.
This is clearly a simple implementation error where repeated cell references are not checked for.