https://bugs.documentfoundation.org/show_bug.cgi?id=157318
Bug ID: 157318 Summary: Named ranges defined at the sheet level are not exported to XLSX Product: LibreOffice Version: 7.6.1.2 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: rafael.palma.l...@gmail.com Created attachment 189684 --> https://bugs.documentfoundation.org/attachment.cgi?id=189684&action=edit ODS file for testing When you create named ranges in an ODS file that are not global (instead their scope is a single sheet), then these named ranges are not exported to XLSX. Steps to reproduce: 1) Open the attached ODS file. It has 2 named ranges (Test1 is global and Test2 is tied to Sheet1) 2) Open the Manage Names dialog to view the existing named ranges (Sheet - Named Ranges and Expressions - Manage) 3) Save this file as XLSX 4) Open the XLSX file and check the named ranges available 5) Notice that Test2 disappeared This seems to have started with LO 7.6. I could not reproduce in 7.5. System info Version: 7.6.1.2 (X86_64) / LibreOffice Community Build ID: 60(Build:2) CPU threads: 12; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+wayland) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 4:7.6.1~rc2-0ubuntu0.23.04.1~lo1 Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.