Ask Your Question

cell reference always include sheet name

asked 2016-06-26 04:31:30 +0200

AndresSolar gravatar image


I have a problem with a calc file. for some reason, calc always include the sheet name to references on the same sheet. Is this due to a preference setting?

Thanks in advance

edit retag flag offensive close merge delete


Please report your LibreOffice version and your operating system.

m.a.riosv gravatar imagem.a.riosv ( 2016-06-26 12:42:42 +0200 )edit

In the other forum you also mentioned a public grid blackout preceeding the observations. This is relevant information you should not abandon here.

Lupp gravatar imageLupp ( 2016-06-26 22:16:46 +0200 )edit

No. It applies to both installations (V. on OS X El Capitan). On was not affected by the blackout since installed on a MacBook Pro 15

AndresSolar gravatar imageAndresSolar ( 2016-06-27 03:16:48 +0200 )edit

I don't exactly know why, but after restoring the old user profile and cleaning up (search&replace) all formulas, the problem seems banned for know.

AndresSolar gravatar imageAndresSolar ( 2016-06-27 04:45:04 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-06-26 22:12:57 +0200

Lupp gravatar image
edit flag offensive delete link more


dead link 20170315

milan gravatar imagemilan ( 2017-03-15 17:27:59 +0200 )edit

The much better structured forum the linked contribution was posted in was closed down (See this announcement). Part of its content was saved (thanks to, but other parts obviously were lost. I have no draft of the post under discussion and I do not remember its content.

Lupp gravatar imageLupp ( 2017-03-15 19:11:33 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2016-06-26 04:31:30 +0200

Seen: 214 times

Last updated: Jun 26 '16