** Summary changed: - [upstream] Formula color-coding fails when multiple identical cell references + Formula color-coding fails when multiple identical cell references
-- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/262511 Title: Formula color-coding fails when multiple identical cell references Status in The OpenOffice.org Suite: Confirmed Status in “libreoffice” package in Ubuntu: New Status in “openoffice.org” package in Ubuntu: Won't Fix Bug description: Binary package hint: openoffice.org In Calc in OpenOffice on Hardy, I have a problem when editing cells with formulae like this: =IF(D13=0;1;EXP(-delta^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. To manage notifications about this bug go to: https://bugs.launchpad.net/openoffice/+bug/262511/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
