You are not logged in.

KSpread reference to other sheets

Ast_Tom

Beginner

  • "Ast_Tom" started this thread

Posts: 7

  • Send private message

1

Thursday, March 9th 2006, 12:58pm

KSpread reference to other sheets

Hello,

Is it possible to reference a cell from another sheet?

For example like in Excel, you can use Sheet2!E2, which is quite handy!
Simple example where I would use it: You have 2 sheets, the first is an overview and the second are the details, and of course you use numbers from your detail sheet in the overview sheet. Can you do this with KSpread?

Thanks,

hoernerfranz

Beginner

Posts: 8

Location: Karlsruhe, Germany

  • Send private message

2

Thursday, March 9th 2006, 2:50pm

short answer: yes :)

Ast_Tom

Beginner

  • "Ast_Tom" started this thread

Posts: 7

  • Send private message

3

Thursday, March 9th 2006, 3:55pm

how? ;)

hoernerfranz

Beginner

Posts: 8

Location: Karlsruhe, Germany

  • Send private message

4

Thursday, March 9th 2006, 4:17pm

as mentioned.
just type:
=sheet1!A1
in a cell from sheet2.
it will display content from cell A1 in sheet1.

bram85

Professional

Posts: 948

Location: Eindhoven

Occupation: Software Engineer

  • Send private message

5

Thursday, March 9th 2006, 4:55pm

When entering formulas it's possible to open another sheet and select the cell, the right coordinates are inserted in the formula.
Bram Schoenmakers
KDE Netherlands (www.kde.nl)

Ast_Tom

Beginner

  • "Ast_Tom" started this thread

Posts: 7

  • Send private message

6

Friday, March 10th 2006, 7:41am

ok, I will try again then :)

What version is this in? 1.4.2? or must it be a higher version number?

bram85

Professional

Posts: 948

Location: Eindhoven

Occupation: Software Engineer

  • Send private message

7

Friday, March 10th 2006, 10:13pm

1.4.2 is the currently stable KSpread. But 1.5 is not far away, it's a matter of weeks by now. But 1.4.2 will do for point 'n clicking cells.
Bram Schoenmakers
KDE Netherlands (www.kde.nl)

Ast_Tom

Beginner

  • "Ast_Tom" started this thread

Posts: 7

  • Send private message

8

Wednesday, March 15th 2006, 9:04am

oké, it works.

I guess I thought it didn't work because I imported an excel sheet into kspread which uses such references, and they were not imported correctly. I will test it maybe a little further.