[Solved] Link checkbox to writer table

Discuss the word processor

[Solved] Link checkbox to writer table

Postby Nikos » Mon Sep 20, 2010 10:47 am

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
Nikos
 
Posts: 172
Joined: Mon Dec 17, 2007 11:50 am

Re: Link checkbox to writer table

Postby Zizi64 » Mon Sep 20, 2010 2:09 pm

Here is an idea:

My solution based on Document Info as storage device, and I used the Custom Field option as display device. (viewtopic.php?f=7&t=31615)
Controlled by Basic macros (API functions).
Checkbox_value_to_table.odt
(17.16 KiB) Downloaded 168 times
Tibor Kovacs, Hungary; AOO4.0.1, LO3.6.4, LO4.2.2 on WinXPprof.SP3
Zizi64
Volunteer
 
Posts: 1784
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Link checkbox to writer table

Postby Nikos » Mon Sep 20, 2010 2:55 pm

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
Nikos
 
Posts: 172
Joined: Mon Dec 17, 2007 11:50 am

Re: Link checkbox to writer table

Postby Villeroy » Mon Sep 20, 2010 8:52 pm

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 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17320
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Link checkbox to writer table

Postby Zizi64 » Mon Sep 20, 2010 10:11 pm

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 167 times
Tibor Kovacs, Hungary; AOO4.0.1, LO3.6.4, LO4.2.2 on WinXPprof.SP3
Zizi64
Volunteer
 
Posts: 1784
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Link checkbox to writer table

Postby Nikos » Fri Oct 01, 2010 8:08 am

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
Nikos
 
Posts: 172
Joined: Mon Dec 17, 2007 11:50 am


Return to Writer

Who is online

Users browsing this forum: Google Feedfetcher and 26 guests