Repository Public
1import AppKit2import Foundation3import SheetCore4import SheetCharts5import SheetUI6@testable import FeatureCharts78/// A session with a small sales table on "Data": header row, month labels in A, three numeric columns, and a9/// formula column E that depends on H2.10@MainActor func makeSession() -> WorkbookSession {11 let wb = Workbook(sheetNames: ["Data", "Other"])12 let s = WorkbookSession(workbook: wb, locale: Locale(identifier: "en_US"))13 let parser = s.parser14 s.perform("setup") { e in15 for (c, h) in ["Month", "North", "Central", "South", "Total"].enumerated() { e.set(sheet: 0, row: 0, col: c, .value(.text(h))) }16 for (i, m) in ["Jan", "Feb", "Mar", "Apr", "May", "Jun"].enumerated() {17 e.set(sheet: 0, row: i + 1, col: 0, .value(.text(m)))18 e.set(sheet: 0, row: i + 1, col: 1, .value(.number(Double(10 + i * 3))))19 e.set(sheet: 0, row: i + 1, col: 2, .value(.number(Double(20 - i))))20 e.set(sheet: 0, row: i + 1, col: 3, .value(.number(Double(5 + i * i))))21 try? e.setInput(sheet: 0, row: i + 1, col: 4, "=(B\(i + 2)+C\(i + 2)+D\(i + 2))*$H$2", parser: parser)22 }23 e.set(sheet: 0, row: 1, col: 7, .value(.number(2)))24 }25 s.engine.clearUndoHistory()26 return s27}2829@MainActor func detection(_ s: WorkbookSession, _ a1: String, sheet: Int = 0) -> SeriesDetection {30 ChartBuilder.detect(AreaRef(sheet: sheet, range: RangeRef(a1: a1)!), in: s.workbook)!31}3233func rangeText(_ ref: DataRef?) -> String { ChartFormat.text(ref, currentSheet: "") }3435/// A flipped 2x bitmap context like the one the grid hands to object renderers.36func bitmapContext(width: Int, height: Int, scale: CGFloat = 2) -> CGContext {37 let ctx = CGContext(data: nil, width: Int(CGFloat(width) * scale), height: Int(CGFloat(height) * scale), bitsPerComponent: 8, bytesPerRow: 0,38 space: CGColorSpace(name: CGColorSpace.sRGB)!, bitmapInfo: CGImageAlphaInfo.premultipliedLast.rawValue)!39 ctx.translateBy(x: 0, y: CGFloat(height) * scale)40 ctx.scaleBy(x: scale, y: -scale)41 return ctx42}4344final class XMLCheck: NSObject, XMLParserDelegate {45 var elements = 046 var texts = 047 func parser(_ parser: XMLParser, didStartElement elementName: String, namespaceURI: String?, qualifiedName qName: String?, attributes attributeDict: [String: String] = [:]) {48 elements += 149 if elementName == "text" { texts += 1 }50 }51 static func parse(_ data: Data) -> (ok: Bool, elements: Int, texts: Int) {52 let p = XMLParser(data: data), d = XMLCheck()53 p.delegate = d54 let ok = p.parse()55 return (ok, d.elements, d.texts)56 }57}5859func pngSize(_ data: Data) -> (Int, Int)? {60 guard let src = CGImageSourceCreateWithData(data as CFData, nil), let img = CGImageSourceCreateImageAtIndex(src, 0, nil) else { return nil }61 return (img.width, img.height)62}63