Bug 144048 - Calc: Define Range doesn't set selected range
Summary: Calc: Define Range doesn't set selected range
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoFilter Calc-DataRange
  Show dependency tree / graph
 
Reported: 2021-08-24 09:21 UTC by Timur
Modified: 2023-04-23 18:57 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
screencast (912.83 KB, video/mp4)
2021-08-25 07:38 UTC, Timur 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Timur 2021-08-24 09:21:33 UTC 
1. Open ODS attachment 144970 [details] from bug 119949
2. Remove existing Autofilter (press Autofilter twice).
3. Mark the area to which the filter should be applied: A1-A6 or A1-A8. 
4. Set: Menu Data > Define Range. Enter Name, Add, OK.
5. With the area marked, enable Autofilter by menu Data > Autofilter.

Experienced: Autofilter also includes rows "this, stuff, shouldn’t be displayed".
Expected: Autofilter has range as defined. 

These are Regina's steps, which work in general, but somehow not in this case.
Comment 1 Timur 2021-08-24 09:35:06 UTC 
Better to test with A1-A8.
In OO 3.3 range would not include A9-A11 (OK), but also not A7-A8 (NOK).
Bug as in Description already in LO 3.5 up to 7.3+.
Comment 2 m_a_riosv 2021-08-24 20:47:45 UTC 
Maybe I didn't follow fine the steps, but no issue for me.
Version: 7.2.0.4 (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Comment 3 Timur 2021-08-25 07:38:30 UTC 
Created attachment 174528 [details]
screencast
Comment 4 m_a_riosv 2021-08-25 09:48:55 UTC 
Ok, I see now, but I'm not sure if it isn't done on purpose.