o e*@sxddlmZddlmZmZddZddZdd ZGd d d eZd d Z ddZ GdddeZ Gddde Z dS)) BiffRecord)packunpackcC ||SN) col_width)sheetcolr >/var/www/html/venv/lib/python3.10/site-packages/xlwt/Bitmap.py _size_col  r cCrr) row_height)r rowr r r _size_rowrrc Cs|t||kr|t||8}|d7}|t||ks|t||kr2|t||8}|d7}|t||ks |}|}||d}||d}|t||kr[|t||8}|d7}|t||ksI|t||krt|t||8}|d7}|t||ksbt||dkst||dkst||dkst||dkrdStt|t||d}tt|t||d}tt|t||d} tt|t||d} |||||| || fS)aCalculate 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 rintfloat) r row_start col_startx1y1widthheightrow_endcol_endx2y2r r r _position_images85  rc@seZdZdZddZdS) 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|07}2|2td|17}2|2|_dS) Nrir s XQ -