Convert Excel spreadsheet to ods with odf 1.3 standard

Aspose.Cells Product Family
21

Thank you ! I was too quick in my earlier post and didn’t notice that the current sheet had switched and were showing a sheet not containing any images. Sorry for that.
Just a minor thing I did notice. The formatting/colors in the Column C is not properly converted into the .ods. The colors are missing. But they are fine and correct on the second sheet in ods. Maybe this is something you can take a look at ?
I must also say that I’m very happy with your response time on this ods matter so far. Thank you very much :slight_smile:

22

@andersalvsaker,

Let us analyze and evaluate it in details and we will get back to you.

23

@andersalvsaker
The first worksheet lost conditional formatting, we have logged it with ticket id CELLSNET-55185 in the issue system.

24

@andersalvsaker
20240222_1.zip (37.5 KB)

Please check the attached file. We have fixed this issue.

1 Like
25

Thank you! This looks perfect :ok_hand:t2:
When will this be available in a release ?

26

@andersalvsaker,

Thanks for your feedback and good to know that it suits your need well.

Please note, the fixes/enhancements will be included in our upcoming release (Aspose.Cells v24.3) that we plan to publish in the first half of March (next month). You will be notified when the next version is released.

1 Like
27

Thank you. Very efficient :ok_hand:t2:

28

@andersalvsaker,

You are welcome.

29

The issues you have found earlier (filed as CELLSNET-55143,CELLSNET-55185) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

30

@andersalvsaker
Please try the following codes with the latest version :

OdsSaveOptions saveOptions = new OdsSaveOptions();
            saveOptions.OdfStrictVersion = Aspose.Cells.Ods.OpenDocumentFormatVersionType.Odf13;
            workbook.Save(Constants.destPath + "CELLSNET55185.ods", saveOptions);
1 Like
31

Thank you we will👍🏻

32

@andersalvsaker,

Please take your time to evaluate the new version with newer APIs as per the suggested code segment. Hopefully it will work for the purpose.

Let us know with detail and samples in case the resultant file is not rendered as per your expectations.

1 Like
33

Hi,

We have now checked the new version and with our simple test files (xlsx) the produced .ods is according to 1.3 spec and check out okay with the simple online tool we’re using.

However if we convert a bit more complex xlsx we get an validation error from the tool:

The document is NOT conformant ODF1.3!

Details:

002 PPT klientmapper.ods: Info: ODF version of root document: 1.3
internal:/schema/odf1.3/OpenDocument-v1.3-manifest-schema.rng: Info: parsed.
002 PPT klientmapper.ods/META-INF/manifest.xml: Info: no errors, no warnings
002 PPT klientmapper.ods/mimetype: Info: no errors, no warnings
002 PPT klientmapper.ods: Info: Media Type: application/vnd.oasis.opendocument.spreadsheet
internal:/schema/odf1.3/OpenDocument-v1.3-schema.rng: Info: parsed.
002 PPT klientmapper.ods/meta.xml: Info: Generator: Microsoft Excel
002 PPT klientmapper.ods/meta.xml: Info: no errors, no warnings
002 PPT klientmapper.ods/settings.xml: Info: no errors, no warnings
002 PPT klientmapper.ods/styles.xml[1,16139]: Error: attribute “style:scale-to-Y” has a bad value: “0” does not satisfy the “positiveInteger” type

Maybe you can have a look into this and see if this can be corrected ?

Excel and .ods output here:
002 PPT klientmapper.zip (74.7 KB)

Thanks in advance !

Kind Regards,
Anders

35

@andersalvsaker
We compared the displayed values of 002 PPT klientmapper.xlsx and 002 PPT klientmapper.ods and found them to be the same. However, it seems that some values do not comply with the ODS specification. We will further investigate to ensure that the written values fully comply with version 1.3 of the specification.

36

@andersalvsaker
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-55316

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

37

@andersalvsaker,

This is to notify you that your issue (logged as “CELLSNET-55316”) has been resolved. The fix/enhancement will be included in the next release (Aspose.Cells v24.4) scheduled for release in the second week of April (next month). You will be notified when the next version is released.

1 Like
38

Thank you :slight_smile:

39

@andersalvsaker,

You are welcome.

40

The issues you have found earlier (filed as CELLSNET-55316) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

1 Like