https://bugs.documentfoundation.org/show_bug.cgi?id=165503
Bug ID: 165503
Summary: FILESAVE XLSX Chart is removed when roundtripped XLSX
is opened in Excel
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: bibisected, bisected, regression
Severity: normal
Priority: medium
Component: filters and storage
Assignee: [email protected]
Reporter: [email protected]
Blocks: 75057
Created attachment 199525
--> https://bugs.documentfoundation.org/attachment.cgi?id=199525&action=edit
Sample XLSX
The attached simple spreadsheet was created in Excel, it has date-value pairs,
and a chart based on those values. Some of the date and/or value cells are
empty.
Saved it back to XLSX, and try opening it in Excel.
=> Excel shows error, and after attempting repairs, chart is removed.
Message is: "Removed Part: /xl/drawings/drawing1.xml part. (Drawing shape)"
(the problem has nothing to do with the drawing)
The issue is that in xl/charts/charts1.xml in the OOXML archive, dates under
<c:numCache> are in string format, and not in numeric format, as expected by
Excel, eg.:
- bad: <c:v>2021.01.03</c:v>
- good: <c:v>44199</c:v>
Observed using LO 25.8.0.0.alpha0+ (41ab24cecd6ad74312843f113d2faa13259cdb7d) /
Windows.
This, like bug 156465, is a regression from the following commit in 7.3:
https://git.libreoffice.org/core/+log/f547cf17a179ebd7de5c2b4dd2d00d0027a25429
author Dennis Francis <[email protected]> Thu Sep 02
14:33:55 2021 +0530
committer Miklos Vajna <[email protected]> Mon Sep 06 08:47:50
2021 +0200
"[API CHANGE] oox: fix import of chart date categories"
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=75057
[Bug 75057] [META] OOXML Chart object issues
--
You are receiving this mail because:
You are the assignee for the bug.
