Re: subform (again)

Hi Frank,

Frank Schoenheit, Sun Microsystems Germany ha scritto:
> 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.
>   
That's incredible, now I also cannot reproduce it, when before sending 
you my db sample, I never had been able to make it working correctly. 
Really I don't know what I have to think. I'll continue to build my 
application and, if it will happen again, I'll check it more deeply. Sorry.
>   
>> 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".
>   
Ok, thanks.
>   
>>    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
>   
Ok, thanks
>   
>>    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 :(
>   
Strange indeed, beacuse I use a very common monitor and monitor setup: 
Samsung 17", 1024x768, 60 Hz. Yesterday, I was trying to shift down, 
about 10 mm, a group of fields in order to insert a new field on the top 
of the page. It has been impossible for me selecting and shifting down 
all fields at once. At the slighest mouse movement, the entire group 
disappeared or jumped inside the page header. Then, I have had to move 
all fields one by one.
>   
>>    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.
>   
Ok, I'll have a look.
> Ciao
> Frank
>   
many thanks for your readiness to help,

Ciao,
Franco
>   
> ------------------------------------------------------------------------
>
>
> Nessun virus nel messaggio in arrivo.
> Controllato da AVG - www.avg.com 
> Versione: 8.5.409 / Database dei virus: 270.13.75/2340 -  Data di rilascio: 09/01/09 20:03:00
>
>