1/ I create a blank file in OpenOffice.
2/ I add a column with 5 values, and a chart based on this empty_with_chart.PNG (11.1 KB)
3/ Then i am running this code :
Workbook wb = new Workbook(@“empty_with_chart.ods”);
Worksheet sheet = wb.Worksheets[0];
Cell cell = sheet.Cells[“A1”];
cell.PutValue(“TEST”);
wb.Save(“MyBook.ods”);
The chart width is 0.01cm, and when i set a bigger width the result is half blue / half white with nothing showing. I have also encountered a case where the chart is not showing at all.
Can someone help me on this subject ? I have tried to parse the sheet and call Calculate on the chart, it has no effect.
ps : I am using the nugget package Aspose.Cells v19.11.0
@vviroleau,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.
This issue has been logged as
CELLSNET- 47023 – Chart lost while loading and saving ODS file
Now the diagrams are displayed, but there are still 10 bugs :
1- Diagram point only is transformed in line only (Sheet2, line 1 diagram 1)
2- Lines and point is transformed in line only (Sheet2, line 1 diagram 2)
3- Line 3D is wrong, the line is not displayed (Sheet2, line 1 diagram 4)
4- XY scatter points only, the points have disappeared (Sheet2, line 2 diagram 1)
5- XY scatter points and line is transform in XY scatter line only (Sheet2, line 2 diagram 2)
6- XY scatter 3D lines is wrong, the line is not showing (Sheet2, line 2 diagram 4)
7- Net points only is wrong, the points are not showing (Sheet2, line 4 diagram 1)
8- Net points and line is transformed in line only (Sheet2, line 4 diagram 2)
9- Net filled is completely different, it’s like it has been transformed in bar ? (Sheet2, line 4 diagram 4)
10- All Line, XY scatter and net diagram have a different font after the save.
The line is thicker and the color has changed. (Sheet2, line 1, 2 and 4)
We noticed mostly your mentioned issues but a few ones are not confirmed. I simply opened your sample ODS file and re-saved it using the following sample code:
e.g Sample code:
Workbook wb = new Workbook("e:\\test2\\allDiagrams_before.ods");
wb.Save("e:\\test2\\out1.ods");
The following issues are not confirmed/reproduced precisely: 2- Lines and point is transformed in line only (Sheet2, line 1 diagram 2) 4- XY scatter points only, the points have disappeared (Sheet2, line 2 diagram 1) 5- XY scatter points and line is transform in XY scatter line only (Sheet2, line 2 diagram 2)
8- Net points and line is transformed in line only (Sheet2, line 4 diagram 2) _ 9- Net filled is completely different, it’s like it has been transformed in bar ? (Sheet2, line 4 diagram 4) 10- All Line, XY scatter and net diagram have a different font after the save.
We appreciate if you could provide some screenshots to highlight the above mentioned issues while comparing charts in input ODS file Vs output ODS file in openoffice. After receiving these details and artifacts, we will log appropriate tickets for the issues.
I could not find your mentioned issues (as per your screenshots). Actually I find a different display when opening input ODS file into openoffice (OpenOffice.org v3.2). I have captured some screenshots to compare those charts from input ODS Vs output ODS (via Aspose.Cells) into openoffice for your reference: https://i.imgur.com/uxrF2MP.png https://i.imgur.com/oLA7bhe.png https://i.imgur.com/BgTGX3b.png
You can clearly see there is not much difference b/w input and output charts.
I have also attached the input file and output file (using your sample code with v19.11.6) for your reference. files1.zip (190.8 KB)
Yes, I am using the same version (i.e., Aspose.Cells for .NET v19.11.6). I even printed the version in the code (at the start), i.e.,
Console.WriteLine(CellsHelper.GetVersion());
it gives correct version number:
19.11.6
If you still find these issues (as per your screenshots), we appreciate if you could create a standalone console demo application with v19.11.6, zip the project and provide us here to reproduce the issue, we will check it soon.
I used your project to open into VS.NET and executed it (with v19.11.6) and it works fine, see the screenshot when running: https://i.imgur.com/BzqtJwj.png
I have attached the output file for your reference. Please open it and see if you see those issues or not. file.zip (54.7 KB)
This is strange that you are seeing this issue where as I could not find those issues (I could only notice 1,3 and 7 issues) on my pc (os: Windows8, openoffice.org 3 (v3.2.0), etc.). Also see the screenshot of the openoffice version that I am using: https://i.imgur.com/BgTGX3b.png
What is your environment, please provide complete details about your environment. Also attach your output file by Aspose.Cells for .NET v19.11.6 which is generated when executing your project with your input ODS file.
Ok, i have unzip my wrong ODS file and your good ODS file, and for example in the folder
Object 0_0, the file content.xml has a difference (a coma instead of a point) regional_point_or_coma.PNG (65.5 KB)
I am under windows 10 but in France.
Can you please change your regional settings to France and see if you can reproduce ? region.PNG (99.9 KB)
Yes, I noticed (I tested the code after changing regional settings to France) this is due to your regional settings in your environment. Could you try to add a line to your code before re-saving ODS file.
e.g Sample code:
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.