I have an Excel file with simple table(one column) and line chart with datetime X axis(format is "MMM yyyy"). I create it by using OpenXML
SDK as data report in .NET web application. When I open genereted file all is OK: I see correct axis labels like "Jun 2001" etc.
When I gernerate similar DOCX
file I generate XLSX
file first and after that embed this XLSX
as external source(from stream) and clone chart part from XLSX
to DOCX
document. The resultant DOCX
is OK except X axis: I don't see "Jun 2001", but some numbers like "40969" and chart is mirrored, X axis has default format(not datetime). But if I open linked chart data source axis format will be changed to Datetime and chart will correct.
How can I fix this problem? Or it is a bug?