[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Bug 150900 depends on bug 161496, which changed state. Bug 161496 Summary: Names defined in LET() cannot be used for ranges in INDEX() https://bugs.documentfoundation.org/show_bug.cgi?id=161496 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 ady changed: What|Removed |Added Depends on||161496 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=161496 [Bug 161496] Names defined in LET() cannot be used for ranges in INDEX() -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 ady changed: What|Removed |Added Depends on||161454 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=161454 [Bug 161454] LET function, round-trip issue with ms sample for the function. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Bug 150900 depends on bug 137543, which changed state. Bug 137543 Summary: Add a LET function into Calc https://bugs.documentfoundation.org/show_bug.cgi?id=137543 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Gabor Kelemen (allotropia) changed: What|Removed |Added Depends on||161428 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=161428 [Bug 161428] Add SCAN function to Calc for interoperability with MS Excel -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Gabor Kelemen (allotropia) changed: What|Removed |Added Depends on||161399 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=161399 [Bug 161399] Support Spilled range operator in Calc -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Gabor Kelemen (allotropia) changed: What|Removed |Added Depends on||158620 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=158620 [Bug 158620] TRANSPOSE() should generate a #SPILL! error if cells available are not sufficient to write the result, i.e. Spill range is too big -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 V Stuart Foote changed: What|Removed |Added Depends on||161271 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=161271 [Bug 161271] enhacement: support excel new excel regex formulae -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Óvári changed: What|Removed |Added Depends on||161159 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=161159 [Bug 161159] Add GROUPBY, PIVOTBY, PERCENTOF functions to Calc -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Bug 150900 depends on bug 160725, which changed state. Bug 160725 Summary: XLOOKUP has different result for approximate search than Excel https://bugs.documentfoundation.org/show_bug.cgi?id=160725 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Aron Budea changed: What|Removed |Added Depends on||160711 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=160711 [Bug 160711] XLOOKUP function in search for empty cell -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Aron Budea changed: What|Removed |Added Depends on||160725 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=160725 [Bug 160725] XLOOKUP has different result for approximate search than Excel -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Bug 150900 depends on bug 159467, which changed state. Bug 159467 Summary: XLOOKUP does not work if embedded in another XLOOKUP https://bugs.documentfoundation.org/show_bug.cgi?id=159467 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Gerry changed: What|Removed |Added Depends on||129129 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=129129 [Bug 129129] Add IMAGE Function to Calc -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Bug 150900 depends on bug 128425, which changed state. Bug 128425 Summary: Add XMATCH function in Calc https://bugs.documentfoundation.org/show_bug.cgi?id=128425 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Bug 150900 depends on bug 127293, which changed state. Bug 127293 Summary: Add XLOOKUP function in Calc https://bugs.documentfoundation.org/show_bug.cgi?id=127293 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Gabor Kelemen (allotropia) changed: What|Removed |Added Depends on||159467 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=159467 [Bug 159467] XLOOKUP does not work if embedded in another XLOOKUP -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Aron Budea changed: What|Removed |Added Depends on||155369 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=155369 [Bug 155369] Formula Calculation: Indirect() returns #REF! -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||151001 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=151001 [Bug 151001] Add EXPAND function to Calc for interoperability with MS Excel -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||151000 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=151000 [Bug 151000] Add CHOOSECOLS function to Calc for interoperability with MS Excel -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||150999 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150999 [Bug 150999] Add CHOOSEROWS function to Calc for interoperability with MS Excel -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||150998 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150998 [Bug 150998] Add DROP function to Calc for interoperability with MS Excel -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||150997 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150997 [Bug 150997] Add TAKE function to Calc for interoperability with MS Excel -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 --- Comment #1 from Michael Warner --- (In reply to Michael Warner from comment #0) > This is not for VBA functions, those should be filed elsewhere. Bug 108908 seems like a good place for them. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Xisco Faulí changed: What|Removed |Added Ever confirmed|0 |1 CC||xiscofa...@libreoffice.org Status|UNCONFIRMED |NEW -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||131536 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=131536 [Bug 131536] FILEOPEN XLSX TEXT formula gives different result than in Excel -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||109409 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=109409 [Bug 109409] TEXTJOIN and CONCAT handle array/matrix column-wise instead of row-wise -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||97831 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=97831 [Bug 97831] Please add new functions IFS, MAXIFS, MINIFS, SWITCH, CONCAT, TEXTJOIN (new in Excel 2016 Jan16) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||69569 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=69569 [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||58874 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=58874 [Bug 58874] OFFSET function in array context compatibility with Excel -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||46918 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=46918 [Bug 46918] CONFIGURATION: MS Excel Function compatibility with LO Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||138749 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=138749 [Bug 138749] Add function LAMBDA for interoperability with MS Excel -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||137543 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=137543 [Bug 137543] Add a LET function into Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||137465 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=137465 [Bug 137465] YIELD function in Calc provides wrong result (different result than Excel), when bond settlement date is within one coupon period until maturity. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||129361 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=129361 [Bug 129361] YIELD function in Calc provides different result than Excel, when there is one coupon period or less until redemption. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||128425 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=128425 [Bug 128425] Add XMATCH function in Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||127624 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=127624 [Bug 127624] Add Excel-compliant version of COUNTIF -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||127293 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=127293 [Bug 127293] Add XLOOKUP function in Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||126573 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=126573 [Bug 126573] Add array functions in Calc: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||106151 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=106151 [Bug 106151] Add a new CELL() function for Excel compatibility -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||96923 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=96923 [Bug 96923] Criteria evaluation of COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||89976 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=89976 [Bug 89976] FEATURE REQUEST:Add PHONETIC function -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||44817 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=44817 [Bug 44817] FILESAVE: when saving as XLS, add explicit warning when file cannot be correctly represented by the file format (# of function args) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||150865 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150865 [Bug 150865] Add TEXTAFTER function to Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||150868 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150868 [Bug 150868] Add HSTACK function to Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||150867 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150867 [Bug 150867] Add VSTACK function to Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||150864 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150864 [Bug 150864] Add TEXTBEFORE function to Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||150866 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150866 [Bug 150866] Add TEXTSPLIT function to Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||150879 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150879 [Bug 150879] Add TOCOL function to Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||150878 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150878 [Bug 150878] Add TOROW function to Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||150880 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150880 [Bug 150880] Add WRAPROWS function to Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Depends on||150881 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150881 [Bug 150881] Add WRAPCOLS function to Calc for interoperability with MS Excel -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Version|7.4.0.0 beta1+ |unspecified -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Alias||Excel-Functions -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150900] [META] Excel Functions
https://bugs.documentfoundation.org/show_bug.cgi?id=150900 Michael Warner changed: What|Removed |Added Blocks||108827 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
