Hi Eike, So does this mean that if I create a matrix formula range and call PushMatrix, I will have the result displayed on the sheet ?
Thanks, Rashi On Tue, Jul 6, 2010 at 2:22 PM, Eike Rathke <e...@openoffice.org> wrote: > Hi rashi, > > On Tuesday, 2010-07-06 12:40:35 +0300, rashi dhing wrote: > > > So I did pore over the various functions of the ScInterpreter like > GetNewMat > > and PushMatrix etc. > > Apart from being extremely complicated, I still really didn't understand > > where the result matrix > > was being set/put into the spreadsheet. > > The result matrix is stored at the top left cell of a matrix formula > range, if there is any (e.g. created by having selected an area and > entered the formula using Ctrl+Enter), respectively at the formula cell. > So if the entire matrix result is to be displayed you, or the user, need > to create a matrix formula range of at least the same size. In the UI > that is done automatically if no range was selected, e.g. entering the > formula =MUNIT(2) and terminating the input with Ctrl+Enter instead of > Enter creates a 2x2 matrix formula range. > > > I did create a matrix but now I don't know how to print the values > > onto the sheet. PushMatrix pushes the matrix onto the stack but that > > does not serve my purpose !! > > What is your purpose then? So far I thought you created a spreadsheet > function that delivers an array/matrix result. If the final result of > a formula was a matrix on the interpreter's stack, that matrix result is > stored at the formula cell for display purposes or further evaluation. > It's nothing you should have to care about. > > Eike > > -- > OOo Calc core developer. Number formatter stricken i18n transpositionizer. > Signature key 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 > D412 > OpenOffice.org Engineering at Oracle: http://blogs.sun.com/GullFOSS > Please don't send personal mail to the e...@sun.com account, which I use > for > mailing lists only and don't read from outside Oracle. Use > er...@sun.comthanks. >