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.
Dear Aldelge, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug