Dear visitor, welcome to KDE-Forum.org.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
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,
short answer: yes
how?
as mentioned.
just type:
=sheet1!A1
in a cell from sheet2.
it will display content from cell A1 in sheet1.
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)
ok, I will try again then
What version is this in? 1.4.2? or must it be a higher version number?
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)
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.
KDE-Forum.org »
KDE »
(K)Office & PIM »
Saturday, November 23rd 2024, 4:06am
Go to the top of the page
