
>\  ใ               @   s   d  d l  m Z d  d l Z d d l m Z y e Wn e k
 rT d d   Z Yn XGd d   d e  Z Gd	 d
   d
 e  Z d S)้    )ฺTestCaseN้   )ฺfrom_this_dirc             C   s/   t  |   } | j d  r+ | d d   } | S)N๚u"๚u'r   )r   r   )ฺreprฺ
startswith)ฺsฺaฉ r   ๚;/home/travis/build/python-excel/xlrd/tests/test_formulas.pyฺascii   s    r   c               @   s|   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 d   Z
 d d   Z d S)ฺTestFormulasc             C   s+   t  j t d   } | j d  |  _ d  S)Nzformula_test_sjmachin.xlsr   )ฺxlrdฺopen_workbookr   ฺsheet_by_indexฺsheet)ฺselfฺbookr   r   r   ฺsetUp   s    zTestFormulas.setUpc             C   s   t  |  j j |  |  S)N)r   r   ฺ
col_values)r   ฺcolฺrowr   r   r   ฺ	get_value   s    zTestFormulas.get_valuec             C   s    |  j  |  j d d  d  d  S)Nr   zK'\u041c\u041e\u0421\u041a\u0412\u0410 \u041c\u043e\u0441\u043a\u0432\u0430')ฺassertEqualr   )r   r   r   r   ฺtest_cell_B2   s    zTestFormulas.test_cell_B2c             C   s    |  j  |  j d d  d  d  S)Nr   ้   z0.14285714285714285)r   r   )r   r   r   r   ฺtest_cell_B3#   s    zTestFormulas.test_cell_B3c             C   s    |  j  |  j d d  d  d  S)Nr   ้   z'ABCDEF')r   r   )r   r   r   r   ฺtest_cell_B4&   s    zTestFormulas.test_cell_B4c             C   s    |  j  |  j d d  d  d  S)Nr   ้   z'')r   r   )r   r   r   r   ฺtest_cell_B5)   s    zTestFormulas.test_cell_B5c             C   s    |  j  |  j d d  d  d  S)Nr   ้   ฺ1)r   r   )r   r   r   r   ฺtest_cell_B6,   s    zTestFormulas.test_cell_B6c             C   s    |  j  |  j d d  d  d  S)Nr   ้   ฺ7)r   r   )r   r   r   r   ฺtest_cell_B7/   s    zTestFormulas.test_cell_B7c             C   s    |  j  |  j d d  d  d  S)Nr   ้   zK'\u041c\u041e\u0421\u041a\u0412\u0410 \u041c\u043e\u0441\u043a\u0432\u0430')r   r   )r   r   r   r   ฺtest_cell_B82   s    zTestFormulas.test_cell_B8N)ฺ__name__ฺ
__module__ฺ__qualname__r   r   r   r   r   r!   r$   r'   r)   r   r   r   r   r      s   r   c               @   sp   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 d   Z
 d S)ฺTestNameFormulasc             C   s+   t  j t d   } | j d  |  _ d  S)Nzformula_test_names.xlsr   )r   r   r   r   r   )r   r   r   r   r   r   :   s    zTestNameFormulas.setUpc             C   s   t  |  j j |  |  S)N)r   r   r   )r   r   r   r   r   r   r   >   s    zTestNameFormulas.get_valuec             C   s    |  j  |  j d d  d  d  S)Nr   z-7.0)r   r   )r   r   r   r   ฺtest_unaryopA   s    zTestNameFormulas.test_unaryopc             C   s    |  j  |  j d d  d  d  S)Nr   r   z4.0)r   r   )r   r   r   r   ฺtest_attrsumD   s    zTestNameFormulas.test_attrsumc             C   s    |  j  |  j d d  d  d  S)Nr   r   z6.0)r   r   )r   r   r   r   ฺ	test_funcG   s    zTestNameFormulas.test_funcc             C   s    |  j  |  j d d  d  d  S)Nr   r    z3.0)r   r   )r   r   r   r   ฺtest_func_var_argsJ   s    z#TestNameFormulas.test_func_var_argsc             C   s    |  j  |  j d d  d  d  S)Nr   r"   z'b')r   r   )r   r   r   r   ฺtest_ifM   s    zTestNameFormulas.test_ifc             C   s    |  j  |  j d d  d  d  S)Nr   r%   z'C')r   r   )r   r   r   r   ฺtest_chooseP   s    zTestNameFormulas.test_chooseN)r*   r+   r,   r   r   r.   r/   r0   r1   r2   r3   r   r   r   r   r-   8   s   r-   )	ฺunittestr   r   ฺbaser   r   ฺ	NameErrorr   r-   r   r   r   r   ฺ<module>   s   $