Issue 38085 - With longer formulas cell coloring of source cells does not work.
Summary: With longer formulas cell coloring of source cells does not work.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 1.1.3
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 100263 107926 115450 (view as issue list)
Depends on:
Blocks:
 
Reported: 2004-11-29 15:27 UTC by gorn
Modified: 2020-02-09 13:21 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.7
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description gorn 2004-11-29 15:27:28 UTC 
With longer formulas cell coloring of source cells does not work.

to recreate

1. Open new Spreadsheet
2. ckick on some cell (D34 for example)
3. copy the following formula into it:
=-(B1*D3*Y7+B2*E3*Y8+B3*F3*Y9+B4*G3*Y10+B5*H3*Y11+B6*I3*Y12+B7*J3*Y13+B8*K3*Y14+B9*L3*Y15+B10*M3*Y16+B11*N3*Y17+B12*O3*Y18+B13*P3*Y19+B14*Q3*Y20)
4. press F2
5. some of the cells and references in the formula are NOT colored (for example P3).
Comment 1 frank 2004-12-07 16:20:59 UTC 
Hi,

currently we are limited to 32 references to be colored. So not a bug but an
enhancement.

Frank
Comment 2 Regina Henschel 2009-12-27 18:56:23 UTC 
*** Issue 107926 has been marked as a duplicate of this issue. ***
Comment 3 Regina Henschel 2009-12-28 18:00:45 UTC 
*** Issue 107926 has been marked as a duplicate of this issue. ***
Comment 4 bettina.haberer 2010-05-21 14:55:36 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".
Comment 5 Regina Henschel 2010-11-07 22:10:24 UTC 
*** Issue 115450 has been marked as a duplicate of this issue. ***
Comment 6 oooforum (fr) 2020-02-09 12:58:02 UTC 
Still reproduced with 4.1.7
Comment 7 oooforum (fr) 2020-02-09 13:21:25 UTC 
*** Issue 100263 has been marked as a duplicate of this issue. ***