[sc-issues] [Issue 109940] Data Pilot DEFECT
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109940 --- Additional comments from r...@openoffice.org Tue Mar 30 15:43:17 + 2010 --- Created an attachment (id=68640) testcase - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 109940] Data Pilot DEFECT
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109940 User raal changed the following: What|Old value |New value CC|'cornouws,gibi' |'cornouws,gibi,raal' --- Additional comments from r...@openoffice.org Tue Mar 30 15:42:04 + 2010 --- Reproducible with version 3.2 I will attach another test case. Seems that datapilot has some limit 16386 rows. Dataloss without warning, please consider target 3.2.1. Attachment - sheet List1, column D reproduce contains unique records. Sheet Průvodce daty_List1_2 is data pilot from column List1.D There is 27722 rows on sheet List1. DataPilot takes only 16384 rows. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 109940] Data Pilot DEFECT
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109940 User cornouws changed the following: What|Old value |New value CC|''|'cornouws' - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 109940] Data Pilot DEFECT
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109940 --- Additional comments from g...@openoffice.org Mon Mar 29 16:44:36 + 2010 --- Perhaps I didn't understand the issue but imha the result is ok as far as there are duplicate values of BNAME (for example, 2 x N1AW, 2 x N1B1, and so on). So what your Data Pilot is asked for is to give one line per item. You can verify that the number is correct by comparison with a Standard filter on your source with: - column BNAME = 'non empty' - More Options: - 'no duplicate' - 'Copy result to ...' free cells = CountA on the filtered result in the status bar give 16385 lines (including title 'BNAME') - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 109940] Data Pilot DEFECT
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109940 User gibi changed the following: What|Old value |New value CC|'cornouws'|'cornouws,gibi' - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 109940] Data Pilot DEFECT
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109940 --- Additional comments from ohal...@openoffice.org Mon Mar 29 17:24:33 + 2010 --- duplicate values of BNAME (for example, 2 x N1AW, 2 x N1B1, and so on). No. A more in-depth look is needed here. If you browse the last lines of the source you will see entries that are not listed in the data pilot. for example: SOG11 SOGG2 SOJP1 SOJP2 SOLMAN_RFC 1 SOLMANSMD1802 SOLMANSOL1921 SOLMANSOL1922 SOLTMWSMD1801 SOLTMWSOL1922 SOLTMWSOL1921 while the data pilot goes only up to SJD11 SJK22 SJPR1 SJSB1 SK011 circa line 16387. Regards, Olivier - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 109940] Data Pilot DEFECT
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109940 Issue #|109940 Summary|Data Pilot DEFECT Component|Spreadsheet Version|OOo 3.2 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|ohallot --- Additional comments from ohal...@openoffice.org Mon Mar 8 15:46:16 + 2010 --- The attached data pilot table (pivot table), contains a extreme situation that leads to error in OpenOffice.org with no warning. The source sheet contains 20305 entries, in column A (header is BNAME) The data pilot is built in the following manner 1)select all cells in BNAME 2)Start the data pilot 3)Drag BNAME in the line field (on the left) 4)drag BNAME in the data field (center) 5)Select COUNT in Options 6)Click in More... and assign a new sheet for the data pilot. 7)Click OK The resulting data pilot, will be placed in a new sheet. We are not concerned on the results of the data pilot (column B). It does count the number of similar occurences of BNAME entries. We think there is an error because the data pilot size is 16387 lines and some entries of the source sheet in BNAME are missing, with no warning (look at the last ones in the source, they do not show in the data pilot). Please advise if this is wornking as expected. We think we have a DEFECT. We must emphasize that the data pilot came from an EXCEL 2003 spreadsheet, and Excel pivot table does show all entries in BNAME. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 109940] Data Pilot DEFECT
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109940 --- Additional comments from ohal...@openoffice.org Mon Mar 8 15:48:03 + 2010 --- Created an attachment (id=68220) Data pilot defect sample - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
