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");
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.
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.,
it gives correct version number:
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: