Apache OpenOffice (AOO) Bugzilla – Issue 19678
Hidden §, cond. Txt, etc: Troubles with db-field names containing a point
Last modified: 2013-02-07 22:39:32 UTC
ABSTRACT: I have two proposals to enhance OOo1.1 or later: 1) Enhanced help on the condition syntax of hidden paragraphs, conditional text, etc. 2) Enhanced syntax of the condition of hidden paragraphs etc. in order to work with databases that contain punctuation and other unusual characters in their field names. EXPLICATORY TEXT: What to do, when a paragraph should only be shown when a specific field whitin a database contains some data? The help says: Insert/Field/Other, select the function tap, then "hidden paragraph", and enter "NOT name" as condition, where "name" is the name of the db-field. Here we are! Now, what to do, if the "name" contains some space, as in "first name". Then you have to enter "NOT [first name]" with brackets. It's a pity that the help of OOo doesn't mention the brackets. Second problem: What must I do when the "name" contains a point, as in "benutzerdef. 1" in the german sdbc:address:mozilla-driver of OOo1.1rc4? I would propose something like "NOT ['benutzerdef. 1']" or 'NOT ["benutzerdef. 1"]'. But both guesses didn't work. And the work around with an SQL-query is a little bit too challenging for a normal user.
reassigned to bh
OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised has the status 'New' pending further action, but has not been updated within the last 4 years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".