Bug 90668 - EDITING: No color border when reference more than 31 cells
Summary: EDITING: No color border when reference more than 31 cells
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-04-17 02:40 UTC by yanjingtao
Modified: 2016-09-15 19:07 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc_No_Border (33.29 KB, image/png)
2015-04-17 02:40 UTC, yanjingtao
Details
demo (8.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-04-17 02:43 UTC, yanjingtao
Details

Note You need to log in before you can comment on or make changes to this bug.
Description yanjingtao 2015-04-17 02:40:19 UTC
Created attachment 114846 [details]
Calc_No_Border

When I edit a cell reference more than 31 cells, the cells later than 31 do not have color border.

Step:
1. Input something in A1 to A40
2. Input this in C27 and press Enter: =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10+A11+A11+A12+A13+A14+A15+A16+A17+A18+A19+A20+A21+A22+A23+A24+A25+A26+A27+A28+A29+A30+A31+A32+A33+A34+A35+A36+A37+A38+A39+A40
3. Double click C27

You can see in Cell A1 to A31, they have color border, in Cell A32 to A40, they don't have any border.

Maybe color is not enough, but maybe it can show black border?
Comment 1 yanjingtao 2015-04-17 02:43:43 UTC
Created attachment 114847 [details]
demo
Comment 2 raal 2015-04-17 09:55:43 UTC
I can confirm with LO 4.4.2.2, win7
Comment 3 Roeland 2016-09-15 19:07:35 UTC
I just tested this with 5.2.1. I can't reproduce the problem. I also remember reading something about improvements to the way formulas refer to cells, but I can't remember where exactly (maybe the release notes).


Setting this as resolved worksforme.