https://bugs.documentfoundation.org/show_bug.cgi?id=92468
Bug ID: 92468
Summary: Circular reference in formulae containing entire
column/row notation A:A/1:1
Product: LibreOffice
Version: 5.1.0.0.alpha0+ Master
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Thank you Eike Rathke for enabling cell highlighting and formula colors for
entire column(s)/row(s) notation. It made it easier to find the bug below.
1. In cell C7 enter: 1
2. In cell A1 enter: =SUM(B:$C)
3. Press Enter
4. Click on cell A1
5. Ctrl+C (copy)
6. Highlight cells B1:E1
7. Ctrl+V (paste)
8. LibreOffice Calc outputs are:
Cell Formula Value Expected value
A1 =SUM(B:$C) 2 Err:522 {Circular reference}
B1 =SUM(C:$C) 1 Err:522 {Circular reference}
C1 =SUM(D:$C) 0 Err:522 {Circular reference}
D1 =SUM(E:$C) 0 Err:522 {Circular reference}
E1 =SUM(F:$C) 0 Err:522 {Circular reference}
LibreOffice
Version: 5.1.0.0.alpha1+ (x64)
Build ID: ab23efcc2bb9ca178dee16b3d01eabb3f80d8e17
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-06-30_19:11:33
Locale: en-AU (en_AU)
9. Microsoft Excel advises there is a circular reference with:
a) a dialog box; and
b) the status bar shows: Circular References: C1
10. Microsoft Excel outputs are:
Cell Formula Expected formula Value Expected value
A1 =SUM(B:$C) =SUM(B:$C) 1 Err {Circular reference}
B1 =SUM(C:$C) =SUM(C:$C) 1 Err {Circular reference}
C1 =SUM($C:D) =SUM(D:$C) 1 Err {Circular reference}
D1 =SUM($C:E) =SUM(E:$C) 1 Err {Circular reference}
E1 =SUM($C:F) =SUM(F:$C) 1 Err {Circular reference}
--
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
