I’ve faced with chart formatting issue (Aspose.Cells 7.0.3).
I created simple chart (lines with markers) with nonintegral values as data source (like 1385.45). The format defined zero decimal places for the data labels. Then I just opened this XLSX document using Aspose and saved it to memory stream and then to file:
var xlsWorkbook = new Workbook(dataStream); xlsWorkbook.Worksheets.ActiveSheetIndex = requiredSheetIndex; xlsWorkbook.Settings.CalcMode = CalcModeType.Manual; … xlsWorkbook.Save(memoryStream, saveFormat); …
The resulted document is not completely similar to the initial one. There are fractional parts of the numbers in the chart data labels. Could you please look into the problem. Used Excel files are attached.
I can notice the second column is not fully displayed although it has the same values. I think you can extend the width of the second column a bit (accordingly), e.g you may add a line of code to your code i.e.
Thanks for the reply. Sorry, but my question was about other thing. Please compare two charts: in the 1st file, and in the 2nd (After Aspose) and pay your attention on chart labels (I mean marker labels, not axe labels).
For example blue line has the next labels: (1st file): 5562; 5459; 5332 … (2nd file): 5561.7; 5458.5; 5331,5 …
My example demonstrates simple example. But this formatting can be really ugly for numbers with a big quantity of decimal places.
In both files, the marker labels are same as shown in the first file:
(1st file): 5562; 5459; 5332 …
Please take screen shots of input and output files to encircle the issued area with red color comparing both files. It will give us the idea about the issue
By the way, I am using Excel 2007 to open the files.
I use Excel 2010 (and it seems it is important - SaveFormat.Xlsx). I tried SaveFormat.Excel97To2003 - the labels are OK for this format, but I can’t use it (cause I work with XLSX fortmatted files), otherwise I will faced with other formatting problems.
Opening the input and output files into MS Excel 2010 can show the issue as you mentioned by your screen shots. I have logged a ticket with an id: CELLSNET-40148. We will look into it soon.