Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 03 Oct 2014 14:30:06 +0200calc: how can I pass the content of a cell to oleobject math and paste the result in a sheet using a macro?https://ask.libreoffice.org/en/question/40623/calc-how-can-i-pass-the-content-of-a-cell-to-oleobject-math-and-paste-the-result-in-a-sheet-using-a-macro/Calc: how can I pass the content of a cell to oleobject math and paste the result in a sheet?
I want to see the formula contained in a cell in a Math object near the cell both for formatting the document and checking the formula. (I work alost only with names in calc).
Math is fine for me and it is easy to programmaticaly format simple formulas so they become accetable for math, but I would like to link the content of the object to the cell without doing the cut paste and edit every time i make a change to a formula.
something like
ActiveSheet.OLEObjects.Add(ClassType:="soffice.StarMathDocument.6", Link:= _
True, DisplayAsIcon:=False).Activate
I have found something here : https://wiki.documentfoundation.org/images/3/37/MG40-MathGuide.pdf at page 45, but i need someone else advice and help to make it work. I believe it could be of help for many people.bigmarckFri, 03 Oct 2014 14:30:06 +0200https://ask.libreoffice.org/en/question/40623/