Launchpad has imported 12 comments from the remote bug at

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at

On 2006-05-31T08:05:37+00:00 Ronny-standtke-d wrote:

I was working on a form letter with a database backend. In this database I 
defined some Boolean fields. In the letter I had some conditional text 
depending on the Boolean fields in the database. Somehow it never worked right 
and I was so frustrated with OOo that I almost gave up.

After many many hours of try and error I noticed that the gray ticks in the 
database table are actually showing a "NULL" value. I was very surprised that 
a Boolean can be "NULL". I was even more surprised that you are defaulting 
to "NULL" when inserting values into a table. And my last surprise was that 
you use a selected(!) checkbox for rendering a "NULL" value.

To avoid the same frustration for other people you should:
- not support "NULL" values for Boolean fields per default (should only be 
supported as an option for database gurus)
- set Boolean fields per default to "FALSE" when inserting data into a 
database table
- use the string "NULL" for rendering "NULL" values

Reply at:

On 2006-06-06T16:14:59+00:00 Christoph-lukasiak wrote:

clu->ronnystandtke: what kind of database do you use?

Reply at:

On 2006-06-07T09:16:00+00:00 Ronny-standtke-d wrote:

> what kind of database do you use?

The kind of database you get when you create a new database with OOo Base 
(OpenDocument Database?). Sorry, I am not familiar with the inner details of 
that format...

Reply at:

On 2006-06-13T12:51:08+00:00 Christoph-lukasiak wrote:

clu->ronnystandtke: then you use the oo native (hsql) db - may you add your (if
not private or confidential) or a sample database file and a step by step
description of what you do, what happens and what you expect to avoid


Reply at:

On 2006-06-13T22:08:45+00:00 Ronny-standtke-d wrote:

Created attachment 37132
Test case

Reply at:

On 2006-06-13T22:16:47+00:00 Ronny-standtke-d wrote:

Take a look at the attached test db. Open the table "Guests" and try inserting 
some data. Notice that the column "Vegetarian" has a NULL value per default. 
Notice also that the NULL value is rendered as a selected checkbox.
This way I thought that the default is "true" where is was actually NULL. 
Notice also that you can set the checkbox to three different states with the 
mouse (including NULL).
I already reported what I expect:
- no NULL values for Boolean fields
- default Boolean fields to "false"
- if you support NULL booleans (e.g. in expert mode) do not use a selected 
checlbox as renderer but the String "NULL"

Reply at:

On 2006-06-20T11:03:55+00:00 Christoph-lukasiak wrote:

not a bug, but a feature enhancement

-> send further to 'requirements'

Reply at:

On 2008-05-15T13:05:52+00:00 Ace-dent-a wrote:

This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please re-test with one of the latest versions of OOo -
the problem(s) may have already been addressed. Either use the recent stable
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be closed or progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further :
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~

Reply at:

On 2008-05-15T18:08:29+00:00 Ronny-standtke-d wrote:

I tested with OOo-2.4 and noticed that you use another icon for rendering NULL
values. Much better.

The problem is that it is still allowed to have NULL values for boolean fields.
It just doesn't make any sense. If I really want to have a three-state field I
would say so. But all I want is a simple boolean yes/no field that can only hold
two states. Is this so complicated?

Reply at:

On 2010-03-03T21:50:33+00:00 collura wrote:

as of OOo 3.2 this is still here.

summary: boolean should default to 2 state for those of us who are simpletons;
also null should not be represented as a half-check.

assuming i am not misunderstanding this issue..

call me oldfashioned but i still think the boolean needs to default to 2

if i need the three state behavior i should select it when defining the base
table field or have some preference defined to select 2 or 3 state for bool
(still default of 2 please).


null rant() {
i can understand the value of the null (user has not specified a choice) 
but as i just spent an hour confused 
because i forgot about 3 state and then furthermore 
because the 3rd state (null) appears to be represented by 'half-a-check' 
which i of course read as a display error of a full check and so 
interpreted as a 'true' which is of course is not..

yes i know (high impedance low voltage, low voltage, high voltage); but you
could just as easily also attribute measurements for electron orbital states 
and mangetoresistance properties and get way more than 2 states along that
argument...but that doesnt make it more understandable to program with.


Reply at:

On 2013-02-02T02:59:39+00:00 Robweir wrote:

This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the 
the latest version of OpenOffice - the problem(s) may already be addressed. 

You can download Apache OpenOffice 3.4.1 from

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the

Reply at:

On 2018-08-04T15:35:51+00:00 OOoForum wrote:

All versions are now obsolete

So, feel free to test last build and reopen if this issue still occurs.

Reply at:

** Changed in: openoffice
       Status: New => Expired

** Changed in: openoffice
   Importance: Unknown => Low

You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

  OpenOffice Database 2.4.1 Boolean Checkbox 3 Mouse Clicks

To manage notifications about this bug go to:

ubuntu-bugs mailing list

Reply via email to