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.com Thanks.
pgpBJ2uBnG08X.pgp
Description: PGP signature
