https://bugs.documentfoundation.org/show_bug.cgi?id=127419
Bug ID: 127419
Summary: EDITING: Database range is extended automatically
against my wishes when filtering
Product: LibreOffice
Version: 6.3.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: leander.holtm...@gmail.com
Description:
When I add a database range (e. g. from A1:B10) and have something in the
subsequent cells of one of the columns (in this example B11 and B12) like SUM()
and then filter the database range via Standard or Advanced filter, LibreOffice
just extends the database range against my wishes to the row that is completely
empty (in this example the range is then A1:B12).
The options when defining the database range don't matter. I did this with a
new user profile.
I do not know whether this behaviour is intended, thus a feature, or a bug. If
it is intendet, consider this a enhancement request.
Steps to Reproduce:
1. Open new document
2. Mark cells A1 to B10
3. Define a database range via 'Data - Define Range...' for A1:B10
4. The options and the name don't matter
5. Write =SUM(A1:A10) in cell A11 and A12
6. Put the cursor back to cell A1
7. Open the Standard Filter dialogue via 'Data - More Filters - Standard
Filter'
Actual Results:
As soon as the Standard Filter dialogue opens, the database range is extended
to A1:B12
Expected Results:
My defined database range should not be extended against my wishes. If I define
a database range, it has to stay how I defined it.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 6.3.1.2 (x64)
Build ID: b79626edf0065ac373bd1df5c28bd630b4424273
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win;
Locale: de-DE (de_DE); UI-Language: en-GB
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
