U ‰d²*ã@sxddlmZddlmZmZdd„Zdd„Zdd „ZGd d „d eƒZd d „Z dd„Z Gdd„deƒZ Gdd„de ƒZ dS)é)Ú BiffRecordé)ÚpackÚunpackcCs | |¡S©N)Z col_width)ÚsheetÚcol©r ú//tmp/pip-unpacked-wheel-xnx7fvnv/xlwt/Bitmap.pyÚ _size_col sr cCs | |¡Sr)Z row_height)rÚrowr r r Ú _size_rowsr c Csp|t||ƒkr&|t||ƒ8}|d7}q|t||ƒkrL|t||ƒ8}|d7}q&|}|}||d}||d}|t||ƒkr’|t||ƒ8}|d7}ql|t||ƒkr¸|t||ƒ8}|d7}q’t||ƒdksðt||ƒdksðt||ƒdksðt||ƒdkrôdStt|ƒ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Úy2r r r Ú_position_images65       ÿ ÿrc@seZdZdZdd„ZdS)Ú ObjBmpRecordé]c 3Cs^|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é éÿús XQ -