Ask Your Question
0

[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

Comments

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
0

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

Rugslug gravatar image

I used

=SHEET()

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

=1+1

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

Stats

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

Seen: 1,115 times

Last updated: Nov 04 '15