Read write and Encrypt .ods file

Aspose.Cells Product Family
1

Hi,


There are few functionality that does not work for .ODS extension.

Is there any way we can get those information.

So, For I encounter following functionality does not work for us.

1) Open .ODS file with password protected. (Test.ods, password is “test”)
2) Encryption of ODS file
3) AutoFit Column
4) Creating form template is not same, lose some formatting (see TestTemplate.ods)

we are using Open Office 4.1

Any help would be appreciated…
2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe the issue relating to not opening password protected ODS file by Aspose.Cells.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43556 - Not able to open the password protected ODS file

We have tested this issue with the following sample code but it throws exception.

For your other issues, please provide us your sample codes and screenshots highlighting your issues. We will look into them and help you asap.

C#

string filePath = @“F:\Shak-Data-RW\Downloads\Test.ods”;


LoadOptions opts = new LoadOptions(LoadFormat.ODS);

opts.Password = “test”;


Workbook workbook = new Workbook(filePath, opts);
Exception:
at ™€.€.›a€()
at ™€.€.™›()
at ™€.€.Read()
at .“.Read(™” )
at .›.()
at .›.Read(™” )
at .›.Read(Stream )
at Aspose.Cells.Workbook.Ÿ(Stream , LoadOptions , Boolean )
at Aspose.Cells.Workbook.Ÿ(String , LoadOptions )
at Aspose.Cells.Workbook..ctor(String file, LoadOptions loadOptions)

Additional information: Unexcepted eof.

3

Thank you for your response.


Are you able to see other issue.

2) workbook.Settings.Password = “test”; // does not work for .ods file

3) worksheet.AutoFitRows(1, 4); // does not work for .ods file

4)
FileStream excleFileFS = new FileStream(templateFile, FileMode.Open);
Workbook workbookTemp = new Workbook(excleFileFS, loadOptions);
excleFileFS.Close();
workbookTemp .Save(“C:\temp\MyODS.ods”, SaveFormat.ODS); // loos some functionality
4
Ankurkumar:
Thank you for your response.

Are you able to see other issue.

2) workbook.Settings.Password = "test"; // does not work for .ods file

Hi,

Thanks for your posting and using Aspose.Cells.

It seems to be a New Feature. It seems, neither opening nor creating of encrypted ODS file is supported, so I have changed the earlier issue to new feature and create this issue also a new feature.

We will look into it and support these features. Once, these are implemented or we have some other update for you, we will let you know asap.

These issues have been logged as

  • CELLSNET-43556 - Open encrypted ODS file
  • CELLSNET-43560 - Encrypt ODS file

I have tested this issue with the following sample code.

C#

Workbook workbook = new Workbook();
workbook.Settings.Password = "test";

workbook.Save("output.xlsx");
workbook.Save("output.ods");

5
Ankurkumar:
Thank you for your response.

Are you able to see other issue.

3) worksheet.AutoFitRows(1, 4); // does not work for .ods file

Hi,

Thanks for using Aspose.Cells.

For this issue, it will be helpful if you could provide us your runnable sample code and also let us know the file name with sheet name ( is it TestTemplate.ods which you have attached earlier, what is the sheet name to test the code with? ).

6
Ankurkumar:
Thank you for your response.

Are you able to see other issue.

4)
FileStream excleFileFS = new FileStream(templateFile, FileMode.Open);
Workbook workbookTemp = new Workbook(excleFileFS, loadOptions);
excleFileFS.Close();
workbookTemp .Save("C:\temp\MyODS.ods", SaveFormat.ODS); // loos some functionality
Hi,

Thanks for your posting and using Apsose.Cells.

Which file the variable templateFile is referring to. Is it CM EXEC REPORTS.xlsx which you have attache earlier or is it TestTemplate.ods file?

Also, highlight your issues in a screenshot or provide some word document with screenshots showing the issues. It will help us look into the issues more closely and precisely and we will be able to fix it soon.
7
Hi

Thank you for your quick response.

From above code and Attached files.

Temp file is : CM EXEC REPORTS.xlsx

Save file : TestTemplate.ods

See TestTemplate.ods ,, it is lossing some format,,like graphs. Filtering column

Thanks !!!
8
Hi

Thank you for your quick response.

worksheet.AutoFitColumns(1, 4); // So far i notice on auto column .

It works fine with .xls,, issue only with .ods extension.

See testAuto.ods

Thanks !!!
9
Ankurkumar:
Hi

Thank you for your quick response.

From above code and Attached files.

Temp file is : CM EXEC REPORTS.xlsx

Save file : TestTemplate.ods

See TestTemplate.ods ,, it is lossing some format,,like graphs. Filtering column

Thanks !!!
Hi,

Thanks for your posting and using Aspose.Cells.

We have converted your XLSX file into ODS file using the following code with the latest version: Aspose.Cells for .NET 8.4.1 and were able to observe these issues.

We have logged them in our database. We will look into them and fix them. Once, these issues are resolved or we have some other update for you, we will let you know asap.

These issues have been logged as

  • CELLSNET-43562 - Filtering on columns is lost when XLSX is converted to ODS
  • CELLSNET-43563 - Charts are lost when XLSX is converted to ODS

C#
string filePath = @"F:\Shak-Data-RW\Downloads\CM+EXEC+REPORTS.xlsx";

Workbook workbook = new Workbook(filePath);
workbook.Save(filePath + ".out.ods");
10

Hi,


This is to inform you that the ticket logged earlier as “CELLSNET-43562” has been marked resolved. We will soon share the fix here for your testing after performing QA and including other enhancements and fixes.

Thank you.
11

The issues you have found earlier (filed as CELLSNET-43562) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
12

@Ankurkumar

Thanks for using Aspose APIs.

For your issues

  • CELLSNET-43556 - Open encrypted ODS file
  • CELLSNET-43560 - Encrypt ODS file

Please download and try the following fix and let us know your feedback.

Download Link:

NuGet Gallery | Aspose.Cells 18.7.0

13

The issues you have found earlier (filed as CELLSNET-43560,CELLSNET-43556,CELLSNET-43563) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi