To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116237 Issue #|116237 Summary|Imported .xls Data Ranges do not display in Data/Selec |t Range Component|Spreadsheet Version|OOO320m18 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|stanheer
------- Additional comments from [email protected] Tue Dec 28 06:30:35 +0000 2010 ------- 1. Create small (4X4) spreadsheet. 2. Define several data ranges 3. Save as .xls 4. Close file. 5. Open file. 6. Data...Select Range is empty. 7. Close. The Ranges are there however as can be seen by creating an ODBC Data Source for the saved Excel file, then opening a new OO document and selecting View...Data Sources. 8. Save the .xls file as .ods 8. Close. 9. Open .ods file - Data Ranges are (still) gone. Issue would not exist (for me) if there were an ODBC Driver for Calc Spreadsheets. I wouldn't have to mess with Excel files for my ODBC Data SOurces. --------------------------------------------------------------------- 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]
