sirtimbly/IronCalc
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
feature/brian-finantial-functions-rebased
IronCalc/xlsx/tests/calc_tests
History
Nicolás Hatcher Andrés d4f69f2ec2 UPDATE: Adds missing information functions (#514) 
* UPDATE: Adds missing information functions

Implements N, CELL, INFO and SHEETS

Note that INFO is implemented as N/IMPL! and CELL is not implemented
for those values that is not implemented in Excel for the web

* FIX: Copilot fixes

* FIX: Make clippy happy
2025-11-06 18:58:39 +01:00
..
ABS.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
AND_OR_XOR.xlsx
Add more tests for OR and XOR
2024-12-26 15:06:54 +01:00
ARABIC_ROMAN.xlsx
UPDATE: Adds ARABIC and ROMAN (#509)
2025-11-03 23:44:22 +01:00
arithmetic.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
ATAN2_POWER.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
AVERAGE.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
BASE.xlsx
UPDATE: Implements BASE and DECIMAL (#504)
2025-11-02 23:30:43 +01:00
BESSEL.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
BITs.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
CHOOSE.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
COMBIN_COMBINA.xlsx
UPDATE: Adds COMBIN, COMBINA and SUMSQ (#511)
2025-11-04 22:16:16 +01:00
COMPLEXs.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
CONCAT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
CONCATENATE.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
CONVERT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
COUNT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
COUNTIF.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
COUNTIFS.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
CUMPRINC_CUMIPMT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
DATE_DAY_MONTH_YEAR.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
DATE_TIME.xlsx
date time functions (#425)
2025-10-19 10:19:19 +02:00
DATE.xlsx
refactor(dates): adjust date handling logic for improved accuracy
2024-12-30 13:12:33 +01:00
DB_DDB.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
defined_names_for_unit_test.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
defined_names.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
DOLLARs.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
EOMONTH.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
ERFs.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
ERROR.TYPE.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
escape_strings.xlsx
fix: fix xml escape in worksheet xml
2024-12-31 09:07:39 +01:00
EXACT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
FACT_DOUBLEFACT.xlsx
Bugfix/nicolas bufixes (#491)
2025-10-30 23:24:47 +01:00
FIND_SEARCH.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
FORMULATEXT.xlsx
UPDATE: Adds FORMULATEXT for Steve
2024-11-27 22:28:07 +01:00
FV.xlsx
FIX: Several fixes on the FV function
2024-12-14 22:08:44 +01:00
GCD_LCM.xlsx
UPDATE: Adds GCD and LCM functions (#502)
2025-11-02 19:50:58 +01:00
GEOMEAN.xlsx.disabled
FIX: Run tests again and disable GEOMEAN test
2024-12-13 16:08:46 +01:00
GESTEP_DELTA.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
HVLOOKUP.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
IFNA.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
IFS.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
IPMT_PPMT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
IRR.xlsx
FIX: Test also full rows and columns in IRR function
2024-11-17 11:59:10 +01:00
IS_INFORMATION.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
ISPMT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
ISREF_ISFORMULA_ISODD_ISEVEN.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
issue_341.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
LOG_LOG10_LN.xlsx
UPDATE: Adds LOG10 and LN for Elsa
2025-07-13 00:10:32 +02:00
logical.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
MATCH.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
MIN_MAX.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
MIRR.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
N_CELL_INFO_SHEETS.xlsx
UPDATE: Adds missing information functions (#514)
2025-11-06 18:58:39 +01:00
NOMINAL_EFFECT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
NPER.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
NPV.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
NUMBER_SYSTEMS.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
PDURATION.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
percentage.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
PMT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
PRODUCT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
PV.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
quotes.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
RADIANS_DEGREES_and_mathematical.xlsx
UPDATE: Adds a bunch of mathematical functions (#496)
2025-11-01 19:32:49 +01:00
range_operator.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
RATE.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
REPT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
ROUND.xlsx
FIX: Update xlsx test for ROUND, ROUNDUP
2025-08-09 10:43:19 +02:00
ROW_COLUM.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
RRI.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
simple_arrays.xlsx
UPDATE: Introducing Arrays
2025-03-17 20:04:47 +01:00
simple_functions.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
SLN_SYD.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
SQRT_SQRTPI.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
STRING_HANDLING.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
SUBSTITUTE.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
SUMIF_AVERAGE_IF.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
SUMIFS.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
SUMSQ.xlsx
UPDATE: Adds COMBIN, COMBINA and SUMSQ (#511)
2025-11-04 22:16:16 +01:00
T_VALUE_VALUETOTEXT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
TBILLs.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
TEXT.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
TEXTBEFORE_TEXTAFTER.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
TEXTJOIN.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
TIME_HOUR_MINUTE_SECOND.xlsx
FIX: Adds test for TIME/HOUR/MINUTE/SECOND (#456)
2025-10-19 15:38:11 +02:00
trigonometric_functions.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
TYPE.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
UNICODE.xlsx
Add error cases
2024-11-17 16:49:41 +01:00
XIRR.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
XLOOKUP.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00
XNPV.xlsx
UPDATE: Dump of initial files
2023-11-20 10:46:19 +01:00