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.
Created attachment 182856 [details] sample ods file with evidence for the problem
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.
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?
(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?
>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.