if __name__ == "__main__":
from sodsspreadsheet import SodsSpreadSheet
t = SodsSpreadSheet(12, 12)
print "Test spreadsheet naming:"
print "-----------------------"
t.setStyle("A1", text="שלום עולם")
t.setStyle("A1:G2", background_color="#00ff00")
t.setStyle("A3:G5", background_color="#ffff00")
t.setValue("A2", 123.4)
t.setValue("B2", "2010-01-01")
t.setValue("C2", "0.6")
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:")
file(filename,"w").write(self.exportCsv(i_max, j_max, delimiter, txt_delimiter))
if __name__ == "__main__":
from sodsspreadsheet import SodsSpreadSheet
t = SodsSpreadSheet()
print "Test spreadsheet naming:"
print "-----------------------"
t.setStyle("A1", text = "Simple ods python")
t.setStyle("A1:G2", background_color = "#00ff00")
t.setStyle("A3:G5", background_color = "#ffff00")
t.setValue("A2", 123.4)
t.setValue("B2", "2010-01-01")
t.setValue("C2", "=0.6")
t.setValue("D2", "= A2 + 3")
t.setStyle("A3:D3", border_top = "1pt solid #ff0000")
t.setValue("C3", "Sum of cells:")
t.setValue("D3", "=sum(A2:D2)")
t.setStyle("D2:D3", condition = "cell-content()<=200")
t.setStyle("D2:D3", condition_color = "#ff0000")
tw = SodsCsv(t)
tw.save("test.csv")
