[Solved] Link checkbox to writer table

Discuss the word processor
Post Reply
Nikos
Posts: 172
Joined: Mon Dec 17, 2007 11:50 am

[Solved] Link checkbox to writer table

Post by Nikos »

Hello everybody,

I have a hopefully simple question regarding forms in OOWriter.
I would like to insert a checkbox into a writer table (not calc) and assign the value of an adjacent cell to that checkbox. So if the checkbox is ticked, the adjucent cell would get e.g. the value 5.

Is this possible without registering a data source?

Thank you in advance,

Nikos
Last edited by Nikos on Fri Oct 01, 2010 8:08 am, edited 1 time in total.
LibreOffice 4.0.5 on OpenSuse 12.3/64bit/KDE4.10 (Version from the TDF page) + LibreOffice 4.1.1 on Debian Wheezy/64bit/KDE4.8 + LibreOffice 4.1.1 on Win7/64bit
User avatar
Zizi64
Volunteer
Posts: 11352
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Link checkbox to writer table

Post by Zizi64 »

Here is an idea:

My solution based on Document Info as storage device, and I used the Custom Field option as display device. (http://user.services.openoffice.org/en/ ... =7&t=31615)
Controlled by Basic macros (API functions).
Checkbox_value_to_table.odt
(17.16 KiB) Downloaded 285 times
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Nikos
Posts: 172
Joined: Mon Dec 17, 2007 11:50 am

Re: Link checkbox to writer table

Post by Nikos »

Thank you.
Very interesting approach,

The only problem I have is, that the table is quite big (approximatelly 90 checkboxes) and I am not so sure document properties would be the right place to store this amount of information...
LibreOffice 4.0.5 on OpenSuse 12.3/64bit/KDE4.10 (Version from the TDF page) + LibreOffice 4.1.1 on Debian Wheezy/64bit/KDE4.8 + LibreOffice 4.1.1 on Win7/64bit
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Link checkbox to writer table

Post by Villeroy »

You should create a database table with a boolean field keeping as many checkboxes and row-IDs as needed and then you can create a Writer document (a report) with a table that depends on the database content.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Zizi64
Volunteer
Posts: 11352
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Link checkbox to writer table

Post by Zizi64 »

Is this possible without registering a data source?
Here is an another idea with macros:
The values are stored in the macro code.
Checkbox_value_to_table2.odt
(16.71 KiB) Downloaded 279 times
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Nikos
Posts: 172
Joined: Mon Dec 17, 2007 11:50 am

Re: Link checkbox to writer table

Post by Nikos »

Thank you,

and sorry for my delayed answer. This definitevly is a more elegant solution for my cause.
LibreOffice 4.0.5 on OpenSuse 12.3/64bit/KDE4.10 (Version from the TDF page) + LibreOffice 4.1.1 on Debian Wheezy/64bit/KDE4.8 + LibreOffice 4.1.1 on Win7/64bit
Post Reply