Repository Public
1import AppKit2import Foundation3import Testing4import SheetCore5import SheetCharts6import SheetUI7@testable import FeatureCharts89@MainActor @Suite struct DetectionTests {10 @Test func automaticDetection() {11 let s = makeSession()12 let d = detection(s, "A1:D7")13 #expect(d.firstRowIsHeader && d.firstColumnIsCategories && !d.seriesInRows && d.isAutomatic)14 #expect(d.dataRange == RangeRef(a1: "B2:D7")!)15 #expect(d.seriesCount == 3)16 let spec = ChartBuilder.spec(.column, d)17 #expect(spec.series.count == 3)18 #expect(rangeText(spec.categories) == "Data!A2:A7")19 #expect(rangeText(spec.series[0].values) == "Data!B2:B7" && rangeText(spec.series[0].nameRef) == "Data!B1")20 #expect(rangeText(spec.series[2].values) == "Data!D2:D7")21 #expect(spec.xAxis.title == "Month")22 }2324 @Test func switchesChangeTheBinding() {25 let s = makeSession()26 var d = detection(s, "B1:D7")27 d.firstRowIsHeader = false28 #expect(!d.isAutomatic)29 var spec = ChartBuilder.spec(.line, d)30 #expect(rangeText(spec.series[0].values) == "Data!B1:B7" && spec.series[0].nameRef == nil)31 d = detection(s, "A1:D7")32 d.seriesInRows = true33 spec = ChartBuilder.spec(.line, d)34 #expect(spec.series.count == 6)35 #expect(rangeText(spec.series[0].values) == "Data!B2:D2" && rangeText(spec.series[0].nameRef) == "Data!A2")36 #expect(rangeText(spec.categories) == "Data!B1:D1")37 d = detection(s, "A1:D7")38 d.firstColumnIsCategories = false39 spec = ChartBuilder.spec(.column, d)40 #expect(spec.categories == nil && spec.series.count == 3) // the text column is never a series41 #expect(!ChartBuilder.suggestions(d, area: AreaRef(sheet: 0, range: d.range), in: s.workbook).isEmpty)42 }4344 @Test func kindSpecificBindings() {45 let s = makeSession()46 let d = detection(s, "B1:D7")47 let scatter = ChartBuilder.spec(.scatter, d)48 #expect(scatter.series.count == 2 && rangeText(scatter.series[0].x) == "Data!B2:B7" && rangeText(scatter.series[0].values) == "Data!C2:C7")49 let bubble = ChartBuilder.spec(.bubble, d)50 #expect(bubble.series.count == 1 && rangeText(bubble.series[0].size) == "Data!D2:D7")51 let heat = ChartBuilder.spec(.heatmap, detection(s, "A1:D7"))52 #expect(heat.series.count == 1 && rangeText(heat.series[0].values) == "Data!B2:D7")53 #expect(rangeText(heat.categories) == "Data!B1:D1" && rangeText(heat.rowLabels) == "Data!A2:A7")54 let pie = ChartBuilder.spec(.pie, detection(s, "A1:D7"))55 #expect(pie.series.count == 1 && rangeText(pie.categories) == "Data!A2:A7")56 let hist = ChartBuilder.spec(.histogram, detection(s, "A1:D7"))57 #expect(hist.categories == nil && hist.series.count == 3)58 let candle = ChartBuilder.spec(.candlestick, detection(s, "A1:E7"))59 #expect(candle.series.count == 1 && candle.series[0].open != nil && candle.series[0].close != nil)60 for kind in ChartKind.allCases { #expect(ChartBuilder.spec(kind, detection(s, "A1:E7")).kind == kind) }61 #expect(ChartFamily.allCases.flatMap(\.kinds).count == 21 && Set(ChartFamily.allCases.flatMap(\.kinds)).count == 21)62 }6364 @Test func rangeTextRoundTrip() {65 let s = makeSession()66 let wb = s.workbook67 #expect(ChartFormat.parse("B2:B7", currentSheet: "Data", workbook: wb) == .ref(.range(sheet: "Data", range: RangeRef(a1: "B2:B7")!)))68 #expect(ChartFormat.parse("other!$A$1:$A$3", currentSheet: "Data", workbook: wb) == .ref(.range(sheet: "Other", range: RangeRef(a1: "A1:A3")!)))69 #expect(ChartFormat.parse("Nope!A1", currentSheet: "Data", workbook: wb) == .invalid)70 #expect(ChartFormat.parse("hello world", currentSheet: "Data", workbook: wb) == .invalid)71 #expect(ChartFormat.parse(" ", currentSheet: "Data", workbook: wb) == .empty)72 let lit = DataRef.literal([1, 2.5, 3])73 #expect(ChartFormat.parse(ChartFormat.text(lit, currentSheet: "Data"), currentSheet: "Data", workbook: wb) == .ref(lit))74 let labels = DataRef.labels(["a", "b; c", "say \"hi\""])75 #expect(ChartFormat.parse(ChartFormat.text(labels, currentSheet: "Data"), currentSheet: "Data", workbook: wb) == .ref(labels))76 _ = wb.addSheet(named: "My Sheet")77 let quoted = DataRef.range(sheet: "My Sheet", range: RangeRef(a1: "C3:D9")!)78 #expect(ChartFormat.text(quoted, currentSheet: "Data") == "'My Sheet'!C3:D9")79 #expect(ChartFormat.parse("'My Sheet'!C3:D9", currentSheet: "Data", workbook: wb) == .ref(quoted))80 #expect(ChartFormat.text(.range(sheet: "Data", range: RangeRef(a1: "A1")!), currentSheet: "data") == "A1")81 let f = ChartFormat.formatter(locale: .enUS)82 #expect(f(1234.5, "#,##0.00") == "1,234.50" && f(0.256, "0%") == "26%" && f(3, "") == nil && f(3, "General") == nil)83 #expect(ChartFormat.display(nil) == "—")84 }85}8687@MainActor @Suite struct InsertionTests {88 @Test func insertCreatesBoundObject() throws {89 let s = makeSession()90 s.select(RangeRef(a1: "A1:D7")!)91 let model = ChartPickerModel(session: s)92 #expect(model.detection?.seriesCount == 3)93 #expect(model.suggested.first?.spec.kind == .column)94 #expect(model.families.count == 7 && model.families.flatMap(\.items).count == 21)95 #expect(model.canInsert)96 let object = try #require(model.insert())97 #expect(object.kind == "chart" && s.selectedObjectID == object.id && s.inspectorPane == ChartsFeature.inspectorPaneID)98 #expect(s.sheet.meta.objects.count == 1)99 let origin = s.suggestedObjectOrigin()100 #expect(object.x == Double(origin.x) && object.y == Double(origin.y) && object.width >= 300 && object.height >= 200)101 let spec = try #require(ChartPayload.chart(object)?.spec)102 #expect(spec.id == object.id)103 #expect(Set(spec.referencedRanges.map { $0.sheet + "!" + $0.range.a1 }) == ["Data!A2:A7", "Data!B1", "Data!B2:B7", "Data!C1", "Data!C2:C7", "Data!D1", "Data!D2:D7"])104 s.undo()105 #expect(s.sheet.meta.objects.isEmpty)106 s.redo()107 #expect(s.sheet.meta.objects.count == 1)108 }109110 @Test func quickInsertUsesCurrentRegion() throws {111 let s = makeSession()112 s.select(cell: CellRef(a1: "C4")!)113 let object = try #require(ChartInsertion.quickInsert(.line, in: s))114 let spec = try #require(ChartPayload.chart(object)?.spec)115 #expect(spec.kind == .line && spec.series.count == 4) // A1:E7 → four numeric columns116 let second = try #require(ChartInsertion.quickInsert(.line, in: s))117 #expect(second.name != object.name)118 s.select(cell: CellRef(a1: "M40")!)119 #expect(ChartInsertion.quickInsert(.pie, in: s) == nil)120 #expect(s.statusMessage != nil)121 }122123 @Test func pickerSwitchesRebuildCandidates() {124 let s = makeSession()125 s.select(RangeRef(a1: "A1:D7")!)126 let model = ChartPickerModel(session: s)127 model.seriesInRows = true128 #expect(model.detection?.seriesCount == 6)129 #expect(model.selected?.spec.series.count == 6)130 model.firstRowIsHeader = false131 #expect(model.detection?.dataRange.r0 == 0)132 // samples stand in for kinds the selection cannot feed, and cannot be inserted133 let empty = makeSession()134 empty.select(cell: CellRef(a1: "M40")!)135 let none = ChartPickerModel(session: empty)136 #expect(none.detection == nil && !none.canInsert && none.families.flatMap(\.items).allSatisfy(\.isSample))137 }138139 @Test func pinThemePayload() throws {140 var spec = ChartSpec(kind: .line, title: "T", series: [SeriesSpec(name: "a", values: .literal([1, 2, 3]))])141 spec.theme = .publication142 let plain = try #require(ChartPayload.encode(ChartValue(spec: spec)))143 let pinned = try #require(ChartPayload.encode(ChartValue(spec: spec, pinTheme: true)))144 #expect(ChartPayload.decode(plain) == ChartValue(spec: spec, pinTheme: false))145 #expect(ChartPayload.decode(pinned) == ChartValue(spec: spec, pinTheme: true))146 #expect(try ChartSpec.decoded(from: pinned) == spec) // still a valid SheetCharts payload147 #expect(ChartValue(spec: spec, pinTheme: true).effectiveTheme(dark: true) == ChartTheme.publication)148 #expect(ChartValue(spec: spec).effectiveTheme(dark: true).isDark)149 #expect(!ChartValue(spec: spec).effectiveTheme(dark: false).isDark)150 }151}152153@MainActor @Suite struct StructureTests {154 func chart(_ s: WorkbookSession) -> ChartSpec { ChartPayload.chart(s.workbook.sheets[0].meta.objects[0])!.spec }155156 func setup() -> WorkbookSession {157 let s = makeSession()158 s.select(RangeRef(a1: "A1:D7")!)159 _ = ChartInsertion.quickInsert(.column, in: s)160 return s161 }162163 @Test func rowsFollowInsertAndDelete() {164 let s = setup()165 s.perform("Insert Rows") { $0.insertRows(sheet: 0, at: 0, count: 3) }166 #expect(rangeText(chart(s).series[0].values) == "Data!B5:B10" && rangeText(chart(s).series[0].nameRef) == "Data!B4")167 #expect(rangeText(chart(s).categories) == "Data!A5:A10")168 s.perform("Insert Rows") { $0.insertRows(sheet: 0, at: 6, count: 2) } // inside the data: the range grows169 #expect(rangeText(chart(s).series[1].values) == "Data!C5:C12")170 s.undo()171 #expect(rangeText(chart(s).series[1].values) == "Data!C5:C10")172 s.undo()173 #expect(rangeText(chart(s).series[0].values) == "Data!B2:B7")174 s.redo()175 #expect(rangeText(chart(s).series[0].values) == "Data!B5:B10")176 s.perform("Delete Rows") { $0.deleteRows(sheet: 0, at: 0, count: 3) }177 #expect(rangeText(chart(s).series[0].values) == "Data!B2:B7")178 s.perform("Delete Rows") { $0.deleteRows(sheet: 0, at: 5, count: 2) } // the last two data rows179 #expect(rangeText(chart(s).series[0].values) == "Data!B2:B5")180 }181182 @Test func columnsFollowInsertAndDelete() {183 let s = setup()184 s.perform("Insert Columns") { $0.insertCols(sheet: 0, at: 1, count: 2) }185 #expect(rangeText(chart(s).series[0].values) == "Data!D2:D7" && rangeText(chart(s).categories) == "Data!A2:A7")186 s.perform("Delete Columns") { $0.deleteCols(sheet: 0, at: 0, count: 1) }187 #expect(rangeText(chart(s).series[0].values) == "Data!C2:C7")188 // the category column was deleted entirely: the chart keeps its last reference instead of losing it189 #expect(chart(s).categories != nil)190 s.undo(); s.undo()191 #expect(rangeText(chart(s).series[0].values) == "Data!B2:B7")192 // edits on another sheet leave the chart alone193 s.perform("Insert Rows") { $0.insertRows(sheet: 1, at: 0, count: 5) }194 #expect(rangeText(chart(s).series[0].values) == "Data!B2:B7")195 }196197 @Test func renameAndMove() {198 let s = setup()199 #expect(s.renameSheet(at: 0, to: "Sales 2026"))200 #expect(rangeText(chart(s).series[0].values) == "'Sales 2026'!B2:B7")201 // the chart still reads its data after the rename202 let snap = ChartSnapshot.capture([chart(s)], workbook: s.workbook)203 #expect(ChartData.resolve(chart(s), source: snap).series[0].finiteValues == [10, 13, 16, 19, 22, 25])204 s.undo()205 #expect(rangeText(chart(s).series[0].values) == "Data!B2:B7")206 s.redo()207 #expect(rangeText(chart(s).series[0].values) == "'Sales 2026'!B2:B7")208 s.undo()209 s.perform("Move") { $0.move(sheet: 0, from: RangeRef(a1: "A1:E7")!, to: CellRef(a1: "C10")!) }210 #expect(rangeText(chart(s).series[0].values) == "Data!D11:D16" && rangeText(chart(s).categories) == "Data!C11:C16")211 s.undo()212 #expect(rangeText(chart(s).categories) == "Data!A2:A7")213 }214215 @Test func figuresAndPinnedChartsAreRemapped() throws {216 let s = setup()217 let spec = chart(s)218 var figure = FigureTemplates.academicDoubleColumn.makeFigure(charts: [spec, spec])219 figure.title = "F"220 let fo = try figure.sheetObject(x: 10, y: 400)221 s.addObject(fo)222 // pin the chart's theme: the flag must survive the rewrite223 var o = s.sheet.meta.objects[0]224 o.payload = ChartPayload.encode(ChartValue(spec: spec, pinTheme: true))!225 s.updateObject(o)226 s.perform("Insert Rows") { $0.insertRows(sheet: 0, at: 0, count: 1) }227 let f = try #require(ChartPayload.figure(s.sheet.meta.objects[1]))228 #expect(rangeText(f.panels[1].chart.series[2].values) == "Data!D3:D8")229 let v = try #require(ChartPayload.chart(s.sheet.meta.objects[0]))230 #expect(v.pinTheme && rangeText(v.spec.series[0].values) == "Data!B3:B8")231 #expect(ChartStructure.remap(kind: "chart", payload: o.payload, .insertRows(sheet: "Other", at: 0, count: 1)) == nil)232 #expect(ChartStructure.remap(kind: "pivot", payload: o.payload, .insertRows(sheet: "Data", at: 0, count: 1)) == nil)233 }234}235