Hi Frank,
since in the meantime I ran into other troubles, here is a new summary
of all what I found, with the clarifications (I hope :-) ) you asked me:
I'm using OpenOffice 3.1 Official Release with Win XP Pro
Forms:
SELECT "TipoDoc", "NumDoc", "DataReg", "IdCont", "Causale", "Parcella",
"AliqIVA", "Parcella" * "AliqIVA" / 100 AS "IVA" FROM "Avere" AS "Avere"
WHERE ( "TipoDoc" = 'PAE' OR "TipoDoc" = 'PAI' )
1. This query is editable if used alone, also having a calculated
field. But as source of a subform grid, linked to main form by
"IdCont", it doesn't work anymore. "IVA" is the calculated field I
need for checking data only. The program doesn't execute the query
but prompts for data input also for that field. Removing IVA
column fron grid, all work fine.
2. In any column of a subform grid, it's possible to pre-set a
default value (Standard Value) like in table fields. That's true
in theory, however, because if I set "AliqIVA" to 0, or 20, or to
whatever else number, the subform grid doesn't work anymore.
Without any calculated fields, obviously.
Reports:
1. In a report, I need to group data by quarter (date), but it
doesn't work. If you select "quarter" in Sorting and Grouping
window, in fact the program groups data on month and, if you close
and reopen the report, you find the Group settled on "month", not
on "quarter".
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. Often, when trying to move a field to the right
side, the entire report shifts to the opposite and I cannot
realize the actual position I am.
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.
4. Fixed Lines cannot cross each other. This is a hard restriction
for any layout.
Finally, about fixed lines, if they will be more widely re-implemented,
as you told me, perhaps it cannot worth that I file an issue for a
limited enhancement like colors, isn't?
Thanks in advance,
Franco
Frank Schoenheit, Sun Microsystems Germany ha scritto:
Hi Franco,
1. A query with one or more calculated fields doesn't work if used as
source for a subform grid. The same query alone works perfectly.
Cannot reproduce. How is your setup, exactly?
2. I'm not able to call any macro by en event from inside any column
(receiving focus, i.e.) of a subform grid. It seems something like
what is described in the issue 60604, wich is formally closed as
fixed.
Well, yes ... as written in the issue, looking into the code, it seems
there has *never ever* been any code for supporting this for table
columns. Basically, the events slipped into the property browser by
accident :)
Nonetheless, it makes sense implementing them.
3. In subform grids, Standard Values (default) don't work.
Cannot reproduce. Again, can you elaborate, please?
1. Fixed lines: I'm not able to draw any vertical line, only
orizontal. Or, better, I can see a vertical line drawn in Report
Designer window, but it disappear in Report preview.
http://www.openoffice.org/issues/show_bug.cgi?id=104447
2. Fixed lines: Users can change colors for any report's object but
fixed lines. They are black, only. This seems to need an enhancement.
Feel free to submit one :)
Though I am not sure we should invest into the current lines, they have
some other quirks, too, so I think they should be re-implemented to be
more like the lines in e.g. Draw.
Ciao
Frank
------------------------------------------------------------------------
Nessun virus nel messaggio in arrivo.
Controllato da AVG - www.avg.com
Versione: 8.5.387 / Database dei virus: 270.13.65/2322 - Data di rilascio: 08/23/09 18:03:00
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
