Bug 151373 - EDITING: Coloured borders of referenced cells missing when more than 128 references in formula expression
Summary: EDITING: Coloured borders of referenced cells missing when more than 128 refe...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3 all versions
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Border
  Show dependency treegraph
 
Reported: 2022-10-06 10:14 UTC by Aldelge
Modified: 2023-08-19 14:13 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
sample ods file with evidence for the problem (13.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-10-06 10:17 UTC, Aldelge
Details
Formula in A152 without skipping rows (9.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-10-07 19:46 UTC, LeroyG
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Aldelge 2022-10-06 10:14:35 UTC
Description:
borders at end of list of selected cells than +/-123  of selected cells

Steps to Reproduce:
1.create file with following cells
1	1
2	1
3	1
4	1
5	1
6	1
7	1
8	1
9	1
10	1
11	1
12	1
13	1
14	1
15	1
16	1
17	1
18	1
19	1
20	1
21	1
22	1
23	1
24	1
25	1
26	1
27	1
28	1
29	1
30	1
31	1
32	1
33	1
34	1
35	1
36	1
37	1
38	1
39	1
40	1
41	1
42	1
43	1
44	1
45	1
46	1
47	1
48	1
49	1
50	1
51	1
52	1
53	1
54	1
55	1
56	1
57	1
58	1
59	1
60	1
61	1
62	1
63	1
64	1
65	1
66	1
67	1
68	1
69	1
70	1
71	1
72	1
73	1
74	1
75	1
76	1
77	1
78	1
79	1
80	1
81	1
82	1
83	1
84	1
85	1
86	1
87	1
88	1
89	1
90	1
91	1
92	1
93	1
94	1
95	1
96	1
97	1
98	1
99	1
100	1
101	1
102	1
103	1
104	1
105	1
106	1
107	1
108	1
109	1
110	1
111	1
112	1
113	1
114	1
115	1
116	1
117	1
118	1
119	1
120	1
121	1
122	1
123	1
124	1
125	1
126	1
127	1
128	1
129	1
130	1
131	1
132	1
133	1
134	1
135	1
136	1
137	1
138	1
139	1
140	1
141	1
142	1
143	1
144	1
145	1
146	1
147	1
148	1
149	1
150	1
	150 (=SOMME(B1:B150))
	150 (=B1+B2+B4+B6+B8+B10+B12+B14+B16+B18+B20+B22+B24+B26+B28+B30+B32+B34+B36+B38+B40+B42+B44+B46+B48+B50+B52+B54+B56+B58+B60+B62+B64+B66+B68+B70+B72+B74+B76+B78+B80+B82+B84+B86+B88+B90+B92+B94+B96+B98+B100+B102+B104+B106+B108+B110+B112+B114+B116+B118+B120+B122+B124+B126+B128+B130+B132+B134+B136+B138+B140+B142+B144+B146+B148+B150+B3+B5+B7+B9+B11+B13+B15+B17+B19+B21+B23+B25+B27+B29+B31+B33+B35+B37+B39+B41+B43+B45+B47+B49+B51+B53+B55+B57+B59+B61+B63+B65+B67+B69+B71+B73+B75+B77+B79+B81+B83+B85+B87+B89+B91+B93+B95+B97+B99+B101+B103+B105+B107+B109+B111+B113+B115+B117+B119+B121+B123+B125+B127+B129+B131+B133+B135+B137+B139+B141+B143+B145+B147+B149

2.select cell b152 (last one) and click anywhere in the input area at top of screen
3.

Actual Results:
all cells in list should be marked as selected (colored borders) but the 22 last ones are not 

Expected Results:
ALL cells in list should be marked as selected (colored borders)


Reproducible: Always


User Profile Reset: No



Additional Info:
I saw it in the last version 7.3.6.2 and also in the previous 7.3.5.2 when I installed it back. It probably should have occurred before but I just recently got a list with so many items.
Comment 1 Aldelge 2022-10-06 10:17:39 UTC
Created attachment 182856 [details]
sample ods file with evidence for the problem
Comment 2 Eike Rathke 2022-10-06 11:23:01 UTC
Known limitation (btw it's 128) that is intended because colouring too many referenced cells slows things down. Previously it was 64 (bug 105622) and before that 32 (bug 65206).

I tend to not increase this any more.
Comment 3 LeroyG 2022-10-07 19:46:47 UTC
Created attachment 182909 [details]
Formula in A152 without skipping rows

Which color do not help much, since there are only eight colors.
But I think that it helps to see which cells are included (or not) in the formula.

However, how frequent is to have a formula with more than 128 references?
Comment 4 LeroyG 2022-10-07 19:49:02 UTC
(In reply to Eike Rathke from comment #2)
> […] colouring too many referenced cells slows things down

Why if since the 9th reference only default cell selection color is applied?
Comment 5 Aldelge 2022-10-08 07:07:11 UTC
>it helps to see which cells are included (or not)

I use it to see if I forgot some cells, comparing 2 totals, and to help me find out which ones. The color has no importance for me.

>how frequent is to have a formula with more than 128 references?

It just happened to me now, I never expected to reach so much elements, but it will not decrease now.
I'll have to find another method :-((
I think now that I never would go higher than  let's say, 150, but you never know.