Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-users@incubator.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <50310811.3090600@hdsnet.hu>
Date: Sun, 19 Aug 2012 17:36:49 +0200
From: =?ISO-8859-1?Q?Reizinger_Zolt=E1n?= <zreizinger@hdsnet.hu>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
 rv:14.0) Gecko/20120713 Thunderbird/14.0
MIME-Version: 1.0
To: ooo-users@incubator.apache.org
Subject: Re: Bug: Field Properties in Table Design dialog of Base
References: <5030F34B.6010008@gmail.com>
In-Reply-To: <5030F34B.6010008@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

2012.08.19. 16:08 keltez�ssel, Dan �rta:
> When using the Table Design dialog to create or modify a table, the 
> default value for the Length property of a given Field Type is not 
> used. This occurs when a field's Field Type is change to another and 
> then changed back.
>      Specifically, this is true for Text [VARCHAR] and Text [CHAR].
>      Examples: Create a table in Design View (opens the Table Design 
> dialog). Enter a name for a field. The Field Type is automatically 
> listed as Text [VARCHAR] Note the Length property. Change the Field 
> Type to Yes/No [BOOLEAN]. The Length property changes to 1. Change the 
> Field Type back to Text [VARCHAR]. The Length property remains 1. 
> Change the Field Type to Binary [BINARY] and not the Length. Now 
> change the Field Type back to Text [VARCHAR]. The Length property does 
> not change.
Hi Dan,

This is an old behavior of OOo I submitted this as enhancement in 2009, 
see: https://issues.apache.org/ooo/show_bug.cgi?id=106964
No solution happens from that time. It is annoying for the first time 
user. A little more experienced Base user, who is design tables, can be 
aware for this, at least it needs to mention in Base guide somewhere. 
The table design contains, the determination of fields sizes, the 
default sizes is a help, but in most cases is useless, if you know what 
are your needs.

This and similar UI tricks made Base harder to use than needed.

Zoltan

> This is also a bug in LO going back at least as far as 3.4.4. A bug 
> report has been filed: Bug #53591. View it here: 
> https://bugs.freedesktop.org/show_bug.cgi?id=53591 for possible 
> additional information.
>
> --Dan
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org