https://bugs.documentfoundation.org/show_bug.cgi?id=92779
Bug ID: 92779
Summary: Converting to entire column is inconsistent (sometimes
works sometimes produces #REF!)
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]
---- Examples where bug disappears ----
Example A (bug disappears)
1. Open LibreOffice (LO) Calc
2. In cell A2 enter: =SUM(B$1:B$1048575)
3. Right click on row heading 4
4. Select 'Insert Rows Above'
5. Cell A2 correctly shows: =SUM(B:B)
6. Repeat steps 3-5 and LO Calc correctly shows formula in A2 as: =SUM(B:B)
Example B (bug disappears)
1. Open LibreOffice (LO) Calc
2. In cell A2 enter: =SUM(B$1:$B$1048575)
3. Right click on row heading 4
4. Select 'Insert Rows Above'
5. Cell A2 correctly shows: =SUM(B:$B)
6. Repeat steps 3-5 and LO Calc correctly shows formula in A2 as: =SUM(B:$B)
Example C (bug disappears)
1. Open LibreOffice (LO) Calc
2. In cell A2 enter: =SUM($B$1:B$1048575)
3. Right click on row heading 4
4. Select 'Insert Rows Above'
5. Cell A2 correctly shows: =SUM($B:B)
6. Repeat steps 3-5 and LO Calc correctly shows formula in A2 as: =SUM($B:B)
Example D (bug disappears)
1. Open LibreOffice (LO) Calc
2. In cell A2 enter: =SUM($B$1:$B$1048575)
3. Right click on row heading 4
4. Select 'Insert Rows Above'
5. Cell A2 correctly shows: =SUM($B:$B)
6. Repeat steps 3-5 and LO Calc correctly shows formula in A2 as: =SUM($B:$B)
---- Examples where bug appears ----
Example E (bug appears)
1. Open LibreOffice (LO) Calc
2. In cell A2 enter: =SUM(B1:B1048575)
3. Right click on row heading 4
4. Select 'Insert Rows Above'
5. Cell A2 incorrectly shows: =SUM(B1:B1048576)
Cell A2 should show: =SUM(B:B) {As shown in Example A, step 5}
6. Repeat steps 3-5 and LO Calc correctly shows formula in A2 as:
=SUM(B1:B#REF!)
Example F (bug appears)
1. Open LibreOffice (LO) Calc
2. In cell A2 enter: =SUM(B1:B$1048575)
3. Right click on row heading 4
4. Select 'Insert Rows Above'
5. Cell A2 incorrectly shows: =SUM(B1:B$1048576)
Cell A2 should show: =SUM(B:B) {As shown in Example A, step 5}
6. Repeat steps 3-5 and LO Calc correctly shows formula in A2 as:
=SUM(B1:B$#REF!)
Example G (bug appears)
1. Open LibreOffice (LO) Calc
2. In cell A2 enter: =SUM(B$1:B1048575)
3. Right click on row heading 4
4. Select 'Insert Rows Above'
5. Cell A2 incorrectly shows: =SUM(B$1:B1048576)
Cell A2 should show: =SUM(B:B) {As shown in Example A, step 5}
6. Repeat steps 3-5 and LO Calc correctly shows formula in A2 as:
=SUM(B$1:B#REF!)
Likewise converting to entire row is inconsistent (sometimes works sometimes
produces #REF!)
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
