Apps :: Siag Spreadsheet; Merge cells, Sheet references



Is it possible to merge cells in Siag?  That is, to be able to be create titles in a spreadsheet by typing the text for the title in the leftmost cell in the block, select the block, and then do "something" which would merge then cells without affecting the width of the cells underneath the merged cells.

Also, does anyone know the correct formula syntax to include the sheet name in a cell reference?
RHTopics, I'm not sure about the mergre.  You might need to write your own in scheme.  Could you do want you want to using the concatenate command, which joins strings together?
= concatenate(A1,B1,C1)

Getting the contents of another cell is done using get_cell(rownumber,colnumber,"Sheet Name") (Sheet name is in quotes and is optional).

To try it out, make a second sheet and put 33 into the A3 cell of the second sheet.  Go to the first sheet and type get_cell(1,3,"Sheet 2") and it puts 33 into that cell.

EDIT:

Just found that you can also do +"Sheet 2"!"A3" instead of using get_cell when you need to reference a cell on another sheet.
clacker,

Thank you for your response.  I got both the get_cell function and +"Sheet 2"!"A3" to work as C expressions.  Still trying to figure out how to convert them into SIOD expressions.

On the merge cells capability, I just wonder if the underlying grid widget used in Siag is able to support that type of operation.

Thanks,

RHT
RHTopics, The siod expression is (x-get-cell row colum "Sheet name").

This puts the string from the conversion of a number in another sheet into the status bar:

(llpr (number->string (x-get-cell 1 1 "sheet 2")))

to write the other sheet's cell to the currently selected cell try:

(set-data nil (number->string (x-get-cell 3 2 "Sheet 2")) 0 LABEL (make-position R C)))
clacker,

Thanks again.

I got both (x-get-cell 1 1 "Sheet name") and (get_cell 1 1 "Sheet name") to work as SIOD expressions

I got Errors when trying your two example SIOD formula expressions.  The first one worked when I removed the llpr function from it.  I tried the llpr function by itself, passing in string like (llpr "string") and it also generated an Error.

RHT
Next Page...
original here.