Repository Public
1import Foundation2import Testing3import SheetCore4import SheetFormat5@testable import SheetEngine67@Suite struct EngineIntegration {8 init() { ORIXEngine.bootstrap() }910 func book(_ cells: [String: String]) -> (Workbook, CalcEngine) {11 let wb = Workbook(sheetNames: ["Sheet1"])12 let e = CalcEngine(workbook: wb)13 let p = InputParser(locale: Locale(identifier: "en_US"))14 e.transaction("fill") { for (a1, text) in cells { let r = CellRef(a1: a1)!; try! e.setInput(sheet: 0, row: r.row, col: r.col, text, parser: p) } }15 e.recalculate()16 return (wb, e)17 }1819 @Test func everyEssentialFunctionOfTheBriefIsRegistered() {20 let required = ["SUM", "AVERAGE", "MIN", "MAX", "COUNT", "COUNTA", "COUNTIF", "COUNTIFS", "SUMIF", "SUMIFS", "AND", "OR", "NOT", "XLOOKUP", "VLOOKUP", "HLOOKUP",21 "INDEX", "MATCH", "XMATCH", "FILTER", "SORT", "SORTBY", "UNIQUE", "SEQUENCE", "TEXT", "TEXTJOIN", "LEFT", "RIGHT", "MID", "FIND", "SEARCH", "SUBSTITUTE",22 "DATE", "YEAR", "MONTH", "DAY", "TODAY", "NOW", "PMT", "PV", "FV", "RATE", "NPER", "NPV", "XNPV", "IRR", "XIRR", "MIRR", "STDEV.S", "STDEV.P",23 "VAR.S", "VAR.P", "CORREL", "SLOPE", "INTERCEPT", "LINEST", "NORM.DIST", "NORM.INV", "T.DIST", "T.INV"]24 let missing = required.filter { FunctionRegistry.standard.lookup($0) == nil }25 #expect(missing.isEmpty, "missing: \(missing)")26 for s in FunctionRegistry.standard.all { #expect(!s.summary.isEmpty && s.signature.contains("("), "\(s.name) lacks documentation") }27 print("registered functions: \(ORIXEngine.functionCount)")28 }2930 @Test func crossLibraryModel() {31 let (wb, e) = book([32 "A1": "Region", "B1": "Product", "C1": "Units", "D1": "Price", "E1": "Revenue",33 "A2": "East", "B2": "Widget", "C2": "10", "D2": "2.5", "E2": "=C2*D2",34 "A3": "West", "B3": "Gadget", "C3": "4", "D3": "10", "E3": "=C3*D3",35 "A4": "East", "B4": "Gadget", "C4": "7", "D4": "10", "E4": "=C4*D4",36 "A5": "West", "B5": "Widget", "C5": "3", "D5": "2.5", "E5": "=C5*D5",37 "G1": "=SUMIFS(E2:E5,A2:A5,\"East\")",38 "G2": "=XLOOKUP(\"Gadget\",B2:B5,D2:D5)",39 "G3": "=TEXT(SUM(E2:E5),\"#,##0.00\")",40 "G4": "=ROUND(PMT(0.06/12,360,-250000),2)",41 "G5": "=TEXTJOIN(\", \",TRUE,SORT(UNIQUE(A2:A5)))",42 "G6": "=LET(total,SUM(E2:E5),share,E2:E5/total,ROUND(MAX(share),4))",43 "G7": "=IFERROR(VLOOKUP(\"None\",B2:E5,4,FALSE),\"n/a\")",44 "G8": "=SUM(FILTER(E2:E5,C2:C5>5))",45 "G9": "=YEAR(DATE(2026,11,21))+WEEKDAY(DATE(2026,11,21))",46 "G10": "=ROUND(STDEV.S(C2:C5),6)",47 "I1": "=SORT(FILTER(A2:E5,A2:A5=\"East\"),5,-1)",48 ])49 let s = wb.sheets[0]50 func v(_ a1: String) -> Value { let r = CellRef(a1: a1)!; return s.value(r.row, r.col) }51 #expect(v("G1") == .number(95)); #expect(v("G2") == .number(10)); #expect(v("G3") == .text("142.50"))52 #expect(v("G4") == .number(1498.88)); #expect(v("G5") == .text("East, West"))53 #expect(v("G6") == .number(0.4912)); #expect(v("G7") == .text("n/a")); #expect(v("G8") == .number(95))54 #expect(v("G9") == .number(2033)); #expect(v("G10") == .number(3.162278))55 #expect(v("I1") == .text("East")); #expect(v("M1") == .number(70)); #expect(v("M2") == .number(25))56 // editing an input flows through every library57 e.set(sheet: 0, "C2", .value(.number(20)))58 e.recalculate()59 #expect(v("G1") == .number(120)); #expect(v("M2") == .number(50)); #expect(v("G3") == .text("167.50"))60 }6162 @Test func formatsRenderValues() {63 #expect(NumberFormat.cached("#,##0.00").render(.number(1234.5)).text == "1,234.50")64 #expect(NumberFormat.cached("yyyy-mm-dd").render(.number(46347)).text == "2026-11-21")65 #expect(NumberFormat.cached("0.0%").render(.number(0.1234)).text == "12.3%")66 }67}6869@Suite struct TextOrdering {70 init() { ORIXEngine.bootstrap() }71 @Test func accentsSortNextToTheirBaseLetter() {72 let wb = Workbook(sheetNames: ["S"])73 let e = CalcEngine(workbook: wb)74 #expect(e.evaluate("=\"é\"<\"f\"", sheet: 0) == .bool(true))75 #expect(e.evaluate("=\"é\"=\"e\"", sheet: 0) == .bool(false))76 #expect(e.evaluate("=\"É\"=\"é\"", sheet: 0) == .bool(true))77 #expect(e.evaluate("=TEXTJOIN(\",\",TRUE,SORT({\"Soutien\";\"Équipe\";\"Zèbre\";\"abc\"}))", sheet: 0) == .text("abc,Équipe,Soutien,Zèbre"))78 #expect(e.evaluate("=COUNTIF({\"été\",\"hiver\",\"zèbre\"},\">f\")", sheet: 0) == .number(2))79 #expect(e.evaluate("=MATCH(\"équipe\",{\"abc\",\"Équipe\",\"zèbre\"},1)", sheet: 0) == .number(2))80 }81}82