To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=35178
------- Additional comments from [EMAIL PROTECTED] Sat Jan 29 13:56:48 -0800 2005 ------- I've found that when using the given test spreadsheet in the Mail Merge and Data Sources screen it makes two tables, "List1" and "Excel_BuiltIn__FilterDatabase_2". "List1" contains all 78 rows, while "Excel_BuiltIn__FilterDatabase_2" doesn't have the last two. Another interesting fact is that if you convert the spreadsheet to a CSV file using "Save As..." and import that as a Data Source, it gets all the numbers up to the "/" character (ex: 1620108041/103877 from Vymer1 in row 75 appears as 1620108041), but if you look at the file as a spreadsheet the column data is intact. Converting the test spreadsheet to a dBase file is similar, but it changes all the blank cells to "0.00", and adds ".00" to all the other numbers as well. All the missing info in Mail Merge is missing if you do queries on the data in the "Toole > Data Source" dialog as well. This was all discovered in OOo113/winXP. --------------------------------------------------------------------- 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]