2008-08-29 06:55:58 |
John Pye |
bug |
|
|
added bug |
2008-10-19 23:12:32 |
Chris Cheney |
openoffice.org: status |
New |
Incomplete |
|
2008-10-19 23:12:32 |
Chris Cheney |
openoffice.org: statusexplanation |
|
Please attach an example document exhibiting this problem. |
|
2008-11-17 18:40:17 |
Chris Cheney |
openoffice.org: status |
Incomplete |
Triaged |
|
2008-11-17 18:40:17 |
Chris Cheney |
openoffice.org: importance |
Undecided |
Low |
|
2008-11-17 18:40:17 |
Chris Cheney |
openoffice.org: statusexplanation |
Please attach an example document exhibiting this problem. |
Verified on upstream's openoffice.org 3.0.0. |
|
2008-11-17 18:41:03 |
Chris Cheney |
bug |
|
|
assigned to openoffice |
2009-03-04 10:17:09 |
GercoKees |
openoffice: status |
New |
Unknown |
|
2009-03-04 10:17:09 |
GercoKees |
openoffice: importance |
Undecided |
Unknown |
|
2009-03-04 10:17:09 |
GercoKees |
openoffice: statusexplanation |
|
|
|
2009-03-04 10:17:43 |
GercoKees |
title |
Formula color-coding fails when multiple identical cell references |
[upstream] Formula color-coding fails when multiple identical cell references |
|
2009-03-04 10:27:37 |
Bug Watch Updater |
openoffice: status |
Unknown |
Confirmed |
|
2011-09-15 14:18:13 |
Björn Michaelsen |
openoffice.org (Ubuntu): status |
Triaged |
Won't Fix |
|
2011-09-16 04:53:10 |
GercoKees |
bug task added |
|
libreoffice (Ubuntu) |
|
2011-09-18 15:07:49 |
penalvch |
summary |
[upstream] Formula color-coding fails when multiple identical cell references |
Formula color-coding fails when multiple identical cell references |
|
2011-10-24 23:46:04 |
John Pye |
attachment added |
|
highlighting.png https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/262511/+attachment/2570972/+files/highlighting.png |
|
2011-10-24 23:46:47 |
John Pye |
libreoffice (Ubuntu): status |
New |
Confirmed |
|
2011-11-25 20:49:07 |
penalvch |
attachment added |
|
excel-screenshot.png https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/262511/+attachment/2608715/+files/excel-screenshot.png |
|
2011-11-25 20:53:45 |
penalvch |
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. |
Binary package hint: openoffice.org
1) lsb_release -rd
Description: Ubuntu 11.10
Release: 11.10
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:3.4.4-0ubuntu1
Candidate: 1:3.4.4-0ubuntu1
Version table:
*** 1:3.4.4-0ubuntu1 0
500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages
100 /var/lib/dpkg/status
1:3.4.3-3ubuntu2 0
500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages
3) What is expected to happen in LibreOffice Calc is in a blank document if one places in D7:
=IF(D13=0;1;EXP(-delta^D13))
only the first D13 left to right is highlighted, while the second D13 is either the same color or not highlighted at all as in Excel screenshot https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/262511/+attachment/2608715/+files/excel-screenshot.png .
4) What happens instead is the first D13 is blue while the second is red as shown in the screenshot https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/262511/+attachment/2570972/+files/highlighting.png . |
|
2011-11-25 20:54:00 |
penalvch |
libreoffice (Ubuntu): importance |
Undecided |
Low |
|
2011-11-25 20:54:00 |
penalvch |
libreoffice (Ubuntu): status |
Confirmed |
Triaged |
|
2011-11-25 20:54:17 |
penalvch |
bug task added |
|
df-libreoffice |
|
2011-11-25 20:54:52 |
penalvch |
df-libreoffice: status |
New |
Incomplete |
|
2012-04-15 02:30:39 |
penalvch |
tags |
migrateoootolo |
i386 migrateoootolo oneiric |
|
2012-04-15 02:35:24 |
penalvch |
summary |
Formula color-coding fails when multiple identical cell references |
Formula color-coding inconsistent with multiple identical cell references |
|
2012-04-15 02:39:39 |
penalvch |
bug watch added |
|
https://bugs.freedesktop.org/show_bug.cgi?id=48719 |
|
2012-04-15 02:39:39 |
penalvch |
df-libreoffice: importance |
Undecided |
Unknown |
|
2012-04-15 02:39:39 |
penalvch |
df-libreoffice: status |
Incomplete |
Unknown |
|
2012-04-15 02:39:39 |
penalvch |
df-libreoffice: remote watch |
|
freedesktop.org Bugzilla #48719 |
|
2012-04-15 02:39:52 |
penalvch |
summary |
Formula color-coding inconsistent with multiple identical cell references |
[Upstream] Formula color-coding inconsistent with multiple identical cell references |
|
2014-10-31 19:12:49 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
Confirmed |
|
2014-10-31 19:12:49 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
Low |
|
2016-01-24 02:37:38 |
penalvch |
libreoffice (Ubuntu): status |
Triaged |
Fix Released |
|