Aspose.Cells breaks scale settings of chart

Aspose.Cells Product Family
1

Received : 2007/08/06 09:45:57
Message : I am using Aspose.Cells 4.3.0.0. The only thing my code does is altering some cell values on the first Workheet in the Workbook (which does NOT contain the Chart). A pivottable on another sheet will take and aggregate these values and the column chart will read the pivottable. This all works perfectly. The only problem is dat Aspose.Cells changes the scaling of the Secondary Horizontal Axis to default (auto scaling). We have configured it explicitly in our excel sheet to "Fixed Min: 0.0 and Fixed Max: 1.0". This makes sure that the series line will run from the left of the screen to the right of the screen in stead of stopping in the middle. If we change it back manually in Excel everything is ok again. So concluding:

- Template Excel file has setting on Second Horizontal Axis of Fixed Min: 0.0 and Fixed Max: 1.0
- When Aspose.Cells opens the file and saves to another file, the newly saved file has default excel settings (auto scaling), which is not correct.

Why does aspose.cells alter these values? How can this be repaired?

(setting minvalue or maxvalue on the axis does not help, already tried that.)

This message was posted using Aspose.Live 2 Forum
2

Hi,

Well, Aspose.Cells.Net normally manipulates Designer Charts fine in the template files. We insist you that do post your template file (zipped) and paste your sample code here. We already sign NDA (Non Disclosure Agreement) with you which defines that only you and Aspose staff can download your attachment(s). Other users won't be able to do that. So please do post us your template file here, It will help us to figure out the issue soon.

Thank you.