https://bugs.documentfoundation.org/show_bug.cgi?id=159076
Bug ID: 159076
Summary: Invalid database range if data filtered
Product: LibreOffice
Version: 7.4.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Description:
Hi Experts,
I've database range in $ThisSheet$A$1:$N$5609 and the total row number is 5611
The value in cell A5610 is 'x123'
This is step by step how the problem is occured :
1. Opened file with database range (example => database range =
$ThisSheet$A$1:$N$5609, but = 5611 row total exist with data)
2. Filter the column A with value = 'x123' (x123 is in cell A5610)
3. The data filtered only show 2 row (1 row header dan 1 row data)
4. Click 'Data'->'Define Range'. The cell range is $ThisSheet$A$1:$N$5611
5. If I clear the filter and click 'Data'->'Define Range'. The cell range is
still $ThisSheet$A$1:$N$5611
If I closed this file, reopen and without filter the data, I click
'Data'->'Define Range'. The cell range is show correct range
$ThisSheet$A$1:$N$5609
Why the range has changed? The correct range is $ThisSheet$A$1:$N$5609 but it
show $ThisSheet$A$1:$N$5611 after I filtered the column
Sincerely,
Oviedityanto
Steps to Reproduce:
1.Opened file with database range (example => database range =
$ThisSheet$A$1:$N$5609, but = 5611 row total exist with data)
2.Filter the column A with value = 'x123' (x123 is in cell A5610)
3.The data filtered only show 2 row (1 row header dan 1 row data)
4.Click 'Data'->'Define Range'. The cell range is $ThisSheet$A$1:$N$5611
5.If I clear the filter and click 'Data'->'Define Range'. The cell range is
still $ThisSheet$A$1:$N$5611
Actual Results:
Incorrect database range cell => $ThisSheet$A$1:$N$5611
Expected Results:
Correct database range cell => $ThisSheet$A$1:$N$5609
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.4.4.2 (x64) / LibreOffice Community
Build ID: 85569322deea74ec9134968a29af2df5663baa21
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-GB
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
