https://bugs.documentfoundation.org/show_bug.cgi?id=172244
Werner Tietz <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #6 from Werner Tietz <[email protected]> --- off topic, workaround for Versions < 26.8 ( only for isolated single array-formula-ranges ! ) ``` from com.sun.star.beans import PropertyValue as pv def resize_FormulaArrays(*_): doc = XSCRIPTCONTEXT.getDocument() frame = doc.CurrentController.Frame disp = XSCRIPTCONTEXT.ctx.ServiceManager.createInstance("com.sun.star.frame.DispatchHelper") sheet = doc.CurrentController.ActiveSheet ranges = sheet.queryContentCells(16) #all Formula[range] for single in ranges: if (formula:=single.ArrayFormula): # is there a ArrayFormula? single.clearContents(16) # clear arg = pv( Name="ToPoint", Value= single[0,0].AbsoluteName) disp.executeDispatch(frame, ".uno:GoToCell", "", 0, (arg,)) arg = pv( Name="Formula", Value = formula[1:-1] ) disp.executeDispatch(frame, ".uno:InsertMatrix", "", 0, (arg,)) ``` -- You are receiving this mail because: You are the assignee for the bug.
