Repository Public
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