[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||161711 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=161711 [Bug 161711] Add COUNTUNIQUE function -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 158789, which changed state. Bug 158789 Summary: Allow SUMIF and SUBTOTAL to apply to arrays https://bugs.documentfoundation.org/show_bug.cgi?id=158789 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 161235, which changed state. Bug 161235 Summary: Function AVERAGE in Calc is not compatible with Excel when logical values are used https://bugs.documentfoundation.org/show_bug.cgi?id=161235 What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |WONTFIX -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Rafael Lima changed: What|Removed |Added Depends on||161235 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=161235 [Bug 161235] Function AVERAGE in Calc is not compatible with Excel when logical values are used -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 160753, which changed state. Bug 160753 Summary: XMATCH function in search for empty cell is different to Excel https://bugs.documentfoundation.org/show_bug.cgi?id=160753 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||160753 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=160753 [Bug 160753] XMATCH function in search for empty cell is different to Excel -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||160893 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=160893 [Bug 160893] XLOOKUP problem with date as text -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Aron Budea changed: What|Removed |Added Depends on||160616 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=160616 [Bug 160616] SUMPRODUCT calculation is broken in some cases, if the ranges are beyond the last cell with data -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||159764 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=159764 [Bug 159764] Implement AVERAGE.WEIGHTED Function in LibreOffice Calc -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||133243 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=133243 [Bug 133243] Formatting cause random generated letters to be regenerated -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 ady 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.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 raal changed: What|Removed |Added Depends on||159544 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=159544 [Bug 159544] Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 137541, which changed state. Bug 137541 Summary: External links in Calc via INDIRECT() always require an update to show values on file open https://bugs.documentfoundation.org/show_bug.cgi?id=137541 What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||159082 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=159082 [Bug 159082] Calc INDIRECT() links faulty in folders other than ~/documents on FILEOPEN -- You are receiving this mail because: You are the assignee for the bug.
[Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||158789 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=158789 [Bug 158789] Allow SUMIF and SUBTOTAL to apply to arrays -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||158247 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=158247 [Bug 158247] Allow F1 in Formula Bar inside formulas to work as in Function Wizard's Formula -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 127498, which changed state. Bug 127498 Summary: TIMEVALUE() sometimes returns a slightly less or greater than expected value https://bugs.documentfoundation.org/show_bug.cgi?id=127498 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||157948 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=157948 [Bug 157948] Offset function using negative numbers for height or width works in Microsoft Excel, not in Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 157948, which changed state. Bug 157948 Summary: Offset function using negative numbers for height or width works in Microsoft Excel, not in Calc https://bugs.documentfoundation.org/show_bug.cgi?id=157948 What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTOURBUG -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 144692, which changed state. Bug 144692 Summary: YEAR() / MONTH() / DAY() give results inconsistent with entered/displayed dates https://bugs.documentfoundation.org/show_bug.cgi?id=144692 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |DUPLICATE -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||157396 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=157396 [Bug 157396] When choosing Italian language, REPLACE function is translated as SUBSTITUTE and vice versa -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Aron Budea changed: What|Removed |Added Depends on||99308 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=99308 [Bug 99308] Amordegrc using obsolete values for degressive amortisation -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||132003 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=132003 [Bug 132003] No way to enable external content for a newly created spreadsheet -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 142905, which changed state. Bug 142905 Summary: LEFT() and empty space at the beginning in .xlsx https://bugs.documentfoundation.org/show_bug.cgi?id=142905 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||152943 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=152943 [Bug 152943] GetErrCode() doesn't work as expected on RISC-V due to floating-point NaN payload not being propagated -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 155402, which changed state. Bug 155402 Summary: FILEOPEN XLSX CELL() function gives different value compared to Excel with filename parameter https://bugs.documentfoundation.org/show_bug.cgi?id=155402 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 155805, which changed state. Bug 155805 Summary: Support for string concatenation with separator https://bugs.documentfoundation.org/show_bug.cgi?id=155805 What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Eyal Rozenberg changed: What|Removed |Added Depends on||155805 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=155805 [Bug 155805] Support for string concatenation with separator -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 141042, which changed state. Bug 141042 Summary: Feature request: add a new function REVERSE(string) https://bugs.documentfoundation.org/show_bug.cgi?id=141042 What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |INVALID -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||11 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=11 [Bug 11] Trim function making index/match or lookup functions calculate all spreadsheet rows instead of data interval -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||150648 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150648 [Bug 150648] EAN13 function works in spreadsheet with LibreOffice 7.3 not 7.4 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||134367 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=134367 [Bug 134367] CALC new formulas: Written down value & written down depreciation -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||155424 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=155424 [Bug 155424] LISTIF function -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 155369, which changed state. Bug 155369 Summary: Formula Calculation: Indirect() returns #REF! https://bugs.documentfoundation.org/show_bug.cgi?id=155369 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Gabor Kelemen (allotropia) changed: What|Removed |Added Depends on||155402 See Also|https://bugs.documentfounda | |tion.org/show_bug.cgi?id=15 | |5402| Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=155402 [Bug 155402] FILEOPEN XLSX CELL() function gives different value compared to Excel with filename parameter -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Gabor Kelemen (allotropia) changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||5402 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||147671 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=147671 [Bug 147671] Only works to Excel generated ActiveCell in the first open file, failed after save and reopen -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||140722 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=140722 [Bug 140722] calc: storing of rounded values and recalculation on load harming display after reload | was: calc: save-load-cycle: some cells shown with wrong value until recalc (F9) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||121488 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=121488 [Bug 121488] ERROR.TYPE for "Search out of range" in Excel return 7 but in Calc #N/D -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||130536 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=130536 [Bug 130536] [FEATURE] Add Ability to Retrieve Financial Data (Stocks) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 128800, which changed state. Bug 128800 Summary: INDEX function insufficiently documented (see comment 8) https://bugs.documentfoundation.org/show_bug.cgi?id=128800 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |DUPLICATE -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||117893 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=117893 [Bug 117893] besselj gives error for negative order -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||120564 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=120564 [Bug 120564] EDITING Add mean absolute deviation from median -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||131526 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=131526 [Bug 131526] Random number generator Option no duplicates -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 BogdanB changed: What|Removed |Added Depends on||113974 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=113974 [Bug 113974] Ability to parse/filter JSON data and extract fields -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||154163 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=154163 [Bug 154163] Change "Degrees freedom" to "Degrees of freedom" -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||153539 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=153539 [Bug 153539] EDITING Some Calc functions get extra leading space character every time the formula is edited (same with save + reload) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 153297, which changed state. Bug 153297 Summary: A complex formula does not work in Calc 7.4.x; (MATCH function) https://bugs.documentfoundation.org/show_bug.cgi?id=153297 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |NOTABUG -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 raal changed: What|Removed |Added Depends on||153297 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=153297 [Bug 153297] A complex formula does not work in Calc 7.4.x; (MATCH function) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||153208 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=153208 [Bug 153208] Regression Analysis Error: LINEST array #VALUE! errors on specific dependent variables -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 152774, which changed state. Bug 152774 Summary: MATCH and HLOOKUP/VLOOKUP return incorrect result when searching for a string in a mixed numeric/string matrix https://bugs.documentfoundation.org/show_bug.cgi?id=152774 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||152774 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=152774 [Bug 152774] MATCH returns incorrect result when searching for a string in a mixed numeric/string matrix -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 133840, which changed state. Bug 133840 Summary: Calc Math error on INTEGER function https://bugs.documentfoundation.org/show_bug.cgi?id=133840 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |NOTABUG -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Buovjaga changed: What|Removed |Added Depends on||146811 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=146811 [Bug 146811] COUNTIF(...; "") does not count empty string formula results -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||152292 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=152292 [Bug 152292] LARGE() and SMALL(): inconsistencies between app and Help pages -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 150011, which changed state. Bug 150011 Summary: Add Croatian Kuna to Euroconvert function https://bugs.documentfoundation.org/show_bug.cgi?id=150011 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||152148 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=152148 [Bug 152148] The Polish version: MAKS.K(dane; rząd_K) ≡ LARGE(…; …) and MIN.K() -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Buovjaga changed: What|Removed |Added Depends on||146017 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=146017 [Bug 146017] HYPERLINK() entry dies once it attempts to link to #N/A result and undo is applied -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 123811, which changed state. Bug 123811 Summary: HYPERLINK Function includes everything written in the cell https://bugs.documentfoundation.org/show_bug.cgi?id=123811 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WONTFIX -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Bug 108827 depends on bug 152014, which changed state. Bug 152014 Summary: Wrong result with match function when multiple spreadsheets are opened https://bugs.documentfoundation.org/show_bug.cgi?id=152014 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||152014 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=152014 [Bug 152014] Wrong result with match function when multiple spreadsheets are opened -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||123811 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=123811 [Bug 123811] HYPERLINK Function includes everything written in the cell -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on|93799 | Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=93799 [Bug 93799] Disabled status bar re-appears after sorting data -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||151851 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=151851 [Bug 151851] Sorting array formula works differently in Calc compared to Excel -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||142905 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=142905 [Bug 142905] LEFT() and empty space at the beginning in .xlsx -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||150782 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150782 [Bug 150782] [FILEOPEN] NUMBERS filter misinterpreting DURATION function -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Depends on||151426 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=151426 [Bug 151426] Feature request: extend IFERROR/IFNA to other predicates -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Michael Warner changed: What|Removed |Added Depends on||150900 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=150900 [Bug 150900] [META] Excel Functions -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> 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 108827] [META] Calc functions bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108827 Roman Kuznetsov <79045_79...@mail.ru> 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.
