Ask Your Question

[calc] How do I get the current sheet number?

asked 2015-11-04 03:36:01 +0200

trueliar gravatar image

How do I get the current sheet number (possibly without macros)in calc?

I've already tried sheet().

thank you

edit retag flag offensive close merge delete


Please, what was wrong with SHEET()?

m.a.riosv gravatar imagem.a.riosv ( 2015-11-04 22:49:49 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-11-04 23:05:33 +0200

Rugslug gravatar image

I used


and it worked for me.

I used

=SHEET(Sheet2.A1)  (Or whatever sheet name you've used)

and it returned the sheet number of Sheet2 cell A1.

Make sure you have an equals sign before the function. Double check that the formula is calculating correctly. Try


for a result of 2 of course. If it stays as =1+1 then the cell may be a text format.

Under Tools, Options, +LibreOffice Calc, View, make sure Display Formulas is unchecked. You can check Value Highlighting to show different colours for different formats. Formulas: green; Numbers: blue; Text: black.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-11-04 03:36:01 +0200

Seen: 1,115 times

Last updated: Nov 04 '15