类型定义#

interface SheetDataInput {
  name?: string;           // 表格名称
  freeze?: string;         // 冻结位置（如 'A1'）
  styles?: CellStyle[];    // 样式定义
  merges?: string[];       // 合并单元格范围（如 ['A1:B2']）
  cols?: {
    len?: number;          // 列数
    [key: number]: { width?: number };
  };
  rows?: {
    [key: number]: {
      cells: {
        [key: number]: {
          text: string;
          style?: number;  // 样式数组索引
          merge?: [number, number];
        };
      };
    };
  };
}

interface Cell {
  text?: string;                    // 单元格文本内容
  style?: number;                   // 样式索引
  merge?: [number, number];         // 合并跨度 [行数, 列数]
  editable?: boolean;               // 是否可编辑
  [key: string]: unknown;
}

interface CellStyle {
  align?: 'left' | 'center' | 'right';
  valign?: 'top' | 'middle' | 'bottom';
  font?: {
    bold?: boolean;
    italic?: boolean;
    name?: string;
    size?: number;
  };
  bgcolor?: string;                 // 背景色
  textwrap?: boolean;               // 文本换行
  color?: string;                   // 文字颜色
  strike?: boolean;                 // 删除线
  underline?: boolean;              // 下划线
  border?: {
    top?: BorderStyle;
    right?: BorderStyle;
    bottom?: BorderStyle;
    left?: BorderStyle;
  };
  format?: string;                  // 数字格式
}

interface CellStyleFull {
  align: 'left' | 'center' | 'right';
  valign: 'top' | 'middle' | 'bottom';
  font: {
    bold: boolean;
    italic: boolean;
    name: string;
    size: number;
  };
  bgcolor: string;
  textwrap: boolean;
  color: string;
  strike: boolean;
  underline: boolean;
  format: string;
}

type BorderStyle = [string, string, string];
// [线条样式, 颜色, 宽度]
// 如 ['thin', '#000000', '1px']

interface ViewRange {
  sri: number;    // 起始行索引
  sci: number;    // 起始列索引
  eri: number;    // 结束行索引
  eci: number;    // 结束列索引
  w: number;      // 宽度
  h: number;      // 高度
  each?: (
    cb: (ri: number, ci: number) => void,
    filteredCb?: (ri: number) => boolean,
  ) => void;
  intersects?: (other: ViewRange) => boolean;
  clone?: () => ViewRange;
}

interface CellRect {
  ri: number;     // 行索引
  ci: number;     // 列索引
  left: number;
  top: number;
  width: number;
  height: number;
}

interface MergeInfo {
  sri: number;    // 起始行索引
  sci: number;    // 起始列索引
  eri: number;    // 结束行索引
  eci: number;    // 结束列索引
}

type ValidationType =
  | 'number'
  | 'email'
  | 'phone'
  | 'list'
  | 'date'
  | 'custom';

type ValidationOperator =
  | 'be'    // 介于
  | 'nbe'   // 不介于
  | 'eq'    // 等于
  | 'neq'   // 不等于
  | 'lt'    // 小于
  | 'lte'   // 小于或等于
  | 'gt'    // 大于
  | 'gte';  // 大于或等于

type ValidationMode = 'stop' | 'alert' | 'hint';

interface ValidationRule {
  type: ValidationType;
  required: boolean;
  value: string | string[];
  operator: ValidationOperator;
}

interface ValidationData {
  refs: string[];           // 单元格引用，如 ['A1', 'B2:C3']
  mode: ValidationMode;
  type: ValidationType;
  required: boolean;
  operator: ValidationOperator;
  value: string | string[];
}

interface ValidationError {
  ri: number;
  ci: number;
  message: string;
}

type ChangeListener = (data: SheetDataInput | SheetDataInput[]) => void;

type StyleValue = string | number | boolean | Record<string, unknown>;

interface DrawBoxOptions {
  bgcolor?: string;
  align?: 'left' | 'center' | 'right';
  valign?: 'top' | 'middle' | 'bottom';
  font?: string;
  color?: string;
  strike?: boolean;
  underline?: boolean;
  textwrap?: boolean;
}

interface DrawBoxParams {
  x: number;
  y: number;
  width: number;
  height: number;
  padding?: number;
  bgcolor?: string;
  borderTop?: BorderStyle | null;
  borderRight?: BorderStyle | null;
  borderBottom?: BorderStyle | null;
  borderLeft?: BorderStyle | null;
}

interface CanvasRenderingOptions {
  fillStyle?: string;
  strokeStyle?: string;
  lineWidth?: number;
  font?: string;
  textAlign?: CanvasTextAlign;
  textBaseline?: CanvasTextBaseline;
}

type RangeCallback<T = unknown> = (value: T) => void;

type EventListener<T = unknown> = (event: T) => void;

type CellRenderFn = (x: number, y: number) => string | number;

interface Messages {
  [key: string]: string | Messages;
}