search

T0ha / ezodf

ezodf is a Python package to create new or open existing OpenDocument (ODF) files to extract, add, modify or delete document data, forked from dead project https://bitbucket.org/mozman/ezodf
Other
61 stars 23 forks source link

ODS: Add rows and columns automatically #14

Closed dablak closed 11 months ago

dablak commented 8 years ago

Hi, this is more a nice to have enhancement request than an issue.

Is it possible/easy for spreadsheets to create columns and rows automatically when adding a value instead of raising an index out of range error?

For example:

sheet = ezodf.Table('Sheet')
print(sheet.nrows(), sheet. ncols())
#0 0
sheet[10, 20].set_value('A value')
print(sheet.nrows(), sheet. ncols())
#10 20

Cheers

chfw commented 8 years ago

+1, odfpy supports this while ezodf wants to the columns and rows in advance. In some situations, the developer just dont know and is forced to find out them first before continuing.