https://bugs.documentfoundation.org/show_bug.cgi?id=91278
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED Assignee|[email protected] |[email protected] |desktop.org | Summary|xlsx formula not importing |xlsx formula not importing |correctly |correctly, with Table | |structured references in | |named expressions and MATCH | |lookup array creation --- Comment #4 from Eike Rathke <[email protected]> --- There are two (or three) problems: 1. LookUpDateAndTime is a named expression that contains Table structured references. TableRefs in named expressions aren't supported yet. * If occurrences of LookUpDateAndTime in the formulas are replaced with it's content Input[DATE]&Input[TIME] the Err508 goes away. However, the formula then still does not work as can be seen if the IFERROR functionality is removed so the formula reads =INDEX(Input[],MATCH(DATEVALUE(DateVal)&DailySchedule[[#This Row],[time]],Input[DATE]&Input[TIME],0),3) because 2. The DailySchedule table is defined to $'Daily Schedule'.$E$4:$F$36 that does not include a header row and there is no TIME header field. Excel apparently allows such construct and remembers the column headers in the OOXML <table><tableColumns><tableColumn> elements. Importing tableColumns definitions is not implemented yet. * This can be worked around by entering TIME in E3 and defining the DailySchedule name to $'Daily Schedule'.$E$3:$F$36 3. Furthermore, Excel seems to treat the MATCH lookup array argument special, because both Input[DATE] and Input[TIME] evaluate to range references ($'Event Scheduler'.$E$5:$E$17 and $'Event Scheduler'.$F$5:$F$17) with which an implicit intersection reference is created (in LibreOffice, in other context also in Excel) depending on the position of the formula where they are used, so actually only F5:F17 could have meaningful results. * My guess is that Excel internally creates an array of the Input[DATE]&Input[TIME] expression when used as a lookup array argument of the MATCH function. This may be a general feature of the MATCH function, and maybe [HV]LOOKUP as well, and not restricted to TableRef arguments. Needs to be evaluated in Excel. All this is lots to do.. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
