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: [email protected]
Reporter: [email protected]
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.
