To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78030
------- Additional comments from [EMAIL PROTECTED] Tue Oct 16 12:53:56 +0000 2007 ------- This is not a "feature request" if you are claiming full Microsoft Excel compatibility. If you want to claim such compatibility and enable people switching from Excel to oocalc then its a requirement. I have attached a physics.xls Excel spreadsheet. There are a number of physics constants and conversion factors in it where the constant or conversion factor has an associated defined name, e.g. the conversion factor for calories to joules has a define "cal_to_J". The constant for the speed of light has two defines "LightSpeed" and "LightSpeed_m". When I use these constants in calculations other spreadsheets, I do not type: Physics.xls!Constants!C28 Instead I type Physics.xls!LightSpeed_m Oocalc does not perform the location of the file and lookup of the value for a define in any formulas involving Name Defines in "external" spreadsheets. As a result of this bug, I must still use Excel (under wine which tends to be problematic) instead of using oocalc for dozens of spreadsheets on scientific research projects I have initiated. Two other points in this to be concerned with... 1. In the past when working with Name Defines under Windows 2000 and Office 2000, it seemed as if the full path, e.g. C:\Username\My Documents\ExcelFiles\Physics.xls" may have been maintained within the file. Under Linux, one may want to truncate to the actual filename and search the directory of the referencing sheet, then perhaps either PATH or OpenOfficeFilePath (if such exists) to find the precise file. When Windows could not find the file a popup window would occur allowing you to browse for the file (only if one canceled the file lookup process would the spreedsheets display a cell error indicating the calculation had failed because the name lookup had failed). 2. The selection of a cell, e.g. Constants!C29 (Light Year (km)), pulls up "LightYear km" in the define name box. But the actual define name is "LightYear_km" as can be seen by hitting the define name box down arrow. I do not believe that Microsoft Excel removes the underscores from the name defines and I would consider it misleading to do so, as it would suggest that my external cell reference should be something like "Physics.xls!LightYear km" which would probably fail the lookup unless there is some code in defined name lookups that considers spaces and underscores to be equivalent characters. --------------------------------------------------------------------- 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]
