https://bugs.freedesktop.org/show_bug.cgi?id=69843
Priority: medium
Bug ID: 69843
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: One cannot enter a whole column as a range
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: kaese...@gmail.com
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.1.2.2 rc
Component: Spreadsheet
Product: LibreOffice
This is the problem:
- enter some numbers into cells A1:A5
- go into C1 and enter
=SUM(
- and then try to make click on the "A" in the column header, which you can't
but which used to be possible.
This is quite annoying because it means if you want to add more values into
A6:A10 and have the sum in C1 updated, you must enter a specific larger range
into C1 - you can't just specify 'the whole column however far down it is',
which would be the intuitive thing to do.
Even more counterintuitively: if you create a Pivot table by
- highlighting multiple columns by clicking on the column headers
- then clicking: Data: Pivot Table: Create
then the Select Source window says "Highlight Selection", which is after all
the whole column, but then the Pivot table data range in the next window is
really only until the bottommost data point (say, C22) so when you add new data
and refresh the Pivot Table, new stuff one may have entered is not included
even though I created the Pivot table from the selection, which was the whole
column.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
