extformat.h

xls文件格式分析基础库

/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 * Copyright (C) Yeico S. A. de C. V.
 * xlsLib -- A multiplatform, C++ library for dynamic generation of Excel (TM) 
 * files.
 *
 * This program 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 2 of the License, or
 * (at your option) any later version.
 *
 * This program 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 this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 *  
 * $Source: /cvsroot/xlslib/xlslib/src/xlslib/extformat.h,v $
 * $Revision: 1.1.1.1 $
 * $Author: darioglz $
 * $Date: 2004/08/27 16:31:46 $
 *
 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 *
 * File description:
 *
 *
 *
 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */


#ifndef EXTFORMAT_H
#define EXTFORMAT_H
#include <config.h>
#include "common.h"
#include "rectypes.h"
#include "record.h"
#include "colors.h"
#include "font.h"
#include "format.h"

namespace xlslib_core
{


  // The XF-record field offsets:
#define XF_OFFSET_FONT         ((unsigned32_t) 4)
#define XF_OFFSET_FORMAT       ((unsigned32_t) 6)
#define XF_OFFSET_PROP         ((unsigned32_t) 8)
#define XF_OFFSET_ALIGN        ((unsigned32_t)10)
#define XF_OFFSET_COLOR        ((unsigned32_t)12)
#define XF_OFFSET_BORDER0      ((unsigned32_t)14)
#define XF_OFFSET_BORDER1      ((unsigned32_t)16)
#define XF_OFFSET_BORDER2      ((unsigned32_t)18)

  // The Cell Properties bit or-masks:
#define XF_PROP_SHIFTPOS_PARENT  (4)

#define XF_PROP_LOCKED      ((unsigned16_t)0x0001)
#define XF_PROP_HIDDEN      ((unsigned16_t)0x0002)
#define XF_PROP_STYLE       ((unsigned16_t)0x0004)
#define XF_PROP_123PREFIX   ((unsigned16_t)0x0008)
#define XF_PROP_XFPARENT    ((unsigned16_t)0xFFF0)

  // The Alignment field bit or-masks:
#define XF_ALIGN_HORIZONTAL  ((unsigned16_t)0x0007)
#define XF_ALIGN_WRAP        ((unsigned16_t)0x0008)
#define XF_ALIGN_VERTICAL    ((unsigned16_t)0x0070)
#define XF_ALIGN_JUSTLAST    ((unsigned16_t)0x0080) /* Used only in far-est versions of excel */
#define XF_ALIGN_ORIENTATION ((unsigned16_t)0x0300)
#define XF_ALIGN_ATRNUM      ((unsigned16_t)0x0400)
#define XF_ALIGN_ATRFONT    ((unsigned16_t)0x0800)
#define XF_ALIGN_ATRALC     ((unsigned16_t)0x1000)
#define XF_ALIGN_ATRBDR     ((unsigned16_t)0x2000)
#define XF_ALIGN_ATRPAT     ((unsigned16_t)0x4000)
#define XF_ALIGN_ATRPROT    ((unsigned16_t)0x8000)

  // Horizontal Align options

#define XF_ALIGN_SHIFTPOS_HALIGN  (0)
#define XF_HALIGN_GENERAL         ((unsigned8_t)0)
#define XF_HALIGN_LEFT            ((unsigned8_t)1)
#define XF_HALIGN_CENTER          ((unsigned8_t)2)
#define XF_HALIGN_RIGHT           ((unsigned8_t)3)
#define XF_HALIGN_FILL            ((unsigned8_t)4)
#define XF_HALIGN_JUSTIFY         ((unsigned8_t)5)
#define XF_HALIGN_CENTERACCROSS   ((unsigned8_t)6)

  typedef enum
    {
      HALIGN_GENERAL = 0,
      HALIGN_LEFT,
      HALIGN_CENTER,
      HALIGN_RIGHT,
      HALIGN_FILL,
      HALIGN_JUSTIFY,
      HALIGN_CENTERACCROSS
    }halign_option_t;

