SPB Git

Repository Public

CoreTests.swift 21.1 KB 466 lines swift

1import Foundation2import Testing3@testable import SheetCore45/// Small harness: one sheet, set cells by A1 text, read computed values.6final class Book {7    let wb = Workbook(sheetNames: ["Sheet1"])8    let engine: CalcEngine9    let parser = InputParser(locale: Locale(identifier: "en_US"))10    init() { engine = CalcEngine(workbook: wb) }11    func set(_ a1: String, _ text: String, sheet: Int = 0) {12        let ref = CellRef(a1: a1)!13        try! engine.setInput(sheet: sheet, row: ref.row, col: ref.col, text, parser: parser)14    }15    func get(_ a1: String, sheet: Int = 0) -> Value {16        engine.recalculate()17        let ref = CellRef(a1: a1)!18        return wb.sheets[sheet].value(ref.row, ref.col)19    }20    func num(_ a1: String, sheet: Int = 0) -> Double { get(a1, sheet: sheet).numberValue ?? .nan }21    func formula(_ a1: String, sheet: Int = 0) -> String {22        let ref = CellRef(a1: a1)!23        return engine.inputText(sheet: sheet, row: ref.row, col: ref.col)24    }25    func eval(_ f: String) -> Value { engine.evaluate(f, sheet: 0) }26}2728@Suite struct AddressTests {29    @Test func columnNames() {30        #expect(A1.columnName(0) == "A")31        #expect(A1.columnName(25) == "Z")32        #expect(A1.columnName(26) == "AA")33        #expect(A1.columnName(16383) == "XFD")34        #expect(A1.columnIndex("XFD") == 16383)35        #expect(A1.columnIndex("XFE") == nil)36        #expect(CellRef(a1: "B3") == CellRef(2, 1))37        #expect(CellRef(a1: "A1048577") == nil)38        #expect(RangeRef(a1: "A:C")?.isWholeColumns == true)39        #expect(RangeRef(a1: "$B$2:$D$5") == RangeRef(r0: 1, c0: 1, r1: 4, c1: 3))40        #expect(RangeRef(r0: 1, c0: 1, r1: 4, c1: 3).a1 == "B2:D5")41    }42}4344@Suite struct ParserTests {45    func rt(_ s: String) -> String { (try? FormulaParser.parse(s).formulaText()) ?? "ERR" }4647    @Test func roundTrip() {48        for f in ["1+2*3", "(1+2)*3", "-A1^2", "SUM(A1:B2,C3)", "'My Sheet'!$A$1:$B$2", "Sheet2!A1", "IF(A1>=10,\"big\",\"small\")",49                  "{1,2;3,4}", "A:A", "$1:$3", "50%", "A1#", "\"a\"\"b\"", "#N/A", "1E-05", "PMT(0.05/12,360,,1)", "Table1[Amount]",50                  "Table1[[#Headers],[Amount]]", "LET(x,5,x*2)", "LAMBDA(a,a+1)(3)", "A1:INDEX(B:B,3)", "1.5E+20", "@A1:A10", "LOG10(100)", "A1<>B1"] {51            #expect(rt(f) == f, "\(f)")52        }53    }5455    @Test func precedence() throws {56        let b = Book()57        #expect(b.eval("=-2^2") == .number(4))58        #expect(b.eval("=2^3^2") == .number(64))59        #expect(b.eval("=1+2*3") == .number(7))60        #expect(b.eval("=10%*50") == .number(5))61        #expect(b.eval("=2*-3") == .number(-6))62        #expect(b.eval("=1&2+3") == .text("15"))63        #expect(b.eval("=1+1=2") == .bool(true))64    }6566    @Test func errors() {67        #expect((try? FormulaParser.parse("=1+")) == nil)68        #expect((try? FormulaParser.parse("=SUM(1,2")) == nil)69        #expect((try? FormulaParser.parse("=\"abc")) == nil)70        #expect((try? FormulaParser.parse("={1,2;3}")) == nil)71        #expect((try? FormulaParser.parse(String(repeating: "(", count: 500) + "1" + String(repeating: ")", count: 500))) == nil)72    }7374    @Test func semicolonSyntax() throws {75        let e = try FormulaParser.parse("=SUM(1,5;2,5)", syntax: .semicolon)76        #expect(e.formulaText() == "SUM(1.5,2.5)")77        #expect(e.formulaText(syntax: .semicolon) == "SUM(1,5;2,5)")78    }7980    @Test func xlfnPrefix() throws {81        #expect(try FormulaParser.parse("=_xlfn.XLOOKUP(1,A:A,B:B)").formulaText() == "XLOOKUP(1,A:A,B:B)")82    }83}8485@Suite struct SemanticsTests {86    @Test func coercion() {87        let b = Book()88        #expect(b.eval("=\"3\"+1") == .number(4))89        #expect(b.eval("=TRUE+1") == .number(2))90        #expect(b.eval("=\"abc\"+1") == .error(.value))91        #expect(b.eval("=1/0") == .error(.div0))92        #expect(b.eval("=A1+1") == .number(1))            // blank is zero93        #expect(b.eval("=A1=0") == .bool(true))94        #expect(b.eval("=A1=\"\"") == .bool(true))95        #expect(b.eval("=\"a\"=\"A\"") == .bool(true))96        #expect(b.eval("=\"a\">5") == .bool(true))         // text sorts after numbers97        #expect(b.eval("=TRUE>\"z\"") == .bool(true))98        #expect(b.eval("=1&\"\"") == .text("1"))99        #expect(b.eval("=0.1+0.2") == .number(0.1 + 0.2))100        #expect(b.eval("=NoSuchName") == .error(.name))101        #expect(b.eval("=NOSUCHFN(1)") == .error(.name))102        #expect(b.eval("=Missing!A1") == .error(.ref))103    }104105    @Test func aggregates() {106        let b = Book()107        b.set("A1", "1"); b.set("A2", "2"); b.set("A3", "text"); b.set("A4", "TRUE"); b.set("A5", "'5")108        #expect(b.num("B1") .isNaN)109        b.set("B1", "=SUM(A1:A5)")110        #expect(b.num("B1") == 3)                         // text and booleans in ranges are ignored111        b.set("B2", "=SUM(A1:A2,\"3\",TRUE)")112        #expect(b.num("B2") == 7)                         // direct arguments are coerced113        b.set("B3", "=COUNT(A1:A5)"); #expect(b.num("B3") == 2)114        b.set("B4", "=COUNTA(A1:A6)"); #expect(b.num("B4") == 5)115        b.set("B5", "=AVERAGE(A1:A2)"); #expect(b.num("B5") == 1.5)116        b.set("B6", "=SUM(A:A)"); #expect(b.num("B6") == 3)117        b.set("B7", "=AVERAGE(C1:C5)"); #expect(b.get("B7") == .error(.div0))118        b.set("A6", "=1/0")119        #expect(b.get("B1") == .number(3))120        #expect(b.get("B6") == .error(.div0))121    }122123    @Test func compensatedSum() {124        let b = Book()125        b.set("A1", "1E+16"); b.set("A2", "1"); b.set("A3", "-1E+16")126        b.set("B1", "=SUM(A1:A3)")127        #expect(b.num("B1") == 1)128    }129130    @Test func lazyAndLambda() {131        let b = Book()132        #expect(b.eval("=IF(TRUE,1,1/0)") == .number(1))133        #expect(b.eval("=IFERROR(1/0,\"x\")") == .text("x"))134        #expect(b.eval("=IFNA(NA(),5)") == .number(5))135        #expect(b.eval("=IFNA(1/0,5)") == .error(.div0))136        #expect(b.eval("=IFS(FALSE,1,TRUE,2)") == .number(2))137        #expect(b.eval("=SWITCH(3,1,\"a\",3,\"c\",\"z\")") == .text("c"))138        #expect(b.eval("=CHOOSE(2,\"a\",\"b\")") == .text("b"))139        #expect(b.eval("=LET(x,5,y,x*2,x+y)") == .number(15))140        #expect(b.eval("=LAMBDA(a,b,a*b)(3,4)") == .number(12))141        #expect(b.eval("=LET(f,LAMBDA(n,n+1),f(f(1)))") == .number(3))142        b.engine.setDefinedName(DefinedName(name: "FACT", formula: "LAMBDA(n,IF(n<=1,1,n*FACT(n-1)))"))143        #expect(b.eval("=FACT(10)") == .number(3628800))144        b.engine.setDefinedName(DefinedName(name: "Rate", formula: "Sheet1!$C$1"))145        b.set("C1", "0.25")146        #expect(b.eval("=Rate*4") == .number(1))147    }148149    @Test func arrays() {150        let b = Book()151        b.set("A1", "1"); b.set("A2", "2"); b.set("A3", "3")152        b.set("C1", "=A1:A3*10")153        #expect(b.num("C1") == 10); #expect(b.num("C2") == 20); #expect(b.num("C3") == 30)154        #expect(b.eval("=SUM(A1:A3*{1;2;3})") == .number(14))155        #expect(b.eval("=SUM({1,2}+{10;20})") == .number(66))156        #expect(b.eval("=SUM(IF(A1:A3>1,A1:A3,0))") == .number(5))157        #expect(b.eval("=SUM(ABS({-1,-2,3}))") == .number(6))158        #expect(b.eval("=INDEX(A1:A3,2)") == .number(2))159        #expect(b.eval("=SUM(INDEX(A1:A3,0))") == .number(6))160        #expect(b.eval("=SUM(A1:INDEX(A1:A3,2))") == .number(3))161        #expect(b.eval("=SUM(OFFSET(A1,1,0,2,1))") == .number(5))162        #expect(b.eval("=INDIRECT(\"A\"&3)") == .number(3))163        #expect(b.eval("=ROWS(A1:A3)") == .number(3))164        #expect(b.eval("=SUM(C1#)") == .number(60))165    }166}167168@Suite struct RecalcTests {169    @Test func incremental() {170        let b = Book()171        b.set("A1", "1"); b.set("B1", "=A1+1"); b.set("C1", "=B1*2"); b.set("D1", "=SUM(A1:C1)")172        #expect(b.num("D1") == 7)173        b.set("A1", "10")174        #expect(b.engine.pendingCount == 3)175        #expect(b.num("C1") == 22); #expect(b.num("D1") == 43)176        b.set("Z9", "5")177        #expect(b.engine.pendingCount == 0)                // unrelated edit schedules nothing178    }179180    @Test func circular() {181        let b = Book()182        b.set("A1", "=B1+1"); b.set("B1", "=A1+1"); b.set("C1", "=5")183        #expect(b.get("A1") == .error(.circular)); #expect(b.get("B1") == .error(.circular)); #expect(b.num("C1") == 5)184        b.set("B1", "1")185        #expect(b.num("A1") == 2)186        b.set("D1", "=D1")187        #expect(b.get("D1") == .error(.circular))188    }189190    @Test func spillAndConflict() {191        let b = Book()192        b.set("A1", "={1,2;3,4}")193        #expect(b.num("B2") == 4)194        b.set("D1", "=B2*10")195        #expect(b.num("D1") == 40)196        b.set("B2", "x")197        #expect(b.get("A1") == .error(.spill)); #expect(b.get("B1") == .blank)198        b.set("B2", "")199        #expect(b.num("A1") == 1); #expect(b.num("B2") == 4); #expect(b.num("D1") == 40)200        b.set("A1", "={7,8}")201        #expect(b.get("A2") == .blank); #expect(b.num("B1") == 8); #expect(b.num("D1") == 0)202    }203204    @Test func deepChainsBothDirections() {205        let b = Book()206        let n = 20_000207        b.engine.transaction("fill") {208            b.engine.set(sheet: 0, row: 0, col: 0, .value(.number(1)))209            for r in 1..<n { b.engine.setFormula(sheet: 0, row: r, col: 0, "=A\(r)+1") }210            // reverse chain: each cell depends on the one below211            b.engine.set(sheet: 0, row: n - 1, col: 1, .value(.number(1)))212            for r in 0..<(n - 1) { b.engine.setFormula(sheet: 0, row: r, col: 1, "=B\(r + 2)+1") }213        }214        #expect(b.num("A\(n)") == Double(n))215        #expect(b.num("B1") == Double(n))216        b.set("A1", "5")217        #expect(b.num("A\(n)") == Double(n + 4))218    }219220    @Test func cancellationInsideALongChain() {221        let wb = Workbook(sheetNames: ["S"])222        let s = wb.sheets[0]223        let n = 200_000224        s.cells.set(row: n - 1, col: 0, Cell(value: .number(1)))225        // every cell depends on the one below: evaluating A1 pulls the whole chain on demand226        for r in 0..<(n - 1) { s.cells.set(row: r, col: 0, Cell(formula: Formula(expr: .binary(.add, .cell(sheet: nil, CellAddr(row: r + 1, col: 0)), .number(1))))) }227        let engine = CalcEngine(workbook: wb)228        var polls = 0229        let stats = engine.recalculate(isCancelled: { polls += 1; return polls > 3 })230        #expect(stats.cancelled)231        #expect(stats.evaluated < n - 1)232        #expect(engine.pendingCount > 0)233        let rest = engine.recalculate()234        #expect(!rest.cancelled && engine.pendingCount == 0)235        #expect(s.value(0, 0) == .number(Double(n)))236    }237238    @Test func volatile() {239        let b = Book()240        b.set("A1", "=RAND()"); b.set("B1", "=A1*2")241        let first = b.num("A1")242        #expect(b.wb.sheets[0].value(0, 1).numberValue == first * 2)243        b.engine.recalculate()244        let second = b.wb.sheets[0].value(0, 0).numberValue!245        #expect(first != second)246        #expect(b.wb.sheets[0].value(0, 1).numberValue == second * 2)247    }248249    @Test func crossSheet() {250        let b = Book()251        let s2 = b.engine.addSheet(named: "Data")252        b.set("A1", "42", sheet: s2)253        b.set("A1", "=Data!A1+1")254        #expect(b.num("A1") == 43)255        #expect(b.engine.renameSheet(at: s2, to: "My Data"))256        #expect(b.formula("A1") == "='My Data'!A1+1")257        #expect(b.num("A1") == 43)258        b.engine.removeSheet(at: s2)259        #expect(b.get("A1") == .error(.ref))260        b.engine.undo()261        #expect(b.num("A1") == 43)262    }263}264265@Suite struct EditingTests {266    @Test func insertDeleteRows() {267        let b = Book()268        b.set("A1", "1"); b.set("A2", "2"); b.set("A3", "3"); b.set("B1", "=SUM(A1:A3)"); b.set("B2", "=A3"); b.set("C5", "=$A$2+A2")269        b.engine.insertRows(sheet: 0, at: 1, count: 2)270        #expect(b.formula("B1") == "=SUM(A1:A5)")271        #expect(b.formula("B4") == "=A5")272        #expect(b.formula("C7") == "=$A$4+A4")273        #expect(b.num("B1") == 6)274        b.engine.deleteRows(sheet: 0, at: 3, count: 1)     // deletes the row holding "2"275        #expect(b.formula("B1") == "=SUM(A1:A4)")276        #expect(b.num("B1") == 4)277        #expect(b.formula("C6") == "=#REF!+#REF!")278        b.engine.undo()279        #expect(b.num("B1") == 6)280        b.engine.undo()281        #expect(b.formula("B1") == "=SUM(A1:A3)"); #expect(b.num("B1") == 6)282        b.engine.redo()283        #expect(b.formula("B1") == "=SUM(A1:A5)")284    }285286    @Test func insertDeleteCols() {287        let b = Book()288        b.set("A1", "1"); b.set("B1", "2"); b.set("C1", "=A1+B1"); b.set("D1", "=SUM(A:B)")289        b.engine.insertCols(sheet: 0, at: 1)290        #expect(b.formula("D1") == "=A1+C1"); #expect(b.formula("E1") == "=SUM(A:C)"); #expect(b.num("D1") == 3)291        b.engine.deleteCols(sheet: 0, at: 0)292        #expect(b.formula("C1") == "=#REF!+B1"); #expect(b.formula("D1") == "=SUM(A:B)")293    }294295    @Test func undoRedoCells() {296        let b = Book()297        b.set("A1", "1"); b.set("A2", "=A1*2")298        b.set("A1", "5")299        #expect(b.num("A2") == 10)300        #expect(b.engine.undo() != nil)301        #expect(b.num("A2") == 2)302        b.engine.redo()303        #expect(b.num("A2") == 10)304        b.engine.clear(sheet: 0, range: RangeRef(a1: "A1:A2")!)305        #expect(b.get("A2") == .blank)306        b.engine.undo()307        #expect(b.num("A2") == 10)308    }309310    @Test func copyPasteRelative() {311        let b = Book()312        b.set("A1", "1"); b.set("A2", "2"); b.set("B1", "=A1*$A$1+A$1")313        let clip = b.engine.copy(sheet: 0, range: RangeRef(a1: "B1")!)314        b.engine.paste(clip, sheet: 0, into: RangeRef(a1: "B2:B3")!)315        #expect(b.formula("B2") == "=A2*$A$1+A$1")316        #expect(b.num("B2") == 3)317        b.engine.paste(clip, sheet: 0, into: RangeRef(a1: "D5")!, mode: .values)318        #expect(b.formula("D5") == "2")319        let c2 = b.engine.copy(sheet: 0, range: RangeRef(a1: "B1")!)320        b.engine.paste(c2, sheet: 0, into: RangeRef(a1: "A5")!)321        #expect(b.formula("A5") == "=#REF!*$A$1+#REF!")322    }323324    @Test func moveFollowsReferences() {325        let b = Book()326        b.set("A1", "7"); b.set("C1", "=A1*2")327        b.engine.move(sheet: 0, from: RangeRef(a1: "A1")!, to: CellRef(a1: "B5")!)328        #expect(b.formula("C1") == "=B5*2"); #expect(b.num("C1") == 14)329    }330331    @Test func mixedTransactionUndo() {332        let b = Book()333        b.set("A1", "1")334        b.engine.transaction("mixed") {335            b.engine.set(sheet: 0, "A1", .value(.number(2)))336            b.engine.insertRows(sheet: 0, at: 0, count: 1)337            b.engine.set(sheet: 0, "A1", .value(.number(9)))338        }339        #expect(b.num("A1") == 9); #expect(b.num("A2") == 2)340        b.engine.undo()341        #expect(b.num("A1") == 1); #expect(b.get("A2") == .blank)342        b.engine.redo()343        #expect(b.num("A1") == 9); #expect(b.num("A2") == 2)344    }345346    @Test func fillSeries() {347        let b = Book()348        b.set("A1", "1"); b.set("A2", "3")349        b.engine.fill(sheet: 0, source: RangeRef(a1: "A1:A2")!, into: RangeRef(a1: "A1:A5")!)350        #expect(b.num("A5") == 9)351        b.set("B1", "Mon")352        b.engine.fill(sheet: 0, source: RangeRef(a1: "B1")!, into: RangeRef(a1: "B1:B8")!)353        #expect(b.get("B7") == .text("Sun")); #expect(b.get("B8") == .text("Mon"))354        b.set("C1", "Item 9")355        b.engine.fill(sheet: 0, source: RangeRef(a1: "C1")!, into: RangeRef(a1: "C1:C3")!)356        #expect(b.get("C3") == .text("Item 11"))357        b.set("D1", "=A1*2")358        b.engine.fill(sheet: 0, source: RangeRef(a1: "D1")!, into: RangeRef(a1: "D1:D3")!)359        #expect(b.formula("D3") == "=A3*2"); #expect(b.num("D3") == 10)360        b.set("E1", "2026-01-30")361        b.engine.fill(sheet: 0, source: RangeRef(a1: "E1")!, into: RangeRef(a1: "E1:E4")!)362        #expect(b.num("E4") == b.num("E1") + 3)363        b.set("F1", "5")364        b.engine.fill(sheet: 0, source: RangeRef(a1: "F1")!, into: RangeRef(a1: "F1:H1")!)365        #expect(b.num("H1") == 5)366    }367368    @Test func sortRows() {369        let b = Book()370        for (i, v) in ["3", "1", "", "b", "2", "a"].enumerated() { b.set("A\(i + 1)", v); b.set("B\(i + 1)", "=ROW()") }371        b.engine.sort(sheet: 0, range: RangeRef(a1: "A1:B6")!, keys: [SortKey(column: 0)])372        #expect((1...6).map { b.get("A\($0)").description } == ["1", "2", "3", "a", "b", ""])373        b.engine.sort(sheet: 0, range: RangeRef(a1: "A1:B6")!, keys: [SortKey(column: 0, ascending: false)])374        #expect((1...6).map { b.get("A\($0)").description } == ["b", "a", "3", "2", "1", ""])375        b.engine.undo(); b.engine.undo()376        #expect((1...3).map { b.get("A\($0)").description } == ["3", "1", ""])377    }378379    @Test func stylesAndMerge() {380        let b = Book()381        b.set("A1", "x"); b.set("B1", "y")382        b.engine.setStyle(sheet: 0, range: RangeRef(a1: "A1:B2")!) { $0.bold = true }383        #expect(b.wb.styles[b.wb.sheets[0].styleID(1, 1)].bold)384        b.engine.setStyle(sheet: 0, range: RangeRef(a1: "C:C")!) { $0.italic = true }385        #expect(b.wb.styles[b.wb.sheets[0].styleID(500_000, 2)].italic)386        #expect(b.wb.sheets[0].cells.count == 4)387        b.engine.merge(sheet: 0, range: RangeRef(a1: "A1:B1")!)388        #expect(b.get("B1") == .blank)389        #expect(b.wb.sheets[0].merge(containing: 0, 1) == RangeRef(a1: "A1:B1")!)390        b.engine.undo()391        #expect(b.get("B1") == .text("y")); #expect(b.wb.sheets[0].meta.merges.isEmpty)392    }393394    @Test func structuredReferences() {395        let b = Book()396        for (i, row) in [["Item", "Qty", "Price"], ["a", "2", "10"], ["b", "3", "20"]].enumerated() {397            for (j, v) in row.enumerated() { b.set("\(A1.columnName(j))\(i + 1)", v) }398        }399        b.engine.editMeta(sheet: 0) { m in400            m.tables.append(TableDef(id: 1, name: "Sales", range: RangeRef(a1: "A1:D3")!, columns: ["Item", "Qty", "Price", "Total"].map { TableColumn(name: $0) }))401        }402        b.set("D1", "Total"); b.set("D2", "=[@Qty]*[@Price]"); b.set("D3", "=Sales[@Qty]*Sales[@Price]")403        b.set("F1", "=SUM(Sales[Total])"); b.set("F2", "=ROWS(Sales[#All])"); b.set("F3", "=INDEX(Sales[#Headers],1,2)")404        #expect(b.num("F1") == 80); #expect(b.num("F2") == 3); #expect(b.get("F3") == .text("Qty"))405    }406}407408@Suite struct InputTests {409    @Test func literals() throws {410        let p = InputParser(locale: Locale(identifier: "en_US"))411        func v(_ s: String) -> Value { if case .value(let x) = try! p.parse(s).input { return x }; return .error(.calc) }412        #expect(v("42") == .number(42)); #expect(v("-1.5e3") == .number(-1500)); #expect(v("1,234.5") == .number(1234.5))413        #expect(v("12%") == .number(0.12)); #expect(v("$1,000") == .number(1000)); #expect(v("(5)") == .number(-5))414        #expect(v("1,23") == .text("1,23")); #expect(v("true") == .bool(true)); #expect(v("'123") == .text("123"))415        #expect(v("2026-03-15") == .number(46096)); #expect(v("3/15/2026") == .number(46096)); #expect(v("15 Mar 2026") == .number(46096))416        #expect(v("12:00") == .number(0.5)); #expect(v("6:00 PM") == .number(0.75))417        #expect(v("hello") == .text("hello")); #expect(v("-abc") == .text("-abc"))418        #expect(try p.parse("12%").numberFormat == "0%")419        let fr = InputParser(locale: Locale(identifier: "fr_CA"))420        if case .value(let x) = try fr.parse("1 234,5").input { #expect(x == .number(1234.5)) }421        if case .formula(let e) = try fr.parse("=SOMME(1,5;2)").input { #expect(e.formulaText() == "SOMME(1.5,2)") }422        #expect(throws: ParseError.self) { try p.parse("=1+") }423    }424425    @Test func dateSerials() {426        #expect(DateSerial.serial(year: 1900, month: 1, day: 1) == 1)427        #expect(DateSerial.serial(year: 1900, month: 2, day: 28) == 59)428        #expect(DateSerial.serial(year: 1900, month: 3, day: 1) == 61)429        #expect(DateSerial.serial(year: 2026, month: 11, day: 21) == 46347)430        #expect(DateSerial.components(46347).month == 11)431        #expect(DateSerial.components(60) == (1900, 2, 29))432        #expect(DateSerial.serial(year: 2024, month: 14, day: 0) == DateSerial.serial(year: 2025, month: 1, day: 31))433        #expect(DateSerial.weekday(46347) == 7)                         // Saturday434        #expect(DateSerial.serial(year: 1904, month: 1, day: 2, date1904: true) == 1)435    }436437    @Test func generalFormatting() {438        #expect(Value.generalString(0.1 + 0.2) == "0.3")439        #expect(Value.generalString(1e20) == "1E+20")440        #expect(Value.generalString(123456789012) == "123456789012")441        #expect(Value.generalString(1.0 / 3) == "0.333333333333333")442        #expect(Value.generalString(-2.5) == "-2.5")443    }444}445446@Suite struct PerformanceSmoke {447    @Test func hundredThousandFormulas() {448        let wb = Workbook(sheetNames: ["S"])449        let sheet = wb.sheets[0]450        let n = 100_000451        for r in 0..<n {452            sheet.cells.set(row: r, col: 0, Cell(value: .number(Double(r))))453            sheet.cells.set(row: r, col: 1, Cell(formula: Formula(expr: try! FormulaParser.parse("A\(r + 1)*2+1"))))454            sheet.cells.set(row: r, col: 2, Cell(formula: Formula(expr: try! FormulaParser.parse("SUM(A\(r + 1):B\(r + 1))"))))455        }456        let engine = CalcEngine(workbook: wb)457        let stats = engine.recalculate()458        #expect(stats.evaluated == 2 * n)459        #expect(sheet.value(n - 1, 2) == .number(Double(n - 1) * 3 + 1))460        engine.set(sheet: 0, row: 10, col: 0, .value(.number(1000)))461        let inc = engine.recalculate()462        #expect(inc.evaluated == 2)463        print("full recalc of \(2 * n) formulas: \(stats.seconds)s; incremental: \(inc.seconds)s")464    }465}466
Files main
Menu

Theme