Jump to content

Problem with Open Office


Recommended Posts

Hi everyone,

i have a problem with open office.

I have used a library downloaded from this site,

using Report Generation Toolkit i have tride to open an Open Office Calc file, but the SW give me this error

25u3ybt.png

 

Can someone help me?!

This is my Labview simple code

2s7xw8m.png

 

Thank you

Bye

Giovanni

Link to post
Share on other sites
  • 3 weeks later...
  • 1 month later...

I'm sorry but I'm not likely to work on this anytime soon. We use MS Office in the office, so OpenOffice is not a logical choice for me to work on, and our projects would usually require to work with MS Office too, if they require any office automation integration.

Link to post
Share on other sites

I've tried a quick and simple example of ooCalc yesterday and it seems that AODL 1.3 is not fully compatible, at least with the latest version of Office 2016. I was able to create the ODS document and open it with Apache OpenOffice 4.1, but it was impossible to open it with MS Excel 2016 without errors. I could create and add pages, and insert cells in a row, but not in a self-resizable table, meaning that AODL does not support correctly the automated resizing of a table when you insert a cell in a random row/column (user needs to resize the collection of rows and columns in a given table).

 

It might simply be a mistake on my part (back of the envelope PofC): mapping 1:1 with an example I saw online from 2010 does fail. I had to create workarounds for it to partially work. 

Since AODL support has been dropped at about the time I started the project, it seems likely that the ooCalc implementation with AODL will be error prone and not compatible with the latest openDocument standards. ooCalc will be lots of work to avoid these pitfalls and might be quite limited. I do not think that adding graphs and images was done with SpreadsheetDocuments in AODL.

 

My takeaway is that supporting text, numbers and formulas might be achievable with a few abstractions, but so far it would be compatible only for OpenOffice and not for MS Office.

 

***EDIT: Compatibility issue is from the Save method().

Link to post
Share on other sites
  • 1 year later...

Hi Francois, my name is Manzai.

I'm facing an issue where after I downloaded the OpenOffice RGT from the link below, found that it does not have AODL.dll file in the folder, for example, ...\normandinf-openofficergt-75893de099fd\AODL\DLLs. Because I keep getting the error of 1386 from LabVIEW. The possible reason of that error is "LabVIEW:  The specified .NET class is not available in LabVIEW.". Do you have any ideas?

 

Please do let me know if you know the solution for this case. Thank you!

Link to post
Share on other sites

It seems the DLL folder is missing from the source code. **EDIT** I've updated the repo to include the files. **END**

In the meantime, use VI Package Manager to install the VIP file which correctly includes the DLLs. You can extract the whole missing folder from there if you want to play with the source.
https://lavag.org/applications/core/interface/file/attachment.php?id=11167

 

 

Edited by Francois Normandin
Link to post
Share on other sites
  • 9 months later...

Hello Francois,

I am using the Openoffice tool created by you.

The problem I am facing is not able to save file. What I am doing is I have created an open office spreadsheet template and adding the values to set cell text and then save to file. Somehow it saves files, but when I open that it says the file is corrupted and it doesn't have any value which I write.

 

Attached a complete Vi with required files.

Open office Report generation Tool.zip

Link to post
Share on other sites

Hi Ashwin, 

Try with "Sheet1" instead of "sheet1".

Otherwise, I am getting corruptions as well... but they can be repaired.

Check out my post from April 16th 2016 above. It might be the reason this does not work (newer version of OADL 1.3)

 

 

 

Edited by Francois Normandin
Link to post
Share on other sites
  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.