Types#

interface SheetDataInput {
  name?: string;           // Sheet name
  freeze?: string;         // Freeze position (e.g., 'A1')
  styles?: CellStyle[];    // Style definitions
  merges?: string[];       // Merged cell ranges (e.g., ['A1:B2'])
  cols?: {
    len?: number;          // Number of columns
    [key: number]: { width?: number };
  };
  rows?: {
    [key: number]: {
      cells: {
        [key: number]: {
          text: string;
          style?: number;  // Index into styles array
          merge?: [number, number];
        };
      };
    };
  };
}

interface Cell {
  text?: string;                    // Cell text content
  style?: number;                   // Style index
  merge?: [number, number];         // Merge span [rows, cols]
  editable?: boolean;               // Whether cell is editable
  [key: string]: unknown;
}

interface CellStyle {
  align?: 'left' | 'center' | 'right';
  valign?: 'top' | 'middle' | 'bottom';
  font?: {
    bold?: boolean;
    italic?: boolean;
    name?: string;
    size?: number;
  };
  bgcolor?: string;                 // Background color
  textwrap?: boolean;               // Text wrapping
  color?: string;                   // Text color
  strike?: boolean;                 // Strikethrough
  underline?: boolean;              // Underline
  border?: {
    top?: BorderStyle;
    right?: BorderStyle;
    bottom?: BorderStyle;
    left?: BorderStyle;
  };
  format?: string;                  // Number format
}

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];
// [line-style, color, width]
// e.g., ['thin', '#000000', '1px']

interface ViewRange {
  sri: number;    // Start row index
  sci: number;    // Start column index
  eri: number;    // End row index
  eci: number;    // End column index
  w: number;      // Width
  h: number;      // Height
  each?: (
    cb: (ri: number, ci: number) => void,
    filteredCb?: (ri: number) => boolean,
  ) => void;
  intersects?: (other: ViewRange) => boolean;
  clone?: () => ViewRange;
}

interface CellRect {
  ri: number;     // Row index
  ci: number;     // Column index
  left: number;
  top: number;
  width: number;
  height: number;
}

interface MergeInfo {
  sri: number;    // Start row index
  sci: number;    // Start column index
  eri: number;    // End row index
  eci: number;    // End column index
}

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

type ValidationOperator =
  | 'be'    // Between
  | 'nbe'   // Not between
  | 'eq'    // Equal
  | 'neq'   // Not equal
  | 'lt'    // Less than
  | 'lte'   // Less than or equal
  | 'gt'    // Greater than
  | 'gte';  // Greater than or equal

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

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

interface ValidationData {
  refs: string[];           // Cell references, e.g., ['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;
}