https://bugs.documentfoundation.org/show_bug.cgi?id=173669
--- Comment #3 from Lars Jødal <[email protected]> --- Created attachment 208697 --> https://bugs.documentfoundation.org/attachment.cgi?id=208697&action=edit Excel versions of the same functions that are new in Calc This attachment was created by opening the .ods file in Excel 365 and saving as native .xlsx (after af few amendments, see below). It can therefore be used for comparison. However: It turns out that my first test was made with an older version of Excel. Excel 365 CAN open the .xlsx exported from LO, but there must be some differnce, as the older Excel can open native .xlsx correctly, but not the one exported from LO. Thus, so the difference will be important only to a minority (like me) who use an older version of Excel on my home computer, rather than paying a yearly fee to Microsoft... You decide what you want to do or not do about that part. Even Excel 365 failed in some details. The array functions using 'inline' functions, =BYROW(A2:C13;MAX) in F2:F13 =BYCOL(A2:C13;AVERAGE) in A17:C17 had only the 'outer' function (BYROW, BYCOL in this case) localized to Danish, but not the 'inner' functions (MAX, AVERAGE in this case). So these have been corrected in this attached .xlsx file. Finally, it appears that Excel cannot handle a cell containing a function value: A47 returns a lambda-function, which can be used with a parameter. In Excel 365, this results in an error: Excel expects the function to be given parameters. LAMBDA functions in Excel appears to be expected to be defined as named functions directly, not as a function in a cell. The use of LAMBDA functions in Excel is described here: https://support.microsoft.com/en-us/excel/functions/lambda-function The ability of LO to define a lambda function by a cell must be considered a feature, not a bug. That Excel does not have this feature is the problem of Excel, not of LO. So: - There appears to be some difference in .xlsx export, but it works much better than I thought (except for old Excel versions). - 'Inline' functions are not exported in a way where they are localized. - LO can handle LAMBDA functions in a way that Excel cannot. -- You are receiving this mail because: You are the assignee for the bug.
