To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55244 Issue #:|55244 Summary:|Bug in conversion from excel for function INDIRETTO Component:|Spreadsheet Version:|OOO 2.0 Beta2 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|cedgia
------- Additional comments from [EMAIL PROTECTED] Thu Sep 29 07:27:04 -0700 2005 ------- I have a proble with the attacched file when I converted it from excel in Openoffice calc 2.0 RC1. If you see the table you can view some Err:502. This is generated from function "indiretto" (I am an italian user); only row 4 display correct result; in this row, in a cell f4 I have substituted the function Indiretto with the interval $Motor.$D$31:$D$55. This rappresent the interval named _400_2Poli_IP55 (see menu Insert/name/define) indicated in A29 cell. Excel don't have problem with function Indiretto(A29); Excel resolve the interval name contained in cell A29 and the function CERCA(A31;kw,Indiretto (a29)) can calculated correctly. Openoffice Calc instead solve correctly the interval named "Kw" ($Motor.$A$3:$A$27) but not the interval "_400_2Poli_IP5" Solution? --------------------------------------------------------------------- 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]
