Repository Public
1import Foundation2import Testing3import SheetCore4import SheetUI5import Audit6@testable import FeatureAudit78@MainActor @Suite struct EffectsAdapterTests {9 func numbers() -> WorkbookSession {10 let s = Fixture.session()11 Fixture.fill(s, (1...20).map { [String($0), String($0 * 10), String($0 - 10)] })12 return s13 }1415 @Test func mapsStyleScaleBarAndIcon() throws {16 let s = numbers() // column C holds -9…1017 var style = DiffStyle(bold: true, italic: nil, textColor: RGBA(hex: 0x112233), fill: RGBA(hex: 0xFFC7CE))18 style.strikethrough = true19 s.perform("rules") { e in20 e.editMeta(sheet: 0) { m in21 m.conditionalFormats = [22 ConditionalFormat(ranges: [Fixture.rg("C1:C20")], kind: .cellIs(op: "equal", formulas: ["10"]), style: style, priority: 1),23 RulePresets.rule(.colorScale, ranges: [Fixture.rg("C1:C20")], priority: 2),24 RulePresets.rule(.dataBars, ranges: [Fixture.rg("C1:C20")], priority: 3),25 ConditionalFormat(ranges: [Fixture.rg("C1:C20")], kind: .iconSet(name: "3Arrows", thresholds: RuleEditorModel.defaultThresholds(for: "3Arrows"), reversed: false), priority: 4),26 ]27 }28 }29 let f = ConditionalFormatter(engine: s.engine)30 let top = ConditionalEffectsAdapter.map(try #require(f.effect(sheet: 0, row: 19, col: 2)))31 #expect(top.fill == RGBA(hex: 0xFFC7CE)) // explicit fill wins over the scale32 #expect(top.textColor == RGBA(hex: 0x112233))33 #expect(top.bold == true && top.italic == nil && top.strikethrough == true)34 #expect(top.dataBarColor == RGBA(hex: 0x0891B2))35 #expect(abs((top.dataBarFraction ?? 0) - 10.0 / 19.0) < 1e-12) // from the zero axis to the right edge36 #expect(top.icon == "arrow.up" && top.iconColor == IconSets.green)3738 let low = ConditionalEffectsAdapter.map(try #require(f.effect(sheet: 0, row: 0, col: 2)))39 #expect(low.fill == RGBA(hex: 0xF8696B)) // colour-scale minimum40 #expect(low.textColor == RGBA(hex: 0x0E1222)) // a fill without text colour gets a readable one41 #expect(ConditionalEffectsAdapter.readableText(on: RGBA(hex: 0x10131F)) == .white)42 #expect(ConditionalEffectsAdapter.readableText(on: RGBA(hex: 0xFFEB84)) == RGBA(hex: 0x0E1222))43 #expect(low.bold == nil)44 #expect(abs((low.dataBarFraction ?? 0) - 9.0 / 19.0) < 1e-12 && low.dataBarColor == IconSets.red) // negative bar45 #expect(low.icon == "arrow.down" && low.iconColor == IconSets.red)46 }4748 @Test func iconSetsCoverEveryDeclaredSize() {49 for name in IconSets.names {50 let icons = IconSets.icons(for: name)51 #expect(icons.count == IconSets.count(of: name), "\(name)")52 #expect(icons.allSatisfy { !$0.symbol.isEmpty })53 }54 #expect(IconSets.icons(for: "4Unknown").count == 4)55 #expect(IconSets.icon(set: "3Arrows", index: 9).symbol == "arrow.up")56 }5758 @Test func producesEffectsForVisibleRangeAndCachesRows() {59 let s = numbers()60 s.perform("rules") { e in61 e.editMeta(sheet: 0) { m in62 m.conditionalFormats = [63 ConditionalFormat(ranges: [Fixture.rg("A1:A20")], kind: .cellIs(op: "greaterThan", formulas: ["15"]), style: RulePresets.redStyle, priority: 1),64 RulePresets.rule(.dataBars, ranges: [Fixture.rg("B1:B20")], priority: 2),65 RulePresets.rule(.iconSet, ranges: [Fixture.rg("C1:C20")], priority: 3),66 ]67 }68 }69 let adapter = ConditionalEffectsAdapter()70 let fx = adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 0, range: Fixture.rg("A1:C20"), revision: s.contentRevision)71 #expect(fx[CellRef(a1: "A16")!]?.fill == RulePresets.redStyle.fill)72 #expect(fx[CellRef(a1: "A15")!] == nil)73 #expect(fx[CellRef(a1: "B20")!]?.dataBarFraction == 1)74 #expect(fx[CellRef(a1: "C1")!]?.icon == "circle.fill" && fx[CellRef(a1: "C1")!]?.iconColor == IconSets.red)75 #expect(fx[CellRef(a1: "C20")!]?.iconColor == IconSets.green)7677 let resolved = adapter.resolvedCells78 let again = adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 0, range: Fixture.rg("A5:C12"), revision: s.contentRevision)79 #expect(adapter.resolvedCells == resolved) // served from the row cache80 #expect(again.count == 16 && again.keys.allSatisfy { $0.row >= 4 && $0.row <= 11 })8182 // an edit invalidates: A1 now exceeds the threshold83 s.perform("edit") { $0.set(sheet: 0, row: 0, col: 0, .value(.number(99))) }84 let after = adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 0, range: Fixture.rg("A1:C20"), revision: s.contentRevision)85 #expect(after[CellRef(a1: "A1")!]?.fill == RulePresets.redStyle.fill)86 #expect(adapter.resolvedCells > resolved)87 s.undo()88 let undone = adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 0, range: Fixture.rg("A1:C20"), revision: s.contentRevision)89 #expect(undone[CellRef(a1: "A1")!] == nil)90 }9192 @Test func noRulesNoWork() {93 let s = numbers()94 let adapter = ConditionalEffectsAdapter()95 #expect(adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 0, range: Fixture.rg("A1:C20"), revision: 1).isEmpty)96 #expect(adapter.resolvedCells == 0)97 #expect(adapter.effects(workbook: s.workbook, engine: s.engine, sheet: 7, range: Fixture.rg("A1"), revision: 1).isEmpty)98 }99}100101@MainActor @Suite struct ValidationAdapterTests {102 func session() -> WorkbookSession {103 let s = Fixture.session()104 Fixture.fill(s, at: "H1", [["Red"], ["Green"], ["Blue"]])105 s.perform("rules") { e in106 e.editMeta(sheet: 0) { m in107 var whole = DataValidation(ranges: [Fixture.rg("A1:A10")], kind: .whole, op: "between", formula1: "1", formula2: "10")108 whole.errorTitle = "Out of range"; whole.errorMessage = "1 to 10 only"109 var warn = DataValidation(ranges: [Fixture.rg("B1:B10")], kind: .decimal, op: "greaterThan", formula1: "0")110 warn.errorStyle = "warning"111 var info = DataValidation(ranges: [Fixture.rg("C1:C10")], kind: .textLength, op: "lessThanOrEqual", formula1: "3")112 info.errorStyle = "information"113 let list = DataValidation(ranges: [Fixture.rg("D1:D10")], kind: .list, formula1: "\"Yes,No,Maybe\"")114 let fromRange = DataValidation(ranges: [Fixture.rg("E1:E10")], kind: .list, formula1: "$H$1:$H$3")115 m.validations = [whole, warn, info, list, fromRange]116 }117 }118 return s119 }120121 func outcome(_ s: WorkbookSession, _ a1: String, _ input: String) -> SheetUI.ValidationOutcome {122 SessionRegistry.shared.note(s)123 return ValidationAdapter().validate(workbook: s.workbook, engine: s.engine, sheet: 0, cell: CellRef(a1: a1)!, input: input)124 }125126 @Test func stopRulesBlock() {127 let s = session()128 guard case .ok = outcome(s, "A1", "5") else { Issue.record("5 should be valid"); return }129 guard case .invalid(let title, let message, let blocking) = outcome(s, "A1", "11") else { Issue.record("11 should be invalid"); return }130 #expect(title == "Out of range" && message == "1 to 10 only" && blocking)131 guard case .invalid(_, _, let b2) = outcome(s, "A2", "2.5") else { Issue.record("2.5 is not whole"); return }132 #expect(b2)133 guard case .invalid(_, _, let b3) = outcome(s, "D1", "Perhaps") else { Issue.record("not in list"); return }134 #expect(b3)135 guard case .ok = outcome(s, "D1", "Maybe") else { Issue.record("in list"); return }136 guard case .ok = outcome(s, "Z9", "anything") else { Issue.record("no rule"); return }137 }138139 @Test func warningAndInformationDoNotBlockAndReachTheStatusLine() {140 let s = session()141 s.statusMessage = nil142 guard case .invalid(_, _, let blocking) = outcome(s, "B1", "-4") else { Issue.record("-4 violates > 0"); return }143 #expect(!blocking)144 #expect(s.statusMessage?.isEmpty == false)145 guard case .invalid(_, _, let b2) = outcome(s, "C1", "toolong") else { Issue.record("length"); return }146 #expect(!b2)147 // the session accepts the entry148 s.select(cell: CellRef(a1: "B1")!)149 s.beginEdit(text: "-4")150 #expect(s.commitEdit(move: nil))151 #expect(Fixture.value(s, "B1") == .number(-4))152 // and refuses a blocked one153 Workspace.shared.validator = ValidationAdapter()154 s.select(cell: CellRef(a1: "A1")!)155 s.beginEdit(text: "50")156 #expect(!s.commitEdit(move: nil))157 s.cancelEdit()158 #expect(Fixture.value(s, "A1") == .blank)159 }160161 @Test func dropdownItems() {162 let s = session()163 let v = ValidationAdapter()164 #expect(v.dropdownItems(workbook: s.workbook, engine: s.engine, sheet: 0, cell: CellRef(a1: "D3")!) == ["Yes", "No", "Maybe"])165 #expect(v.dropdownItems(workbook: s.workbook, engine: s.engine, sheet: 0, cell: CellRef(a1: "E3")!) == ["Red", "Green", "Blue"])166 #expect(v.dropdownItems(workbook: s.workbook, engine: s.engine, sheet: 0, cell: CellRef(a1: "A1")!) == nil)167 ValidationActions.choose("Green", for: CellRef(a1: "E3")!, in: s)168 #expect(Fixture.value(s, "E3") == .text("Green"))169 s.undo()170 #expect(Fixture.value(s, "E3") == .blank)171 }172}173174@MainActor @Suite struct AssistAdapterTests {175 func workbook() -> Workbook {176 let s = Fixture.sales()177 s.perform("meta") { e in178 e.setDefinedName(DefinedName(name: "SalesTax", formula: "Sales!$A$1"))179 _ = try? TableActions.create(engine: e, sheet: 0, range: Fixture.rg("A1:D7"), options: .init(name: "SalesData"))180 }181 return s.workbook182 }183184 @Test func completesFunctionsWithCategoryNamesTablesAndSheets() throws {185 let wb = workbook()186 let a = try #require(AssistAdapter.assist(text: "=SU", cursor: 3, workbook: wb))187 #expect(a.replaceStart == 1 && a.replaceLength == 2)188 let sum = try #require(a.candidates.first { $0.text == "SUM" })189 #expect(sum.kind == "function" && sum.detail.contains("Math"))190191 let b = try #require(AssistAdapter.assist(text: "=1+Sal", cursor: 6, workbook: wb))192 #expect(b.candidates.contains { $0.kind == "name" && $0.text == "SalesTax" })193 #expect(b.candidates.contains { $0.kind == "table" && $0.text == "SalesData" })194 #expect(b.candidates.contains { $0.kind == "sheet" && $0.text == "Sales!" })195196 let c = try #require(AssistAdapter.assist(text: "=SUM(SalesData[Re", cursor: 17, workbook: wb))197 #expect(c.candidates.map(\.text) == ["Region]", "Revenue]"])198 #expect(c.replaceLength == 2)199 }200201 @Test func specialFormsAreOfferedAndExplained() throws {202 for name in ["IF", "IFS", "IFERROR", "IFNA", "SWITCH", "CHOOSE", "LET", "LAMBDA"] {203 let text = "=" + name204 let a = try #require(AssistAdapter.assist(text: text, cursor: text.utf16.count, workbook: nil, limit: 200), "\(name)")205 #expect(a.candidates.contains { $0.text == name && $0.kind == "function" }, "\(name)")206 let call = text + "("207 let sig = try #require(AssistAdapter.assist(text: call, cursor: call.utf16.count, workbook: nil), "\(name)")208 #expect(sig.signature?.hasPrefix(name + "(") == true, "\(name)")209 #expect(sig.argumentIndex == 0)210 }211 }212213 @Test func signatureFollowsTheActiveArgument() throws {214 let text = "=IF(A1>2,\"yes\","215 let a = try #require(AssistAdapter.assist(text: text, cursor: text.utf16.count, workbook: nil))216 #expect(a.signature == "IF(condition, value_if_true, [value_if_false])")217 #expect(a.argumentIndex == 2)218 #expect(a.summary?.isEmpty == false)219 #expect(AssistAdapter.assist(text: "=\"SU", cursor: 4, workbook: nil) == nil) // inside a string220 #expect(AssistAdapter.assist(text: "=1+2", cursor: 4, workbook: nil) == nil)221 }222}223