  // Vertical Align options
#define XF_ALIGN_SHIFTPOS_VALIGN  (4)

#define XF_VALIGN_TOP     ((unsigned8_t)0)
#define XF_VALIGN_CENTER  ((unsigned8_t)1)
#define XF_VALIGN_BOTTOM  ((unsigned8_t)2)
#define XF_VALIGN_JUSTIFY ((unsigned8_t)3)

  typedef enum
    {
      VALIGN_TOP = 0,
      VALIGN_CENTER,
      VALIGN_BOTTOM,
      VALIGN_JUSTIFY
    }valign_option_t;

  // Text Orientation Options
#define XF_ALIGN_SHIFTPOS_ORI  (8)

#define XF_ORI_NONE             ((unsigned8_t)0)
#define XF_ORI_TOPBOTTOMTXT     ((unsigned8_t)1)
#define XF_ORI_90NOCLOCKTXT     ((unsigned8_t)2)
#define XF_ORI_90CLOCKTXT       ((unsigned8_t)3)

  typedef enum
    {
      ORI_NONE = 0,      
      ORI_TOPBOTTOMTXT,
      ORI_90NOCLOCKTXT,
      ORI_90CLOCKTXT     
    }txtori_option_t;

  // The Color field bit or-masks:
#define XF_COLOR_FOREGROUND    ((unsigned16_t)0x007f)
#define XF_COLOR_BACKGROUND    ((unsigned16_t)0x1f80)
#define XF_COLOR_PIVOT         ((unsigned16_t)0x2000)
#define XF_COLOR_RESERVED      ((unsigned16_t)0xc000)

#define XF_COLOR_SHIFTPOS_FG  (0)
#define XF_COLOR_SHIFTPOS_BG  (7)

  // The Border0 field bit or-masks:

#define XF_SHIFTPOS_BOTTOMSTYLE  (6)
#define XF_SHIFTPOS_BOTTOMCOLOR  (9)

#define XF_BORDER0_FILLPATTERN    ((unsigned16_t)0x003f)
#define XF_BORDER0_BOTTOMSTYLE   ((unsigned16_t)0x01c0)
#define XF_BORDER0_BOTTOMCOLOR   ((unsigned16_t)0xfe00)

#define XF_FILL_NONE                ((unsigned8_t)0x00)
#define XF_FILL_SOLID               ((unsigned8_t)0x01)
#define XF_FILL_ATEN75              ((unsigned8_t)0x03)
#define XF_FILL_ATEN50              ((unsigned8_t)0x02)
#define XF_FILL_ATEN25              ((unsigned8_t)0x04)
#define XF_FILL_ATEN12              ((unsigned8_t)0x11)
#define XF_FILL_ATEN06              ((unsigned8_t)0x12)
#define XF_FILL_HORIZ_LIN           ((unsigned8_t)0x05)
#define XF_FILL_VERTICAL_LIN        ((unsigned8_t)0x06)
#define XF_FILL_DIAG                ((unsigned8_t)0x07)
#define XF_FILL_INV_DIAG            ((unsigned8_t)0x08)
#define XF_FILL_INTER_DIAG          ((unsigned8_t)0x09)
#define XF_FILL_DIAG_THICK_INTER    ((unsigned8_t)0x0a)
#define XF_FILL_HORIZ_LINES_THIN    ((unsigned8_t)0x0b)
#define XF_FILL_VERTICAL_LINES_THIN ((unsigned8_t)0x0c)
#define XF_FILL_DIAG_THIN           ((unsigned8_t)0x0d)
#define XF_FILL_INV_DIAG_THIN       ((unsigned8_t)0x0e)
#define XF_FILL_HORIZ_INT_THIN      ((unsigned8_t)0x0f)
#define XF_FILL_HORIZ_INTER_THICK   ((unsigned8_t)0x10)

