Apache OpenOffice (AOO) Bugzilla – Issue 59204
Report Wizard: Columns using reserved words like table display wrong result
Last modified: 2008-05-20 11:55:58 UTC
If you have a column in a table of view that is named "table" the Report Wizard will generate the report but it will change the field and as: "table_renamed_1" - The problem is that the report is not going to work. Steps to repoduce : Try the following: 3 columns of data, group by two columns, one of them being named "table". Bug found in 2.0.1 RC4. I don't know if the same is appling for other reserved names.
This bug is reproducible on MySQL, PostgreSQL and HSQL Tables. The pattern is "table_renamed_X" where X is an randomly generated integer. In addition to this the report-output is not generated (i.e. shown) and the field-name can not be altered afterwards to make the report work again. Works in 2.0.0.
On Win98SE a Base database (HSQL) doesn't work properly in OOo2.0.0 [680m3 (build:8968)] German version: - create new database - create table with 3 fields: "table" (Text), "test" (Text), "tabelle" (Text) - close table and let OOo create an ID when saving the table - double click on tale in table window and enter some values in two records (table: "what_else" / "text", test: "test" / "nothing", tabelle: "empty" / "aaa" - close table window - right click on table in table window and select report-wizard - select all fields in step 1 - don't change anything in step 2 to 6 expected: report with all the entries result: all fileds except tabelle are filled properly, but in tabelle there is the default text in line 1 "Ut wisi enim ad mimin veniam, quis nostrud exerci", line 2 is empty. I don't have the english version, but I suppose, fieldname "tabelle" will work for you, "table" not. In OOo2.0.1 [680m146[build8989)] German version the bug is reproducible, but with quite a strange behaviour: - I opened the file created with OOo2.0.0 and started the report-wizard expected: wizard works as in OOo2.0.0 (producing default string in filed "tabelle") result: OOo shows crash window in front (Title "Soffice", text: "Diese Anwendung wird aufgrund eines ungültigen Vorgangs geschlossen. ...") but works fine behind of it. The "tabelle" field shows the default text and you may close the report window, rename the reports, close base and OOo without any problem. Afterwards you may close the crash window - if you do it before, OOo is killed and crash reporter starts with next opening. The new report can be opened without any problem. I confirm this issue, even if it seems to be more complex than thought before. Added regression keyword because it worked (at least without crash) in OOo2.0.0. Added crash keyword (even if it doesn't crash fully on Win98SE) @intersol, @simonaw: could you please provide your OS? Best regards Bernhard
Created attachment 32326 [details] Base database with 1 table and two reports created with 2.0.0 and 2.0.1
Hi, I can reproduce this wrong behaviour with the tablefield "table" in the attached database. However I have no crash and in 2.0.0, 2.0.1 and m151 I have the same behaviour. So I remove the keyword regression and send it to the right developer. Bye Marc
.
Resetting target to OOo 2.x
bc: setting target to OOo 2.3
bc: Setting target to OOo.2.x
I could still reproduce the problem in a SRC680/m237. I asked fs to decide for which target this is to be fixed. *** This issue has been marked as a duplicate of 47269 ***
bc: changing target to OOo 3.0 because of lack of resources to take care of this problem.
closed duplicate