/*
 * This file is part of TREB.
 *
 * TREB is free software: you can redistribute it and/or modify it under the 
 * terms of the GNU General Public License as published by the Free Software 
 * Foundation, either version 3 of the License, or (at your option) any 
 * later version.
 *
 * TREB is distributed in the hope that it will be useful, but WITHOUT ANY 
 * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS 
 * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more 
 * details.
 *
 * You should have received a copy of the GNU General Public License along 
 * with TREB. If not, see <https://www.gnu.org/licenses/>. 
 *
 * Copyright 2022-2026 trebco, llc. 
 * info@treb.app
 * 
 */

import type { CellStyle, Color } from './style';
import type { SerializedValueType } from './value-type';
import type { IArea } from './area';
import type { AnnotationLayout } from './layout';
import type { Table } from './table';
import type { DataValidation, AnnotationType, ConditionalFormat } from 'treb-data-model';

export interface CellParseResult {
  row: number;
  column: number;
  type: SerializedValueType; // ValueType,
  value: number|string|undefined|boolean;
  calculated?: number|string|undefined|boolean;
  calculated_type?: SerializedValueType; // ValueType,
  style_ref?: number;
  hyperlink?: string;
  validation?: DataValidation;
  merge_area?: IArea;
  area?: IArea;

  /** dynamic arrays */
  spill?: IArea;
  
  table?: Table;
}

export interface AnchoredAnnotation {
  layout: AnnotationLayout;
  type?: AnnotationType;
  formula?: string;
  data?: any;
}

/**
 * this is moved from export to avoid a circular reference
 */
export interface ImportedSheetData {
  name: string|undefined;
  cells: CellParseResult[];
  default_column_width: number;
  column_widths: number[];
  row_heights: number[];
  styles: CellStyle[];
  conditional_formats: ConditionalFormat[];
  data_validations?: DataValidation[];

  // optional, for backcompat
  sheet_style?: number;
  column_styles?: number[];
  row_styles?: number[];

  annotations?: AnchoredAnnotation[];
  outline?: number[];

  // new
  tab_color?: Color;

  hidden?: boolean;

}