To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73831 Issue #|73831 Summary|"NextRecord" breaks conditional formating Component|Word processor Version|OOo 2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|mru Reported by|rkollien
------- Additional comments from [EMAIL PROTECTED] Wed Jan 24 10:03:31 -0800 2007 ------- Hello, querying the bugs database i found some bugs regarding the problem, that using the "NextRecord" field command (Feldbefehl in german) breaks the evaluation of conditional formating. As i found, all issues are marked as "fixed", but in my constellation, the problem still exists. I have a database (tried ODBC, csv, Calc-table; no difference) with some records containing accounting info. I created a writer document with a table with enough rows to hold the maximum possible records for one bill. Each table row (=database record) should be preceded by a little text. When the records are less than the number of rows, the row of course shouldn't contain this text. So i defined a conditional text like database.table.field NEQ "" "Preceding Text " ELSE "". This is ok until the _last_ record is retrieved. In all subsequent rows following the _last retrieved_ record, they evaluate like the last one did. IMO, when the "end-of-file" is reached, evaluating the conditionals are stopped. Reproducing this issue is very simple and works for all versions of OOo: 1) Create a CSV file containing some fields (lets assume "Name" and "Street") and enter two (2) records: "Bugsbunny";"Top of the hill" "Donald Duck";"Somewhere" 2) Make a data connection to access the csv file in Writer 3) Create an empty Writer document, insert a table with five(!!) rows and three columns. 4) Drag'n'drop "Name" to the first col on each row, "Street" to the third. 5) In column two insert a conditional text like db.table.Street EQ "Somewhere" "this shouldn't happen" ELSE "". 6) After the database field "Street" in each of the five rows insert the "NextRecord" field (not in the last row, but that doesn't matter). 7) Print and you will see. Row three to five have "this shouldn't happen" in column two as the last printed record evaluated to this. --------------------------------------------------------------------- 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]