I generate the attached Excel documents with the same code, however the result for XLS (Excel97To2003) is different to XLSX.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
In the code I set the range of the X axis to be defined as min 5 and max 150, i.e.
chart.CategoryAxis.IsAutomaticMinValue = true;
chart.CategoryAxis.MinValue = 5;
However, in the XLS output this is ignored and Excel uses its own range. In the XLS the range of the X axis is not set.
In the XLSX this range is applied.
Is this difference a “feature” of Excel or a problem with Aspose?