Re: finally successful in ods with python, just one help needed.

2009-03-17 Thread Krishnakant
Hi David and John. Thanks a lot, the problem is solved. David, your idea was the key to solve the problem. Actually John in his code and the explanation made it clear that the wrong attributes were being used on wrong elements. david's code confirmed the fact. The center style which david had in

Re: finally successful in ods with python, just one help needed.

2009-03-15 Thread John Machin
On Mar 15, 4:46 am, David Bolen wrote: [snip] > Note that it appears creating such a spreadsheet directly in Calc also > adds covered table cells for those cells beneath the spanned cell, but > Calc loads a file fine without those and still lets you later split > the merge and edit the underlyin

Re: finally successful in ods with python, just one help needed.

2009-03-14 Thread David Bolen
Krishnakant writes: > based on your code snippid I added a couple of lines to actually center > align text in the merged cell in first row. Sorry, guess I should have verified handling all the requirements :-) I think there's two issues: * I neglected to add the style I created to the document

Re: finally successful in ods with python, just one help needed.

2009-03-14 Thread Krishnakant
Hi David, based on your code snippid I added a couple of lines to actually center align text in the merged cell in first row. Please note in the following code that I have added ParagraphProperties in the imports and created one style with textalign="center" as an attribute. *** code follows ***

Re: finally successful in ods with python, just one help needed.

2009-03-14 Thread David Bolen
Krishnakant writes: > However when I apply the same elements and attributes to the one I am > creating with odfpy, I get "attribute not allowed " errors. > If some one is interested to look at the code, please let me know, I can > send an attachment off the list so that others are not forced to >

Re: finally successful in ods with python, just one help needed.

2009-03-14 Thread Krishnakant
On Thu, 2009-03-12 at 14:49 -0700, John Machin wrote: > I see that you haven't had the evil spirits exorcised from your mail/ > news client ... it's hijacked a thread again :-( > don't worry, won't happen this time. It seams I did some thing wrong with the settings and it drops out mails. Now the

Re: finally successful in ods with python, just one help needed.

2009-03-12 Thread John Machin
On Mar 13, 7:17 am, Krishnakant wrote: > Hello all specially John and Terry. Hello again Krishnakant, I see that you haven't had the evil spirits exorcised from your mail/ news client ... it's hijacked a thread again :-( > > I finally got my way around odfpy and could manage the spreadsheet to

finally successful in ods with python, just one help needed.

2009-03-12 Thread Krishnakant
Hello all specially John and Terry. I finally got my way around odfpy and could manage the spreadsheet to some extent. However I now have a small but unexpected problem. I would be very happy if some one could help me understand why is the text not getting centered in the spreadsheet I create.