https://bugs.documentfoundation.org/show_bug.cgi?id=96981
Bug ID: 96981
Summary: Formula creation using entire sheet heading
Product: LibreOffice
Version: 5.2.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Let ALL_HEADING be the rectangle which is the intersection of the row and
column headings, i.e. Left of column heading A and above row heading 1.
Scenario A – works correctly
============================
1. In cell A1, type: =SUM(
2. Click ALL_HEADING and nothing happens as this would create a circular
reference.
Scenario B – works correctly
============================
1. Create 3 sheets, i.e. Sheet1, Sheet2 and Sheet3.
2. Click Sheet1.
3. Press and hold Ctrl and click Sheet3, then release Ctrl.
4. In cell A1 (still on Sheet1), type: =SUM(
5. Click on Sheet3.
6. Click ALL_HEADING and nothing happens as this would create a circular
reference in Sheet3.
Scenario C – works incorrectly
==============================
1. Create 3 sheets, i.e. Sheet1, Sheet2 and Sheet3.
2. Click Sheet1.
3. In cell A1, type: =SUM(
4. Press Ctrl+PgDn (or click on Sheet2).
5. Click ALL_HEADING (in Sheet2) and cell A1 (of Sheet1) contains
Current behaviour : =SUM(
Expected behaviour : =SUM(Sheet2.1:1048576)
Note: Another representation for the entire sheet could be:
=SUM(Sheet2.A:AMJ)
however, this may cause regressions when the maximum number of columns is
increased (see bug 50916). Saving entire sheets using row references may be
preferable to using column references.
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
