Description: When the Excel 2010 document provided with this issue is opened in LibreOffice Calc 7.3.4.2, the data for the charts is missing. Please see attached screenshots comparing the view in Excel and Calc This issue is similar to #83307, but has more chart types and has xlsx (not xls) Our final use case is Export to PDF on Linux, but since the view is incorrect on Windows, the exported PDF is also missing the data (on Windows and Linux). Steps to Reproduce: 1. View the "Chart Insert excel 2010.xlsx" attached to this issue 2. Compare the view of Sheet 1 in Excel and Calc Actual Results: Chart data are missing for all charts on Sheet 1 Expected Results: View of Sheet 1 in Calc should match Excel Reproducible: Always User Profile Reset: No Additional Info: Version: 7.3.4.2 (x64) / LibreOffice Community Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Created attachment 181450 [details] Source Excel document to open in Calc
Created attachment 181451 [details] Screenshot showing comparison of top 3 charts on Sheet 1
Created attachment 181452 [details] Screenshot showing comparison of bottom 3 charts on Sheet 1
Created attachment 181455 [details] Data series in Excel The Excel chart has a fixed value using "={1}" as its series values. See attached screenshot for more info. In LibreOffice this fixed value is not imported. Apparently LO cannot handle "={1}" in the "Range for Y-values". This is clearly an import issue. Tested with: Version: 7.3.4.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 1:7.3.4-0ubuntu0.22.04.1 Calc: threaded Also repro in 7.5+
Created attachment 181456 [details] Data series in LO Calc Notice that "Range for Y-values" is empty. Entering "={1}" here does not work.