iB::Topic::Siag Spreadsheet; Merge cells, Sheet references

	Damn Small Linux :: Damn Small Linux Board The DSL Forums

» Welcome Guest
[ Log In :: Register ]

Damn Small Linux Board » Damn Small Linux » Apps » Siag Spreadsheet; Merge cells, Sheet references

		Mini-ITX Boards Sale, Fanless BareBones Mini-ITX, Bootable 1G DSL USBs, 533MHz Fanless PC <-- SALE $200 each!
		Get The Official Damn Small Linux Book. DSL Market , Great VPS hosting provided by Tektonic

Pages: (2) </ [1] 2 >/

[ Track this topic :: Email this topic :: Print this topic ]

Topic: Siag Spreadsheet; Merge cells, Sheet references

< Next Oldest | Next Newest >

RHTopics

Group: Members
Posts: 9
Joined: Oct. 2005

Posted: Oct. 25 2005,14:46

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?

clacker

Group: Members
Posts: 570
Joined: June 2004

Posted: Oct. 25 2005,16:35

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.

RHTopics

Group: Members
Posts: 9
Joined: Oct. 2005

Posted: Oct. 25 2005,20:46

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

clacker

Group: Members
Posts: 570
Joined: June 2004

Posted: Oct. 25 2005,21:47

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)))

RHTopics

Group: Members
Posts: 9
Joined: Oct. 2005

Posted: Oct. 26 2005,01:05

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

5 replies since Oct. 25 2005,14:46

< Next Oldest | Next Newest >

[ Track this topic :: Email this topic :: Print this topic ]

Pages: (2) </ [1] 2 >/

Damn Small Linux Board » Damn Small Linux » Apps » Siag Spreadsheet; Merge cells, Sheet references