Apache OpenOffice (AOO) Bugzilla – Issue 26787
Different colors for one cell in formula-string
Last modified: 2014-12-15 01:47:17 UTC
I have attached 2 screenshots. One of Calc and one of Excel of the same document. As you can see there, Calc does set different colors for the same cell in formula editing mode. But the corresponding cell can only have one color. (Calc sets the last color of the formula-string for the cell.) I call this a bug, because there are colors in the formula-string that no cell has. Excel correctly sets one color (blue) for the same cell (as you can see in the attached screenshot). Please handle this like Excel!
Created attachment 13968 [details] calc.png
Created attachment 13969 [details] excel.png
Hi Bettina, another enhancement for you. Frank
I see this issue is 18 months old :-( In the mean time it's been carried through to 2.0.0 (verified on linux and windows). I'd also consider it as a defect, not an enhancement. I find it terribly annoying when trying to understand formulas and the *same* cell reference is colored differently every time, completely confusing the user when looking for colored cells that don't exist. Please fix. Btw, OOo ROCKS and you guys are doing a GREAT job! I can't believe just how much OOo has grown up thanks to you...
please have a look at Issue 7320 also
*** Issue 58032 has been marked as a duplicate of this issue. ***
Whem moving such a colored frame of a referenced cell, Excel is intelligent enough to apply different color to the remaining references to the "old" cell directly after moving. This should not be forgotten when fixing this bug for OOo.
*** Issue 66578 has been marked as a duplicate of this issue. ***
*** Issue 92490 has been marked as a duplicate of this issue. ***
I would characterize this as a fairly big issue (and more than 4 years old) for a product that is already so polished and is about to go 3.0. Just my two cents. Keep up the good work.
"I would characterize this as a fairly big issue (and more than 4 years old) for a product that is already so polished and is about to go 3.0. Just my two cents." It's a pity that Sun, Novell and IBM don't work one one code base together. IBM has it's Lotuy Symphony and Novell it's fork Go-OO. On both forks you can see some improvements over Sun's OOo/SO. Well MS is surely happy about this situation that it's competitors are incapable of working together.
"one one"->"on one"
*** Issue 103466 has been marked as a duplicate of this issue. ***
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
I would not classify this as trivial.