https://bugs.documentfoundation.org/show_bug.cgi?id=92759
Bug ID: 92759
Summary: #REF! when inserting rows or columns which exceeds max
row and max column in formulae range
Product: LibreOffice
Version: 5.0.0.3 rc
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Version: 5.0.0.3 (x64)
Build ID: f79b5ba13f5e6cbad23f8038060e556217e66632
1. Open LibreOffice Calc
2. In cell A2 enter: =SUM($B2:B1048573)
3. Select rows 4 to 14
4. Right click on any row heading from 4 to 14
5. Insert Rows Above
6. Formula in cell A2 shows: =SUM($B2:B#REF!)
Expected formula in cell A2: =SUM($B2:B1048576)
Unfortunately, bug also occurs when entering columns which exceed column limit.
May relate to bug 92751
Thank you
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
