Repository Public
1import Foundation2import Testing3import SheetCore4import SheetUI5import Audit6@testable import FeatureAudit78@MainActor @Suite struct FormulaInsightTests {9 func model() -> WorkbookSession {10 let s = Fixture.session(["Calc", "Out"])11 Fixture.fill(s, [12 ["Qty", "Price", "Total", "Check"],13 ["2", "10", "=A2*B2", "=C2/A6"],14 ["3", "10", "=A3*B3", "=IF(C3>20,\"big\",\"small\")"],15 ["4", "10", "=A4*B4+5", ""],16 ["5", "10", "=A5*B5", ""],17 ["", "", "=SUM(C2:C5)", ""],18 ])19 Fixture.fill(s, sheet: 1, [["=Calc!C6*2"]])20 return s21 }2223 @Test func formulaStepsPrecedentsAndDependents() throws {24 let s = model()25 let i = FormulaInsight.make(engine: s.engine, sheet: 0, cell: CellRef(a1: "C6")!)26 #expect(i.formula == "=SUM(C2:C5)" && i.value == .number(145))27 #expect(i.spans.map(\.text).joined() == "=SUM(C2:C5)")28 #expect(i.spans.contains { $0.kind == .function && $0.text == "SUM" } && i.spans.contains { $0.kind == .reference && $0.colorIndex == 0 })29 let x = try #require(i.explanation)30 #expect(x.steps.last?.value.number == 145 && !x.description.isEmpty)31 #expect(i.precedents.map(\.address) == ["C2:C5"] && i.precedents[0].range == Fixture.rg("C2:C5"))32 #expect(i.dependents.map(\.address) == ["Out!A1"] && i.dependents[0].preview == "290" && i.dependents[0].formula == "=Calc!C6*2")33 #expect(i.error == nil && i.inconsistency == nil)3435 let branch = FormulaInsight.make(engine: s.engine, sheet: 0, cell: CellRef(a1: "D3")!)36 #expect(branch.value == .text("big"))37 #expect(branch.explanation?.steps.contains { $0.expression == "C3>20" && $0.value.display == "TRUE" } == true)38 #expect(branch.precedents.map(\.address) == ["C3"] && branch.precedents[0].preview == "30")39 }4041 @Test func comparisonWithNeighboursAndInconsistencyHint() throws {42 let s = model()43 let odd = FormulaInsight.make(engine: s.engine, sheet: 0, cell: CellRef(a1: "C4")!)44 let above = try #require(odd.comparisons.first { $0.side == .above })45 #expect(above.neighbour == CellRef(a1: "C3")! && above.neighbourFormula == "=A3*B3" && above.expected == "=A4*B4")46 #expect(!above.isCopy)47 #expect(above.diff.segments.filter { $0.kind == .added }.map(\.token).joined() == "+5")48 #expect(above.diff.segments.filter { $0.kind == .removed }.isEmpty)49 #expect(odd.inconsistency != nil)50 #expect(odd.comparisons.first { $0.side == .left } == nil) // B4 is a value5152 let regular = FormulaInsight.make(engine: s.engine, sheet: 0, cell: CellRef(a1: "C3")!)53 #expect(regular.comparisons.first { $0.side == .above }?.isCopy == true)54 #expect(regular.inconsistency == nil)5556 // a typed value between two copies of a formula57 s.perform("overwrite") { $0.set(sheet: 0, row: 2, col: 2, .value(.number(30))) }58 let typed = FormulaInsight.make(engine: s.engine, sheet: 0, cell: CellRef(a1: "C3")!)59 #expect(typed.formula == nil && typed.comparisons.isEmpty)60 #expect(typed.inconsistency == nil) // C4 differs from C2: no shared pattern around it61 s.perform("fix") { _ = $0.setFormula(sheet: 0, row: 3, col: 2, "=A4*B4") }62 #expect(FormulaInsight.make(engine: s.engine, sheet: 0, cell: CellRef(a1: "C3")!).inconsistency != nil)63 }6465 @Test func errorsAreExplainedAndValuesHaveNoFormula() throws {66 let s = model()67 let e = FormulaInsight.make(engine: s.engine, sheet: 0, cell: CellRef(a1: "D2")!)68 #expect(e.value == .error(.div0))69 let x = try #require(e.error)70 #expect(x.error == .div0 && !x.summary.isEmpty && !x.suggestion.isEmpty)71 let v = FormulaInsight.make(engine: s.engine, sheet: 0, cell: CellRef(a1: "A2")!)72 #expect(v.formula == nil && v.explanation == nil && v.precedents.isEmpty)73 #expect(v.dependents.map(\.address) == ["C2"])74 let blank = FormulaInsight.make(engine: s.engine, sheet: 0, cell: CellRef(a1: "Z99")!)75 #expect(blank.value == .blank && blank.dependents.isEmpty)76 #expect(FormulaInsight.make(engine: s.engine, sheet: 9, cell: CellRef(0, 0)).formula == nil)77 }7879 @Test func navigatorParsesAddresses() throws {80 let s = model()81 #expect(Navigator.parse("Out!A1", in: s)?.sheet == 1)82 #expect(Navigator.parse("B2:C3", in: s)?.range == Fixture.rg("B2:C3"))83 #expect(Navigator.parse("Nope!A1", in: s) == nil)84 Navigator.go(s, address: "Out!A1")85 #expect(s.sheetIndex == 1 && s.selection.active == CellRef(0, 0))86 s.studioPane = "auditor"87 Navigator.go(s, sheet: 0, range: Fixture.rg("C4"), reveal: true)88 #expect(s.sheetIndex == 0 && s.selection.active == CellRef(a1: "C4")! && s.studioPane == nil && s.scrollTarget == CellRef(a1: "C4")!)89 }90}9192@MainActor @Suite struct DependencyModelTests {93 func session() -> WorkbookSession {94 let s = Fixture.session()95 Fixture.fill(s, [["1", "=A1+1", "=B1*2", "=C1+B1"], ["=D1", "=A2+A1", "", ""]])96 return s97 }9899 @Test func tracesBothDirectionsAndLaysOutLeftToRight() throws {100 let s = session()101 let m = DependencyModel()102 m.setRoot(sheet: 0, cell: CellRef(a1: "C1")!)103 m.depth = 3104 m.refresh(engine: s.engine, contentRevision: s.contentRevision)105 let g = try #require(m.graph)106 #expect(Set(g.nodes.map { $0.range.a1 }) == ["A1", "B1", "C1", "D1", "A2", "B2"])107 #expect(m.selectedID == g.root)108 let root = try #require(m.rect(of: g.root))109 let a1 = try #require(m.rect(of: g.nodes.first { $0.range.a1 == "A1" }!.id))110 let d1 = try #require(m.rect(of: g.nodes.first { $0.range.a1 == "D1" }!.id))111 #expect(a1.maxX < root.minX && root.maxX < d1.minX) // precedents left, dependents right112 #expect(m.contentSize.width > DependencyModel.nodeSize.width * 3)113114 m.direction = .precedents115 m.refresh(engine: s.engine, contentRevision: s.contentRevision)116 #expect(Set(m.graph?.nodes.map { $0.range.a1 } ?? []) == ["A1", "B1", "C1"])117 m.direction = .dependents; m.depth = 1118 m.refresh(engine: s.engine, contentRevision: s.contentRevision)119 #expect(Set(m.graph?.nodes.map { $0.range.a1 } ?? []) == ["C1", "D1"])120 }121122 @Test func hitTestingFitZoomAndKeyboard() throws {123 let s = session()124 let m = DependencyModel()125 m.setRoot(sheet: 0, cell: CellRef(a1: "C1")!)126 m.refresh(engine: s.engine, contentRevision: s.contentRevision)127 let g = try #require(m.graph)128 m.fit(in: CGSize(width: 1200, height: 600))129 #expect(m.scale == 1 && !m.needsFit) // small graph: centred at 100 %130 m.fit(in: CGSize(width: 300, height: 300))131 #expect(m.scale == 0.8) // too large: stays readable, centred on the root132 if let r = m.rect(of: g.root) { #expect(abs(r.midX * m.scale + m.offset.width - 150) < 1) }133 m.fit(in: CGSize(width: 300, height: 300), readable: false)134 #expect(m.scale < 0.5 && m.offset.width >= 24) // whole graph visible135 m.fit(in: CGSize(width: 1200, height: 600))136 let r = try #require(m.rect(of: g.root))137 let centre = CGPoint(x: r.midX * m.scale + m.offset.width, y: r.midY * m.scale + m.offset.height)138 #expect(m.node(at: centre)?.id == g.root)139 #expect(m.node(at: CGPoint(x: -500, y: -500)) == nil)140 m.zoom(by: 1.5, around: centre)141 #expect(m.node(at: centre)?.id == g.root) // the anchor stays put142 m.zoom(by: 100, around: centre)143 #expect(m.scale == 2.5)144 let left = try #require(m.neighbour(.left)), right = try #require(m.neighbour(.right))145 #expect(g.node(left)?.range.a1 == "B1" && g.node(right)?.range.a1 == "D1")146 m.selectedID = left147 #expect(m.neighbour(.right) == g.root)148149 // re-rooting and the node cap150 m.setRoot(sheet: 0, cell: CellRef(a1: "A1")!)151 #expect(m.needsFit && m.autoFit)152 m.refresh(engine: s.engine, contentRevision: s.contentRevision)153 #expect(m.graph?.root != g.root)154 }155156 @Test func largeGraphsAreCappedUntilMoreIsRequested() throws {157 let s = Fixture.session()158 Fixture.fill(s, [["1"]] + (0..<400).map { _ in ["=$A$1+1"] })159 let m = DependencyModel()160 m.setRoot(sheet: 0, cell: CellRef(0, 0))161 m.refresh(engine: s.engine, contentRevision: s.contentRevision)162 #expect(m.graph?.isTruncated == true && (m.graph?.nodes.count ?? 0) <= DependencyModel.pageSize + 1)163 m.showMore()164 m.refresh(engine: s.engine, contentRevision: s.contentRevision)165 #expect((m.graph?.nodes.count ?? 0) > DependencyModel.pageSize + 1)166 m.showMore()167 m.refresh(engine: s.engine, contentRevision: s.contentRevision)168 #expect(m.graph?.isTruncated == false && m.graph?.nodes.count == 401)169 }170171 @Test func cyclesAreFlagged() throws {172 let s = Fixture.session()173 Fixture.fill(s, [["=B1+1", "=A1*2"]])174 let m = DependencyModel()175 m.setRoot(sheet: 0, cell: CellRef(0, 0))176 m.refresh(engine: s.engine, contentRevision: s.contentRevision)177 #expect(m.graph?.hasCycle == true)178 }179}180