<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Google Sheets export to XLSX gives lowercase formula "ifs()"" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130509#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Google Sheets export to XLSX gives lowercase formula "ifs()"" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130509">bug 130509</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>Interestingly, IFS is implemented in LO 5.2 in <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Please add new functions IFS, MAXIFS, MINIFS, SWITCH, CONCAT, TEXTJOIN (new in Excel 2016 Jan16)" href="show_bug.cgi?id=97831">tdf#97831</a> for interoperability with Excel 2016; yet, Excel 2016 does not have this function, and MS documentation only mentions Excel 2019 and 365 as having it [1]. Could it be that this function support was implemented incorrectly in LO? I only have Excel 2016; someone with Excel 2019 is needed to test and provide a reference spreadsheet with this function made in Excel. [1] <a href="https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45?ui=en-US&rs=en-US&ad=US">https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45?ui=en-US&rs=en-US&ad=US</a></pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>