  typedef enum
    {
      FILL_NONE = 0,
      FILL_SOLID,
      FILL_ATEN75,
      FILL_ATEN50,
      FILL_ATEN25,
      FILL_ATEN12,
      FILL_ATEN06,
      FILL_HORIZ_LIN,
      FILL_VERTICAL_LIN,
      FILL_DIAG,
      FILL_INV_DIAG,
      FILL_INTER_DIAG,
      FILL_DIAG_THICK_INTER,
      FILL_HORIZ_LINES_THIN,
      FILL_VERTICAL_LINES_THIN,
      FILL_DIAG_THIN,
      FILL_INV_DIAG_THIN,
      FILL_HORIZ_INT_THIN,
      FILL_HORIZ_INTER_THICK   
    }fill_option_t;

  // The Border1 field bit or-masks:
#define XF_SHIFTPOS_TOPSTYLE   (0)
#define XF_SHIFTPOS_LEFTSTYLE  (3)
#define XF_SHIFTPOS_RIGHTSTYLE (6)
#define XF_SHIFTPOS_TOPCOLOR   (9)

#define XF_BORDER1_TOPSTYLE     ((unsigned16_t)0x0007)
#define XF_BORDER1_LEFTSTYLE    ((unsigned16_t)0x0038)
#define XF_BORDER1_RIGHTSTYLE   ((unsigned16_t)0x01c0)
#define XF_BORDER1_TOPCOLOR     ((unsigned16_t)0xfe00)

  // The Border2 field bit or-masks:
#define XF_SHIFTPOS_LEFTCOLOR  (0)
#define XF_SHIFTPOS_RIGHTCOLOR (7)

#define XF_BORDER2_LEFTCOLOR    ((unsigned16_t)0x007f)
#define XF_BORDER2_RIGHTCOLOR   ((unsigned16_t)0x3f80)
#define XF_BORDER2_RESERVED     ((unsigned16_t)0xc000)

  // Border Options
#define XF_BRDOPTION_NONE       ((unsigned8_t)0x00)
#define XF_BRDOPTION_THIN       ((unsigned8_t)0x01)
#define XF_BRDOPTION_MEDIUM     ((unsigned8_t)0x02)
#define XF_BRDOPTION_DASHED     ((unsigned8_t)0x03)
#define XF_BRDOPTION_DOTTED     ((unsigned8_t)0x04)
#define XF_BRDOPTION_THICK      ((unsigned8_t)0x05)
#define XF_BRDOPTION_DOUBLE     ((unsigned8_t)0x06)
#define XF_BRDOPTION_HAIR       ((unsigned8_t)0x07)

  typedef enum
    {
      BORDER_NONE = 0,
      BORDER_THIN,
      BORDER_MEDIUM,
      BORDER_DASHED,
      BORDER_DOTTED,
      BORDER_THICK,
      BORDER_DOUBLE,
      BORDER_HAIR    
    }border_style_t;

#define XF_BORDER_BOTTOM  ((unsigned8_t)0)
#define XF_BORDER_TOP     ((unsigned8_t)1)
#define XF_BORDER_LEFT    ((unsigned8_t)2)
#define XF_BORDER_RIGHT   ((unsigned8_t)3)

