view as bug list
-
150900:
[META] Excel Functions
[NEW; assigned to libreoffice-bugs]
-
44817:
FILESAVE: when saving as XLS, add explicit warning when file cannot be correctly represented (limit of 30 arguments in functions)
[NEW; assigned to libreoffice-bugs]
-
89976:
FEATURE REQUEST:Add PHONETIC function
[NEW; assigned to libreoffice-bugs]
-
96923:
Criteria evaluation of COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS
[NEW; assigned to libreoffice-bugs]
-
106151:
Add a new CELL() function for Excel compatibility
[NEW; assigned to libreoffice-bugs]
-
127624:
Add Excel-compliant version of COUNTIF
[NEW; assigned to libreoffice-bugs]
-
129129:
Add IMAGE Function to Calc
[NEW; assigned to libreoffice-bugs]
-
129361:
YIELD function in Calc provides different result than Excel, when there is one coupon period or less until redemption.
[NEW; assigned to libreoffice-bugs]
-
137465:
YIELD function in Calc provides wrong result (different result than Excel), when bond settlement date is within one coupon period until maturity.
[NEW; assigned to libreoffice-bugs]
-
137543:
Add a LET function into Calc
[ASSIGNED; assigned to balazs.varga991]
-
138749:
Add function LAMBDA for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
150864:
Add TEXTBEFORE function to Calc
[NEW; assigned to libreoffice-bugs]
-
150865:
Add TEXTAFTER function to Calc
[NEW; assigned to libreoffice-bugs]
-
150866:
Add TEXTSPLIT function to Calc
[NEW; assigned to libreoffice-bugs]
-
150867:
Add VSTACK function to Calc
[NEW; assigned to libreoffice-bugs]
-
150868:
Add HSTACK function to Calc
[NEW; assigned to libreoffice-bugs]
-
150878:
Add TOROW function to Calc
[NEW; assigned to libreoffice-bugs]
-
150879:
Add TOCOL function to Calc
[NEW; assigned to libreoffice-bugs]
-
150880:
Add WRAPROWS function to Calc
[NEW; assigned to libreoffice-bugs]
-
150881:
Add WRAPCOLS function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
150997:
Add TAKE function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
150998:
Add DROP function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
150999:
Add CHOOSEROWS function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
151000:
Add CHOOSECOLS function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
151001:
Add EXPAND function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
158620:
TRANSPOSE() should generate a #SPILL! error if cells available are not sufficient to write the result, i.e. Spill range is too big
[NEW; assigned to libreoffice-bugs]
-
161159:
Add GROUPBY, PIVOTBY, PERCENTOF functions to Calc
[UNCONFIRMED; assigned to libreoffice-bugs]
-
161271:
enhancement: support new Excel regex spreadsheet functions, REGEXTEST, REGEXEXTRACT, REGEXREPLACE
[NEW; assigned to libreoffice-bugs]
-
46918:
CONFIGURATION: MS Excel Function compatibility with LO Calc
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
58874:
OFFSET function in array context compatibility with Excel
[RESOLVED FIXED; assigned to erack]
-
69569:
Implementation of YEARFRAC function inconsistent with Excel
[RESOLVED FIXED; assigned to winfrieddonkers]
-
97831:
Please add new functions IFS, MAXIFS, MINIFS, SWITCH, CONCAT, TEXTJOIN (new in Excel 2016 Jan16)
[RESOLVED FIXED; assigned to winfrieddonkers]
-
109409:
TEXTJOIN and CONCAT handle array/matrix column-wise instead of row-wise
[VERIFIED FIXED; assigned to erack]
-
126573:
Add array functions in Calc: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY
[RESOLVED FIXED; assigned to balazs.varga991]
-
127293:
Add XLOOKUP function in Calc
[RESOLVED FIXED; assigned to balazs.varga991]
-
128425:
Add XMATCH function in Calc
[RESOLVED FIXED; assigned to balazs.varga991]
-
131536:
FILEOPEN XLSX TEXT formula gives different result than in Excel
[VERIFIED FIXED; assigned to erack]
-
155369:
Formula Calculation: Indirect() returns #REF!
[VERIFIED FIXED; assigned to dennisfrancis.in]
-
159467:
XLOOKUP does not work if embedded in another XLOOKUP
[RESOLVED FIXED; assigned to balazs.varga991]
-
160711:
XLOOKUP function in search for empty cell
[VERIFIED FIXED; assigned to balazs.varga991]
-
160725:
XLOOKUP has different result for approximate search than Excel
[RESOLVED FIXED; assigned to balazs.varga991]
view as bug list