Hello All.
I have been using OpenOffice 2 builds for some time in an attempt to
build a production database. Though the quality has improved greatly
there are several critical issues that have been present since Beta 1.
I have waited for to be fixed but this has not occurred so I can only
assume they are unreported. I have tried to use issuezilla but I am not
an experienced software developer and so have limited familiarity with
professional software development and the tools that go with it. I am
afraid I was unable to comprehend the issuezilla system so I am posting
here in the hopes of finding some help.
My production database is going fairly smoothly and data entry is
reliable and easier than MS Access. However, three things (mainly) are
causing me frustration. I will list them here.
1) I am certain this is a bug. It is clearly reproducible and has been
with every version since Beta 1. In a database with two or more tables,
I create a form which accesses data from two of these tables. In design
view we can see there is the main form, and within the form heirarchy, a
subform. Call the main form "MF" and the subform "SF". Form MF gets
its data from table T1 and SF gets its data from table T2. It is
possible to link master and slave fields in forms MF and SF so that MF
can pass data directly to SF. This works correctly when only a single
master and slave field are set. However, when multiple master/slave
fields are set the data is passed incorrectly.
For a single master/slave set we would expect to see Value "a" from MF
passed as value "a" to SF. This works as expected. For two fields
being linked, we would expect to see "a;b" from MF appear as "a;b" in
SF. Instead we see "a;b" appear as "a:a".
So using a real-world example, if Table 1 contained names and address
and so on and Table 2 contain names and invoices we could link field
"LastName" in the main form (with data source Table 1) to field
"LastName" in the sub form (with data source Table 2) and then also link
the fields "FirstName" from both tables. So we select from the main
form the record of mister Cameron Mitchell and we would expect to see
"Mitchell; Cameron" appear in the subform. However, as previously
stated, the first linkage appears to override all the others and instead
we see "Mitchell; Mitchell".
I hope this description of the problem is clear enough. This problem is
fully reproduceable.
2) When a form contains a grid showing record details and a new entry is
made to a grid that is visually full and not scrolled down to the
bottom, although data can be entered without error, the grid may begin
to show incorrect entries when it jumps to the bottom of the grid upon
entering new data. This can be cleared by reloading the form, but is
obviously not the correct behaviour for the form. Just to specify
again. The problem is NOT in data entry. Data entered is correctly
stored. However the grid object appears to suffer from misdraw and must
be refreshed to correct the display error.
Related to this is the size of the vertical scroll bar on the grid. If
a certain amount of data is entered in the grid such that it appears
full, the scroll bar will not correctly scroll to the bottom of the list
by dragging it down. If the mouse wheel is used, instead of the bar
progressing downwards it simply gets smaller.
I cannot reliably reproduce these errors but they are common enough that
observing them should not be a problem.
3) The final bug I have noticed is that placing a text box in a form
does not correctly display the data in it but instead seems to act as a
format box set at the default format settings. The form controls for
the object are correctly laid out but the behaviour of the box itself
seems to suggest its object type is set to format box regardless.
Changing the text box to a format box then allows normal alterations to
be made.
I hope that I can get some feedback here and if these are indeed issues
could they please be submitted. Has anyone else encountered these
issues? I would hate for them to make it into the final release.
Thankyou.
Peter Kaye.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
