To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44019 Issue #:|44019 Summary:|Error with named ranges importing Excel doc Component:|Spreadsheet Version:|OOo 1.1.2 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|open-import Assigned to:|spreadsheet Reported by:|kylebateman
------- Additional comments from [EMAIL PROTECTED] Thu Mar 3 13:10:16 -0800 2005 ------- I have an Excel-created spreadsheet that has a bunch of formulae which reference named cells from a vlookup function. It looks like the original sheet has named cell ranges on each sheet which have the same name (unique per sheet, but not unique across the whole spreadsheet). The importer seems to try to rename certain of the named ranges to something different (like Heat1___1 rather than the original Heat1). But it still seems to have duplicates across most of the sheets. This renaming takes place on all sheets except the one called "10 Cars" which looks like the way it is in Excel. The formula (in the Score column) on sheets "8 Cars" and "4 Cars" work (after putting in valid data to the Place columns). On all the other sheets, they just yield Err:502 (no matter the data). "8 Cars" and "4 Cars" also show Err:502 until valid data is put in. You're supposed to put the numbers "1, 2, 3, or 4" in the "Place" column to show which car came in in which place (in a race). Then the score and place columns should show which cars are the winners. BTW, Excel shows 0's in the Score column until data is input--openoffice shows Err:502. That's not a major issue, but a difference. The main issue is I end up with a bunch of non-uniquely named ranges which the vlookups seem to choke on . I'll attach the file. --------------------------------------------------------------------- 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]