Apache OpenOffice (AOO) Bugzilla – Issue 65309
Hidden paragraph condition fields do not work with database identifiers containing periods
Last modified: 2017-05-20 11:19:37 UTC
To reproduce this problem, create a spreadsheet file with multiple records. Make sure the first row is reserved for field names. Choose "test_field" as the field name. Make some records have a blank field. Save the spreadsheet with a filename that contains extra periods, like so: test.11.05.2006.ods Now create a Writer document. Next to a bit of text like "Dear", insert fields into the document from the spreadsheet file you just created. Add a conditional hidden paragraph field with a condition as shown: NOT test.11.05.2006.Sheet1.test_field Perform a mail merge from the tools menu. In the merged document, the condition is completely ignored. During the merge, there are no visible errors reported. Now re-open the spreadsheet file. Do a "Save As" and save the spreadsheet with a simple name: dud.ods Return to the Writer document. Remove the existing fields, and insert new fields from "dud.ods". Add a conditional hidden paragraph field with the condition NOT dud.Sheet1.test_field. Repeat the merge. Now the hidden paragraph conditional behaves as expected.
Reassigned to ES.
ES->OS: as discussed, field conditions expect DatabaseName.Table.Field. If the DatabaseName contains itself dots such as Data.base.Name, the condition cannot find the database called "Data", the table called "base" and the field called "Name". We should have a mechanism which *looks for* the existing database dynamically and not only expects a fixed syntax.
Reassigned
Reset assigne to the default "issues@openoffice.apache.org".