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