Summary: | Name box -> Manage Names -> Range Options -> 'Filter' is not persisted when saved in xlsx format (Steps in comment 6) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | dmitry.a |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | buzea.bogdan, miguelangelrv, xiscofauli |
Priority: | medium | ||
Version: | 7.1.6.2 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 109178 | ||
Attachments: | Sample file saved with 7.1.6 |
Description
dmitry.a
2021-10-17 14:42:03 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 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 Hi. Sorry I have not provided full info initially. The document needs to be saved in Excel 2007-365 (*.xlsx) format. Hi. The bug still exists. Can anyone have a look? The file needs to be saved in xlsx format in order to reproduce it. Works for me. Saved in both .xls and .xlsx formats. I tested with master (7.5) and with 7.2.7. 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 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 |