î lÐR\Ž ã@s¯dZddlmZmZmZmZddlmZmZdZ dZ ej ddddƒZ e j ejd dd dd dƒƒd d „Zdd„Zdd„ZdS)z Tablib - ODF Support. é)Ú opendocumentÚstyleÚtableÚtext)ÚBytesIOÚunicodeÚodsÚnameÚboldÚfamilyZ paragraphZ fontweightZfontweightasianZfontweightcomplexcCs}tjƒ}|jjtƒtjd|jr7|jndƒ}|jj|ƒt ||ƒt ƒ}|j |ƒ|j ƒS)z&Returns ODF representation of Dataset.r zTablib Dataset) rÚOpenDocumentSpreadsheetÚautomaticstylesÚ addElementr rÚTableÚtitleÚ spreadsheetÚ dset_sheetrÚsaveÚgetvalue)ÚdatasetÚwbÚwsÚstream©rúH/var/www/dbchiro/venv/lib/python3.4/site-packages/tablib/formats/_ods.pyÚ export_sets $   rcCs¡tjƒ}|jjtƒxbt|jƒD]Q\}}tjd|j rS|j nd|ƒ}|j j|ƒt ||ƒq,Wt ƒ}|j |ƒ|jƒS)z'Returns ODF representation of DataBook.r zSheet%s)rr r rr Ú enumerateZ _datasetsrrrrrrrr)ZdatabookrÚiZdsetrrrrrÚ export_books (  rc Cs`|jddƒ}xBt|jƒD]1\}}|}|j|d||dfƒq"Wxt|ƒD]ô\}}|d}tjdtddƒ}xÃt|ƒD]µ\} } yt| dd ƒ} Wntk rÕYnX|j tj ƒƒ|dkro|j ro|j dtƒ|j |ƒtj ƒ} tjƒ} | j tjd | dtƒƒ| j | ƒ|j | ƒqŸy‘d | krÀ|j |ƒtj ƒ} | j tjd | ƒƒ|j | ƒn?|j |ƒtj ƒ} | j tjd | ƒƒ|j | ƒWqŸtk rS|j |ƒtj ƒ} | j tjd | ƒƒ|j | ƒYqŸXqŸWqdWd S) z-Completes given worksheet from given Dataset.ZdictsFréZ stylenameZdefaultcellstylenamer ÚerrorsÚignorerÚ N)Ú_packagerZ _separatorsÚinsertrZTableRowr rÚ TypeErrorrZ TableColumnÚheadersZ setAttributeZ TableCellrÚPZSpan) rrr#rÚsepÚ_offsetÚrowZ row_numberZodf_rowÚjÚcolZcellÚprrrr/sH#              rN)r)Ú__doc__ZodfrrrrZ tablib.compatrrrÚ extensionsZStyler rZTextPropertiesrrrrrrrÚs"%