1# usage: runpy.sh fixtures/normal-values5b/make.py <port> <out.ods> <symbol.png> 2import sys, uno 3from unohelp import connect, desktop, pv 4from com.sun.star.awt import Rectangle 5from com.sun.star.table import CellRangeAddress 6 7port, out, png = int(sys.argv[1]), sys.argv[2], sys.argv[3] 8ctx = connect(port) 9d = desktop(ctx) 10doc = d.loadComponentFromURL("private:factory/scalc", "_blank", 0, (pv("Hidden", True),)) 11sh = doc.Sheets.getByIndex(0) 12for r, row in enumerate([["", "a", "b"], ["x", 1, 2], ["y", 3, 5], ["z", 4, 8]]): 13 for c, v in enumerate(row): 14 cell = sh.getCellByPosition(c, r) 15 if isinstance(v, str): cell.String = v 16 else: cell.Value = v 17rng = sh.getCellRangeByName("A1:C4").getRangeAddress() 18r = Rectangle(); r.X, r.Y, r.Width, r.Height = 8000, 1000, 9000, 7000 19sh.Charts.addNewByName("c1", r, (rng,), True, True) 20m = sh.Charts.getByName("c1").EmbeddedObject 21gp = ctx.ServiceManager.createInstanceWithContext("com.sun.star.graphic.GraphicProvider", ctx) 22g = gp.queryGraphic((pv("URL", uno.systemPathToFileUrl(png)),)) 23series = m.getFirstDiagram().getCoordinateSystems()[0].getChartTypes()[0].getDataSeries() 24s = series[0] 25sym = s.Symbol 26sym.Style = uno.Enum("com.sun.star.chart2.SymbolStyle", "GRAPHIC") 27sym.Graphic = g 28s.Symbol = sym 29print("readback", s.Symbol.Style, s.Symbol.Graphic, g, s.SymbolBitmapURL if hasattr(s,"SymbolBitmapURL") else None) 30sh.getColumns().getByIndex(2).IsVisible = False 31rng2 = sh.getCellRangeByName("A1:C4").getRangeAddress() 32r2 = Rectangle(); r2.X, r2.Y, r2.Width, r2.Height = 8000, 9000, 9000, 7000 33sh.Charts.addNewByName("c2", r2, (rng2,), True, True) 34doc.storeToURL(uno.systemPathToFileUrl(out), (pv("FilterName", "calc8"),)) 35doc.close(True) 36