Apache OpenOffice (AOO) Bugzilla – Issue 595
[RFE] restrict input len in formatted fields (was: error entering)
Last modified: 2017-05-20 10:45:19 UTC
I was very happy to see that OpenOffice was able to sort and to store my bibliography and to use it in a text without effort. Great but it doesn't work. My computer: PC with a Celeron 500 320 Mo RAM 1Go free on the Linux partition Linux 2.4.1 (built) binaries of OpenOffice 619 XFree 4.0.1 (binaries) Gnome 1.2.0 (built) (Do you need more informations???) In the bibliography database manager (not the beamer viewer) I'm just not allowed to write a Title that contains more than 80 characters. But what I don't understand that is when I want to use this database in my text, OpenOffice shutdown without any massage. I've managed to write the entire title in the beamer. Steph. PS: I'm student and have to write my PhD report and want to use OpenOffice instead of the other $oft ...
The bibliography part is a wordprocessor part and not a database access part so I change the product.
Reassigned to Eric Savary
> (Do you need more informations???) Well, the main one: what do you exactly when you say: "when I *want to use this database in my text*, OpenOffice shutdown". While inserting an entry? Editing it? Inserting a Bibliography index?? -> this I cannot reproduice. For the other problem (80 chars. only): ok, submission to developpment. NOTE: in the future, please, 1 Problem=1 Issue in IssueZilla... don't mix! Thank you!
After a short test (current build), all text fields are limited to 75 char and 50 for 'Author' and 'Title' (which can content usually the longest strings). As Stephane says, the Beamer part of the Database accepts much more characters in each field.
.
The columns are limited in the database table and so the edit fields restrict the length. The beamer doesn't care about the length :-(.
The behaviour of the controls in the bibliography is not a bug, but a feature :) In general, a text field can have a maximum text length. If -1 is specified for this, no restrictions apply when entering the text. If 0 is specified (which is the case for the bibliography controls), the field obtains the length restrictions from the underlying database field. In our case this means that the edit field looks at the table field, which is defined as "text, length 80" (or something like that), so it limits it's input this way, too. The controls in the grid view of the bibliography are not completely the same as the others (more precise: in the grid control formatted fields instead of edit fields are used). The bug here is that these fields behave different, regarding the maximum text length. I'll fix this for the formatted fields, i.e., after this the input in the grid is restricted the same way as in the lower controls. This restriction is no bug, as everything you enter _more_ than the limit would be rejected (more precise: cutted, more or less silently) by the database driver, as there's simply no room in the dbf file. So if you want to have more characters than this limit, you would need to adjust the bibliography table so that the fields are allowed to contain more data (you could use the table design component for this, to be invoked from the context menu of the table in the data source browser).
P2 -> P3 no guarantee for next build (632), or Frank?
no guarantee :) I have heavy work load at the moment, so may be this will take a while. The more as it's no "fix" for the original "bug" Stephane submitted, but a new (small) feature. Stephane, what about the other effect you described herein? The office crashing if you try to "use the database in your text"?
Stephane, can you confirm that in the latest build (641B), the office does not crash anymore? The change with the field length is still pending, I just want to get ridd off this crash ... Frank
changing the Summary for easier recognition assumed that the crash does not happen anymore (could never reproduce it) due to missing feedback from Stephane
target milestone set to OOo 2.0
changing to ENHANCEMENT
"According to the OpenOffice.org roadmap (http://tools.openoffice.org/releases) this issue was retargeted to OOo Later."
change subcomponent to 'none'
Reset the assignee to the default "issues@openoffice.apache.org".