Re: subform (again)

"Frank Schoenheit, Sun Microsystems Germany" <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Hi Franco,

> As for the subform grid, with this set up it works. "Num Doc" field is 
> an Auto-Increment one and it works fine. There are several records 
> already registered for many people, but others haven't any.
> Fill up "Tipo Doc" with "PAE" or "PAI", "Data Reg" with a date, 
> "Parcella" with an amount.  Now, if you try to insert an integer (0 to 
> 20, i.e.) into "AliqIVA" you will be able to add a new record, but if 
> you set that field from 0 to 20 as default, you'll get an error.

Strange enough, I cannot reproduce this. I opened the form in edit mode,
entered a default value for the "AliqIVA" column (0 or 20 or 13 or ...),
left design mode, moved the main form to a record where the sub form
contained no entries, and added a new sub form entry as you described.
No matter whether I left the default value alone, or overwrote it - it
worked like a charm.

> Moreover, if you try to add a calculated field as column in the subform 
> grid, i.e. "Parcella" * "AliqIVA" / 100, you'll get another error.

Now known as http://www.openoffice.org/issues/show_bug.cgi?id=104686.
workaround: Set the "Input Required" property for this column to "No".

>    1. In a report, I need to group data by quarter (date), but it
>       doesn't work.

http://www.openoffice.org/issues/show_bug.cgi?id=104712

>    2. Drag and drop fields between report sections is really a pain.
>       Fields disappear or seem to go random. Mouse position is
>       absolutely not reliable. Same thing if you try to resize a field
>       or a fixed line.

Hmm, cannot reproduce. That's a difficult one, it might depend on screen
resolution and the like, which might are likely to be different on our
machines :(

>    3. Labels have vertical alignement, too, but it really doesn't work.
>       If you set it to "center", i.e., when reopening report, vertical
>       alignement is settled to "standard" again.

Sounds like issue 99058. At least, I just tried in CWS dba32f, and there
the "middle" setting for the vertical alignment is persistent.

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.