Please update documentation

eea / odfpy

API for OpenDocument in Python

GNU General Public License v2.0

311 stars 64 forks source link

Please update documentation #99

Open froeschin opened 4 years ago

froeschin commented 4 years ago

I am working with odfpy for creating a Libre Office spreadsheet. Sometimes I find it hard to find the information I need in the documentation. Especially I need to know:

how to merge cells
how to set a border for a cell
how to create formulas
how to align text in a cell

froeschin commented 4 years ago

I now found solutions for the above problems:

Merging cells: cell = TableCell(numberrowsspanned=2, numbercolumnsspanned=3)

Setting borders: style.addElement(TableCellProperties(border="0.74pt solid #808080"))

Creating formulas: cell = TableCell(formula="of:=[.A1]*[B2]")

Align text: style.addElement(ParagraphProperties(textalign="end"))

Still it would be nice to have this documented.