[Libreoffice-bugs] [Bug 127419] New: EDITING: Database range is extended automatically against my wishes when filtering

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: leander.holtmann at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190907/146dd526/attachment.html>