Bug 145185 - Name box -> Manage Names -> Range Options -> 'Filter' is not persisted when saved in xlsx format (Steps in comment 6)
Summary: Name box -> Manage Names -> Range Options -> 'Filter' is not persisted when s...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Name
  Show dependency tree / graph
 
Reported: 2021-10-17 14:42 UTC by dmitry.a
Modified: 2023-05-26 04:43 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample file saved with 7.1.6 (7.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-10-17 19:02 UTC, m_a_riosv 		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 dmitry.a 2021-10-17 14:42:03 UTC 
Description:
'Filter' checkbox of a named range is not persisted after re-opening a document.

Steps to Reproduce:
1.Using the Name Box -> Manage names define a named range
2.Mark this name as 'Filter' in Range options
3.Save document
4.Load document

Actual Results:
Filter checkbox is not marked for the named range.

Expected Results:
Filter checkbox is marked for the named range.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.6.2 / LibreOffice Community
Build ID: 0e133318fcee89abacd6a7d077e292f1145735c3
CPU threads: 12; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: en-US (en.UTF-8); UI: en-US
Calc: threaded
Comment 1 m_a_riosv 2021-10-17 19:02:26 UTC 
Created attachment 175797 [details]
Sample file saved with 7.1.6

Works for me with
Version: 7.2.2.2 (x64) / LibreOffice Community
Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Version: 7.1.6.2 (x64) / LibreOffice Community
Build ID: 0e133318fcee89abacd6a7d077e292f1145735c3
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: es-ES Calc: threaded
Comment 2 Xisco Faulí 2021-10-22 09:15:29 UTC 
Thank you for reporting the bug. To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test?

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
Comment 3 dmitry.a 2021-10-23 11:39:38 UTC 
Hi. Sorry I have not provided full info initially. The document needs to be saved in Excel 2007-365 (*.xlsx) format.
Comment 4 dmitry.a 2021-12-16 08:49:26 UTC 
Hi. The bug still exists. Can anyone have a look?

The file needs to be saved in xlsx format in order to reproduce it.
Comment 5 Justin L 2022-09-06 14:48:26 UTC 
Works for me. Saved in both .xls and .xlsx formats. I tested with master (7.5) and with 7.2.7.
Comment 6 Xisco Faulí 2022-09-06 14:55:15 UTC 
No, the issue is still reproducible in

Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: 64f673238cf9b645a751e8f8137ca14e595a779a
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: en-US
Calc: threaded

Steps:
1. Open the attached document
2. See Name box -> Manage Names -> Range Options -> 'Filter' is opted in
3. Save as XLSX and reopen
4. Name box -> Manage Names -> Range Options -> 'Filter' is opted out
Comment 7 BogdanB 2023-05-26 04:43:08 UTC 
Also in
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded