î nÐR\²*ã@s¨ddlmZddlmZmZdd„Zdd„Zdd „ZGd d „d eƒZd d „Z dd„Z Gdd„deƒZ Gdd„de ƒZ dS)é)Ú BiffRecordé)ÚpackÚunpackcCs |j|ƒS)N)Z col_width)ÚsheetÚcol©rú//var/www/dbchiro/venv/build/xlwt/xlwt/Bitmap.pyÚ _size_col sr cCs |j|ƒS)N)Z row_height)rÚrowrrr Ú _size_rowsr c Cs x6|t||ƒkr8|t||ƒ8}|d7}qWx6|t||ƒkrq|t||ƒ8}|d7}q<W|}|}||d}||d}x6|t||ƒkrÒ|t||ƒ8}|d7}qWx6|t||ƒkr |t||ƒ8}|d7}qÖWt||ƒdks`t||ƒdks`t||ƒdks`t||ƒdkrddStt|ƒt||ƒdƒ}tt|ƒt||ƒdƒ}tt|ƒt||ƒdƒ} tt|ƒt||ƒdƒ} |||||| || fS)aúCalculate the vertices that define the position of the image as required by the OBJ record. +------------+------------+ | A | B | +-----+------------+------------+ | |(x1,y1) | | | 1 |(A1)._______|______ | | | | | | | | | | | +-----+----| BITMAP |-----+ | | | | | | 2 | |______________. | | | | (B2)| | | | (x2,y2)| +---- +------------+------------+ Example of a bitmap that covers some of the area from cell A1 to cell B2. Based on the width and height of the bitmap we need to calculate 8 vars: col_start, row_start, col_end, row_end, x1, y1, x2, y2. The width and height of the cells are also variable and have to be taken into account. The values of col_start and row_start are passed in from the calling function. The values of col_end and row_end are calculated by subtracting the width and height of the bitmap from the width and height of the underlying cells. The vertices are expressed as a percentage of the underlying cell width as follows (rhs values are in pixels): x1 = X / W *1024 y1 = Y / H *256 x2 = (X-1) / W *1024 y2 = (Y-1) / H *256 Where: X is distance from the left side of the underlying cell Y is distance from the top of the underlying cell W is the width of the cell H is the height of the cell Note: the SDK incorrectly states that the height should be expressed as a percentage of 1024. col_start - Col containing upper left corner of object row_start - Row containing top left corner of object x1 - Distance to left side of object y1 - Distance to top of object width - Width of image frame height - Height of image frame rrNié)r r ÚintÚfloat) rÚ row_startÚ col_startÚx1Úy1ÚwidthÚheightÚrow_endÚcol_endÚx2Úy2rrr Ú_position_images05**####rc@s"eZdZdZdd„ZdS)Ú ObjBmpRecordé]c 3CsM|j|} |j|} t|||||| | ƒ} | \} } }}}}}}d}d}d}d}| }| }|}|}|}|}|}|}d} d}!d}"d}#d}$d}%d}&d}'d}(d})d}*d}+d},d}-d}.d}/d}0d}1td|ƒ}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td|ƒ7}2|2td| ƒ7}2|2td|!ƒ7}2|2td|"ƒ7}2|2td |#ƒ7}2|2td |$ƒ7}2|2td |%ƒ7}2|2td |&ƒ7}2|2td |'ƒ7}2|2td |(ƒ7}2|2td |)ƒ7}2|2td |*ƒ7}2|2td|+ƒ7}2|2td|,ƒ7}2|2td|-ƒ7}2|2td|.ƒ7}2|2td|/ƒ7}2|2td|0ƒ7}2|2td|1ƒ7}2|2|_dS) Nréiré éÿzs   XQ -