To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43152 Issue #:|43152 Summary:|Issue in compatibility with Excel cross page |references. Component:|Spreadsheet Version:|680m79 Platform:|All URL:| OS/Version:|Windows 2000 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|alex_rus
------- Additional comments from [EMAIL PROTECTED] Sat Feb 19 14:12:07 -0800 2005 ------- Hi, it seems there is compatibility issue in Cal with Excel. I understand that it arise due to different way calc handles references but for me it's bug in compatibility of Excel and Calc. The issue is as follow: The usage of complex formulas in Excel leads to error, for example: i used the following formula in Excel: =SUMIF(INDIRECT(CONCATENATE(D$3;"!";"K:K"));$A4;INDIRECT(CONCATENATE(D$3;"!";"I:I"))) As Calc has different cell reference style the formula must be read as: =SUMIF(INDIRECT(CONCATENATE(D$3;".";"K1:K65536"));$A4;INDIRECT(CONCATENATE(D$3;".";"I1:I65536"))) so i must manually correct all formulas as they are not converted automatically. Is there any chance to correct this issue? Basically to make Cal understand ref like =sum(sheet1!C:C) Alexander --------------------------------------------------------------------- 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]