  typedef enum
    {
      BORDER_BOTTOM = 0,
      BORDER_TOP,
      BORDER_LEFT,
      BORDER_RIGHT 
    }border_side_t;

#define XF_COLOR_CODE_BLACK           ((unsigned8_t)(COLOR_CODE_BLACK))
#define XF_COLOR_CODE_DARK_RED        ((unsigned8_t)(COLOR_CODE_DARK_RED))
#define XF_COLOR_CODE_RED             ((unsigned8_t)(COLOR_CODE_RED))
#define XF_COLOR_CODE_FUCSIA          ((unsigned8_t)(COLOR_CODE_FUCSIA))
#define XF_COLOR_CODE_COMBINED01      ((unsigned8_t)(COLOR_CODE_COMBINED01))
#define XF_COLOR_CODE_COMBINED02      ((unsigned8_t)(COLOR_CODE_COMBINED02))
#define XF_COLOR_CODE_COMBINED03      ((unsigned8_t)(COLOR_CODE_COMBINED03))
#define XF_COLOR_CODE_COMBINED04      ((unsigned8_t)(COLOR_CODE_COMBINED04))
#define XF_COLOR_CODE_COMBINED05      ((unsigned8_t)(COLOR_CODE_COMBINED05))
#define XF_COLOR_CODE_COMBINED06      ((unsigned8_t)(COLOR_CODE_COMBINED06))
#define XF_COLOR_CODE_OLIVE           ((unsigned8_t)(COLOR_CODE_OLIVE))
#define XF_COLOR_CODE_DARK_YELLOW     ((unsigned8_t)(COLOR_CODE_DARK_YELLOW))
#define XF_COLOR_CODE_COMBINED07      ((unsigned8_t)(COLOR_CODE_COMBINED07))
#define XF_COLOR_CODE_YELLOW          ((unsigned8_t)(COLOR_CODE_YELLOW))
#define XF_COLOR_CODE_LIGHT_YELLOW    ((unsigned8_t)(COLOR_CODE_LIGHT_YELLOW))
#define XF_COLOR_CODE_DARK_GREEN      ((unsigned8_t)(COLOR_CODE_DARK_GREEN))
#define XF_COLOR_CODE_GREEN           ((unsigned8_t)(COLOR_CODE_GREEN))
#define XF_COLOR_CODE_COMBINED08      ((unsigned8_t)(COLOR_CODE_COMBINED08))
#define XF_COLOR_CODE_LIVING_GREEN    ((unsigned8_t)(COLOR_CODE_LIVING_GREEN))
#define XF_COLOR_CODE_LIGHT_GREEN     ((unsigned8_t)(COLOR_CODE_LIGHT_GREEN))
#define XF_COLOR_CODE_COMBINED09      ((unsigned8_t)(COLOR_CODE_COMBINED09))
#define XF_COLOR_CODE_BLUE_GREEN      ((unsigned8_t)(COLOR_CODE_BLUE_GREEN))
#define XF_COLOR_CODE_AQUAMARINA      ((unsigned8_t)(COLOR_CODE_AQUAMARINA))
#define XF_COLOR_CODE_TURQOISE        ((unsigned8_t)(COLOR_CODE_TURQOISE))
#define XF_COLOR_CODE_COMBINED10      ((unsigned8_t)(COLOR_CODE_COMBINED10))
#define XF_COLOR_CODE_DARK_BLUE       ((unsigned8_t)(COLOR_CODE_DARK_BLUE))
#define XF_COLOR_CODE_BLUE            ((unsigned8_t)(COLOR_CODE_BLUE))
#define XF_COLOR_CODE_LIGHT_BLUE      ((unsigned8_t)(COLOR_CODE_LIGHT_BLUE))
#define XF_COLOR_CODE_SKY_BLUE        ((unsigned8_t)(COLOR_CODE_SKY_BLUE))
#define XF_COLOR_CODE_COMBINED11      ((unsigned8_t)(COLOR_CODE_COMBINED11))
#define XF_COLOR_CODE_INDIGO          ((unsigned8_t)(COLOR_CODE_INDIGO))
#define XF_COLOR_CODE_BLUE_GRAY       ((unsigned8_t)(COLOR_CODE_BLUE_GRAY))
#define XF_COLOR_CODE_VIOLET          ((unsigned8_t)(COLOR_CODE_VIOLET))
#define XF_COLOR_CODE_PLUM            ((unsigned8_t)(COLOR_CODE_PLUM))
#define XF_COLOR_CODE_LAVANDER        ((unsigned8_t)(COLOR_CODE_LAVANDER))
#define XF_COLOR_CODE_COMBINED12      ((unsigned8_t)(COLOR_CODE_COMBINED12))