To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=11251
------- Additional comments from [EMAIL PROTECTED] Fri Nov 3 08:25:51 -0800 2006 ------- I'm finding the behavior of the "any record" and "next record" fields extremely inconsistent and confusing. But since I'm trying to use these features for the first time, maybe I'm not understanding how it's supposed to work. Here's a test with OOo 2.0.4 (SUSE Linux 10.1 RPM package): 1. Create a new Writer document 2. Select from menu: Insert > Fields > Other... a. Go to the Database tab b. Select "Any record" in the Type list c. Set Record Number to 1 (for first record) d. Click Insert button then Close button 3. Press Enter in the document to add a new line 4. Open Datasources (F4) a. Navigate to a table of a database (I'm using the biblio table of the included Bibliography database) b. Click a heading in the table (e.g. Identifier) c. Drag the heading to the document on the second line (this should insert a field for this record in the document) d. Press Enter to add a new line 5. Go back to Insert > Fields > Other... and add a field of type "record number", put a new line after that, and add a field of type "next record" and add a new line. 6. Copy and paste these last three lines a few times at the end of the document to repeat them. 7. In the datasources area, click the upper-left of the table to select all records, then click the Data to Fields button in the toolbar. 8. Make sure View > Field Names is *un*checked. Actual result: No text in the document, other than the record number fields, which all read "1" Expected result: The first few records of the Identifier fields should be shown, and the record number fields should read follow the sequence 1, 2, 3, etc. 9. Now double-click the Any Record field on the first line of the document. Change the record number to 2 and click OK. 10. Repeat steps 7-8. Actual result: The "expected results" mentioned above occur. Even though the record number entered was 2, it's starting with the *first* record, and the first Record Number field reads "1". (Likewise, if the "any record" field was set to record number 3, it starts with the *second* record.) I can understand numbering records starting with 0, but why would they begin numbering with 2? 11. Finally, add at the end of the document another Any Record field (on its own line) and set the record number to 2 again. 12. Copy everything from the second line of the document to the line before this new Any Record field and paste it below the new Any Record field. 13. Repeat steps 7-8. Now, earlier when I tried this, it displayed the records in an order like the following: <any record,record#2> 1, 2, 3, 4 <any record,record#2> 1, 5, 6, 7 It was as if the Next Record fields were continuing from where they left off instead of continuing from the last Any Record field But this time (as I'm writing this) it's doing what I would have expected: <any record,record#2> 1, 2, 3, 4 <any record,record#2> 1, 2, 3, 4 I cannot figure out why it would do this one way one time and a different way the next. Another issue I encountered is when there are more "Next Record" fields and mail-merge fields than there are records in the database. The mail-merge fields for the records beyond the end of the database show up blank, and in this scenario all subsequent "Any record" fields seem to have no effect at all, regardless of the record number they're set to. It took me a long time to figure out that I had to set the record number for the "any record" field one higher than what I actually wanted, and even longer to figure out why the "any record" fields weren't working (I had inserted more fields than records in the database earlier in the document). Searching the OOo help documentation, OOo forum, or Issuezilla did not come up with *any* clues, leaving me to figure all this out on my own. Therefore, I feel there is either a bug in OOo regarding these fields and/or poor user documentation. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
