t.setValue("C5", 0.6)
t.setValue("C6", 0.6)
t.setValue("C7", 0.8)
t.setValue("C8", 0.8)
t.setValue("C9", "=AVERAGE(C5:C8)")
t.setValue("C10", "=SUM(C5:C8)")
t.setValue("D2", "= SIN(PI()/2)")
t.setValue("D10", "=IF(A2>3;C7;C9)")
t.setStyle("A3:D3", border_top="1pt solid #ff0000")
t.setValue("C3", "Sum of cells:")
t.setValue("D3", "=SUM($A$2:D2)")
t.setStyle("D2:D3", condition="cell-content()<=100")
t.setStyle("D2:D3", condition_background_color="#ff0000")
tw = SodsOds(t)
tw.save("test.ods")
print "Test load:"
print "----------"
t2 = SodsSpreadSheet(12, 12)
tw = SodsOds(t2)
tw.load("test.ods")
print t2.getCell("A1").text
print t2.getCell("D3").condition_state
