Apache OpenOffice Community Forum

Hi guys,

I would like to add a checkbox on a Sheet on Calc program using Java code.

Now, I have all the code to connect to the file, but I don't know how add a checkbox on the sheet and using after that in my code.

I will be so happy if you could say how do it and where I could find a good reference of the API for Java.

Thanks.

Put it onto the sheet manually, and control the visibility of it by your code.

The LO API is same for every programming languages. (maybe you can not control/handle some feature in one or the other IDE/language, but the API functions, procedures and objects are same.)

There appear to be very few people using OO with Java and therefore relatively few resources available and few people to help you. You'll usually be able to find what you want to do in Basic and will have to translate.

https://wiki.openoffice.org/wiki/Docume ... and_Shapes

Zizi64 wrote:Put it onto the sheet manually, and control the visibility of it by your code.

The LO API is same for every programming languages. (maybe you can not control/handle some feature in one or the other IDE/language, but the API functions, procedures and objects are same.)

How can I control the visibility of it by code? Sorry, but I'm learning this API.

Thanks for your help.

JeJe wrote:There appear to be very few people using OO with Java and therefore relatively few resources available and few people to help you. You'll usually be able to find what you want to do in Basic and will have to translate.

https://wiki.openoffice.org/wiki/Docume ... and_Shapes

This link is wonderfull for my needs. Thank you so much.

Setting the visibility is an example of what I was saying about finding it in Basic and translating. The API is the same for all languages

viewtopic.php?f=20&t=27081

.setvisible(false) or .setvisible(true)

You might find MRI helps. You can inspect an object and easily see all its properties and methods such as setvisible.

https://extensions.openoffice.org/en/pr ... ction-tool

It can help you write your code, for example

viewtopic.php?t=55835#p245258

Generating complex form documents by code is a misconception. Simply use templates. Templates provide the core functionality of any office suite.

JeJe wrote:You might find MRI helps. You can inspect an object and easily see all its properties and methods such as setvisible.

https://extensions.openoffice.org/en/pr ... ction-tool

It can help you write your code, for example

viewtopic.php?t=55835#p245258

Very useful. I will try it.

Villeroy wrote:Generating complex form documents by code is a misconception. Simply use templates. Templates provide the core functionality of any office suite.

I will study this option. Thanks.

A template is an almost normal office document with all the layout, formatting, form controls and contents except for content that needs to be added by a user. A template opens as a new document with a document title like "Untitled 1". When the user saves it, he will be prompted for the path name of a new document. You open a letter template for a new letter and type in the letter text. You open a productivity template for a new profit calculation with all layout, formatting, input cells and formulas predefined. SInce more than 30 years, this is the core of office software and it does not require any kind of programming skills.

Look at this link for using the LO/OO API in JAVA
http://fivedots.coe.psu.ac.th/~ad/jlop/#contents
I believe chapter 40 discusses checkboxes

Wow you're awsome! Thanks a lot for your help. Now I have how start my study.