Apache OpenOffice (AOO) Bugzilla – Issue 89550
Err:504. =INDEX(Range,pos) to import as =INDEX(Range;1;pos)
Last modified: 2008-05-28 14:05:58 UTC
Due to Excel's overloading of the INDEX syntax, Calc incorrectly imports some INDEX formulae. An Excel sheet containing the formula: =INDEX(Range,n) will, if the Range is a single row or column, find the nth entry in the range, starting from either the left or top of the range. Importing to Calc, I get =INDEX(Range;n) and the error Err:504 Manually correcting it in Calc to =INDEX(Range;1;n) gives the expected result the same as Excel. Files are attached for both Excel and Calc. Jason
Created attachment 53707 [details] Calc file showing import error for INDEX
Created attachment 53708 [details] Excel file that does not import INDEX correctly to Calc
Hi Eike, in Excel if the aray contains only one row or column the corresponding argument is optional. That seems to be the problem here
already fixed in cws_odff3 by #i66930# *** This issue has been marked as a duplicate of 66930 ***
closed because duplicate
Have just downloaded OOo 3.0 Beta, dated 7th May 2008, and the same error occurs. Is there a more recent version I should be testing with? Jason
Created attachment 53719 [details] Screenshot showing the error in Calc 3.0 Beta
Issue 66930 is about the returned value of INDEX when correctly entered in Calc. This issue is about how the formula is imported from .xls files, and is specific to the INDEX function because Calc doesn't allow optional parameters to be omitted in the middle of a parameter list. Given that it is not possible to change the global behaviour of optional parameters in Calc, the import function should be modified to insert sensible values (1 in this case), in place of the missing optional parameters from Excel. This is only required for single-row or single-column references: when Excel has a multi-row or multi-column reference, it needs both row and column parameters, just as Calc does.
Actually this is a duplicate of issue 78781 that is fixed in CWS odff03, see also http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=269 For when the CWS will be integrated monitor http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fodff03 *** This issue has been marked as a duplicate of 78781 ***
Closing dup.