SPB Git

Repository Public

FormulaTests.swift 9.3 KB 180 lines swift

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
Files main
Menu

Theme