It might be due different behaviours of XLS and XLSX file formats of MS Excel. Anyways, could you try our latest fix/version e.g v7.3.3.3: Aspose.Cells for .NET v7.3.3.3 if it works fine.
If you still find the issue with latest fix/version, kinldy paste your complete sample runnable code or attach sample console application (you may zip it prior attaching) here, we will check your issue soon.
I cannot send source as it is as we are using other 3rd party components. We could write a new standalone client to test this for you but it will take us some time. I wanted to ask if you are aware of this issue in Excel or Aspose already before we investigate this further?
Well, mostly such issue occurs because you need to set some extra properties to make them work. Means, such issues are mostly related with sample code.
However, it could also be a bug or some broken feature and we will investigate it once we will get your standalone application.
Also, we will look into it at our end and help you with some advice asap.
After an initial test with v7.3.3, I can notice the issue for XLS file format (XLSX works fine though) by just running the demo code after adding your suggested lines i.e. After: //Set properties of chart Add: chart.CategoryAxis.IsLogarithmic = true; chart.CategoryAxis.IsAutomaticMaxValue = false; chart.CategoryAxis.IsAutomaticMinValue = false; chart.CategoryAxis.MinValue = 5; chart.CategoryAxis.MaxValue = 150;
in the "scatter-connected-by-lines.aspx/cs" featured demo. The category axis for XLS chart still shows max value as 100 instead of 150.
I have logged a ticket with an id: CELLSNET-41186 for your issue. We will look into your issue soon.
I am afraid, your issue is not sorted out yet. However, I have asked the concerned developer to update on your issue. Once we receive any update on it, we will let you know here.
We have investigated the logarithmic issues for Excel 2003. We found that for XLS file format, the maximum value or the minimum value must be the values in the pattern/range such as, 1, 10, 100, … and so on, so, they seem to be an integer that should be multiple of 10.
Therefore, the values, 5 and 150, are not accepted for Excel 2003 file format.
Thanks for your posting and considering Aspose.Cells.
It’s good to know that you now understand the limitation of Excel 2003 format and you can now devise a workaround for it.
We have closed this thread now. Let us know if you face any other issue, we will be glad to help you asap.
Also, for other other chart types and general Aspose.Cells API(s), we recommend you to download and try our latest offline demos, which you can find from the given links.