Description: The attached file was generated by open the "Charting Basics" template in Numbers 11.2 and saving without making changes. When opening with the current release build (7.2.5.2), a number of formats are incorrect: Table "Monthly Sales by Region" (original table in worksheet "Interactive Chart") should have months as column labels, but LO shows raw date codes. A similar issue affects "Comparison of Units Sold by Year" (column headers should be year) Table "Monthly Sales by Region" (original table in worksheet "Interactive Chart") body cells (B2:E5) are formatted as number in Numbers, but LO shows currency. This issue also affects "Comparison of Units Sold by Year" and "Average Rainfall" Table "Average Rainfall" (original table in worksheet "2-Axis Chart") column B is formatted as Number with 2 decimal places, but LO shows integers. Steps to Reproduce: Open Attached File. Actual Results: See Description Expected Results: See Description Reproducible: Always User Profile Reset: Yes Additional Info: See Description
Created attachment 177892 [details] sample File was generated by opening Numbers 11.2 and creating a new document from the template Basic > Charting Basics
I doesn't see any data on the sheet "Interactive Chart", only one text box. Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 2f4f4cbeb8e50081d607b86b0475b93971c40ab8 CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: tr-TR (cs_CZ.UTF-8); UI: en-US Calc: threaded Jumbo
A "Sheet" in Numbers can contain multiple objects, including "Tables" and charts and text boxes. LibreOffice projects each supported object into its own "worksheet". If a table has a title, the generated worksheet uses the title as the worksheet name. That decision loosely "makes sense" given that LO has no direct equivalent of a Numbers Sheet. In the "Interactive Chart" Sheet in Numbers, there is a text box, a table and a chart. LibreOffice put the text box in the "Interactive Chart" worksheet. Since the table has a title "Monthly Sales by Region", LibreOffice actually generated a worksheet called "Monthly Sales by Region" and put the table there. The phrase `Table "Monthly Sales by Region" (original table in worksheet "Interactive Chart")` should be parsed as 'LibreOffice generated a table "Monthly Sales by Region". This table corresponds to the "Interactive Chart" Numbers sheet.'
I don't know what Numbers is, but there, how are those cells formatted, as all, general numbers, date, specific date.. which format code exactly? Is this a bug against Calc or libetonyek as reported? MSO doesn't open it at all.