| |
| Publicado el 22,diciembre 2015 - 15:05 |
In Portugal we have to generate all the editable documents in ODF format if the application is used in one of the government departments.
In Windev it's easy to generate xls or rtf files.
I can't find any option to generate the same files in ODF.
The AAF only works with XLS & RTF.
I can find a lot of XLS* function but i can't find ODT* or ODS* function.
Any tips or advices are welcome.
Thanks |
| |
| |
| | | |
|
| | |
| |
| Publicado el 22,diciembre 2015 - 15:38 |
Hi Paulo,
Isn't ODF just a standard means of encoding office documents (word processor, spreadshseet) files into XML? I've not worked with ODF docs before but is the ODF XML schema available somewhere?
I've noticed that there's an add-in available for M$ Office. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 22,diciembre 2015 - 15:47 |
Hi Darren
I supose so, ODF are the format used by openoffice.
I can find the description here (http://docs.oasis-open.org/office/v1.1/OS/OpenDocument-v1.1.pdf).
I can't find any option in windev to generate ODS files or to convert from XLS to ODS.
We use a lot of tabel controls to take advantage of the AAF features but i can't find any way to generate ODS files instead of XLS or ODT files instead of DOC/RTF. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 22,diciembre 2015 - 17:37 |
Hi Paulo,
maybe there is no short way ? . But if you study the examples "WD Controlling OpenOffice Writer" and "WD Controlling OpenOffice calc" you can find a solution. You could build your files as xls or rtf, then opening them with OpenOffice (via OLE) and saving them as ODF/ODS.
A different approach would be to "write" the data directly to OpenOffice (via OLE) and save the file.
Regards, Heinz |
| |
| |
| | | |
|
| | |
| |
| Publicado el 22,diciembre 2015 - 18:09 |
Hi Heinz,
Unfortunatly this looks like the only solution.
It would be nice if PCSOFT provides ODF support, let's pray for it in some future version.
Thanks |
| |
| |
| | | |
|
| | |
| |
| Publicado el 22,diciembre 2015 - 18:13 |
Hi Paulo,
Sorry - what I was eluding to was that you might have to code it. I mentioned M$ Office as you might be able to use the M$ Office add-in, but maybe OpenOffice has something that is a little bit more "ready to go"?
This might be useful:
http://odf-converter.sourceforge.net/
...and this might be too much, but goes into the subject at a pretty low level:
http://mashupguide.net/1.0/html/ch17.xhtml |
| |
| |
| | | |
|
| | |
| |
| Publicado el 22,diciembre 2015 - 18:33 |
Darren
I can't use the M$ Office way because a lot of the government departments are moving to free software, that's why they issue this law.
I'm goint to try the converter you mention and the Heinz sugestion (usinf the saveas option of the openoffice) to see if i can do something usable. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 22,diciembre 2015 - 19:15 |
I received one answer from PC SOFT about this isue and ODF suport isn't planned to happen.
Unfortunately I will have to code a lot to try to do something similar to the AAF to generate files in ODF or i can not sell to the public sector. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,diciembre 2015 - 05:37 |
Hello Paulo
Why not contact Gembox. They are asking for suggestions on the next format to support so it can't hurt to ask.
http://www.gemboxsoftware
Regards
Al |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,diciembre 2015 - 14:02 |
Paulo,
WD does support automating OpenOffice.
Why not use that and generate required documents.
There are examples provided with WD. For example "WD Controlling OpenOffice Calc".
Do look at them closely.
HTH
Yogi Yang |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,diciembre 2015 - 15:36 |
Hi Yogi,
I know that but as i told in the previous answers i loose the AAF features and i have to change all my apps to generate all the documents using OLE.
I have a lot of options using the XLS*,TABLETOEXCEL and TABLETOWORD functions, it allow me to generate almost all the outputs in the server side (using services) without having excel in the server, to use this kind of behaviour i have to install the openoffice in the server and sometimes it's easy to do it because of the rules imposed by the IT guys of our clients.
My first option at the moment if to convert the already generated documents using the saveas option of the openoffice after the generation of the document.
The use of ODF is mandatory in my country for the public sector and it will take me a lot of time to change all my apps.
As nowadays ODF is a standard format in all of this kind of SW maybe with a little luck PCSOFT think about this in the future. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,diciembre 2015 - 13:30 |
Hi Paulo,
2 possibilities:
1) If you only need to export to odf in 'plain format', then you can create a simple textfile, with 'tab' as a seperator for each column. Name the textfile with an extension of .xls or .ods and you can open it with a spreadsheet.
2) If you need more sophisticated output, then create such a sophisticated ods in OpenOffice, save it, ADD the extension .zip and look into it. You see the different XML-files. You can work on them directly.
We used this latter method in another environment and although in the beginning it is a bit peeking and pooking, at a certain moment you find out what you need to change to get a certain result.
Of course, point 1) is easier to implement and as it is mentioned to use it from the AAF, that might be what you are looking for.
Hope it helps,
Rudolf |
| |
| |
| | | |
|
| | |