
>\
                 @   sU   d  d l  Z  d  d l Z d  d l m Z d d l m Z Gd d   d e  j  Z d S)    N)UNICODE_LITERAL   )from_this_dirc               @   sd   e  Z d  Z d d   Z d d   Z d d   Z d d   Z d	 d
   Z d d   Z d d   Z	 d S)TestCellc             C   s7   t  j t d  d d |  _ |  j j d  |  _ d  S)Nzprofiles.xlsformatting_infoTZ
PROFILEDEF)xlrdopen_workbookr   booksheet_by_namesheet)self r   7/home/travis/build/python-excel/xlrd/tests/test_cell.pysetUp   s    zTestCell.setUpc             C   s   |  j  j d  } | j d d  } |  j | j t j  j  |  j | j d  |  j t | j  t t	 d    |  j
 | j d k  d  S)NZTRAVERSALCHAINAGEr    )r	   r
   cellassertEqualctyper   XL_CELL_EMPTYvaluetyper   
assertTruexf_index)r   r   r   r   r   r   test_empty_cell   s    %zTestCell.test_empty_cellc             C   s   |  j  j d d  } |  j | j t j j  |  j | j d  |  j t | j  t t	 d    |  j
 | j d k  d  S)Nr   ZPROFILr   )r   r   r   r   r   r	   XL_CELL_TEXTr   r   r   r   r   )r   r   r   r   r   test_string_cell   s
    %zTestCell.test_string_cellc             C   s[   |  j  j d d  } |  j | j t j j  |  j | j d  |  j | j	 d k  d  S)Nr   d   r   )
r   r   r   r   r   r	   XL_CELL_NUMBERr   r   r   )r   r   r   r   r   test_number_cell    s    zTestCell.test_number_cellc             C   sp   |  j  j d  } | j d d  } |  j | j t j  j  |  j | j d d d |  j	 | j
 d k  d  S)NZPROFILELEVELSr      gjtp@placesr   )r	   r
   r   r   r   r   r   assertAlmostEqualr   r   r   )r   sheet2r   r   r   r   test_calculated_cell&   s
    zTestCell.test_calculated_cellc             C   s   t  j t d  d d } | j d  } | j d \ } } } } |  j | j | |  j d  |  j | | | | f d  d  S)Nzxf_class.xlsr   TZtable2r   ZMERGEDr            )r   r$   r%   r&   )r   r   r   r
   merged_cellsr   r   r   )r   r	   sheet3Zrow_loZrow_hiZcol_loZcol_hir   r   r   test_merged_cells-   s
    zTestCell.test_merged_cellsc             C   s   t  j t d   } | j d  } g  } | j } |  j | |  | j d  } d g } | j } |  j | |  | j d  } d d d d g } | j } |  j | |  | j d
  } d d d g } | j } |  j | |  d  S)Nzmerged_cells.xlsxZSheet1ZSheet2r   r   r%   ZSheet3   	   ZSheet4      r&   )r   r   r   r%   )r   r   r   r%   )r   r   r%   r*   )r   r*   r   r%   )r   r+   r%   r*   )r   r   r   r%   )r%   r,   r   r   )r   r-   r%   r&   )r   r   r   r
   r'   r   )r   r	   Zsheet1expectedZgotr"   r(   Zsheet4r   r   r   test_merged_cells_xlsx4   s"    					zTestCell.test_merged_cells_xlsxN)
__name__
__module____qualname__r   r   r   r   r#   r)   r/   r   r   r   r   r      s   r   )unittestr   Zxlrd.timemachiner   baser   TestCaser   r   r   r   r   <module>   s   